KbdefqqX

1CREATE DATABASE IF NOT EXISTS appDB;
2CREATE USER IF NOT EXISTS 'user'@'%' IDENTIFIED BY 'password';
3-- GRANT ALL PRIVILEGES ON appDB.* TO 'user'@'%' IDENTIFIED BY 'secret';
4FLUSH PRIVILEGES;
5
6USE appDB;
7CREATE TABLE IF NOT EXISTS users (
8  ID INT(11) NOT NULL AUTO_INCREMENT,
9  name VARCHAR(20) NOT NULL,
10  surname VARCHAR(40) NOT NULL,
11  PRIMARY KEY (ID)
12);
13
14INSERT INTO users (name, surname)
15SELECT * FROM (SELECT 'Alex', 'Rover') AS tmp
16WHERE NOT EXISTS (
17    SELECT name FROM users WHERE name = 'Alex' AND surname = 'Rover'
18) LIMIT 1;
19
20INSERT INTO users (name, surname)
21SELECT * FROM (SELECT 'Bob', 'Marley') AS tmp
22WHERE NOT EXISTS (
23    SELECT name FROM users WHERE name = 'Bob' AND surname = 'Marley'
24) LIMIT 1;
25
26INSERT INTO users (name, surname)
27SELECT * FROM (SELECT 'Alex', 'Rover') AS tmp
28WHERE NOT EXISTS (
29    SELECT name FROM users WHERE name = 'Alex' AND surname = 'Rover'
30) LIMIT 1;
31
32INSERT INTO users (name, surname)
33SELECT * FROM (SELECT 'Kate', 'Yandson') AS tmp
34WHERE NOT EXISTS (
35    SELECT name FROM users WHERE name = 'Kate' AND surname = 'Yandson'
36) LIMIT 1;
37
38INSERT INTO users (name, surname)
39SELECT * FROM (SELECT 'Lilo', 'Black') AS tmp
40WHERE NOT EXISTS (
41    SELECT name FROM users WHERE name = 'Lilo' AND surname = 'Black'
42) LIMIT 1;