`bank_account` varchar(60) DEFAULT NULL,
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`branch_code`,`debtor_no`),
- KEY `branch_code` (`branch_code`),
KEY `branch_ref` (`branch_ref`),
KEY `group_no` (`group_no`)
) ENGINE=MyISAM AUTO_INCREMENT=4 ;
`tax_included` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`type`,`trans_no`),
KEY `debtor_no` (`debtor_no`,`branch_code`),
- KEY `tran_date` (`tran_date`)
+ KEY `tran_date` (`tran_date`),
+ KEY `order_` (`order_`)
) ENGINE=InnoDB;
--
`reference` varchar(60) NOT NULL default '',
`delivery_date` date NOT NULL default '0000-00-00',
`loc_code` varchar(5) default NULL,
+ `rate` double NOT NULL default '1',
PRIMARY KEY (`id`),
KEY `delivery_date` (`delivery_date`),
KEY `purch_order_no` (`purch_order_no`)
-- Dumping data for table `0_grn_batch`
--
-INSERT INTO `0_grn_batch` VALUES(1, 2, 1, '1', '2009-06-21', 'DEF');
+INSERT INTO `0_grn_batch` VALUES(1, 2, 1, '1', '2009-06-21', 'DEF', '1');
-- --------------------------------------------------------
`tax_included` tinyint(1) NOT NULL default '0',
`tax_algorithm` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`type`,`trans_no`),
- KEY `supplier_id` (`supplier_id`),
- KEY `SupplierID_2` (`supplier_id`,`supp_reference`),
- KEY `type` (`type`),
+ KEY `supplier_id` (`supplier_id`,`supp_reference`),
KEY `tran_date` (`tran_date`)
) ENGINE=InnoDB;
`show_codes` tinyint(1) NOT NULL default '0',
`show_hints` tinyint(1) NOT NULL default '0',
`last_visit_date` datetime default NULL,
- `query_size` tinyint(1) default '10',
+ `query_size` tinyint(1) unsigned default '10',
`graphic_links` tinyint(1) default '1',
`pos` smallint(6) default '1',
`print_profile` varchar(30) NOT NULL default '1',