diff options
Diffstat (limited to 'schema/aur-schema.sql')
| -rw-r--r-- | schema/aur-schema.sql | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/schema/aur-schema.sql b/schema/aur-schema.sql index adacdf0..0efae93 100644 --- a/schema/aur-schema.sql +++ b/schema/aur-schema.sql @@ -96,7 +96,7 @@ INSERT INTO PackageCategories (Category) VALUES ('fonts'); -- CREATE TABLE PackageBases ( ID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, - Name VARCHAR(64) NOT NULL, + Name VARCHAR(255) NOT NULL, CategoryID TINYINT UNSIGNED NOT NULL DEFAULT 1, NumVotes INTEGER UNSIGNED NOT NULL DEFAULT 0, OutOfDateTS BIGINT UNSIGNED NULL DEFAULT NULL, @@ -125,8 +125,8 @@ CREATE TABLE PackageBases ( CREATE TABLE Packages ( ID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, PackageBaseID INTEGER UNSIGNED NOT NULL, - Name VARCHAR(64) NOT NULL, - Version VARCHAR(32) NOT NULL DEFAULT '', + Name VARCHAR(255) NOT NULL, + Version VARCHAR(255) NOT NULL DEFAULT '', Description VARCHAR(255) NOT NULL DEFAULT "An Arch Package", URL VARCHAR(255) NOT NULL DEFAULT "https://www.archlinux.org", PRIMARY KEY (ID), @@ -139,7 +139,7 @@ CREATE TABLE Packages ( -- CREATE TABLE Licenses ( ID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, - Name VARCHAR(64) NOT NULL, + Name VARCHAR(255) NOT NULL, PRIMARY KEY (ID), UNIQUE (Name) ) ENGINE = InnoDB; @@ -160,7 +160,7 @@ CREATE TABLE PackageLicenses ( -- CREATE TABLE Groups ( ID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, - Name VARCHAR(64) NOT NULL, + Name VARCHAR(255) NOT NULL, PRIMARY KEY (ID), UNIQUE (Name) ) ENGINE = InnoDB; @@ -196,7 +196,7 @@ CREATE TABLE PackageDepends ( PackageID INTEGER UNSIGNED NOT NULL, DepTypeID TINYINT UNSIGNED NOT NULL, DepName VARCHAR(255) NOT NULL, - DepCondition VARCHAR(20), + DepCondition VARCHAR(255), INDEX (PackageID), INDEX (DepName), FOREIGN KEY (PackageID) REFERENCES Packages(ID) ON DELETE CASCADE, @@ -222,7 +222,7 @@ CREATE TABLE PackageRelations ( PackageID INTEGER UNSIGNED NOT NULL, RelTypeID TINYINT UNSIGNED NOT NULL, RelName VARCHAR(255) NOT NULL, - RelCondition VARCHAR(20), + RelCondition VARCHAR(255), INDEX (PackageID), INDEX (RelName), FOREIGN KEY (PackageID) REFERENCES Packages(ID) ON DELETE CASCADE, |