diff --git a/doc/SQL/mysql/2015110400.sql b/doc/SQL/mysql/2015110400.sql new file mode 100644 index 0000000..22dd073 --- /dev/null +++ b/doc/SQL/mysql/2015110400.sql @@ -0,0 +1,23 @@ +CREATE TABLE IF NOT EXISTS `chwala_sessions` ( + `id` varchar(40) BINARY NOT NULL, + `uri` varchar(1024) BINARY NOT NULL, + `owner` varchar(255) BINARY NOT NULL, + `owner_name` varchar(255) DEFAULT NULL, + `data` mediumtext, + PRIMARY KEY (`id`), + INDEX `uri_index` (`uri`(255)), + INDEX `owner` (`owner`) +) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */; + +CREATE TABLE IF NOT EXISTS `chwala_invitations` ( + `session_id` varchar(40) BINARY NOT NULL, + `user` varchar(255) BINARY NOT NULL, + `user_name` varchar(255) DEFAULT NULL, + `status` varchar(16) NOT NULL, + `changed` datetime DEFAULT NULL, + `comment` mediumtext, + CONSTRAINT `session_id_fk_chwala_invitations` FOREIGN KEY (`session_id`) + REFERENCES `chwala_sessions`(`id`) ON DELETE CASCADE ON UPDATE CASCADE, + INDEX `session_id` (`session_id`), + UNIQUE INDEX `user_session_id` (`user`, `session_id`) +) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */; diff --git a/doc/SQL/oracle.initial.sql b/doc/SQL/oracle.initial.sql index 1d523d0..104839b 100644 --- a/doc/SQL/oracle.initial.sql +++ b/doc/SQL/oracle.initial.sql @@ -1,15 +1,42 @@ CREATE TABLE "chwala_locks" ( "uri" varchar(512) NOT NULL, "owner" varchar(256), "timeout" integer, "expires" timestamp DEFAULT NULL, "token" varchar(256), "scope" smallint, "depth" smallint ); CREATE INDEX "uri_index" ON "chwala_locks" ("uri", "depth"); CREATE INDEX "expires_index" ON "chwala_locks" ("expires"); CREATE INDEX "token_index" ON "chwala_locks" ("token"); -INSERT INTO "system" ("name", "value") VALUES ('chwala-version', '2013111300'); + +CREATE TABLE "chwala_sessions" ( + "id" varchar(40) NOT NULL, + "uri" varchar(1024) NOT NULL, + "owner" varchar(255) NOT NULL, + "owner_name" varchar(255) DEFAULT NULL, + "data" long, + PRIMARY KEY ("id") +); + +CREATE INDEX "chwala_sessions_uri_idx" ON "chwala_sessions" ("uri"); +CREATE INDEX "chwala_sessions_owner_idx" ON "chwala_sessions" ("owner"); + + +CREATE TABLE "chwala_invitations" ( + "session_id" varchar(40) NOT NULL + REFERENCES "chwala_sessions" ("id") ON DELETE CASCADE ON UPDATE CASCADE, + "user" varchar(255) NOT NULL, + "user_name" varchar(255) DEFAULT NULL, + "status" varchar(16) NOT NULL, + "changed" timestamp DEFAULT NULL, + "comment" long +); + +CREATE INDEX "chwala_invitations_session_id_idx" ON "chwala_invitations" ("session_id"); +CREATE UNIQUE INDEX "chwala_invitations_user_idx" ON "chwala_invitations" ("user", "session_id"); + +INSERT INTO "system" ("name", "value") VALUES ('chwala-version', '2015110400'); diff --git a/doc/SQL/oracle/2015110400.sql b/doc/SQL/oracle/2015110400.sql new file mode 100644 index 0000000..1915a7f --- /dev/null +++ b/doc/SQL/oracle/2015110400.sql @@ -0,0 +1,25 @@ +CREATE TABLE "chwala_sessions" ( + "id" varchar(40) NOT NULL, + "uri" varchar(1024) NOT NULL, + "owner" varchar(255) NOT NULL, + "owner_name" varchar(255) DEFAULT NULL, + "data" long, + PRIMARY KEY ("id") +); + +CREATE INDEX "chwala_sessions_uri_idx" ON "chwala_sessions" ("uri"); +CREATE INDEX "chwala_sessions_owner_idx" ON "chwala_sessions" ("owner"); + + +CREATE TABLE "chwala_invitations" ( + "session_id" varchar(40) NOT NULL + REFERENCES "chwala_sessions" ("id") ON DELETE CASCADE ON UPDATE CASCADE, + "user" varchar(255) NOT NULL, + "user_name" varchar(255) DEFAULT NULL, + "status" varchar(16) NOT NULL, + "changed" timestamp DEFAULT NULL, + "comment" long +); + +CREATE INDEX "chwala_invitations_session_id_idx" ON "chwala_invitations" ("session_id"); +CREATE UNIQUE INDEX "chwala_invitations_user_idx" ON "chwala_invitations" ("user", "session_id");