CREATE TABLE Products (
prodid VARCHAR(32) NOT NULL PRIMARY KEY, INDEX (prodid),
catid VARCHAR(32) NOT NULL REFERENCES Categories,
description VARCHAR(255) NOT NULL
);
CREATE TABLE Categories (
catid VARCHAR(32) NOT NULL PRIMARY KEY, INDEX (catid),
title VARCHAR(64) NOT NULL,
parent VARCHAR(32) NOT NULL REFERENCES Categories
);
CREATE TABLE Customers (
login VARCHAR(32) NOT NULL PRIMARY KEY, INDEX (login),
name VARCHAR(255) NOT NULL,
password VARCHAR(32) NOT NULL,
email VARCHAR(255),
address VARCHAR(255) NOT NULL
);
CREATE TABLE Sessions (
sessionid VARCHAR(32) NOT NULL PRIMARY KEY,
INDEX (sessionid),
login VARCHAR(32) REFERENCES Customer,
start DATETIME NOT NULL,
lastuse DATETIME NOT NULL
);
CREATE TABLE Carts (
sessionid VARCHAR(32) NOT NULL REFERENCES Session,
prodid VARCHAR(32) NOT NULL REFERENCES Products,
quantity INTEGER,
PRIMARY KEY (sessionid, prodid)
);
|