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),
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),