YRP7B1SR

1SET foreign_key_checks = 0;
2DROP TABLE IF EXISTS users;
3DROP TABLE IF EXISTS advertisements ;
4SET foreign_key_checks = 1;
5
6CREATE TABLE IF NOT EXISTS users (
7	login VARCHAR(45) NOT NULL,
8	password VARCHAR(45) NOT NULL,
9	name VARCHAR(60) NOT NULL,
10	surname VARCHAR(60) NOT NULL,
11	phone VARCHAR(15) NOT NULL,
12	mail VARCHAR(60) NOT NULL,
13	date BIGINT NOT NULL DEFAULT 0,
14	lastactive BIGINT NOT NULL DEFAULT 0,
15	PRIMARY KEY (login)
16);
17
18CREATE TABLE IF NOT EXISTS advertisements (
19	id BIGINT NOT NULL AUTO_INCREMENT,
20	user VARCHAR(45) NOT NULL,
21	info VARCHAR(60) NOT NULL,
22	PRIMARY KEY (id),
23	FOREIGN KEY (user) REFERENCES users(login)
24);