diff options
| -rw-r--r-- | support/schema/aur-schema.sql | 18 | ||||
| -rw-r--r-- | web/lib/pkgfuncs.inc | 13 |
2 files changed, 15 insertions, 16 deletions
diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql index c775af1..13e83d1 100644 --- a/support/schema/aur-schema.sql +++ b/support/schema/aur-schema.sql @@ -67,7 +67,7 @@ CREATE TABLE PackageCategories ( Category CHAR(32) NOT NULL, PRIMARY KEY (ID) ); -INSERT INTO PackageCategories (ID, Category) VALUES (0, 'none'); +INSERT INTO PackageCategories (Category) VALUES ('none'); INSERT INTO PackageCategories (Category) VALUES ('daemons'); INSERT INTO PackageCategories (Category) VALUES ('devel'); INSERT INTO PackageCategories (Category) VALUES ('editors'); @@ -94,12 +94,12 @@ CREATE TABLE PackageLocations ( Location CHAR(32) NOT NULL, PRIMARY KEY (ID) ); -INSERT INTO PackageLocations (ID, Location) VALUES (0, 'none'); -INSERT INTO PackageLocations (ID, Location) VALUES (1, 'Unsupported'); -INSERT INTO PackageLocations (ID, Location) VALUES (2, 'AUR'); -INSERT INTO PackageLocations (ID, Location) VALUES (3, 'Current'); -INSERT INTO PackageLocations (ID, Location) VALUES (4, 'Extra'); -INSERT INTO PackageLocations (ID, Location) VALUES (5, 'Unstable'); +INSERT INTO PackageLocations (Location) VALUES ('none'); +INSERT INTO PackageLocations (Location) VALUES ('Unsupported'); +INSERT INTO PackageLocations (Location) VALUES ('AUR'); +INSERT INTO PackageLocations (Location) VALUES ('Current'); +INSERT INTO PackageLocations (Location) VALUES ('Extra'); +INSERT INTO PackageLocations (Location) VALUES ('Unstable'); -- Information about the actual packages @@ -108,13 +108,13 @@ CREATE TABLE Packages ( ID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, Name CHAR(32) NOT NULL, Version CHAR(32) NOT NULL DEFAULT '', - CategoryID TINYINT UNSIGNED NOT NULL, + CategoryID TINYINT UNSIGNED NOT NULL DEFAULT 1, Description CHAR(128) NOT NULL DEFAULT "An Arch Package", URL CHAR(255) NOT NULL DEFAULT "http://www.archlinux.org", DummyPkg TINYINT UNSIGNED NOT NULL DEFAULT 0, -- 1=>dummy FSPath CHAR(255) NOT NULL DEFAULT '', URLPath CHAR(255) NOT NULL DEFAULT '', - LocationID TINYINT UNSIGNED NOT NULL, + LocationID TINYINT UNSIGNED NOT NULL DEFAULT 1, NumVotes INTEGER UNSIGNED NOT NULL DEFAULT 0, OutOfDate TINYINT UNSIGNED DEFAULT 0, SubmittedTS BIGINT UNSIGNED NOT NULL, diff --git a/web/lib/pkgfuncs.inc b/web/lib/pkgfuncs.inc index 6ea3831..4ae7a4e 100644 --- a/web/lib/pkgfuncs.inc +++ b/web/lib/pkgfuncs.inc @@ -56,7 +56,7 @@ function canManagePackage($uid=0,$AURMUID=0, $MUID=0, $SUID=0, $managed=0) { function pkgCategories() { $cats = array(); $dbh = db_connect(); - $q = "SELECT * FROM PackageCategories "; + $q = "SELECT * FROM PackageCategories WHERE ID != 1 "; $q.= "ORDER BY Category ASC"; $result = db_query($q, $dbh); if ($result) { @@ -72,7 +72,7 @@ function pkgCategories() { function pkgLocations() { $locs = array(); $dbh = db_connect(); - $q = "SELECT * FROM PackageLocations "; + $q = "SELECT * FROM PackageLocations WHERE ID != 1 "; $q.= "ORDER BY Location ASC"; $result = db_query($q, $dbh); if ($result) { @@ -130,11 +130,10 @@ function create_dummy($pname="", $sid="") { if (!$result) { # Insert the dummy # - $q = "INSERT INTO Packages (Name, CategoryID, Description, "; - $q.= "URL, LocationID, SubmittedTS, SubmitterUID) VALUES ('"; - $q.= mysql_escape_string($pname)."', 0, "; - $q.= "'A dummy package', '/#', 0, UNIX_TIMESTAMP(), "; - $q.= $uid.")"; + $q = "INSERT INTO Packages (Name, Description, URL, SubmittedTS, "; + $q.= "SubmitterUID) VALUES ('"; + $q.= mysql_escape_string($pname)."', 'A dummy package', '/#', "; + $q.= "UNIX_TIMESTAMP(), ".$uid.")"; $result = db_query($q, $dbh); if (!$result) { return NULL; |