Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE users (
- id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
- name CHAR (30),
- email CHAR(30)
- );
- CREATE TABLE groups (
- id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
- g_name CHAR (30),
- description CHAR(30)
- );
- CREATE TABLE users_groups (
- id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
- u_id INT,
- g_id INT,
- FOREIGN KEY (u_id) REFERENCES users(id),
- FOREIGN KEY (g_id) REFERENCES groups(id)
- );
- INSERT INTO users(id, name, email)
- VALUES
- (1,'Курятник', 'stanislav.kuryatnik@mail.ru'),
- (2,'Кравчук', 'pulsarv@rambler.ru'),
- (3,'Кравчук', 'leybal@ukr.net'),
- (4,'Ткачук', 'fabri4eg@gmail.com'),
- (5,'Журило', 'fumus.27@gmail.com'),
- (6,'Урбанас', 'viktornord1@gmail.com'),
- (7,'Шемшур', 'shemshur90@gmail.com'),
- (8,'Письменний', 'lpie@hotmail.com'),
- (9,'Козека', 'kozeka.alex@gmail.com'),
- (10,'Сиротчук', 'qweasz@ukr.net'),
- (11,'Сиротчук', 'adimetra@rambler.ru'),
- (12,'Бородько', '220v2@mail.ru'),
- (13,'Мельник', 'wmsystem2008@yandex.ru'),
- (14,'Вихрист', 'vyhrystmax@gmail.com'),
- (15,'Сергієнко', 'geekhub@ukr.net'),
- (16,'Міщенко', 'olegigm@gmail.com'),
- (17,'Рупп', 'rupp1993@gmail.com'),
- (18,'Безпоясний', 'kongolez@ukr.net'),
- (19,'Ткаченко', 'victor-t@ukr.net'),
- (20,'Михайловскимй', 'vsmihaylovsky@gmail.com');
- INSERT INTO groups(id, g_name, description)
- VALUES
- (1, 'Rock', 'The show most go on'),
- (2, 'Pop', 'Some description'),
- (3, 'Dance', 'Have a good time'),
- (4, 'Rap', 'Some another description');
- INSERT INTO users_groups(id, u_id, g_id)
- VALUES
- (1, 1, 1),
- (2, 2, 2),
- (3, 3, 2),
- (4, 4, 3),
- (5, 5, 1),
- (6, 6, 1),
- (7, 7, 1),
- (8, 8, 4),
- (9, 9, 3),
- (10,10, 1),
- (11,11, 1),
- (12,12, 2),
- (13,13, 4),
- (14,14, 1),
- (15,15, 1),
- (16,16, 3),
- (17,17, 2),
- (18,18, 1),
- (19,19, 1),
- (20,20, 2);
- (21,20, 1);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement