1create sequence "auth_users_seq"; 2create table "auth_users" ( 3 "id" int4 default nextval('auth_users_seq'::text) NOT NULL, 4 "user_id" int4 default currval('auth_users_seq') NOT NULL, 5 "active" bool, 6 "user_name" varchar, 7 "passwd" varchar, 8 "crypt" varchar, 9 "first_name" varchar, 10 "last_name" varchar, 11 "email" varchar, 12 CONSTRAINT auth_users_pk PRIMARY KEY (user_id) 13); 14 15insert into auth_users 16( active, user_name, passwd, crypt, first_name, last_name, email ) 17VALUES 18( 't', 'user1', 'for_test', 'fo5XAdfKx4dwQ', 'User', 'Number One', 19'uno@example.com' ); 20 21create sequence "auth_groups_seq"; 22create table "auth_groups" ( 23 "id" int4 default nextval('auth_groups_seq'::text) NOT NULL, 24 "name" varchar, 25 "ident" varchar, 26 "description" text 27); 28 29insert into auth_groups ( name, ident, description ) 30VALUES ( 'User_Admin', 'ADMIN', 'Allowed to manage users' ); 31 32create sequence "auth_group_members_seq"; 33create table "auth_group_members" ( 34 "id" int4 default nextval('auth_group_members_seq'::text) NOT NULL, 35 "user_id" int4, 36 "group_id" int4 37); 38 39insert into auth_group_members ( user_id, group_id ) VALUES ( 1, 1 ); 40 41create sequence "auth_pages_seq"; 42create table "auth_pages" ( 43 "id" int4 default nextval('auth_pages_seq'::text) NOT NULL, 44 "user_perm" int4, 45 "group_perm" int4, 46 "world_perm" int4, 47 "owner_id" int4, 48 "group_id" int4, 49 "uri" varchar, 50 "title" varchar 51); 52 53