ALTER TABLE new_name ADD COLUMN new_field integer;
-ALTER TABLE person ADD COLUMN is_rock_star tinyint(4) DEFAULT '1';
+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 name name varchar(20) NOT NULL;
-ALTER TABLE person CHANGE COLUMN age age integer(11) DEFAULT '18';
+ALTER TABLE person CHANGE COLUMN age age integer(11) DEFAULT 18;
-ALTER TABLE person CHANGE COLUMN iq iq integer(11) DEFAULT '0';
+ALTER TABLE person CHANGE COLUMN iq iq integer(11) DEFAULT 0;
ALTER TABLE person CHANGE COLUMN description physical_description text;
ADD COLUMN new_field integer;
ALTER TABLE person DROP INDEX UC_age_name,
- ADD COLUMN is_rock_star tinyint(4) DEFAULT '1',
+ ADD COLUMN is_rock_star tinyint(4) DEFAULT 1,
CHANGE COLUMN person_id person_id integer(11) NOT NULL 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',
+ CHANGE COLUMN age age integer(11) DEFAULT 18,
+ CHANGE COLUMN iq iq integer(11) DEFAULT 0,
CHANGE COLUMN description physical_description text,
ADD UNIQUE UC_person_id (person_id),
ADD UNIQUE UC_age_name (age, name),
ALTER TABLE person DROP INDEX UC_age_name,
DROP INDEX u_name,
- ADD COLUMN is_rock_star tinyint(4) DEFAULT '1',
+ ADD COLUMN is_rock_star tinyint(4) DEFAULT 1,
CHANGE COLUMN person_id person_id integer(11) NOT NULL 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',
+ CHANGE COLUMN age age integer(11) DEFAULT 18,
+ CHANGE COLUMN iq iq integer(11) DEFAULT 0,
CHANGE COLUMN description physical_description text,
ADD UNIQUE INDEX unique_name (name),
ADD UNIQUE UC_person_id (person_id),