create sequence "auth_users_seq";
create table "auth_users" (
"id" int4 default nextval('auth_users_seq'::text) NOT NULL,
"user_id" int4 default currval('auth_users_seq') NOT NULL,
"active" bool,
"user_name" varchar,
"passwd" varchar,
"crypt" varchar,
"first_name" varchar,
"last_name" varchar,
"email" varchar,
CONSTRAINT auth_users_pk PRIMARY KEY (user_id)
);
insert into auth_users
( active, user_name, passwd, crypt, first_name, last_name, email )
VALUES
( 't', 'user1', 'for_test', 'fo5XAdfKx4dwQ', 'User', 'Number One',
'uno@example.com' );
create sequence "auth_groups_seq";
create table "auth_groups" (
"id" int4 default nextval('auth_groups_seq'::text) NOT NULL,
"name" varchar,
"ident" varchar,
"description" text
);
insert into auth_groups ( name, ident, description )
VALUES ( 'User_Admin', 'ADMIN', 'Allowed to manage users' );
create sequence "auth_group_members_seq";
create table "auth_group_members" (
"id" int4 default nextval('auth_group_members_seq'::text) NOT NULL,
"user_id" int4,
"group_id" int4
);
insert into auth_group_members ( user_id, group_id ) VALUES ( 1, 1 );
create sequence "auth_pages_seq";
create table "auth_pages" (
"id" int4 default nextval('auth_pages_seq'::text) NOT NULL,
"user_perm" int4,
"group_perm" int4,
"world_perm" int4,
"owner_id" int4,
"group_id" int4,
"uri" varchar,
"title" varchar
);