summaryrefslogtreecommitdiffstats
path: root/support/schema/aur-schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'support/schema/aur-schema.sql')
-rw-r--r--support/schema/aur-schema.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql
index ffd1d98..9c5d920 100644
--- a/support/schema/aur-schema.sql
+++ b/support/schema/aur-schema.sql
@@ -144,8 +144,11 @@ CREATE TABLE PackageVotes (
--
CREATE TABLE PackageContents (
PackageID INTEGER UNSIGNED NOT NULL,
+ FileName CHAR(32) NOT NULL,
Path CHAR(255) NOT NULL,
+ FileSize BIGINT UNSIGNED NOT NULL default 0,
INDEX (PackageID),
+ INDEX (FileName),
FOREIGN KEY (PackageID) REFERENCES Packages(ID) ON DELETE CASCADE
);