install/schemas/postgresql_stage2.sql
changeset 857 f3a5a276208c
parent 831 45e887f23282
child 862 8356381e8d1e
equal deleted inserted replaced
856:0b7ff06aad13 857:f3a5a276208c
   348     sfunc = array_append,
   348     sfunc = array_append,
   349     stype = anyarray,
   349     stype = anyarray,
   350     initcond = '{}'
   350     initcond = '{}'
   351 );
   351 );
   352 
   352 
       
   353 -- The default config. Kind of important.
       
   354 -- P.S. the allowed_mime_types value is a compressed bitfield. Source for the (rather simple) algo is in functions.php.
   353 
   355 
   354 INSERT INTO {{TABLE_PREFIX}}config(config_name, config_value) VALUES
   356 INSERT INTO {{TABLE_PREFIX}}config(config_name, config_value) VALUES
   355   ('site_name', '{{SITE_NAME}}'),
   357   ('site_name', '{{SITE_NAME}}'),
   356   ('main_page', 'Main_Page'),
       
   357   ('site_desc', '{{SITE_DESC}}'),
   358   ('site_desc', '{{SITE_DESC}}'),
   358   ('wiki_mode', '{{WIKI_MODE}}'),
   359   ('wiki_mode', '{{WIKI_MODE}}'),
   359   ('wiki_edit_notice', '0'),
       
   360   ('sflogo_enabled', '0'),
       
   361   ('sflogo_groupid', ''),
       
   362   ('sflogo_type', '1'),
       
   363   ('w3c_vh32', '0'),
       
   364   ('w3c_vh40', '0'),
       
   365   ('w3c_vh401', '0'),
       
   366   ('w3c_vxhtml10', '0'),
       
   367   ('w3c_vxhtml11', '0'),
       
   368   ('w3c_vcss', '0'),
       
   369   ('approve_comments', '0'),
       
   370   ('enable_comments', '1'),
       
   371   ('plugin_SpecialAdmin.php', '1'),
       
   372   ('plugin_SpecialPageFuncs.php', '1'),
       
   373   ('plugin_SpecialUserFuncs.php', '1'),
       
   374   ('plugin_SpecialCSS.php', '1'),
       
   375   ('copyright_notice', '{{COPYRIGHT}}'),
   360   ('copyright_notice', '{{COPYRIGHT}}'),
   376   ('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.'),
       
   377   ('cache_thumbs', '{{ENABLE_CACHE}}'),
   361   ('cache_thumbs', '{{ENABLE_CACHE}}'),
   378   ('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' ),
       
   379   ('contact_email', '{{ADMIN_EMAIL}}'),
   362   ('contact_email', '{{ADMIN_EMAIL}}'),
   380   ('powered_btn', '1');
   363   ('allowed_mime_types', 'cbf2:7414a6b80184038102810b810781098106830a810282018101820683018102840182038104821a850682028104810a82018116'),
       
   364   ('enano_version', '{{VERSION}}');
   381 
   365 
   382 INSERT INTO {{TABLE_PREFIX}}page_text(page_id, namespace, page_text, char_tag) VALUES
   366 INSERT INTO {{TABLE_PREFIX}}page_text(page_id, namespace, page_text, char_tag) VALUES
   383   ('Main_Page', 'Article', E'{{MAIN_PAGE_CONTENT}}', '');
   367   ('Main_Page', 'Article', E'{{MAIN_PAGE_CONTENT}}', '');
   384   
   368   
   385 INSERT INTO {{TABLE_PREFIX}}logs(time_id, date_string, log_type, action, page_id, namespace, author, page_text) VALUES
   369 INSERT INTO {{TABLE_PREFIX}}logs(time_id, date_string, log_type, action, page_id, namespace, author, page_text) VALUES