| | |
| | | BEGIN |
| | | :NEW."user_id" := "users_seq".nextval; |
| | | END; |
| | | |
| | | / |
| | | |
| | | CREATE TABLE "session" ( |
| | | "sess_id" varchar(128) NOT NULL PRIMARY KEY, |
| | |
| | | BEGIN |
| | | :NEW."identity_id" := "identities_seq".nextval; |
| | | END; |
| | | |
| | | / |
| | | |
| | | CREATE TABLE "contacts" ( |
| | | "contact_id" integer PRIMARY KEY, |
| | |
| | | BEGIN |
| | | :NEW."contact_id" := "contacts_seq".nextval; |
| | | END; |
| | | |
| | | / |
| | | |
| | | CREATE TABLE "contactgroups" ( |
| | | "contactgroup_id" integer PRIMARY KEY, |
| | |
| | | BEGIN |
| | | :NEW."contactgroup_id" := "contactgroups_seq".nextval; |
| | | END; |
| | | |
| | | / |
| | | |
| | | CREATE TABLE "contactgroupmembers" ( |
| | | "contactgroup_id" integer NOT NULL |
| | |
| | | BEGIN |
| | | :NEW."search_id" := "searches_seq".nextval; |
| | | END; |
| | | |
| | | / |
| | | |
| | | CREATE TABLE "system" ( |
| | | "name" varchar(64) NOT NULL PRIMARY KEY, |
| | | "value" long |
| | | ); |
| | | |
| | | INSERT INTO "system" ("name", "value") VALUES ('roundcube-version', '2014042900'); |
| | | INSERT INTO "system" ("name", "value") VALUES ('roundcube-version', '2015030800'); |