install/schemas/mysql_stage2.sql
changeset 923 9ef3ccac13de
parent 838 34fa18bedeb1
child 924 142a29b583f9
equal deleted inserted replaced
922:d6f391475bb9 923:9ef3ccac13de
   355   ('wiki_mode', '{{WIKI_MODE}}'),
   355   ('wiki_mode', '{{WIKI_MODE}}'),
   356   ('copyright_notice', '{{COPYRIGHT}}'),
   356   ('copyright_notice', '{{COPYRIGHT}}'),
   357   ('cache_thumbs', '{{ENABLE_CACHE}}'),
   357   ('cache_thumbs', '{{ENABLE_CACHE}}'),
   358   ('contact_email', '{{ADMIN_EMAIL}}'),
   358   ('contact_email', '{{ADMIN_EMAIL}}'),
   359   ('allowed_mime_types', 'cbf2:7414a6b80184038102810b810781098106830a810282018101820683018102840182038104821a850682028104810a82018116'),
   359   ('allowed_mime_types', 'cbf2:7414a6b80184038102810b810781098106830a810282018101820683018102840182038104821a850682028104810a82018116'),
       
   360   ('theme_default', 'enanium'),
   360   ('enano_version', '{{VERSION}}');
   361   ('enano_version', '{{VERSION}}');
   361 
   362 
   362 INSERT INTO {{TABLE_PREFIX}}page_text(page_id, namespace, page_text, char_tag) VALUES
   363 INSERT INTO {{TABLE_PREFIX}}page_text(page_id, namespace, page_text, char_tag) VALUES
   363   ('Main_Page', 'Article', '{{MAIN_PAGE_CONTENT}}', '');
   364   ('Main_Page', 'Article', '{{MAIN_PAGE_CONTENT}}', '');
   364   
   365   
   367 
   368 
   368 INSERT INTO {{TABLE_PREFIX}}pages(page_order, name, urlname, namespace, special, visible, comments_on, protected, delvotes, delvote_ips) VALUES
   369 INSERT INTO {{TABLE_PREFIX}}pages(page_order, name, urlname, namespace, special, visible, comments_on, protected, delvotes, delvote_ips) VALUES
   369   (NULL, 'Main Page', 'Main_Page', 'Article', 0, 1, 1, 1, 0, '');
   370   (NULL, 'Main Page', 'Main_Page', 'Article', 0, 1, 1, 1, 0, '');
   370 
   371 
   371 INSERT INTO {{TABLE_PREFIX}}themes(theme_id, theme_name, theme_order, default_style, enabled) VALUES
   372 INSERT INTO {{TABLE_PREFIX}}themes(theme_id, theme_name, theme_order, default_style, enabled) VALUES
   372   ('oxygen', 'Oxygen', 1, 'bleu.css', 1),
   373   ('enanium', 'Enanium', 1, 'babygrand.css', 1),
   373   ('stpatty', 'St. Patty', 2, 'shamrock.css', 1);
   374   ('oxygen', 'Oxygen', 2, 'bleu.css', 1),
       
   375   ('stpatty', 'St. Patty', 3, 'shamrock.css', 1);
   374 
   376 
   375 INSERT INTO {{TABLE_PREFIX}}users(user_id, username, password, password_salt, email, real_name, user_level, theme, style, signature, reg_time, account_active, user_registration_ip) VALUES
   377 INSERT INTO {{TABLE_PREFIX}}users(user_id, username, password, password_salt, email, real_name, user_level, theme, style, signature, reg_time, account_active, user_registration_ip) VALUES
   376   (1, 'Anonymous', 'invalid-pass-hash', '', 'anonspam@enanocms.org', 'None', 1, 'oxygen', 'bleu', '', 0, 0, '{{IP_ADDRESS}}'),
   378   (1, 'Anonymous', 'invalid-pass-hash', '', 'anonspam@enanocms.org', 'None', 1, 'enanium', 'babygrand', '', 0, 0, '{{IP_ADDRESS}}'),
   377   (2, '{{ADMIN_USER}}', '{{ADMIN_PASS}}', '{{ADMIN_PASS_SALT}}', '{{ADMIN_EMAIL}}', '{{REAL_NAME}}', 9, 'oxygen', 'bleu', '', UNIX_TIMESTAMP(), 1, '{{IP_ADDRESS}}');
   379   (2, '{{ADMIN_USER}}', '{{ADMIN_PASS}}', '{{ADMIN_PASS_SALT}}', '{{ADMIN_EMAIL}}', '{{REAL_NAME}}', 9, 'enanium', 'babygrand', '', UNIX_TIMESTAMP(), 1, '{{IP_ADDRESS}}');
   378   
   380   
   379 INSERT INTO {{TABLE_PREFIX}}users_extra(user_id) VALUES
   381 INSERT INTO {{TABLE_PREFIX}}users_extra(user_id) VALUES
   380   (2);
   382   (2);
   381   
   383   
   382 INSERT INTO {{TABLE_PREFIX}}ranks(rank_id, rank_title, rank_style) VALUES
   384 INSERT INTO {{TABLE_PREFIX}}ranks(rank_id, rank_title, rank_style) VALUES