DROP TABLE IF EXISTS `0_budget_trans`;
CREATE TABLE IF NOT EXISTS `0_budget_trans` (
- `counter` int(11) NOT NULL auto_increment,
- `type` smallint(6) NOT NULL default '0',
- `type_no` bigint(16) NOT NULL default '1',
+ `id` int(11) NOT NULL auto_increment,
`tran_date` date NOT NULL default '0000-00-00',
`account` varchar(15) NOT NULL default '',
`memo_` tinytext NOT NULL,
`amount` double NOT NULL default '0',
`dimension_id` int(11) default '0',
`dimension2_id` int(11) default '0',
- `person_type_id` int(11) default NULL,
- `person_id` tinyblob,
- PRIMARY KEY (`counter`),
- KEY `Type_and_Number` (`type`,`type_no`),
+ PRIMARY KEY (`id`),
KEY `Account` (`account`,`tran_date`,`dimension_id`,`dimension2_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 ;
`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;
--
INSERT INTO `0_fiscal_year` VALUES(2, '2009-01-01', '2009-12-31', 1);
INSERT INTO `0_fiscal_year` VALUES(3, '2010-01-01', '2010-12-31', 0);
INSERT INTO `0_fiscal_year` VALUES(4, '2011-01-01', '2011-12-31', 0);
+INSERT INTO `0_fiscal_year` VALUES(5, '2012-01-01', '2012-12-31', 0);
+INSERT INTO `0_fiscal_year` VALUES(6, '2013-01-01', '2013-12-31', 0);
--
-- Table structure for table `0_gl_trans`
`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');
-- --------------------------------------------------------
INSERT INTO `0_sys_prefs` VALUES('domicile', 'setup.company', 'varchar', 55, '');
INSERT INTO `0_sys_prefs` VALUES('curr_default', 'setup.company', 'char', 3, 'USD');
INSERT INTO `0_sys_prefs` VALUES('use_dimension', 'setup.company', 'tinyint', 1, '1');
-INSERT INTO `0_sys_prefs` VALUES('f_year', 'setup.company', 'int', 11, '3');
+INSERT INTO `0_sys_prefs` VALUES('f_year', 'setup.company', 'int', 11, '6');
INSERT INTO `0_sys_prefs` VALUES('no_item_list', 'setup.company', 'tinyint', 1, '0');
INSERT INTO `0_sys_prefs` VALUES('no_customer_list', 'setup.company', 'tinyint', 1, '0');
INSERT INTO `0_sys_prefs` VALUES('no_supplier_list', 'setup.company', 'tinyint', 1, '0');
INSERT INTO `0_sys_prefs` VALUES('version_id', 'system', 'varchar', 11, '2.3rc');
INSERT INTO `0_sys_prefs` VALUES('auto_curr_reval', 'setup.company', 'smallint', 6, '1');
INSERT INTO `0_sys_prefs` VALUES('grn_clearing_act', 'glsetup.purchase', 'varchar', 15, '1550');
+INSERT INTO `0_sys_prefs` VALUES('bcc_email', 'setup.company', 'varchar', 100, '');
INSERT INTO `0_sys_prefs` VALUES('deferred_income_act', 'glsetup.sales', 'varchar', '15', '');
INSERT INTO `0_sys_prefs` VALUES('gl_closing_date','setup.closing_date', 'date', 8, '');
`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',