summaryrefslogtreecommitdiffstats
path: root/support/schema
diff options
context:
space:
mode:
Diffstat (limited to 'support/schema')
-rw-r--r--support/schema/aur-schema.sql26
1 files changed, 13 insertions, 13 deletions
diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql
index c896aa3..b713fc8 100644
--- a/support/schema/aur-schema.sql
+++ b/support/schema/aur-schema.sql
@@ -11,7 +11,7 @@ CREATE TABLE AccountTypes (
ID TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
AccountType VARCHAR(32) NOT NULL DEFAULT '',
PRIMARY KEY (ID)
-);
+) ENGINE = InnoDB;
INSERT INTO AccountTypes (ID, AccountType) VALUES (1, 'User');
INSERT INTO AccountTypes (ID, AccountType) VALUES (2, 'Trusted User');
INSERT INTO AccountTypes (ID, AccountType) VALUES (3, 'Developer');
@@ -39,7 +39,7 @@ CREATE TABLE Users (
INDEX (AccountTypeID),
INDEX (NewPkgNotify),
FOREIGN KEY (AccountTypeID) REFERENCES AccountTypes(ID) ON DELETE NO ACTION
-);
+) ENGINE = InnoDB;
-- A default developer account for testing purposes
INSERT INTO Users (ID, AccountTypeID, Username, Email, Passwd) VALUES (
1, 3, 'dev', 'dev@localhost', MD5('dev'));
@@ -57,7 +57,7 @@ CREATE TABLE Sessions (
LastUpdateTS BIGINT UNSIGNED NOT NULL,
FOREIGN KEY (UsersID) REFERENCES Users(ID) ON DELETE CASCADE,
UNIQUE (SessionID)
-);
+) ENGINE = InnoDB;
-- Categories for grouping packages when they reside in
@@ -68,7 +68,7 @@ CREATE TABLE PackageCategories (
ID TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
Category VARCHAR(32) NOT NULL,
PRIMARY KEY (ID)
-);
+) ENGINE = InnoDB;
INSERT INTO PackageCategories (Category) VALUES ('none');
INSERT INTO PackageCategories (Category) VALUES ('daemons');
INSERT INTO PackageCategories (Category) VALUES ('devel');
@@ -116,7 +116,7 @@ CREATE TABLE Packages (
FOREIGN KEY (CategoryID) REFERENCES PackageCategories(ID) ON DELETE NO ACTION,
FOREIGN KEY (SubmitterUID) REFERENCES Users(ID) ON DELETE NO ACTION,
FOREIGN KEY (MaintainerUID) REFERENCES Users(ID) ON DELETE NO ACTION
-);
+) ENGINE = InnoDB;
-- Track which dependencies a package has
@@ -128,7 +128,7 @@ CREATE TABLE PackageDepends (
INDEX (PackageID),
FOREIGN KEY (PackageID) REFERENCES Packages(ID) ON DELETE CASCADE,
FOREIGN KEY (DepPkgID) REFERENCES Packages(ID) ON DELETE CASCADE
-);
+) ENGINE = InnoDB;
-- Track which sources a package has
@@ -138,7 +138,7 @@ CREATE TABLE PackageSources (
Source VARCHAR(255) NOT NULL DEFAULT "/dev/null",
INDEX (PackageID),
FOREIGN KEY (PackageID) REFERENCES Packages(ID) ON DELETE CASCADE
-);
+) ENGINE = InnoDB;
-- Track votes for packages
@@ -150,7 +150,7 @@ CREATE TABLE PackageVotes (
INDEX (PackageID),
FOREIGN KEY (UsersID) REFERENCES Users(ID) ON DELETE CASCADE,
FOREIGN KEY (PackageID) REFERENCES Packages(ID) ON DELETE CASCADE
-);
+) ENGINE = InnoDB;
CREATE UNIQUE INDEX VoteUsersIDPackageID ON PackageVotes (UsersID, PackageID);
-- Record comments for packages
@@ -168,7 +168,7 @@ CREATE TABLE PackageComments (
FOREIGN KEY (UsersID) REFERENCES Users(ID) ON DELETE CASCADE,
FOREIGN KEY (DelUsersID) REFERENCES Users(ID) ON DELETE CASCADE,
FOREIGN KEY (PackageID) REFERENCES Packages(ID) ON DELETE CASCADE
-);
+) ENGINE = InnoDB;
-- Comment addition notifications
--
@@ -177,7 +177,7 @@ CREATE TABLE CommentNotify (
UserID INTEGER UNSIGNED NOT NULL,
FOREIGN KEY (PkgID) REFERENCES Packages(ID) ON DELETE CASCADE,
FOREIGN KEY (UserID) REFERENCES Users(ID) ON DELETE CASCADE
-);
+) ENGINE = InnoDB;
CREATE UNIQUE INDEX NotifyUserIDPkgID ON CommentNotify (UserID, PkgID);
-- Package name blacklist
@@ -187,7 +187,7 @@ CREATE TABLE PackageBlacklist (
Name VARCHAR(64) NOT NULL,
PRIMARY KEY (ID),
UNIQUE (Name)
-);
+) ENGINE = InnoDB;
-- Vote information
--
@@ -203,7 +203,7 @@ CREATE TABLE IF NOT EXISTS TU_VoteInfo (
Abstain tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (ID),
FOREIGN KEY (SubmitterID) REFERENCES Users(ID) ON DELETE CASCADE
-);
+) ENGINE = InnoDB;
-- Individual vote records
--
@@ -212,4 +212,4 @@ CREATE TABLE IF NOT EXISTS TU_Votes (
UserID int(10) unsigned NOT NULL,
FOREIGN KEY (VoteID) REFERENCES TU_VoteInfo(ID) ON DELETE CASCADE,
FOREIGN KEY (UserID) REFERENCES Users(ID) ON DELETE CASCADE
-);
+) ENGINE = InnoDB;