OSSP CVS Repository

ossp - Difference in ossp-pkg/quos/openpkg.sql versions 1.1 and 1.2
Not logged in
[Honeypot]  [Browse]  [Home]  [Login]  [Reports
[Search]  [Ticket]  [Timeline
  [History

ossp-pkg/quos/openpkg.sql 1.1 -> 1.2

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

CVSTrac 2.0.1