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 47 48 49 50 51 52 53
| CREATE TABLE zz_operator (
operator_id int(4) NOT NULL,
operator_name varchar(64) NOT NULL,
PRIMARY KEY(operator_id)
);
CREATE TABLE zz_billing (
client_id int(10) NOT NULL,
compte_id varchar(16) NOT NULL,
product_id varchar(16) NOT NULL,
product_name varchar(128) NOT NULL,
price int(5) NOT NULL,
billing_date datetime NOT NULL,
operator_id int(4) NOT NULL,
broadcaster_id varchar(8) NOT NULL,
PRIMARY KEY(client_id,compte_id,billing_date,product_id)
);
CREATE TABLE zz_broadcaster (
broadcaster_id char(8) NOT NULL,
broadcaster_name varchar(64) NOT NULL,
PRIMARY KEY(broadcaster_id)
);
INSERT INTO zz_operator VALUES ('3','PARIS');
INSERT INTO zz_operator VALUES ('12','ANGERS');
INSERT INTO zz_operator VALUES ('15','LYON');
INSERT INTO zz_operator VALUES ('16','LILLE');
INSERT INTO zz_operator VALUES ('17','NICE');
INSERT INTO zz_operator VALUES ('24','ORLEANS');
INSERT INTO zz_broadcaster VALUES ('INT','INTERNET');
INSERT INTO zz_broadcaster VALUES ('PRP','PROSPEC');
INSERT INTO zz_broadcaster VALUES ('TEL','TELEPHONE');
INSERT INTO zz_broadcaster VALUES ('BTQ','BOUTIQUE');
INSERT INTO zz_broadcaster VALUES ('DRT','DIRECT');
INSERT INTO zz_broadcaster VALUES ('EVT','EVENEMENT');
INSERT INTO zz_billing VALUES ('053003','47410','DRT01351','LIT','399','20091101205716','3','DRT');
INSERT INTO zz_billing VALUES ('053411','67308','INT39429','TABLE','399','20091030210749','12','INT');
INSERT INTO zz_billing VALUES ('053411','67308','INT38721','CHAISE','499','20091031214001','12','INT');
INSERT INTO zz_billing VALUES ('054420','10187','PRPP12922','STYLO','0','20091029055853','15','PRP');
INSERT INTO zz_billing VALUES ('054420','10187','PRPP13039','CAHIER','0','20091029060050','15','PRP');
INSERT INTO zz_billing VALUES ('054420','10187','PRPP13040','ECRAN','0','20091029064530','15','PRP');
INSERT INTO zz_billing VALUES ('054420','10187','PRPP12992','SOURIS','0','20091030184130','15','PRP');
INSERT INTO zz_billing VALUES ('054420','10187','PRPP12753','CLAVIER','0','20091101073241','15','PRP');
INSERT INTO zz_billing VALUES ('054420','10187','PRPP12926','RAM','0','20091102180806','15','PRP');
INSERT INTO zz_billing VALUES ('054778','84001','INT39551','CPU','399','20091030203632','3','INT');
INSERT INTO zz_billing VALUES ('054787','86069','BTQ73002','CARNET','799','20091101205317','3','BTQ');
INSERT INTO zz_billing VALUES ('054790','88379','INT38873','FEUILLE','499','20091101204457','3','INT');
INSERT INTO zz_billing VALUES ('054790','88379','BTQ40768','CABLE','599','20091103014128','3','BTQ');
INSERT INTO zz_billing VALUES ('054790','88379','TEL0502071803','TELEPHONE','399','20091103222405','3','TEL');
INSERT INTO zz_billing VALUES ('054810','95184','PRPP12629','CLEF','0','20091030180650','3','PRP');
INSERT INTO zz_billing VALUES ('054977','29288','EVT03306','SERRURE','499','20091102095958','15','EVT');
INSERT INTO zz_billing VALUES ('055186','44143','INT36401','PORTE','399','20091103210321','3','INT');
INSERT INTO zz_billing VALUES ('055464','08394','INT37865','ARMOIRE','499','20091029204543','3','INT');
INSERT INTO zz_billing VALUES ('055602','34565','INT38886','LAVABO','399','20091101135720','17','INT');
INSERT INTO zz_billing VALUES ('055623','44102','INT36395','PEIGNE','399','20091102160823','16','INT'); |
Partager