· 8 years ago · Mar 28, 2018, 05:54 AM
1CREATE TABLE IF NOT EXISTS `creditors` (
2 `id` int(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
3 `name` varchar(50) NOT NULL,
4 `route` varchar(255) NOT NULL,
5 `mobile` int(10) NOT NULL,
6 `credit_amount` double(100) NOT NULL,
7 `start_date` date NOT NULL,
8 `due_date` date NOT NULL,
9 UNIQUE KEY `idUnique` (`id`)
10) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1