File: datamanage/db.txt

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`)
);