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 ;
`dflt_dim2` int(11) default NULL,
`inactive` tinyint(1) NOT NULL default '0',
`dflt_no_sale` tinyint(1) NOT NULL default '0',
+ `dflt_no_sale` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`category_id`),
UNIQUE KEY `description` (`description`)
) ENGINE=MyISAM AUTO_INCREMENT=5 ;
-- Dumping data for table `0_stock_category`
--
-INSERT INTO `0_stock_category` VALUES(1, 'Components', 1, 'each', 'B', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0);
-INSERT INTO `0_stock_category` VALUES(2, 'Charges', 1, 'each', 'D', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0);
-INSERT INTO `0_stock_category` VALUES(3, 'Systems', 1, 'each', 'M', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0);
-INSERT INTO `0_stock_category` VALUES(4, 'Services', 1, 'hrs', 'D', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0);
+INSERT INTO `0_stock_category` VALUES(1, 'Components', 1, 'each', 'B', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0, 0);
+INSERT INTO `0_stock_category` VALUES(2, 'Charges', 1, 'each', 'D', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0, 0);
+INSERT INTO `0_stock_category` VALUES(3, 'Systems', 1, 'each', 'M', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0, 0);
+INSERT INTO `0_stock_category` VALUES(4, 'Services', 1, 'hrs', 'D', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0, 0);
-- --------------------------------------------------------
`overhead_cost` double NOT NULL default '0',
`inactive` tinyint(1) NOT NULL default '0',
`no_sale` tinyint(1) NOT NULL default '0',
+ `no_purchase` tinyint(1) NOT NULL default '0',
`editable` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`stock_id`)
) ENGINE=InnoDB;