`area` int(11) default NULL,
`salesman` int(11) NOT NULL default '0',
`phone` varchar(30) NOT NULL default '',
+ `phone2` varchar(30) NOT NULL default '',
`fax` varchar(30) NOT NULL default '',
`contact_name` varchar(60) NOT NULL default '',
`email` varchar(100) NOT NULL default '',
`disable_trans` tinyint(4) NOT NULL default '0',
`br_post_address` tinytext NOT NULL,
`group_no` int(11) NOT NULL default '0',
+ `notes` tinytext NOT NULL,
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`branch_code`,`debtor_no`),
KEY `branch_code` (`branch_code`),
`discount` double NOT NULL default '0',
`pymt_discount` double NOT NULL default '0',
`credit_limit` float NOT NULL default '1000',
+ `notes` tinytext NOT NULL,
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`debtor_no`),
UNIQUE KEY `name` (`name`)
`location_name` varchar(60) NOT NULL default '',
`delivery_address` tinytext NOT NULL,
`phone` varchar(30) NOT NULL default '',
+ `phone2` varchar(30) NOT NULL default '',
`fax` varchar(30) NOT NULL default '',
`email` varchar(100) NOT NULL default '',
`contact` varchar(30) NOT NULL default '',
### Data of table `0_locations` ###
-INSERT INTO `0_locations` VALUES ('DEF', 'Default', 'N/A', '', '', '', '', '0');
+INSERT INTO `0_locations` VALUES ('DEF', 'Default', 'N/A', '', '', '', '', '', '0');
### Structure of table `0_movement_types` ###
`shipper_id` int(11) NOT NULL auto_increment,
`shipper_name` varchar(60) NOT NULL default '',
`phone` varchar(30) NOT NULL default '',
+ `phone2` varchar(30) NOT NULL default '',
`contact` tinytext NOT NULL,
`address` tinytext NOT NULL,
`inactive` tinyint(1) NOT NULL default '0',
### Data of table `0_shippers` ###
-INSERT INTO `0_shippers` VALUES ('1', 'Default', '', '', '', '0');
+INSERT INTO `0_shippers` VALUES ('1', 'Default', '', '', '', '', '0');
### Structure of table `0_sql_trail` ###
`address` tinytext NOT NULL,
`supp_address` tinytext NOT NULL,
`phone` varchar(30) NOT NULL default '',
+ `phone2` varchar(30) NOT NULL default '',
`fax` varchar(30) NOT NULL default '',
`gst_no` varchar(25) NOT NULL default '',
`contact` varchar(60) NOT NULL default '',