iQiS9byV

1DROP DATABASE IF EXISTS myDB;
2CREATE DATABASE myDB;
3use myDB;
4CREATE TABLE users(
5id INTEGER PRIMARY KEY  AUTO_INCREMENT,
6login VARCHAR(20) NOT NULL UNIQUE
7);
8
9CREATE TABLE groups(
10id INTEGER PRIMARY KEY NOT NULL AUTO_INCREMENT,
11name VARCHAR(30) NOT NULL
12);
13
14CREATE TABLE users_groups(
15user_id INTEGER REFERENCES users(id) ,
16group_id INTEGER REFERENCES groups(id)
17
18);
19
20INSERT INTO users VALUES(DEFAULT, 'Zhora');
21INSERT INTO users VALUES(DEFAULT, 'Grigory');
22INSERT INTO users VALUES(DEFAULT, 'admin');
23
24INSERT INTO groups VALUES(DEFAULT, 'simply_user');
25INSERT INTO groups VALUES(DEFAULT, 'simply_user');
26INSERT INTO groups VALUES(DEFAULT, 'admin');
27
28SELECT * FROM users;
29
30SELECT * FROM groups;