PHP Classes

File: datamanage/db.txt

Recommend this page to a friend!
  Classes of Mathew  >  Data Manager  >  datamanage/db.txt  >  Download  
File: datamanage/db.txt
Role: Auxiliary data
Content type: text/plain
Description: db
Class: Data Manager
Retrieve and store MySQL records using Web forms
Author: By
Last change:
Date: 9 years ago
Size: 2,329 bytes
 

Contents

Class file image Download
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`) );