install/schemas/postgresql_stage2.sql
changeset 923 9ef3ccac13de
parent 862 8356381e8d1e
child 924 142a29b583f9
equal deleted inserted replaced
922:d6f391475bb9 923:9ef3ccac13de
   360   ('wiki_mode', '{{WIKI_MODE}}'),
   360   ('wiki_mode', '{{WIKI_MODE}}'),
   361   ('copyright_notice', '{{COPYRIGHT}}'),
   361   ('copyright_notice', '{{COPYRIGHT}}'),
   362   ('cache_thumbs', '{{ENABLE_CACHE}}'),
   362   ('cache_thumbs', '{{ENABLE_CACHE}}'),
   363   ('contact_email', '{{ADMIN_EMAIL}}'),
   363   ('contact_email', '{{ADMIN_EMAIL}}'),
   364   ('allowed_mime_types', 'cbf2:7414a6b80184038102810b810781098106830a810282018101820683018102840182038104821a850682028104810a82018116'),
   364   ('allowed_mime_types', 'cbf2:7414a6b80184038102810b810781098106830a810282018101820683018102840182038104821a850682028104810a82018116'),
       
   365   ('theme_default', 'enanium'),
   365   ('enano_version', '{{VERSION}}');
   366   ('enano_version', '{{VERSION}}');
   366 
   367 
   367 INSERT INTO {{TABLE_PREFIX}}page_text(page_id, namespace, page_text, char_tag) VALUES
   368 INSERT INTO {{TABLE_PREFIX}}page_text(page_id, namespace, page_text, char_tag) VALUES
   368   ('Main_Page', 'Article', '{{MAIN_PAGE_CONTENT}}', '');
   369   ('Main_Page', 'Article', '{{MAIN_PAGE_CONTENT}}', '');
   369   
   370   
   371   ({{UNIX_TIME}}, 'DEPRECATED', 'page', 'edit', 'Main_Page', 'Article', '{{ADMIN_USER}}', '{{MAIN_PAGE_CONTENT}}');
   372   ({{UNIX_TIME}}, 'DEPRECATED', 'page', 'edit', 'Main_Page', 'Article', '{{ADMIN_USER}}', '{{MAIN_PAGE_CONTENT}}');
   372 
   373 
   373 INSERT INTO {{TABLE_PREFIX}}pages(page_order, name, urlname, namespace, special, visible, comments_on, protected, delvotes, delvote_ips) VALUES
   374 INSERT INTO {{TABLE_PREFIX}}pages(page_order, name, urlname, namespace, special, visible, comments_on, protected, delvotes, delvote_ips) VALUES
   374   (NULL, 'Main Page', 'Main_Page', 'Article', 0, 1, 1, 1, 0, '');
   375   (NULL, 'Main Page', 'Main_Page', 'Article', 0, 1, 1, 1, 0, '');
   375 
   376 
   376 INSERT INTO {{TABLE_PREFIX}}themes(theme_id, theme_name, theme_order, DEFAULT_style, enabled) VALUES
   377 INSERT INTO {{TABLE_PREFIX}}themes(theme_id, theme_name, theme_order, default_style, enabled) VALUES
   377   ('oxygen', 'Oxygen', 1, 'bleu.css', 1),
   378   ('enanium', 'Enanium', 1, 'babygrand.css', 1),
   378   ('stpatty', 'St. Patty', 2, 'shamrock.css', 1);
   379   ('oxygen', 'Oxygen', 2, 'bleu.css', 1),
       
   380   ('stpatty', 'St. Patty', 3, 'shamrock.css', 1);
   379 
   381 
   380 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, user_lang, user_has_avatar, avatar_type) VALUES
   382 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, user_lang, user_has_avatar, avatar_type) VALUES
   381   (1, 'Anonymous', 'invalid-pass-hash', '', 'anonspam@enanocms.org', 'None', 1, 'oxygen', 'bleu', '', 0, 0, '', 0, 0, 'png'),
   383   (1, 'Anonymous', 'invalid-pass-hash', '', 'anonspam@enanocms.org', 'None', 1, 'enanium', 'babygrand', '', 0, 0, '', 0, 0, 'png'),
   382   (2, '{{ADMIN_USER}}', '{{ADMIN_PASS}}', '{{ADMIN_PASS_SALT}}', '{{ADMIN_EMAIL}}', '{{REAL_NAME}}', 9, 'oxygen', 'bleu', '', {{UNIX_TIME}}, 1, '{{IP_ADDRESS}}', 0, 0, 'png');
   384   (2, '{{ADMIN_USER}}', '{{ADMIN_PASS}}', '{{ADMIN_PASS_SALT}}', '{{ADMIN_EMAIL}}', '{{REAL_NAME}}', 9, 'enanium', 'babygrand', '', {{UNIX_TIME}}, 1, '{{IP_ADDRESS}}', 0, 0, 'png');
   383   
   385   
   384 INSERT INTO {{TABLE_PREFIX}}users_extra(user_id) VALUES
   386 INSERT INTO {{TABLE_PREFIX}}users_extra(user_id) VALUES
   385   (2);
   387   (2);
   386   
   388   
   387 INSERT INTO {{TABLE_PREFIX}}ranks(rank_id, rank_title, rank_style) VALUES
   389 INSERT INTO {{TABLE_PREFIX}}ranks(rank_id, rank_title, rank_style) VALUES