CREATE DATABASE `recoltabogata_xhost_ro01` /*!40100 DEFAULTCHARACTER SET latin1 */;

USE recoltabogata_xhost_ro01;

CREATE TABLE `clienti` (

  `id_client` int(11)NOT NULL,

  `nume` varchar(30)NOT NULL,

  KEY `id_client`(`id_client`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO clienti(`id_client`, `nume`) VALUES('1','Chiticariu Laurentiu');

INSERT INTO clienti(`id_client`, `nume`) VALUES('2','Chiticariu Lura');

INSERT INTO clienti(`id_client`, `nume`) VALUES('3','Bosinceanu Cristian');

CREATE TABLE `comenzi` (

  `id_client` int(11)NOT NULL,

  `id_produs` int(11)NOT NULL,

  `cantitate` int(11)NOT NULL,

  PRIMARY KEY  (`id_client`),

  KEY `id_produs`(`id_produs`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `produse` (

  `id_produs` int(11)NOT NULL,

  `nume` varchar(30)NOT NULL,

  `pret` int(11) NOTNULL,

  PRIMARY KEY  (`id_produs`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO produse(`id_produs`, `nume`, `pret`) VALUES('1','Unitate Centrala', '500');

INSERT INTO produse(`id_produs`, `nume`, `pret`) VALUES('2','Monitor', '200');

INSERT INTO produse(`id_produs`, `nume`, `pret`) VALUES('3','Tastatura', '100');

INSERT INTO produse(`id_produs`, `nume`, `pret`) VALUES('4','Mouse', '100');

INSERT INTO produse(`id_produs`, `nume`, `pret`) VALUES('5','Sistem Audio', '150');

INSERT INTO produse(`id_produs`, `nume`, `pret`) VALUES('6','Laptop', '1000');

INSERT INTO produse(`id_produs`, `nume`, `pret`) VALUES('7','Imprimanta', '300');