ALTER TABLE new_name ADD COLUMN new_field int;
CREATE TEMPORARY TABLE person_temp_alter (
- person_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
+ person_id INTEGER PRIMARY KEY NOT NULL,
name varchar(20) NOT NULL,
age int(11) DEFAULT 18,
weight double(11,2),
iq int(11) DEFAULT 0,
is_rock_star tinyint(4) DEFAULT 1,
+ value double(8,2) DEFAULT 0.00,
physical_description text
);
-INSERT INTO person_temp_alter( person_id, name, age, weight, iq, is_rock_star, physical_description) SELECT person_id, name, age, weight, iq, is_rock_star, physical_description FROM person;
+INSERT INTO person_temp_alter( person_id, name, age, weight, iq, value, physical_description) SELECT person_id, name, age, weight, iq, value, description FROM person;
DROP TABLE person;
CREATE TABLE person (
- person_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
+ person_id INTEGER PRIMARY KEY NOT NULL,
name varchar(20) NOT NULL,
age int(11) DEFAULT 18,
weight double(11,2),
iq int(11) DEFAULT 0,
is_rock_star tinyint(4) DEFAULT 1,
+ value double(8,2) DEFAULT 0.00,
physical_description text
);
CREATE UNIQUE INDEX UC_age_name02 ON person (age, name);
-INSERT INTO person SELECT person_id, name, age, weight, iq, is_rock_star, physical_description FROM person_temp_alter;
+INSERT INTO person SELECT person_id, name, age, weight, iq, is_rock_star, value, physical_description FROM person_temp_alter;
DROP TABLE person_temp_alter;