ALTER TABLE person ADD COLUMN is_rock_star tinyint(4) DEFAULT 1;
-ALTER TABLE person CHANGE COLUMN person_id person_id integer(11) NOT NULL auto_increment;
+ALTER TABLE person CHANGE COLUMN person_id person_id integer(11) auto_increment;
ALTER TABLE person CHANGE COLUMN name name varchar(20) NOT NULL;
ALTER TABLE person DROP INDEX UC_age_name,
ADD COLUMN is_rock_star tinyint(4) DEFAULT 1,
- CHANGE COLUMN person_id person_id integer(11) NOT NULL auto_increment,
+ CHANGE COLUMN person_id person_id integer(11) auto_increment,
CHANGE COLUMN name name varchar(20) NOT NULL,
CHANGE COLUMN age age integer(11) DEFAULT 18,
CHANGE COLUMN iq iq integer(11) DEFAULT 0,
ALTER TABLE person DROP INDEX UC_age_name,
DROP INDEX u_name,
ADD COLUMN is_rock_star tinyint(4) DEFAULT 1,
- CHANGE COLUMN person_id person_id integer(11) NOT NULL auto_increment,
+ CHANGE COLUMN person_id person_id integer(11) auto_increment,
CHANGE COLUMN name name varchar(20) NOT NULL,
CHANGE COLUMN age age integer(11) DEFAULT 18,
CHANGE COLUMN iq iq integer(11) DEFAULT 0,