X7ms9Qhe

1drop database diana;
2create database diana;
3use diana;
4
5
6
7create table if not exists clienti
8(
9	cnp varchar(13) primary key,
10	nume varchar(20) not null,
11	preume varchar(20) not null,
12	adresa varchar(40),
13	email varchar(20),
14	telefon varchar(20),
15	cont varchar(20),
16	data_contract date,
17	tip int,
18	puncte int, 
19	sold int,
20	check (tip IN ('BZ','AR','AU', 'PL')),
21	check (email like '%@%.%')
22);# MySQL returned an empty result set (i.e. zero rows).
23
24
25create table if not exists facturi
26(
27	id_factura int primary key,
28	cnp varchar(13) not null,
29	serie_numar varchar(10),
30	emitere date,
31	scadenta date
32);# MySQL returned an empty result set (i.e. zero rows).
33
34
35create table if not exists detalii
36(
37	id_factura int not null,
38	id_serviciu int not null,
39	cantitate int not null,
40	check (cantitate > 0),
41    primary key (id_factura, id_serviciu)
42);# MySQL returned an empty result set (i.e. zero rows).
43
44
45create table if not exists servicii
46(
47	id_serviciu int primary key,
48	denumire varchar(50) not null,
49	pret int not null,
50	descriere text,
51	check (pret > 0)
52);# MySQL returned an empty result set (i.e. zero rows).