OSSP CVS Repository

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