Page MenuHomePhorge
Files F2533377

No OneTemporary
Actions

Size
4 KB
Referenced Files
None
Subscribers
None

View Options

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");

File Metadata

Mime Type
text/x-diff
Expires
Thu, Feb 5, 1:17 PM (1 h, 12 m)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
427927
Default Alt Text
(4 KB)

Event Timeline