create table "auth_users" (
    "id"            INTEGER PRIMARY KEY AUTOINCREMENT, 
    "user_id"       INTEGER UNSIGNED NOT NULL DEFAULT '0',
    "active"        bool,
    "user_name"     varchar,
    "passwd"        varchar,
    "crypt"         varchar,
    "first_name"    varchar,
    "last_name"     varchar,
    "email"         varchar
);

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 table "auth_groups" (
    "id"            INTEGER PRIMARY KEY AUTOINCREMENT,
    "name"          varchar,
    "ident"			varchar,
	"description"   text
);

insert into auth_groups ( name, ident, description )
VALUES ( 'User_Admin', 'ADMIN', 'Allowed to manage users' );

create table "auth_group_members" (
    "id"        INTEGER PRIMARY KEY AUTOINCREMENT,
    "user_id"   int4,
    "group_id"  int4
);

insert into auth_group_members ( user_id, group_id ) VALUES ( 1, 1 );

create table "auth_pages" (
    "id"            INTEGER PRIMARY KEY AUTOINCREMENT,
    "user_perm"     int4,
    "group_perm"    int4,
    "world_perm"    int4,
    "owner_id"      int4,
    "group_id"      int4,
    "uri"           varchar,
    "title"         varchar
);