File indexing completed on 2024-04-21 06:00:36 

0001 CREATE TABLE `member_avatar_type`
0002 (
0003     `member_avatar_type_id` INT NOT NULL,
0004     `title`                 VARCHAR(45),
0005     PRIMARY KEY (`member_avatar_type_id`)
0006 );
0007 
0008 
0009 INSERT INTO `member_avatar_type` (`member_avatar_type_id`, `title`)
0010 VALUES (0, 'unknow');
0011 INSERT INTO `member_avatar_type` (`member_avatar_type_id`, `title`)
0012 VALUES (1, 'auto generated letter avatar');
0013 INSERT INTO `member_avatar_type` (`member_avatar_type_id`, `title`)
0014 VALUES (2, 'user uploaded');
0015 
0016 
0017 ALTER TABLE `member`
0018     ADD COLUMN `avatar_type_id` INT(11) NOT NULL DEFAULT 1 AFTER `avatar`;
0019 
0020 
0021 UPDATE `member`
0022 SET `avatar_type_id` = 0;