mirror of
https://github.com/sphildreth/roadie
synced 2024-09-19 22:21:58 +00:00
3 lines
No EOL
206 B
SQL
3 lines
No EOL
206 B
SQL
-- Add new column to Genre for Normalized Name < 1.0.2.1 database
|
|
ALTER TABLE `genre` ADD `normalizedName` varchar(100) NULL;
|
|
CREATE INDEX `genre_normalizedName_IDX` USING BTREE ON `genre` (normalizedName); |