· 10 years ago · Aug 22, 2016, 03:10 PM
1CREATE TABLE IF NOT EXISTS `mwdpb_vat` (
2 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
3 `user_id` int(10) unsigned NOT NULL,
4 `invoice_number` varchar(100) DEFAULT NULL,
5 `invoice_date` datetime DEFAULT NULL,
6 `due_date` datetime DEFAULT NULL,
7 `description` text,
8 `customer` varchar(100) DEFAULT NULL,
9 `currency` varchar(100) DEFAULT NULL,
10 `amount` varchar(10) NOT NULL,
11 `type` varchar(10) DEFAULT NULL,
12 PRIMARY KEY (`id`),
13 UNIQUE KEY `id_UNIQUE` (`id`),
14 KEY `user_id` (`user_id`)
15) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1030 ;