diff options
author | eric <eric> | 2004-07-01 22:20:09 +0000 |
---|---|---|
committer | eric <eric> | 2004-07-01 22:20:09 +0000 |
commit | 993fcb7811d763368a6940730d3870b0013623c0 (patch) | |
tree | 4665a7a5abc964b4877ffebed626835a83789773 /support/schema/aur-schema.sql | |
parent | ab6afc990ccfca02e3c027be2b97ded6c9f51ad6 (diff) |
still working on pkgsearch.php::do_Details
Diffstat (limited to 'support/schema/aur-schema.sql')
-rw-r--r-- | support/schema/aur-schema.sql | 19 |
1 files changed, 18 insertions, 1 deletions
diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql index dd02310..fde8b95 100644 --- a/support/schema/aur-schema.sql +++ b/support/schema/aur-schema.sql @@ -108,7 +108,6 @@ CREATE TABLE Packages ( CategoryID TINYINT UNSIGNED NOT NULL, Description CHAR(128) NOT NULL DEFAULT "An Arch Package", URL CHAR(255) NOT NULL DEFAULT "http://www.archlinux.org", - Source CHAR(255) NOT NULL DEFAULT "/dev/null", LocationID TINYINT UNSIGNED NOT NULL, NumVotes INTEGER UNSIGNED NOT NULL DEFAULT 0, OutOfDate TINYINT UNSIGNED DEFAULT 0, @@ -133,6 +132,24 @@ CREATE TABLE Packages ( ); +-- Track which dependencies a package has +-- +CREATE TABLE PackageDepends ( + PackageID INTEGER UNSIGNED NOT NULL, + DepPkgID INTEGER UNSIGNED NOT NULL, + INDEX (PackageID) +); + + +-- Track which sources a package has +-- +CREATE TABLE PackageSources ( + PackageID INTEGER UNSIGNED NOT NULL, + Source CHAR(255) NOT NULL DEFAULT "/dev/null", + INDEX (PackageID) +); + + -- Track votes for packages -- CREATE TABLE PackageVotes ( |