-
Notifications
You must be signed in to change notification settings - Fork 0
/
sql_fitness
46 lines (34 loc) · 1.75 KB
/
sql_fitness
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
login as root
CREATE USER 'student'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'student'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'student'@'localhost' IDENTIFIED BY 'password';
mysql -u student -p
CREATE DATABASE Sporteezone
CHARACTER SET utf8mb4
COLLATE utf8mb4_czech_ci;
USE Sporteezone;
DROP table fitness;
CREATE TABLE fitness
(
id INT PRIMARY KEY AUTO_INCREMENT,
nazev VARCHAR(50),
url VARCHAR(70),
ulice VARCHAR(30),
mesto VARCHAR(20),
psc INT(5),
multisport BOOLEAN,
activepass BOOLEAN,
platba VARCHAR(30),
pohlavi VARCHAR(10),
mhd BOOLEAN
);
INSERT INTO fitness (nazev, url, ulice, mesto, psc, multisport, activepass, platba, pohlavi, mhd)
VALUES ("Fitness centrum AFIT", "www.afit.cz", "Táborská 157", "Brno", 61500, 1, 1, "Benefit plus Edenred Sodexo", "muži/ženy", 1);
INSERT INTO fitness (nazev, url, ulice, mesto, psc, multisport, activepass, platba, pohlavi, mhd)
VALUES ('Fitness Blue Gym', 'www.bluegym.cz', 'Kotlářská 51a', 'Brno', '60200', 1, 0, '', 'muži/ženy', 1);
INSERT INTO fitness (nazev, url, ulice, mesto, psc, multisport, activepass, platba, pohlavi, mhd)
VALUES ('BFIT.CZ', 'www.bfit.cz', 'Veveří 455/8', 'Brno', '60200', NULL, NULL, NULL, 'muži/ženy', 1);
INSERT INTO fitness (nazev, url, ulice, mesto, psc, multisport, activepass, platba, pohlavi, mhd)
VALUES ('Myfit', 'www.myfit.cz', 'tř. Kapitána Jaroše 7b', 'Brno', 60200, 1, 0, 'Benefit plus Edenred Sodexo', 'muži/ženy', 1);
INSERT INTO fitness (nazev, url, ulice, mesto, psc, multisport, activepass, platba, pohlavi, mhd)
VALUES ('Weisser Sport Centrum', 'wwww.weissersportcentrum.cz', 'Tůmova 12', 'Brno', 61600, 1, 1, NULL, 'muži/ženy', 1);