install/schemas/mysql_stage2.sql
changeset 519 94214ec0871c
parent 499 6b7fdd898ba3
child 541 acb7e23b6ffa
equal deleted inserted replaced
518:2b826f2640e9 519:94214ec0871c
   316   private_key text,
   316   private_key text,
   317   public_key text,
   317   public_key text,
   318   PRIMARY KEY ( key_id )
   318   PRIMARY KEY ( key_id )
   319 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
   319 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
   320 
   320 
       
   321 -- Added in 1.1.4
       
   322 -- This is really honestly a better way to handle plugins.
       
   323 
       
   324 CREATE TABLE {{TABLE_PREFIX}}plugins (
       
   325   plugin_id int(12) NOT NULL auto_increment,
       
   326   plugin_filename varchar(63),
       
   327   plugin_flags int(12),
       
   328   plugin_version varchar(16),
       
   329   PRIMARY KEY ( plugin_id )
       
   330 ) ENGINE `MyISAM` CHARACTER SET `utf8` COLLATE `utf8_bin`;
       
   331 
   321 INSERT INTO {{TABLE_PREFIX}}config(config_name, config_value) VALUES
   332 INSERT INTO {{TABLE_PREFIX}}config(config_name, config_value) VALUES
   322   ('site_name', '{{SITE_NAME}}'),
   333   ('site_name', '{{SITE_NAME}}'),
   323   ('main_page', 'Main_Page'),
   334   ('main_page', 'Main_Page'),
   324   ('site_desc', '{{SITE_DESC}}'),
   335   ('site_desc', '{{SITE_DESC}}'),
   325   ('wiki_mode', '{{WIKI_MODE}}'),
   336   ('wiki_mode', '{{WIKI_MODE}}'),
   333   ('w3c_vxhtml10', '0'),
   344   ('w3c_vxhtml10', '0'),
   334   ('w3c_vxhtml11', '0'),
   345   ('w3c_vxhtml11', '0'),
   335   ('w3c_vcss', '0'),
   346   ('w3c_vcss', '0'),
   336   ('approve_comments', '0'),
   347   ('approve_comments', '0'),
   337   ('enable_comments', '1'),
   348   ('enable_comments', '1'),
   338   ('plugin_SpecialAdmin.php', '1'),
       
   339   ('plugin_SpecialPageFuncs.php', '1'),
       
   340   ('plugin_SpecialUserFuncs.php', '1'),
       
   341   ('plugin_SpecialCSS.php', '1'),
       
   342   ('copyright_notice', '{{COPYRIGHT}}'),
   349   ('copyright_notice', '{{COPYRIGHT}}'),
   343   ('wiki_edit_notice_text', '== Why can I edit this page? ==\n\nEveryone can edit almost any page in this website. This concept is called a wiki. It gives everyone the opportunity to make a change for the best. While some spam and vandalism may occur, it is believed that most contributions will be legitimate and helpful.\n\nFor security purposes, a history of all page edits is kept, and administrators are able to restore vandalized or spammed pages with just a few clicks.'),
   350   ('wiki_edit_notice_text', '== Why can I edit this page? ==\n\nEveryone can edit almost any page in this website. This concept is called a wiki. It gives everyone the opportunity to make a change for the best. While some spam and vandalism may occur, it is believed that most contributions will be legitimate and helpful.\n\nFor security purposes, a history of all page edits is kept, and administrators are able to restore vandalized or spammed pages with just a few clicks.'),
   344   ('cache_thumbs', '{{ENABLE_CACHE}}'),
   351   ('cache_thumbs', '{{ENABLE_CACHE}}'),
   345   ('max_file_size', '256000'),('enano_version', '{{VERSION}}'),( 'allowed_mime_types', 'cbf:len=185;crc=55fb6f14;data=0[1],1[4],0[3],1[1],0[22],1[1],0[16],1[3],0[16],1[1],0[1],1[2],0[6],1[1],0[1],1[1],0[4],1[2],0[3],1[1],0[48],1[2],0[2],1[1],0[4],1[1],0[37]|end' ),
   352   ('max_file_size', '256000'),('enano_version', '{{VERSION}}'),( 'allowed_mime_types', 'cbf:len=185;crc=55fb6f14;data=0[1],1[4],0[3],1[1],0[22],1[1],0[16],1[3],0[16],1[1],0[1],1[2],0[6],1[1],0[1],1[1],0[4],1[2],0[3],1[1],0[48],1[2],0[2],1[1],0[4],1[1],0[37]|end' ),
   346   ('contact_email', '{{ADMIN_EMAIL}}'),
   353   ('contact_email', '{{ADMIN_EMAIL}}'),