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