73 CREATE TABLE {{TABLE_PREFIX}}session_keys( |
73 CREATE TABLE {{TABLE_PREFIX}}session_keys( |
74 session_key varchar(32), |
74 session_key varchar(32), |
75 salt varchar(32), |
75 salt varchar(32), |
76 user_id mediumint(8), |
76 user_id mediumint(8), |
77 auth_level tinyint(1) NOT NULL DEFAULT '0', |
77 auth_level tinyint(1) NOT NULL DEFAULT '0', |
78 source_ip varchar(10) default '0x7f000001', |
78 source_ip varchar(39) NOT NULL DEFAULT '127.0.0.1', |
79 time bigint(15) default '0' |
79 time bigint(15) default '0' |
80 ) CHARACTER SET `utf8` COLLATE `utf8_bin`; |
80 ) CHARACTER SET `utf8` COLLATE `utf8_bin`; |
81 |
81 |
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, |
88 group_list text DEFAULT NULL, |
89 group_policy ENUM('allow', 'deny') NOT NULL DEFAULT 'deny' |
89 group_policy ENUM('allow_all', 'whitelist', 'blacklist') NOT NULL DEFAULT 'allow_all' |
90 ) CHARACTER SET `utf8` COLLATE `utf8_bin`; |
90 ) CHARACTER SET `utf8` COLLATE `utf8_bin`; |
91 |
91 |
92 CREATE TABLE {{TABLE_PREFIX}}users( |
92 CREATE TABLE {{TABLE_PREFIX}}users( |
93 user_id mediumint(8) NOT NULL auto_increment, |
93 user_id mediumint(8) NOT NULL auto_increment, |
94 username text, |
94 username text, |