gbhf5Gyu

1CREATE TABLE IF NOT EXISTS `accounts` (
2  `idx` int(10) unsigned NOT NULL auto_increment,
3  `cid` int(10) unsigned NOT NULL,
4  `totalcost` decimal(16,2) NOT NULL,
5  `transactionid` varchar(40) default NULL,
6  `agent` varchar(64) NOT NULL,
7  `duedate` date default NULL,
8  `invoicedate` date default NULL,
9  `lastupdatedby` varchar(64) NOT NULL,
10  `lastupdatetime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
11  `attached_invoice` varchar(255) default NULL,
12  `source` tinyint(3) unsigned NOT NULL,
13  `status` tinyint(4) NOT NULL default '0',
14  PRIMARY KEY  (`idx`),
15  KEY `cid` (`cid`)
16) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ;
17
18CREATE TABLE IF NOT EXISTS `accounts_products` (
19  `idx` int(10) unsigned NOT NULL auto_increment,
20  `aid` int(10) unsigned NOT NULL,
21  `pid` int(10) unsigned NOT NULL,
22  `info` varchar(255) default NULL,
23  PRIMARY KEY  (`idx`),
24  KEY `aid` (`aid`,`pid`)
25) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ;
26
27
28CREATE TABLE IF NOT EXISTS `customers` (
29  `idx` int(10) unsigned NOT NULL auto_increment,
30  `fullname` varchar(255) NOT NULL,
31  `business` varchar(255) NOT NULL,
32  `address_line_1` varchar(255) NOT NULL,
33  `address_line_2` varchar(255) default NULL,
34  `address_line_3` varchar(255) default NULL,
35  `address_line_4` varchar(255) default NULL,
36  `postcode` varchar(16) NOT NULL,
37  `landline` varchar(16) default NULL,
38  `mobile` varchar(16) default NULL,
39  `fax` varchar(16) default NULL,
40  `email` varchar(255) default NULL,
41  PRIMARY KEY  (`idx`),
42  FULLTEXT KEY `search` (`fullname`,`business`,`address_line_1`,`address_line_2`,`address_line_3`,`postcode`,`email`)
43) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ;