equal
deleted
inserted
replaced
127 user_homepage text, |
127 user_homepage text, |
128 user_location text, |
128 user_location text, |
129 user_job text, |
129 user_job text, |
130 user_hobbies text, |
130 user_hobbies text, |
131 email_public smallint NOT NULL DEFAULT 0, |
131 email_public smallint NOT NULL DEFAULT 0, |
|
132 disable_js_fx smallint NOT NULL DEFAULT 0, |
132 PRIMARY KEY ( user_id ) |
133 PRIMARY KEY ( user_id ) |
133 ); |
134 ); |
134 |
135 |
135 CREATE TABLE {{TABLE_PREFIX}}banlist( |
136 CREATE TABLE {{TABLE_PREFIX}}banlist( |
136 ban_id SERIAL, |
137 ban_id SERIAL, |
202 |
203 |
203 CREATE TABLE {{TABLE_PREFIX}}groups( |
204 CREATE TABLE {{TABLE_PREFIX}}groups( |
204 group_id SERIAL, |
205 group_id SERIAL, |
205 group_name varchar(64), |
206 group_name varchar(64), |
206 group_type smallint NOT NULL DEFAULT 1, |
207 group_type smallint NOT NULL DEFAULT 1, |
207 PRIMARY KEY ( group_id ), |
208 system_group smallint NOT NULL DEFAULT 0, |
208 system_group smallint NOT NULL DEFAULT 0 |
209 group_rank int DEFAULT NULL, |
|
210 PRIMARY KEY ( group_id ) |
209 ); |
211 ); |
210 |
212 |
211 CREATE TABLE {{TABLE_PREFIX}}group_members( |
213 CREATE TABLE {{TABLE_PREFIX}}group_members( |
212 member_id SERIAL, |
214 member_id SERIAL, |
213 group_id int NOT NULL, |
215 group_id int NOT NULL, |