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
8 lines
441 B
SQL
8 lines
441 B
SQL
-- update video storage
|
|
ALTER TABLE `aowow_videos`
|
|
ADD COLUMN `pos` tinyint unsigned NOT NULL AFTER `videoId`,
|
|
ADD COLUMN `url` varchar(64) NOT NULL COMMENT 'preview thumb' AFTER `pos`,
|
|
ADD COLUMN `width` smallint unsigned NOT NULL AFTER `url`,
|
|
ADD COLUMN `height` smallint unsigned NOT NULL AFTER `width`,
|
|
ADD COLUMN `name` varchar(64) DEFAULT NULL AFTER `height`,
|
|
MODIFY COLUMN `caption` varchar(200) DEFAULT NULL;
|