]>
Commit | Line | Data |
---|---|---|
a5eae6b7 MR |
1 | <?php |
2 | /* $Id$ */ | |
3 | ||
4 | function make_sql_stm() { | |
5 | $db = array(); | |
6 | ||
7 | array_push($db, "create sequence roles_pk_seq"); | |
8 | array_push($db, "create table roles ( | |
9 | id integer primary key default nextval('roles_pk_seq'), | |
10 | name varchar(256) not null | |
11 | )"); | |
12 | array_push($db, "insert into roles values(0,'administrator')"); | |
13 | array_push($db, "insert into roles values(1,'power user')"); | |
14 | array_push($db, "insert into roles values(2,'user')"); | |
15 | ||
16 | array_push($db, "create sequence users_pk_seq"); | |
17 | array_push($db, "create table users ( | |
18 | id integer primary key default nextval('users_pk_seq'), | |
19 | uid varchar(256) not null, | |
20 | pwd varchar(256) not null, | |
21 | userrole integer not null, | |
22 | timeout integer default 3600, | |
23 | userview varchar(256) default 'week', | |
24 | weekstart integer default 0, | |
25 | daystart numeric(4,2) default 8.00, | |
26 | dayend numeric(4,2) default 17.00, | |
27 | timezone varchar(256) default 'Etc/UTC', | |
28 | seckey varchar(256) default '', | |
29 | pubkey varchar(256) default '', | |
30 | constraint uid_index unique (uid), | |
31 | constraint userrole_fk foreign key (userrole) references roles (id) | |
32 | on update cascade | |
33 | on delete restrict | |
34 | )"); | |
35 | ||
36 | array_push($db, "create sequence calendar_pk_seq"); | |
37 | array_push($db, "create table calendar ( | |
38 | id integer default nextval('calendar_pk_seq'), | |
39 | uid integer not null, | |
40 | name varchar(256) not null, | |
41 | color varchar(256) default 'navy', | |
42 | config varchar(4000) default '', | |
43 | constraint calendar_pk primary key (id, uid), | |
44 | constraint uid_fk foreign key (uid) references users (id) | |
45 | on update cascade | |
46 | on delete cascade | |
47 | )"); | |
48 | array_push($db, "create table about ( | |
49 | id integer default 1, | |
50 | version varchar(256) default '')"); | |
51 | array_push($db, "create table ldap ( | |
52 | enable integer default 0, | |
53 | dns varchar(256) default '', | |
54 | tls integer default 0, | |
55 | base_dn varchar(256) default '', | |
56 | user_attr varchar(256) default 'uid')"); | |
57 | ||
58 | return $db; | |
59 | } |