create table users(
user_id int(8) NOT NULL AUTO_INCREMENT PRIMARY KEY,
user_name VARCHAR(64) UNIQUE NOT NULL,
pass VARCHAR(64) NOT NULL
);
create table products(
product_id INTEGER(13) UNIQUE NOT NULL PRIMARY KEY,
product_name VARCHAR(64),
image VARCHAR(64),
price INTEGER(10)
);
create table pois(
poi_id INTEGER(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
user_id INTEGER(8),
product_id INTEGER(13),
date DATETIME NOT NULL,
cap TINYINT(1),
FOREIGN KEY(user_id) REFERENCES users(user_id),
FOREIGN KEY(product_id) REFERENCES products(product_id)
);
create table users(
user_id int(8) NOT NULL AUTO_INCREMENT PRIMARY KEY,
user_name VARCHAR(64) UNIQUE NOT NULL,
pass VARCHAR(64) NOT NULL
);
create table products(
product_id INTEGER(13) UNIQUE NOT NULL PRIMARY KEY,
product_name VARCHAR(64),
image VARCHAR(64),
price INTEGER(10)
);
create table pois(
poi_id INTEGER(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
user_id INTEGER(8),
product_id INTEGER(13),
date DATETIME NOT NULL,
cap TINYINT(1),
FOREIGN KEY(user_id) REFERENCES users(user_id),
FOREIGN KEY(product_id) REFERENCES products(product_id)
);