install/schemas/postgresql_stage2.sql
changeset 430 ec90736b9cb9
parent 413 6607cd646d6d
child 436 242353360e37
equal deleted inserted replaced
426:f5718d7c2a6a 430:ec90736b9cb9
    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,
       
    88   group_policy varchar(5) NOT NULL DEFAULT 'deny',
       
    89   CHECK (group_policy IN ('allow', 'deny'))
    87 );
    90 );
    88 
    91 
    89 CREATE TABLE {{TABLE_PREFIX}}users(
    92 CREATE TABLE {{TABLE_PREFIX}}users(
    90   user_id SERIAL,
    93   user_id SERIAL,
    91   username text,
    94   username text,