Subversion Repositories SmartDukaan

Rev

Blame | Last modification | View Log | RSS feed 

SQLite format 3@  ñûöñ





½½!g‚a''…table__main___item__main___itemCREATE TABLE __main___item (
        id INTEGER NOT NULL, 
        catalog_item_id INTEGER, 
        vendor_item_id INTEGER, 
        feature_id INTEGER, 
        feature_description VARCHAR(200), 
        "addedOn" TIMESTAMP, 
        status INTEGER, 
        "initDate" TIMESTAMP, 
        "startDate" TIMESTAMP, 
        "retireDate" TIMESTAMP, 
        weight FLOAT, 
        PRIMARY KEY (id)
)‚C99„!table__main___itemchangelog__main___itemchangelogCREATE TABLE __main___itemchangelog (
        id INTEGER NOT NULL, 
        old_status INTEGER, 
        new_status INTEGER, 
        timestamp TIMESTAMP, 
        item_id INTEGER, 
        PRIMARY KEY (id), 
         CONSTRAINT __main___itemchangelog_item_id_fk FOREIGN KEY(item_id) REFERENCES __main___item (id)
)O91indexix___main___itemchangelog_item_id__main___itemchangelogCREATE INDEX ix___main___itemchangelog_item_id ON __main___itemchangelog (item_id)
8½Ç?‚//ƒ]table__main___iteminfo__main___iteminfoCREATE TABLE __main___iteminfo (
        id INTEGER NOT NULL, 
        "key" VARCHAR(30), 
        value VARCHAR(100), 
        item_id INTEGER, 
        PRIMARY KEY (id), 
         CONSTRAINT __main___iteminfo_item_id_fk FOREIGN KEY(item_id) REFERENCES __main___item (id)
)E/indexix___main___iteminfo_item_id__main___iteminfoCREATE INDEX ix___main___iteminfo_item_id ON __main___iteminfo (item_id)‚))ƒItable__main___price__main___price   CREATE TABLE __main___price (
        id INTEGER NOT NULL, 
        price FLOAT, 
        warehouse_id INTEGER, 
        item_id INTEGER, 
        PRIMARY KEY (id), 
         CONSTRAINT __main___price_item_id_fk FOREIGN KEY(item_id) REFERENCES __main___item (id)
)v?)indexix___main___price_item_id__main___price
CREATE INDEX ix___main___price_item_id ON __main___price (item_id)>11‚'table__main___warehouse__main___warehouseCREATE TABLE __main___warehouse (
        id INTEGER NOT NULL, 
        location VARCHAR(20), 
        status INTEGER, 
        "addedOn" TIMESTAMP, 
        PRIMARY KEY (id)
)





§§‡Kƒ] GG†9table__main___iteminventoryhistory__main___iteminventoryhistoryCREATE TABLE __main___iteminventoryhistory (
        id INTEGER NOT NULL, 
        timestamp TIMESTAMP, 
        availibility INTEGER, 
        item_id INTEGER, 
        warehouse_id INTEGER, 
        PRIMARY KEY (id), 
         CONSTRAINT __main___iteminventoryhistory_item_id_fk FOREIGN KEY(item_id) REFERENCES __main___item (id), 
         CONSTRAINT __main___iteminventoryhistory_warehouse_id_fk FOREIGN KEY(warehouse_id) REFERENCES __main___warehouse (id)
)A
gGaindexix___main___iteminventoryhistory_warehouse_id__main___iteminventoryhistoryCREATE INDEX ix___main___iteminventoryhistory_warehouse_id ON __main___iteminventoryhistory (warehouse_id)2]GMindexix___main___iteminventoryhistory_item_id__main___iteminventoryhistoryCREATE INDEX ix___main___iteminventoryhistory_item_id ON __main___iteminventoryhistory (item_id)



q
6qBeO]indexix___main___currentinventorysnapshot_item_id__main___currentinventorysnapshotCREATE INDEX ix___main___currentinventorysnapshot_item_id ON __main___currentinventorysnapshot (item_id)Q
oOqindexix___main___currentinventorysnapshot_warehouse_id__main___currentinventorysnapshotCREATE INDEX ix___main___currentinventorysnapshot_warehouse_id ON __main___currentinventorysnapshot (warehouse_id)ƒsOO†Utable__main___currentinventorysnapshot__main___currentinventorysnapshotCREATE TABLE __main___currentinventorysnapshot (
        id INTEGER NOT NULL, 
        "checkedOn" TIMESTAMP, 
        availibility INTEGER, 
        item_id INTEGER, 
        warehouse_id INTEGER, 
        PRIMARY KEY (id), 
         CONSTRAINT __main___currentinventorysnapshot_item_id_fk FOREIGN KEY(item_id) REFERENCES __main___item (id), 
         CONSTRAINT __main___currentinventorysnapshot_warehouse_id_fk FOREIGN KEY(warehouse_id) REFERENCES __main___warehouse (id)
)