Index: ossp-pkg/quos/openpkg.sql
RCS File: /v/ossp/cvs/ossp-pkg/quos/openpkg.sql,v
rcsdiff -q -kk '-r1.1' '-r1.2' -u '/v/ossp/cvs/ossp-pkg/quos/openpkg.sql,v' 2>/dev/null
--- openpkg.sql	2004/10/25 14:35:11	1.1
+++ openpkg.sql	2004/11/08 15:25:50	1.2
@@ -25,12 +25,12 @@
 --
 
 CREATE TABLE quos_rdf (
-    rd_id           BIGSERIAL UNIQUE NOT NULL PRIMARY KEY,
+    rd_id           INTEGER UNIQUE NOT NULL PRIMARY KEY,
     rd_url          TEXT
 );
 
 CREATE TABLE quos_package (
-    pk_id           BIGSERIAL UNIQUE NOT NULL PRIMARY KEY,
+    pk_id           INTEGER UNIQUE NOT NULL PRIMARY KEY,
     pk_name         TEXT,
     pk_version      TEXT,
     pk_release      TEXT,
@@ -42,58 +42,42 @@
     pk_url          TEXT,
     pk_vendor       TEXT,
     pk_description  TEXT,
-    pk_rdf          BIGINT UNIQUE NOT NULL
+    pk_rdf          INTEGER NOT NULL
                     REFERENCES quos_rdf (rd_id)
                     MATCH FULL DEFERRABLE
 );
 
 CREATE TABLE quos_buildprereq (
-    bp_id           BIGINT UNIQUE NOT NULL
+    bp_id           INTEGER NOT NULL
                     REFERENCES quos_package (pk_id)
-                    MATCH FULL DEFERRABLE
-                    PRIMARY KEY,
+                    MATCH FULL DEFERRABLE,
     bp_key          TEXT,         
     bp_op           TEXT,
-    bp_val          TEXT,
-    bp_rdf          BIGINT UNIQUE NOT NULL
-                    REFERENCES quos_rdf (rd_id)
-                    MATCH FULL DEFERRABLE
+    bp_val          TEXT
 );
 
 CREATE TABLE quos_prereq (
-    rp_id           BIGINT UNIQUE NOT NULL
+    rp_id           INTEGER NOT NULL
                     REFERENCES quos_package (pk_id)
-                    MATCH FULL DEFERRABLE
-                    PRIMARY KEY,
+                    MATCH FULL DEFERRABLE,
     rp_key          TEXT,         
     rp_op           TEXT,
     rp_val          TEXT
-    rp_rdf          BIGINT UNIQUE NOT NULL
-                    REFERENCES quos_rdf (rd_id)
-                    MATCH FULL DEFERRABLE
 );
 
 CREATE TABLE quos_provide (
-    pr_id           BIGINT UNIQUE NOT NULL
+    pr_id           INTEGER NOT NULL
                     REFERENCES quos_package (pk_id)
-                    MATCH FULL DEFERRABLE
-                    PRIMARY KEY,
+                    MATCH FULL DEFERRABLE,
     pr_key          TEXT,         
     pr_op           TEXT,
     pr_val          TEXT
-    pr_rdf          BIGINT UNIQUE NOT NULL
-                    REFERENCES quos_rdf (rd_id)
-                    MATCH FULL DEFERRABLE
 );
 
 CREATE TABLE quos_source (
-    sr_id           BIGINT UNIQUE NOT NULL
+    sr_id           INTEGER NOT NULL
                     REFERENCES quos_package (p_id)
-                    MATCH FULL DEFERRABLE
-                    PRIMARY KEY,
+                    MATCH FULL DEFERRABLE,
     sr_url          TEXT
-    sr_rdf          BIGINT UNIQUE NOT NULL
-                    REFERENCES quos_rdf (rd_id)
-                    MATCH FULL DEFERRABLE
 );