Pastebin

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,
        InsertTime TIMESTAMP 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,
        InsertTime TIMESTAMP 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);