schema.sql
changeset 32 4d87aad3c4c0
parent 30 7e8fd44b36b0
child 33 143d3ee32f3c
equal deleted inserted replaced
31:dc8741857bde 32:4d87aad3c4c0
   259 
   259 
   260 INSERT INTO {{TABLE_PREFIX}}themes(theme_id, theme_name, theme_order, default_style, enabled) VALUES
   260 INSERT INTO {{TABLE_PREFIX}}themes(theme_id, theme_name, theme_order, default_style, enabled) VALUES
   261   ('oxygen', 'Oxygen', 1, 'bleu.css', 1),
   261   ('oxygen', 'Oxygen', 1, 'bleu.css', 1),
   262   ('stpatty', 'St. Patty', 2, 'shamrock.css', 1);
   262   ('stpatty', 'St. Patty', 2, 'shamrock.css', 1);
   263 
   263 
   264 INSERT INTO {{TABLE_PREFIX}}users(user_id, username, password, email, real_name, user_level, theme, style, signature, reg_time) VALUES(1, 'Anonymous', 'invalid-pass-hash', 'anonspam@enanocms.org', 'None', 1, 'oxygen', 'bleu', '', 0);
   264 INSERT INTO {{TABLE_PREFIX}}users(user_id, username, password, email, real_name, user_level, theme, style, signature, reg_time, account_active) VALUES
   265 
   265   (1, 'Anonymous', 'invalid-pass-hash', 'anonspam@enanocms.org', 'None', 1, 'oxygen', 'bleu', '', 0, 0),
   266 INSERT INTO {{TABLE_PREFIX}}users(user_id, username, password, email, real_name, user_level, theme, style, account_active, reg_time) VALUES
   266   (2, '{{ADMIN_USER}}', '{{ADMIN_PASS}}', '{{ADMIN_EMAIL}}', '{{REAL_NAME}}', 9, 'oxygen', 'bleu', 1, UNIX_TIMESTAMP(), 1);
   267   (2, '{{ADMIN_USER}}', '{{ADMIN_PASS}}', '{{ADMIN_EMAIL}}', '{{REAL_NAME}}', 9, 'oxygen', 'bleu', 1, UNIX_TIMESTAMP());
   267 
       
   268 INSERT INTO {{TABLE_PREFIX}}users_extra(user_id) VALUES
       
   269   (2);
   268 
   270 
   269 INSERT INTO {{TABLE_PREFIX}}groups(group_id,group_name,group_type,system_group) VALUES(1, 'Everyone', 3, 1),
   271 INSERT INTO {{TABLE_PREFIX}}groups(group_id,group_name,group_type,system_group) VALUES(1, 'Everyone', 3, 1),
   270   (2,'Administrators',3,1),
   272   (2,'Administrators',3,1),
   271   (3,'Moderators',3,1);
   273   (3,'Moderators',3,1);
   272 
   274