install/schemas/mysql_stage2.sql
changeset 430 ec90736b9cb9
parent 422 ca37fcd08c4e
child 436 242353360e37
equal deleted inserted replaced
426:f5718d7c2a6a 430:ec90736b9cb9
    82 CREATE TABLE {{TABLE_PREFIX}}themes(
    82 CREATE TABLE {{TABLE_PREFIX}}themes(
    83   theme_id varchar(63),
    83   theme_id varchar(63),
    84   theme_name text,
    84   theme_name text,
    85   theme_order smallint(5) NOT NULL DEFAULT '1',
    85   theme_order smallint(5) NOT NULL DEFAULT '1',
    86   default_style varchar(63) NOT NULL DEFAULT '',
    86   default_style varchar(63) NOT NULL DEFAULT '',
    87   enabled tinyint(1) NOT NULL DEFAULT '1'
    87   enabled tinyint(1) NOT NULL DEFAULT '1',
       
    88   group_list text DEFAULT NULL,
       
    89   group_policy ENUM('allow', 'deny') NOT NULL DEFAULT 'deny'
    88 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
    90 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
    89 
    91 
    90 CREATE TABLE {{TABLE_PREFIX}}users(
    92 CREATE TABLE {{TABLE_PREFIX}}users(
    91   user_id mediumint(8) NOT NULL auto_increment,
    93   user_id mediumint(8) NOT NULL auto_increment,
    92   username text,
    94   username text,