Tims-PackageServer-Administration/install.sql at master · wbbaddons/Tims-PackageServer-Administration · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
CREATE TABLE wcf1_packageserver_package_to_group (
	packageIdentifier VARCHAR(255),
	groupID INT(10),
	permissionString MEDIUMTEXT,
	PRIMARY KEY(packageIdentifier, groupID),
	KEY (groupID)
);

CREATE TABLE wcf1_packageserver_package_to_user (
	packageIdentifier VARCHAR(255),
	userID INT(10),
	permissionString MEDIUMTEXT,
	PRIMARY KEY(packageIdentifier, userID),
	KEY (userID)
);

CREATE TABLE wcf1_packageserver_package_permission_general (
	packageIdentifier VARCHAR(255) PRIMARY KEY,
	permissionString MEDIUMTEXT
);

-- foreign keys
ALTER TABLE wcf1_packageserver_package_to_group ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE;
ALTER TABLE wcf1_packageserver_package_to_user ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;