Mercurial Mercurial > repos > enano-1.1 / comparison
summary | shortlog | changelog | graph | tags | bookmarks | branches | files | changeset | file | latest | revisions | annotate | diff | comparison | raw | help
Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
install/schemas/mysql_stage2.sql
changeset 353 2398420f48e7
parent 350 dd7cbc97f681
parent 351 8978cb3541ca
child 359 e0787bb6285b
equal deleted inserted replaced
350:dd7cbc97f681 353:2398420f48e7 
   177   username varchar(63) NOT NULL,
 
   177   username varchar(63) NOT NULL,
 
   178   time int(12) NOT NULL DEFAULT 0,
 
   178   time int(12) NOT NULL DEFAULT 0,
 
   179   page_id varchar(63),
 
   179   page_id varchar(63),
 
   180   namespace varchar(63),
 
   180   namespace varchar(63),
 
   181   PRIMARY KEY ( hit_id ) 
   181   PRIMARY KEY ( hit_id ) 
       
   182 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
 
       
   183 
       
   184 CREATE TABLE {{TABLE_PREFIX}}search_index(
 
       
   185   word varchar(64) NOT NULL,
 
       
   186   page_names text,
 
       
   187   PRIMARY KEY ( word ) 
   182 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
 
   188 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
 
   183 
   189 
   184 CREATE TABLE {{TABLE_PREFIX}}groups(
 
   190 CREATE TABLE {{TABLE_PREFIX}}groups(
 
   185   group_id mediumint(5) UNSIGNED NOT NULL auto_increment,
 
   191   group_id mediumint(5) UNSIGNED NOT NULL auto_increment,
 
   186   group_name varchar(64),
 
   192   group_name varchar(64),
 
   298   ('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' ),
 
   304   ('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' ),
 
   299   ('contact_email', '{{ADMIN_EMAIL}}'),
 
   305   ('contact_email', '{{ADMIN_EMAIL}}'),
 
   300   ('powered_btn', '1');
 
   306   ('powered_btn', '1');
 
   301 
   307 
   302 INSERT INTO {{TABLE_PREFIX}}page_text(page_id, namespace, page_text, char_tag) VALUES
 
   308 INSERT INTO {{TABLE_PREFIX}}page_text(page_id, namespace, page_text, char_tag) VALUES
 
   303   ('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 have 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.', '');
 
   309   ('Main_Page', 'Article', '{{MAIN_PAGE_CONTENT}}', '');
 
       
   310   
       
   311 INSERT INTO {{TABLE_PREFIX}}logs(time_id, date_string, log_type, action, page_id, namespace, author, page_text) VALUES
 
       
   312   ({{UNIX_TIME}}, 'DEPRECATED', 'page', 'edit', 'Main_Page', 'Article', '{{ADMIN_USER}}', '{{MAIN_PAGE_CONTENT}}');
 
   304 
   313 
   305 INSERT INTO {{TABLE_PREFIX}}pages(page_order, name, urlname, namespace, special, visible, comments_on, protected, delvotes, delvote_ips) VALUES
 
   314 INSERT INTO {{TABLE_PREFIX}}pages(page_order, name, urlname, namespace, special, visible, comments_on, protected, delvotes, delvote_ips) VALUES
 
   306   (NULL, 'Main Page', 'Main_Page', 'Article', 0, 1, 1, 1, 0, '');
 
   315   (NULL, 'Main Page', 'Main_Page', 'Article', 0, 1, 1, 1, 0, '');
 
   307 
   316 
   308 INSERT INTO {{TABLE_PREFIX}}themes(theme_id, theme_name, theme_order, default_style, enabled) VALUES
 
   317 INSERT INTO {{TABLE_PREFIX}}themes(theme_id, theme_name, theme_order, default_style, enabled) VALUES
Enano CMS (1.1.x)