equal
deleted
inserted
replaced
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 'allow_all', |
88 group_policy varchar(9) NOT NULL DEFAULT 'allow_all', |
89 CHECK (group_policy IN ('allow_all', 'whitelist', 'blacklist')) |
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, |
191 PRIMARY KEY ( hit_id ) |
191 PRIMARY KEY ( hit_id ) |
192 ); |
192 ); |
193 |
193 |
194 CREATE TABLE {{TABLE_PREFIX}}search_index( |
194 CREATE TABLE {{TABLE_PREFIX}}search_index( |
195 word varchar(64) NOT NULL, |
195 word varchar(64) NOT NULL, |
|
196 word_lcase varchar(64) NOT NULL, |
196 page_names text, |
197 page_names text, |
197 PRIMARY KEY ( word ) |
198 PRIMARY KEY ( word ) |
198 ); |
199 ); |
199 |
200 |
200 CREATE TABLE {{TABLE_PREFIX}}groups( |
201 CREATE TABLE {{TABLE_PREFIX}}groups( |