Changeset 8 for trunk/tools/db-setup.pgsql

Timestamp:

20/04/06 00:57:57 (3 years ago)

Author:

smoku

Message:

changed "object-sequence" to SERIAL 'type'

Files:

• trunk/tools/db-setup.pgsql (modified) (15 diffs)

trunk/tools/db-setup.pgsql

@@ -20 +20 @@
     "hash" varchar(40) );
 
-CREATE SEQUENCE "object-sequence";
-
 --
 -- Session manager tables 
@@ -32 +30 @@
 CREATE TABLE "active" (
     "collection-owner" text PRIMARY KEY,
-    "object-sequence" bigint,
+    "object-sequence" serial,
     "time" integer );
 
@@ -41 +39 @@
 CREATE TABLE "logout" (
     "collection-owner" text PRIMARY KEY,
-    "object-sequence" bigint,
+    "object-sequence" serial,
     "time" integer NOT NULL );
 
@@ -50 +48 @@
 CREATE TABLE "roster-items" (
     "collection-owner" text,
-    "object-sequence" bigint,
+    "object-sequence" serial,
     "jid" text NOT NULL,
     "name" text,
@@ -66 +64 @@
 CREATE TABLE "roster-groups" (
     "collection-owner" text,
-    "object-sequence" bigint,
+    "object-sequence" serial,
     "jid" text NOT NULL,
     "group" text NOT NULL,
@@ -80 +78 @@
 CREATE TABLE "vcard" (
     "collection-owner" text PRIMARY KEY,
-    "object-sequence" bigint,
+    "object-sequence" serial,
     "fn" text,
     "nickname" text,
@@ -135 +133 @@
 CREATE TABLE "queue" (
     "collection-owner" text,
-    "object-sequence" bigint,
+    "object-sequence" serial,
     "xml" text NOT NULL );
 
@@ -146 +144 @@
 CREATE TABLE "private" (
     "collection-owner" text,
-    "object-sequence" bigint,
+    "object-sequence" serial,
     "ns" text,
     "xml" text,
@@ -159 +157 @@
 CREATE TABLE "motd-message" (
     "collection-owner" text PRIMARY KEY,
-    "object-sequence" bigint,
+    "object-sequence" serial,
     "xml" text NOT NULL);
 
@@ -168 +166 @@
 CREATE TABLE "motd-times" (
     "collection-owner" text PRIMARY KEY,
-    "object-sequence" bigint,
+    "object-sequence" serial,
     "time" integer NOT NULL);
 
@@ -177 +175 @@
 CREATE TABLE "disco-items" (
     "collection-owner" text,
-    "object-sequence" bigint,
+    "object-sequence" serial,
     "jid" text,
     "name" text,
@@ -190 +188 @@
 CREATE TABLE "privacy-default" (
     "collection-owner" text PRIMARY KEY,
-    "object-sequence" bigint,
+    "object-sequence" serial,
     "default" text );
 
@@ -199 +197 @@
 CREATE TABLE "privacy-items" (
     "collection-owner" text,
-    "object-sequence" bigint,
+    "object-sequence" serial,
     "list" text NOT NULL,
     "type" text,
@@ -215 +213 @@
 CREATE TABLE "vacation-settings" (
     "collection-owner" text PRIMARY KEY,
-    "object-sequence" bigint,
+    "object-sequence" serial,
     "start" int,
     "end" int,
@@ -226 +224 @@
 CREATE TABLE "status" (
     "collection-owner" text PRIMARY KEY,
-    "object-sequence" bigint,
+    "object-sequence" serial,
     "status" text,
     "show" text,