UQwnarfM

1CREATE TABLE IF NOT EXISTS `cars` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `car_brand_id` int(11) NOT NULL,
4  `car_model_id` int(11) NOT NULL,
5  `nr_inmatriculare` varchar(20) NOT NULL,
6  `filiala_id` int(11) NOT NULL,
7  `an_fabricatie` date NOT NULL,
8  `an_achizitie` date NOT NULL,
9  `created` datetime NOT NULL,
10  `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
11  `company_id` int(11) NOT NULL,
12  `serie_sasiu` varchar(100) NOT NULL,
13  `serie_carte` varchar(100) NOT NULL,
14  `culoare` varchar(100) NOT NULL,
15  `email_office` varchar(150) NOT NULL,
16  `contact_emails` text NOT NULL,
17  `status` tinyint(4) NOT NULL DEFAULT 1,
18  `comment` text NOT NULL,
19  `combustibil` smallint(6) NOT NULL COMMENT '1-benzina, 2-motorina, 3-gaz',
20  PRIMARY KEY (`id`)
21) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=latin1;