1 1. Add DepDesc column to PackageDepends and split dependency names:
4 ALTER TABLE PackageDepends ADD COLUMN DepDesc VARCHAR(255) NULL DEFAULT NULL;
6 SET DepDesc = SUBSTRING(DepName FROM POSITION(': ' IN DepName) + 2)
7 WHERE POSITION(': ' IN DepName) > 0;
9 SET DepName = SUBSTRING(DepName FROM 1 FOR POSITION(': ' IN DepName) - 1)
10 WHERE POSITION(': ' IN DepName) > 0;
13 2. Add RenderedComment column to PackageComments:
16 ALTER TABLE PackageComments ADD COLUMN RenderedComment TEXT NOT NULL;
19 3. Add Terms and AcceptedTerms tables:
23 ID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
24 Description VARCHAR(255) NOT NULL,
25 URL VARCHAR(8000) NOT NULL,
26 Revision INTEGER UNSIGNED NOT NULL DEFAULT 1,
30 CREATE TABLE AcceptedTerms (
31 UsersID INTEGER UNSIGNED NOT NULL,
32 TermsID INTEGER UNSIGNED NOT NULL,
33 Revision INTEGER UNSIGNED NOT NULL DEFAULT 0,
34 FOREIGN KEY (UsersID) REFERENCES Users(ID) ON DELETE CASCADE,
35 FOREIGN KEY (TermsID) REFERENCES Terms(ID) ON DELETE CASCADE