72 CREATE TABLE {{TABLE_PREFIX}}session_keys( |
72 CREATE TABLE {{TABLE_PREFIX}}session_keys( |
73 session_key varchar(32), |
73 session_key varchar(32), |
74 salt varchar(32), |
74 salt varchar(32), |
75 user_id int, |
75 user_id int, |
76 auth_level smallint NOT NULL DEFAULT '0', |
76 auth_level smallint NOT NULL DEFAULT '0', |
77 source_ip varchar(10) DEFAULT '0x7f000001', |
77 source_ip varchar(39) NOT NULL DEFAULT '127.0.0.1', |
78 time bigint DEFAULT '0' |
78 time bigint DEFAULT '0' |
79 ); |
79 ); |
80 |
80 |
81 CREATE TABLE {{TABLE_PREFIX}}themes( |
81 CREATE TABLE {{TABLE_PREFIX}}themes( |
82 theme_id varchar(63), |
82 theme_id varchar(63), |
83 theme_name text, |
83 theme_name text, |
84 theme_order smallint NOT NULL DEFAULT '1', |
84 theme_order smallint NOT NULL DEFAULT '1', |
85 default_style varchar(63) NOT NULL DEFAULT '', |
85 default_style varchar(63) NOT NULL DEFAULT '', |
86 enabled smallint NOT NULL DEFAULT '1', |
86 enabled smallint NOT NULL DEFAULT '1', |
87 group_list text DEFAULT NULL, |
87 group_list text DEFAULT NULL, |
88 group_policy varchar(5) NOT NULL DEFAULT 'deny', |
88 group_policy varchar(5) NOT NULL DEFAULT 'allow_all', |
89 CHECK (group_policy IN ('allow', 'deny')) |
89 CHECK (group_policy IN ('allow_all', 'whitelist', 'blacklist')) |
90 ); |
90 ); |
91 |
91 |
92 CREATE TABLE {{TABLE_PREFIX}}users( |
92 CREATE TABLE {{TABLE_PREFIX}}users( |
93 user_id SERIAL, |
93 user_id SERIAL, |
94 username text, |
94 username text, |