USE dbadapter;


/************ Update: Tables ***************/

/******************** Add Table: bar ************************/

/* Build Table Structure */
CREATE TABLE bar
(
	id INTEGER NOT NULL IDENTITY (1, 1)
);

/* Table Items: bar */
ALTER TABLE bar ADD CONSTRAINT pkbar
	PRIMARY KEY (id);

/******************** Add Table: foo ************************/

/* Build Table Structure */
CREATE TABLE foo
(
	id INTEGER NOT NULL IDENTITY (1, 1),
	f1 INTEGER NOT NULL,
	f2 TEXT NOT NULL,
	f3 TEXT NOT NULL,
	f4 DATETIME NOT NULL,
	f5 INTEGER NOT NULL DEFAULT 1,
	f6 INTEGER NOT NULL DEFAULT 0,
	f7 INTEGER NOT NULL DEFAULT 2,
	f8 INTEGER NOT NULL DEFAULT 8,
	f10 INTEGER NOT NULL DEFAULT 0,
	f11 INTEGER NOT NULL DEFAULT 0,
	f12 TEXT NOT NULL,
	f15 INTEGER NOT NULL DEFAULT 0
);

/* Table Items: foo */
ALTER TABLE foo ADD CONSTRAINT pkfoo
	PRIMARY KEY (id);

/******************** Add Table: table1 ************************/

/* Build Table Structure */
CREATE TABLE table1
(
	id INTEGER NOT NULL,
	name VARCHAR(50) NOT NULL,
	InsertBy VARCHAR(50) NOT NULL,
	UpdateBy VARCHAR(50) NOT NULL,
	UpdateTime TIMESTAMP NOT NULL,
	col1 INTEGER NOT NULL DEFAULT 0,
	col2 INTEGER NOT NULL DEFAULT 0,
	col3 INTEGER NOT NULL DEFAULT 0
);

/* Table Items: table1 */
ALTER TABLE table1 ADD CONSTRAINT pktable1
	PRIMARY KEY (id);

/******************** Add Table: table2 ************************/

/* Build Table Structure */
CREATE TABLE table2
(
	id INTEGER NOT NULL,
	name VARCHAR(50) NOT NULL,
	InsertBy VARCHAR(50) NOT NULL,
	UpdateBy VARCHAR(50) NOT NULL,
	UpdateTime TIMESTAMP NOT NULL,
	col1 INTEGER NOT NULL DEFAULT 0,
	col2 INTEGER NOT NULL DEFAULT 0,
	col3 INTEGER NOT NULL DEFAULT 0
);

/* Table Items: table2 */
ALTER TABLE table2 ADD CONSTRAINT pktable2
	PRIMARY KEY (id);

/******************** Add Table: table3 ************************/

/* Build Table Structure */
CREATE TABLE table3
(
	id INTEGER NOT NULL,
	f1 VARCHAR(50) NOT NULL,
	f2 VARCHAR(50) NOT NULL,
	f3 VARCHAR(50) NOT NULL
);

/* Table Items: table3 */
ALTER TABLE table3 ADD CONSTRAINT pktable3
	PRIMARY KEY (id);

/******************** Add Table: table4 ************************/

/* Build Table Structure */
CREATE TABLE table4
(
	id INTEGER NOT NULL IDENTITY (1, 1),
	name TEXT NOT NULL
);

/* Table Items: table4 */
ALTER TABLE table4 ADD CONSTRAINT pktable4
	PRIMARY KEY (id);

/******************** Add Table: table5 ************************/

/* Build Table Structure */
CREATE TABLE table5
(
	id INTEGER NOT NULL IDENTITY (1, 1),
	fooid INTEGER NOT NULL,
	f1 TEXT NOT NULL,
	f2 TEXT NOT NULL,
	f3 TEXT NOT NULL,
	f4 TEXT NOT NULL
);

/* Table Items: table5 */
ALTER TABLE table5 ADD CONSTRAINT pktable5
	PRIMARY KEY (id);

/******************** Add Table: table6 ************************/

/* Build Table Structure */
CREATE TABLE table6
(
	id INTEGER NOT NULL IDENTITY (1, 1),
	f1 INTEGER NOT NULL DEFAULT 0
);

/* Table Items: table6 */
ALTER TABLE table6 ADD CONSTRAINT pktable6
	PRIMARY KEY (id);

/******************** Add Table: table7 ************************/

/* Build Table Structure */
CREATE TABLE table7
(
	id INTEGER NOT NULL IDENTITY (1, 1),
	f1 TEXT NOT NULL
);

/* Table Items: table7 */
ALTER TABLE table7 ADD CONSTRAINT pktable7
	PRIMARY KEY (id);


/************ Add Foreign Keys to Database ***************/

/************ Foreign Key: fk_table5_foo ***************/
ALTER TABLE table5 ADD CONSTRAINT fk_table5_foo
	FOREIGN KEY (fooid) REFERENCES foo (id);