Changeset 9

Timestamp:

20/04/06 01:18:08 (3 years ago)

Author:

smoku

Message:

reverted SERIAL type change

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