CREATE TABLE IF NOT EXISTS `customer` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`did` varchar(40) NOT NULL,
`cname` varchar(100) NOT NULL,
`acname` varchar(100) NOT NULL,
`org` varchar(100) NOT NULL,
`address` varchar(255) NOT NULL,
`street` varchar(255) NOT NULL,
`city` varchar(100) NOT NULL DEFAULT '0',
`state` varchar(100) NOT NULL DEFAULT '0',
`country` varchar(100) NOT NULL,
`pin` varchar(50) NOT NULL,
`ph` varchar(50) NOT NULL,
`mob` varchar(50) NOT NULL,
`fax` varchar(75) NOT NULL,
`aphone` varchar(50) NOT NULL,
`web` varchar(100) NOT NULL,
`email` varchar(100) NOT NULL,
`aemail` varchar(100) NOT NULL,
`desig` varchar(255) NOT NULL,
`dept` varchar(255) NOT NULL,
`b_cname` varchar(100) NOT NULL,
`b_acname` varchar(100) NOT NULL,
`b_org` varchar(100) NOT NULL,
`b_address` varchar(100) NOT NULL,
`b_street` varchar(255) NOT NULL,
`b_city` varchar(100) NOT NULL DEFAULT '0',
`b_state` varchar(100) NOT NULL DEFAULT '0',
`b_country` varchar(100) NOT NULL,
`b_pin` varchar(50) NOT NULL,
`b_ph` varchar(50) NOT NULL,
`b_mob` varchar(50) NOT NULL,
`b_fax` varchar(75) NOT NULL,
`b_aphone` varchar(50) NOT NULL,
`b_web` varchar(100) NOT NULL,
`b_email` varchar(100) NOT NULL,
`b_aemail` varchar(100) NOT NULL,
`b_desig` varchar(255) NOT NULL,
`b_dept` varchar(255) NOT NULL,
`s_cname` varchar(100) NOT NULL,
`s_acname` varchar(100) NOT NULL,
`s_org` varchar(100) NOT NULL,
`s_address` varchar(100) NOT NULL,
`s_street` varchar(255) NOT NULL,
`s_city` varchar(100) NOT NULL DEFAULT '0',
`s_state` varchar(100) NOT NULL DEFAULT '0',
`s_country` varchar(100) NOT NULL,
`s_pin` varchar(50) NOT NULL,
`s_ph` varchar(50) NOT NULL,
`s_mob` varchar(50) NOT NULL,
`s_fax` varchar(75) NOT NULL,
`s_aphone` varchar(50) NOT NULL,
`s_web` varchar(100) NOT NULL,
`s_email` varchar(100) NOT NULL,
`s_aemail` varchar(100) NOT NULL,
`s_desig` varchar(255) NOT NULL,
`s_dept` varchar(255) NOT NULL,
`ad_dt` datetime NOT NULL,
`ad_id` int(11) NOT NULL,
`is_cust` int(2) DEFAULT '0',
`ctype` int(2) NOT NULL,
`kst` varchar(255) NOT NULL,
`cst` varchar(255) NOT NULL,
`tin` varchar(255) NOT NULL,
`status` int(2) DEFAULT '1',
PRIMARY KEY (`id`)
);
|
Download
