fqNMA1sG

1create database opera1;
2
3use opera1;
4
5create table if not exists admin(
6id_admin int unique,
7username varchar(255),
8parola 		 varchar(255),
9primary key(id_admin)
10);
11
12create table if not exists casier(
13id_casier int auto_increment unique,
14username varchar(255),
15parola varchar(255),
16nume varchar(255),
17primary key(id_casier)
18);
19
20create table if not exists spectacol(
21id_spectacol int auto_increment unique,
22titlu varchar(255),
23gen varchar(255),
24regia varchar(255),
25distributia varchar(255),
26data_premiera timestamp,
27nr_bilete int,
28primary key(id_spectacol)
29);
30
31create table if not exists bilet(
32id_bilet int auto_increment unique,
33rand int,
34numar int,
35id_spectacol int,
36primary key (id_bilet),
37foreign key (id_spectacol) references spectacol (id_spectacol)
38);
39
40use opera;
41select * from admin; 
42select * from bilet;
43select * from casier;
44select * from spectacol;
45
46
47use opera;
48insert into admin
49values(1, "eu", "parola");
50insert into admin 
51values (11,"admin", "8c6976e5b5410415bde908bd4dee15dfb167a9c873fc4bb8a81f6f2ab448a918");
52insert into casier
53values (1, "a","a","a", true);
54insert into spectacol
55values(1,"a","b","c","d",null, 5);
56
57insert into bilet
58values(1,1,1,1);