96s50K5j

1create database if not exists patruPunctNoua;
2use patruPunctNoua;
3
4create table if not exists clientt (
5ID int unique primary key auto_increment,
6nume varchar(20)
7);
8
9create table if not exists email (
10ID int,
11email varchar(20),
12foreign key (ID) references clientt(ID));
13
14create table if not exists recomandari (
15ID int,
16ClientID int,
17data date,
18foreign key (ID) references clientt(ID),
19foreign key (ClientID) references clientt(ID),
20primary key (ClientID)
21);
22
23create table if not exists contracte (
24ID int,
25foreign key (ID) references clientt(ID),
26contractID int primary key
27);
28
29create table if not exists telefon (
30ID int primary key auto_increment unique,
31model_telefon int,
32foreign key (model_telefon) references contracte(contractID)
33);
34
35create table if not exists caracteristici (
36model_telefon int,
37foreign key (model_telefon) references telefon(model_telefon),
38primary key (model_telefon),
39Bluetooth varchar(20),
40WindowsVers varchar(20),
41DimensiuneEcran varchar(20)
42);
43
44create table if not exists companie (
45ID int primary key unique auto_increment,
46numarFiscal varchar(20)
47);
48
49create table if not exists magazine (
50ID int primary key unique auto_increment,
51strada varchar(20),
52oras varchar(20),
53codPostal varchar(20)
54);
55
56alter table magazine
57add column venit int;
58
59create table if not exists dealeri (
60zona varchar(20),
61IDPartener int,
62foreign key (IDPartener) references companie(ID),
63numeDealer varchar(20)
64);