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