-
Notifications
You must be signed in to change notification settings - Fork 1
/
Test.db
7 lines (7 loc) · 6.04 KB
/
Test.db
1
SQLite format 3 @ o o -�} ��N� �m!!�%tableItemReviewItemReviewCREATE TABLE ItemReview(id INTEGER PRIMARY KEY, Rating INT, Item_id INTEGER, Account_id INTEGER, Description TEXT, FOREIGN KEY(Item_id) REFERENCES Item(id), FOREIGN KEY(Account_id) REFERENCES Account(id))�Z�tableCartEntryCartEntryCREATE TABLE CartEntry(id INTEGER PRIMARY KEY, Quantity INT, Item_id INTEGER, Account_id INTEGER, FOREIGN KEY(Item_id) REFERENCES Item(id), FOREIGN KEY(Account_id) REFERENCES Account(id))~�StableAccountAccountCREATE TABLE Account(id INTEGER PRIMARY KEY, Pass TEXT, Type INT, Username TEXT, Email TEXT UNIQUE)-A indexsqlite_autoindex_Account_1Account }�]tableItemItemCREATE TABLE Item(id INTEGER PRIMARY KEY, Name TEXT, PriceDollars INT, PriceCents INT, Description TEXT) � TestccTest item � &'password [email protected]