[webcal.git] / utils / db_create.sql

BEGIN TRANSACTION;
DELETE FROM sqlite_sequence;
INSERT INTO "sqlite_sequence" VALUES('roles',2);
INSERT INTO "sqlite_sequence" VALUES('user',5);
CREATE TABLE roles (
id integer primary key autoincrement,
name text not null
);
INSERT INTO "roles" VALUES(0,'administrator');
INSERT INTO "roles" VALUES(1,'power user');
INSERT INTO "roles" VALUES(2,'user');
CREATE TABLE user (
id integer primary key autoincrement,
uid text not null,
pwd text not null,
userrole integer not null,
timeout integer default 3600,
userview text default 'week',
weekstart integer default 0,
daystart real default 8.00,
dayend real default 17.00,
seckey text default '',
pubkey text default '',
constraint uid_index unique (uid)
constraint userrole_fk foreign key (userrole) references roles (id)
on delete restrict
on update cascade
on insert cascade
);
INSERT INTO "user" VALUES(1,'admin','d033e22ae348aeb5660fc2140aec35850c4da997',0,1200,'week',0,8.0,17.0,'','');
Commit	Line	Data
a5eae6b7 MR	1	BEGIN TRANSACTION;
	2	DELETE FROM sqlite_sequence;
	3	INSERT INTO "sqlite_sequence" VALUES('roles',2);
	4	INSERT INTO "sqlite_sequence" VALUES('user',5);
	5	CREATE TABLE roles (
	6	id integer primary key autoincrement,
	7	name text not null
	8	);
	9	INSERT INTO "roles" VALUES(0,'administrator');
	10	INSERT INTO "roles" VALUES(1,'power user');
	11	INSERT INTO "roles" VALUES(2,'user');
	12	CREATE TABLE user (
	13	id integer primary key autoincrement,
	14	uid text not null,
	15	pwd text not null,
	16	userrole integer not null,
	17	timeout integer default 3600,
	18	userview text default 'week',
	19	weekstart integer default 0,
	20	daystart real default 8.00,
	21	dayend real default 17.00,
	22	seckey text default '',
	23	pubkey text default '',
	24	constraint uid_index unique (uid)
	25	constraint userrole_fk foreign key (userrole) references roles (id)
	26	on delete restrict
	27	on update cascade
	28	on insert cascade
	29	);
	30	INSERT INTO "user" VALUES(1,'admin','d033e22ae348aeb5660fc2140aec35850c4da997',0,1200,'week',0,8.0,17.0,'','');
	31