· 8 years ago · Apr 23, 2018, 06:30 AM
1CREATE TABLE IF NOT EXISTS `tm_master_client` (
2 `client_id` int(11) NOT NULL AUTO_INCREMENT,
3 `client_initial` varchar(10) DEFAULT NULL,
4 `client_name` varchar(255) DEFAULT NULL,
5 `client_person` varchar(255) DEFAULT NULL,
6 `client_address` varchar(255) DEFAULT NULL,
7 `client_phone` varchar(20) DEFAULT NULL,
8 `client_fax` varchar(20) DEFAULT NULL,
9 `client_web` varchar(100) DEFAULT NULL,
10 `client_city` varchar(255) DEFAULT NULL,
11 `client_zipcode` varchar(10) DEFAULT NULL,
12 `time_add` timestamp NULL DEFAULT '0000-00-00 00:00:00',
13 `time_update` timestamp NULL DEFAULT NULL,
14 `user_add` varchar(50) DEFAULT NULL,
15 `user_update` varchar(50) DEFAULT NULL,
16 `app_id` int(11) DEFAULT NULL,
17 PRIMARY KEY (`client_id`)
18) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;