Hello,
Start with a new DB and go to SQL tab and execute:
CREATE TABLE customer(
id INTEGER,
firstName TEXT,
middleName TEXT,
lastName TEXT,
address TEXT,
contactNum TEXT
);
CREATE TABLE item(
id INTEGER,
name TEXT,
description TEXT
);
CREATE TABLE orders(
id INTEGER,
customerID INTEGER,
date TEXT,
FOREIGN KEY(customerId) REFERENCES customer(id)
);
CREATE TABLE item_order(
id INTEGER,
orderID INTEGER,
itemId INTEGER,
quantity INTEGER,
FOREIGN KEY(orderId) REFERENCES orders(Id),
FOREIGN KEY(itemId) REFERENCES item(Id)
);
After you execute this, save the db.
Now switch to the "Database structure" tab, and SQLite Browser will simply close!
Now anytime you try to open that DB, the browser crashes!
Hello,
Start with a new DB and go to SQL tab and execute:
CREATE TABLE customer(
id INTEGER,
firstName TEXT,
middleName TEXT,
lastName TEXT,
address TEXT,
contactNum TEXT
);
CREATE TABLE item(
id INTEGER,
name TEXT,
description TEXT
);
CREATE TABLE orders(
id INTEGER,
customerID INTEGER,
date TEXT,
FOREIGN KEY(customerId) REFERENCES customer(id)
);
CREATE TABLE item_order(
id INTEGER,
orderID INTEGER,
itemId INTEGER,
quantity INTEGER,
FOREIGN KEY(orderId) REFERENCES orders(Id),
FOREIGN KEY(itemId) REFERENCES item(Id)
);
After you execute this, save the db.
Now switch to the "Database structure" tab, and SQLite Browser will simply close!
Now anytime you try to open that DB, the browser crashes!