1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
|
ALTER TABLE %PREFIX%entry MODIFY `Description` MEDIUMTEXT NOT NULL DEFAULT '';
ALTER TABLE %PREFIX%entry ADD `LastModifier` INT UNSIGNED NOT NULL AFTER `Author`;
UPDATE %PREFIX%entry SET LastModifier = Author;
ALTER TABLE %PREFIX%entry MODIFY `Author` INT UNSIGNED NOT NULL;
ALTER TABLE %PREFIX%entry MODIFY `ID` INT UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE %PREFIX%entry ADD `WhenModified` DATETIME NOT NULL AFTER `WhenEntered`;
ALTER TABLE %PREFIX%entry MODIFY `WhenEntered` DATETIME NOT NULL;
UPDATE %PREFIX%entry SET WhenModified = WhenEntered;
ALTER TABLE %PREFIX%entry ADD `Revision` INT UNSIGNED NOT NULL;
CREATE TABLE %PREFIX%revision (
`ID` INT UNSIGNED AUTO_INCREMENT UNIQUE,
`Entry` INT UNSIGNED NOT NULL,
`Data` LONGTEXT,
INDEX( `Entry` )
)
CHARACTER SET utf8
COLLATE utf8_unicode_ci
;
# TODO: Update date when we are done
UPDATE %PREFIX%meta Set Value='2009-05-11' WHERE Name='Version';
|