utils/db_create.postgresql.php

   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 }