76C3dqGg

1sqlite3_exec(database, "CREATE TABLE IF NOT EXISTS ODOMETER ( odometerId  INTEGER NOT NULL PRIMARY KEY, carId INTEGER NOT NULL, year INTEGER, startOdometer INTEGER, startOdometerDate	DATETIME, endOdometer INTEGER, endOdometerDate	DATETIME)", NULL, NULL, NULL);		
2		sqlite3_exec(database, "INSERT INTO ODOMETER (odometerId, carId, year, startOdometer, startOdometerDate, endOdometer, endOdometerDate)  SELECT carId, carId, 2009, startOdometer, startOdometerDate, endOdometer, endOdometerDate FROM CAR", NULL, NULL, NULL);		
3		sqlite3_exec(database, "CREATE TEMPORARY TABLE X (carId INTEGER NOT NULL PRIMARY KEY, make  VARCHAR (50), model   VARCHAR (50), licenseNum  VARCHAR (20), isDefault   CHAR (1))", NULL, NULL, NULL);		
4		sqlite3_exec(database, "INSERT INTO X SELECT carId, make, model, licenseNum, isDefault FROM CAR", NULL, NULL, NULL);
5		sqlite3_exec(database,"DROP TABLE CAR", NULL, NULL, NULL);
6		sqlite3_exec(database,"CREATE TABLE CAR (carId INTEGER NOT NULL PRIMARY KEY, make              VARCHAR (50), model             VARCHAR (50), licenseNum           VARCHAR (20), isDefault        CHAR (1) )", NULL, NULL, NULL);
7		sqlite3_exec(database,"INSERT INTO CAR SELECT * FROM X", NULL, NULL, NULL);	
8		sqlite3_exec(database,"DROP TABLE X", NULL, NULL, NULL);