Commit | Line | Data |
---|---|---|
5600b2fe SJ |
1 | ALTER TABLE profile_name_enum ADD COLUMN general_type ENUM('lastname', 'firstname', 'nickname') NOT NULL DEFAULT 'lastname'; |
2 | ||
3 | UPDATE profile_name_enum | |
4 | SET general_type = 'lastname' | |
5 | WHERE type LIKE 'lastname%' OR type LIKE 'name_%'; | |
6 | UPDATE profile_name_enum | |
7 | SET general_type = 'firstname' | |
8 | WHERE type LIKE 'firstname%'; | |
9 | UPDATE profile_name_enum | |
10 | SET general_type = 'nickname' | |
11 | WHERE type IN ('pseudonym', 'nickname'); | |
12 | ||
13 | ALTER TABLE search_name ADD COLUMN general_type ENUM('lastname', 'firstname', 'nickname') NOT NULL DEFAULT 'lastname'; | |
14 | ||
15 | -- vim:set syntax=mysql: |