schema.sql
changeset 304 e2cb5f1432c8
parent 279 8acd77a6c19d
parent 297 ee1fc84f12a8
child 333 32429702305e
equal deleted inserted replaced
280:dc08c70ca550 304:e2cb5f1432c8
    47   edit_summary text,
    47   edit_summary text,
    48   minor_edit tinyint(1)
    48   minor_edit tinyint(1)
    49 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
    49 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
    50 
    50 
    51 CREATE TABLE {{TABLE_PREFIX}}page_text(
    51 CREATE TABLE {{TABLE_PREFIX}}page_text(
    52   page_id varchar(63),
    52   page_id varchar(255),
    53   namespace varchar(16) NOT NULL default 'Article',
    53   namespace varchar(16) NOT NULL default 'Article',
    54   page_text text,
    54   page_text text,
    55   char_tag varchar(63),
    55   char_tag varchar(63),
    56   FULLTEXT KEY {{TABLE_PREFIX}}page_search_idx (page_id, namespace, page_text)
    56   FULLTEXT KEY {{TABLE_PREFIX}}page_search_idx (page_id, namespace, page_text)
    57 ) ENGINE = MYISAM CHARACTER SET `utf8`;
    57 ) ENGINE = MYISAM CHARACTER SET `utf8`;
    58 
    58 
    59 CREATE TABLE {{TABLE_PREFIX}}pages(
    59 CREATE TABLE {{TABLE_PREFIX}}pages(
    60   page_order int(8),
    60   page_order int(8),
    61   name varchar(127),
    61   name varchar(255),
    62   urlname varchar(63),
    62   urlname varchar(255),
    63   namespace varchar(16) NOT NULL default 'Article',
    63   namespace varchar(16) NOT NULL default 'Article',
    64   special tinyint(1) default '0',
    64   special tinyint(1) default '0',
    65   visible tinyint(1) default '1',
    65   visible tinyint(1) default '1',
    66   comments_on tinyint(1) default '1',
    66   comments_on tinyint(1) default '1',
    67   protected tinyint(1) NOT NULL DEFAULT 0,
    67   protected tinyint(1) NOT NULL DEFAULT 0,
   302   ('plugin_SpecialUserFuncs.php', '1'),
   302   ('plugin_SpecialUserFuncs.php', '1'),
   303   ('plugin_SpecialCSS.php', '1'),
   303   ('plugin_SpecialCSS.php', '1'),
   304   ('copyright_notice', '{{COPYRIGHT}}'),
   304   ('copyright_notice', '{{COPYRIGHT}}'),
   305   ('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.'),
   305   ('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.'),
   306   ('cache_thumbs', '{{ENABLE_CACHE}}'),
   306   ('cache_thumbs', '{{ENABLE_CACHE}}'),
   307   ('max_file_size', '256000'),('enano_version', '{{VERSION}}'),( 'allowed_mime_types', 'cbf:len=168;crc=c3dcad3f;data=0[1],1[4],0[3],1[1],0[2],1[1],0[11],1[1],0[7],1[1],0[9],1[1],0[6],1[3],0[10],1[1],0[2],1[2],0[1],1[1],0[1],1[2],0[6],1[3],0[1],1[1],0[2],1[4],0[1],1[2],0[3],1[1],0[4],1[2],0[26],1[5],0[6],1[2],0[2],1[1],0[4],1[1],0[10],1[2],0[1],1[1],0[6]|end' ),
   307   ('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' ),
   308   ('contact_email', '{{ADMIN_EMAIL}}'),
   308   ('contact_email', '{{ADMIN_EMAIL}}'),
   309   ('powered_btn', '1');
   309   ('powered_btn', '1');
   310 
   310 
   311 INSERT INTO {{TABLE_PREFIX}}page_text(page_id, namespace, page_text, char_tag) VALUES
   311 INSERT INTO {{TABLE_PREFIX}}page_text(page_id, namespace, page_text, char_tag) VALUES
   312   ('Main_Page', 'Article', '=== Enano has been successfully installed and is working. ===\n\nIf you can see this message, it means that you\'ve finished the Enano setup process and are ready to start building your website. Congratulations!\n\nTo edit this front page, click the Log In button to the left, enter the credentials you provided during the installation, and click the Edit This Page button that appears on the blue toolbar just above this text. You can also [http://docs.enanocms.org/Help:2.4 learn more] about editing pages.\n\nTo create more pages, use the Create a Page button to the left. If you enabled wiki mode, you don\'t have to log in first, however your IP address will be shown in the page history.\n\nVisit the [http://docs.enanocms.org/Help:Contents Enano documentation project website] to learn more about administering your site effectively and keeping things secure.\n\n\'\'\'NOTE:\'\'\' You\'ve just installed an unstable version of Enano. This release is completely unsupported and may contain security issues or serious usability bugs. You should not use this release on a production website. The Enano team will not provide any type of support at all for this experimental release.', '');
   312   ('Main_Page', 'Article', '=== Enano has been successfully installed and is working. ===\n\nIf you can see this message, it means that you\'ve finished the Enano setup process and are ready to start building your website. Congratulations!\n\nTo edit this front page, click the Log In button to the left, enter the credentials you provided during the installation, and click the Edit This Page button that appears on the blue toolbar just above this text. You can also [http://docs.enanocms.org/Help:2.4 learn more] about editing pages.\n\nTo create more pages, use the Create a Page button to the left. If you enabled wiki mode, you don\'t have to log in first, however your IP address will be shown in the page history.\n\nVisit the [http://docs.enanocms.org/Help:Contents Enano documentation project website] to learn more about administering your site effectively and keeping things secure.\n\n\'\'\'NOTE:\'\'\' You\'ve just installed an unstable version of Enano. This release is completely unsupported and may contain security issues or serious usability bugs. You should not use this release on a production website. The Enano team will not provide any type of support at all for this experimental release.', '');