-- http://www.phpmyadmin.net
--
-- Host: localhost
--- Generation Time: Sep 26, 2014 at 11:37 AM
+-- Generation Time: Sep 26, 2015 at 11:37 AM
-- Server version: 5.0.51
-- PHP Version: 5.2.6-1+lenny2
`notes` tinytext NOT 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=1 ;
-- Dumping data for table `0_fiscal_year`
--
-INSERT INTO `0_fiscal_year` VALUES(1, '2013-01-01', '2013-12-31', 0);
-INSERT INTO `0_fiscal_year` VALUES(2, '2014-01-01', '2014-12-31', 0);
+INSERT INTO `0_fiscal_year` VALUES(2, '2016-01-01', '2016-12-31', 0);
--
-- Table structure for table `0_gl_trans`
`alloc` double NOT NULL default '0',
`tax_included` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`type`,`trans_no`),
- KEY `supplier_id` (`supplier_id`,`supp_reference`),
+ KEY `supplier_id` (`supplier_id`),
+ KEY `SupplierID_2` (`supplier_id`,`supp_reference`),
KEY `type` (`type`),
KEY `tran_date` (`tran_date`)
) ENGINE=InnoDB;