q8g8Ec1y

1DROP TABLE IF EXISTS invoice;
2CREATE TABLE `invoice` (
3  `id` int(11) NOT NULL AUTO_INCREMENT,
4  `travel_package_id` int(11) NOT NULL,
5  `client_company_id` int(11) DEFAULT NULL,
6  `client_person_id` int(11) DEFAULT NULL,
7  `subagent_package_id` varchar(50) COLLATE utf8_bin DEFAULT NULL,
8  `description_package` text COLLATE utf8_bin,
9  `invoice_note` text COLLATE utf8_bin,
10  `package_note` text COLLATE utf8_bin,
11  `created_by` int(11) NOT NULL,
12  `service_traffic_date` date DEFAULT NULL,
13  `currency_date` date DEFAULT NULL,
14  `manual_created_date` date DEFAULT NULL,
15  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
16  PRIMARY KEY (`id`)
17) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
18
19DROP TABLE IF EXISTS invoice_client_company;
20CREATE TABLE `invoice_client_company` (
21  `id` int(11) NOT NULL AUTO_INCREMENT,
22  `agency_id` int(11) NOT NULL,
23  `name` varchar(100) COLLATE utf8_bin NOT NULL,
24  `address` varchar(100) COLLATE utf8_bin DEFAULT NULL,
25  `pib` varchar(45) COLLATE utf8_bin DEFAULT NULL,
26  `phone` varchar(45) COLLATE utf8_bin DEFAULT NULL,
27  `email` varchar(45) COLLATE utf8_bin DEFAULT NULL,
28  `created_by` int(11) NOT NULL,
29  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
30  PRIMARY KEY (`id`)
31) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
32
33DROP TABLE IF EXISTS invoice_client_person;
34CREATE TABLE `invoice_client_person` (
35  `id` int(11) NOT NULL AUTO_INCREMENT,
36  `agency_id` int(11) NOT NULL,
37  `name` varchar(100) COLLATE utf8_bin NOT NULL,
38  `address` varchar(100) COLLATE utf8_bin DEFAULT NULL,
39  `social_number` varchar(45) COLLATE utf8_bin DEFAULT NULL,
40  `phone` varchar(45) COLLATE utf8_bin DEFAULT NULL,
41  `created_by` int(11) NOT NULL,
42  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
43  PRIMARY KEY (`id`)
44) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
45
46DROP TABLE IF EXISTS invoice_prices;
47CREATE TABLE `invoice_prices` (
48  `id` int(11) NOT NULL AUTO_INCREMENT,
49  `invoice_id` int(11) NOT NULL,
50  `description` varchar(255) COLLATE utf8_bin NOT NULL,
51  `price` decimal(11,2) NOT NULL,
52  `currency` varchar(45) COLLATE utf8_bin NOT NULL,
53  `quantity` int(2) unsigned NOT NULL,
54  PRIMARY KEY (`id`)
55) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;