647be4a946
* move sql files into its own folder. * move outdated updates out of the update folder, sorted by github tags * split up the db dump so my editor doesn't try to hang itself if i dare to touch that file
7 lines
460 B
SQL
7 lines
460 B
SQL
ALTER TABLE `aowow_articles`
|
|
CHANGE COLUMN `type` `type` SMALLINT(5) NULL DEFAULT NULL FIRST,
|
|
CHANGE COLUMN `typeId` `typeId` MEDIUMINT(9) NULL DEFAULT NULL AFTER `type`,
|
|
CHANGE COLUMN `locale` `locale` TINYINT(4) UNSIGNED NOT NULL AFTER `typeId`,
|
|
ADD COLUMN `url` VARCHAR(50) NULL DEFAULT NULL AFTER `locale`,
|
|
ADD COLUMN `editAccess` SMALLINT UNSIGNED NOT NULL DEFAULT '2' AFTER `url`,
|
|
ADD UNIQUE INDEX `locale_url` (`locale`, `url`);
|