X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sql%2Fen_US-demo.sql;h=62a93c3f28511175e350e3465af4fec3c4a0506e;hb=fec081ddbcf4f2ceb4b325f30cfc1005e855b724;hp=574d5cd4ba91be759eddae99b934ea08ef9ea56d;hpb=3fd7df0efa6893e784c538b996f7968cd6dcd4d0;p=fa-stable.git diff --git a/sql/en_US-demo.sql b/sql/en_US-demo.sql index 574d5cd4..62a93c3f 100644 --- a/sql/en_US-demo.sql +++ b/sql/en_US-demo.sql @@ -1183,27 +1183,6 @@ INSERT INTO `0_loc_stock` VALUES('DEF', '3400', 0); -- -------------------------------------------------------- --- --- Table structure for table `0_movement_types` --- - -DROP TABLE IF EXISTS `0_movement_types`; -CREATE TABLE IF NOT EXISTS `0_movement_types` ( - `id` int(11) NOT NULL auto_increment, - `name` varchar(60) NOT NULL default '', - `inactive` tinyint(1) NOT NULL default '0', - PRIMARY KEY (`id`), - UNIQUE KEY `name` (`name`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; - --- --- Dumping data for table `0_movement_types` --- - -INSERT INTO `0_movement_types` VALUES(1, 'Adjustment', 0); - --- -------------------------------------------------------- - -- -- Table structure for table `0_payment_terms` -- @@ -1833,11 +1812,9 @@ CREATE TABLE `0_stock_moves` ( `type` smallint(6) NOT NULL DEFAULT '0', `loc_code` char(5) NOT NULL DEFAULT '', `tran_date` date NOT NULL DEFAULT '0000-00-00', - `person_id` int(11) DEFAULT NULL, `price` double NOT NULL DEFAULT '0', `reference` char(40) NOT NULL DEFAULT '', `qty` double NOT NULL DEFAULT '1', - `discount_percent` double NOT NULL DEFAULT '0', `standard_cost` double NOT NULL DEFAULT '0', PRIMARY KEY (`trans_id`), KEY `type` (`type`,`trans_no`), @@ -1849,42 +1826,42 @@ CREATE TABLE `0_stock_moves` ( -- INSERT INTO `0_stock_moves` VALUES -('1', '1', '102', '25', 'DEF', '2009-06-21', '2', '10', '', '100', '0', '10'), -('2', '1', '103', '25', 'DEF', '2009-06-21', '2', '11', '', '100', '0', '11'), -('3', '1', '104', '25', 'DEF', '2009-06-21', '2', '12', '', '100', '0', '12'), -('4', '1', '102', '26', 'DEF', '2009-06-21', '0', '0', '1', '-10', '0', '0'), -('5', '1', '103', '26', 'DEF', '2009-06-21', '0', '0', '1', '-10', '0', '0'), -('6', '1', '104', '26', 'DEF', '2009-06-21', '0', '0', '1', '-10', '0', '0'), -('7', '1', '3400', '26', 'DEF', '2009-06-21', '0', '0', '1', '10', '0', '0'), -('8', '2', '102', '13', 'DEF', '2009-06-21', '0', '30.4', '1', '-2', '0', '10'), -('9', '3', '102', '13', 'DEF', '2009-06-21', '0', '50', 'auto', '-1', '0', '10'), -('10', '4', '102', '13', 'DEF', '2009-06-21', '0', '35.89', 'auto', '-1', '0', '10'), -('11', '3', '102', '26', 'DEF', '2009-06-21', '0', '0', '3', '-2', '0', '0'), -('12', '3', '103', '26', 'DEF', '2009-06-21', '0', '0', '3', '-2', '0', '0'), -('13', '3', '104', '26', 'DEF', '2009-06-21', '0', '0', '3', '-2', '0', '0'), -('14', '3', '3400', '26', 'DEF', '2009-06-21', '0', '0', '3', '2', '0', '0'), -('15', '4', '102', '26', 'DEF', '2009-06-21', '0', '0', '4', '-4', '0', '0'), -('16', '4', '103', '26', 'DEF', '2009-06-21', '0', '0', '4', '-4', '0', '0'), -('17', '4', '104', '26', 'DEF', '2009-06-21', '0', '0', '4', '-4', '0', '0'), -('18', '4', '3400', '26', 'DEF', '2009-06-21', '0', '0', '4', '4', '0', '0'), -('19', '2', '102', '26', 'DEF', '2009-06-21', '0', '0', '', '-2', '0', '0'), -('20', '2', '103', '26', 'DEF', '2009-06-21', '0', '0', '', '-2', '0', '0'), -('21', '2', '104', '26', 'DEF', '2009-06-21', '0', '0', '', '-2', '0', '0'), -('22', '1', '3400', '29', 'DEF', '2009-06-21', '0', '0', '', '2', '0', '0'), -('23', '5', '102', '26', 'DEF', '2009-06-21', '0', '0', '5', '-5', '0', '0'), -('24', '5', '103', '26', 'DEF', '2009-06-21', '0', '0', '5', '-5', '0', '0'), -('25', '5', '104', '26', 'DEF', '2009-06-21', '0', '0', '5', '-5', '0', '0'), -('26', '5', '3400', '26', 'DEF', '2009-06-21', '0', '0', '5', '5', '0', '0'), -('27', '6', '102', '26', 'DEF', '2009-06-21', '0', '0', '6', '5', '0', '0'), -('28', '6', '103', '26', 'DEF', '2009-06-21', '0', '0', '6', '5', '0', '0'), -('29', '6', '104', '26', 'DEF', '2009-06-21', '0', '0', '6', '5', '0', '0'), -('30', '6', '3400', '26', 'DEF', '2009-06-21', '0', '0', '6', '-5', '0', '0'), -('31', '7', '102', '26', 'DEF', '2009-06-21', '0', '0', '7', '2', '0', '0'), -('32', '7', '103', '26', 'DEF', '2009-06-21', '0', '0', '7', '2', '0', '0'), -('33', '7', '104', '26', 'DEF', '2009-06-21', '0', '0', '7', '2', '0', '0'), -('34', '7', '3400', '26', 'DEF', '2009-06-21', '0', '0', '7', '-2', '0', '0'), -('35', '5', '102', '13', 'DEF', '2009-06-21', '0', '50', 'auto', '-1', '0', '10'), -('36', '3', '102', '11', 'DEF', '2009-06-21', '0', '37.68', 'Return Ex Inv: 18', '1', '0', '10'); +('1', '1', '102', '25', 'DEF', '2009-06-21', '10', '', '100', '10'), +('2', '1', '103', '25', 'DEF', '2009-06-21', '11', '', '100', '11'), +('3', '1', '104', '25', 'DEF', '2009-06-21', '12', '', '100', '12'), +('4', '1', '102', '26', 'DEF', '2009-06-21', '0', '1', '-10', '0'), +('5', '1', '103', '26', 'DEF', '2009-06-21', '0', '1', '-10', '0'), +('6', '1', '104', '26', 'DEF', '2009-06-21', '0', '1', '-10', '0'), +('7', '1', '3400', '26', 'DEF', '2009-06-21', '0', '1', '10', '0'), +('8', '2', '102', '13', 'DEF', '2009-06-21', '30.4', '1', '-2', '10'), +('9', '3', '102', '13', 'DEF', '2009-06-21', '50', 'auto', '-1', '10'), +('10', '4', '102', '13', 'DEF', '2009-06-21', '35.89', 'auto', '-1', '10'), +('11', '3', '102', '26', 'DEF', '2009-06-21', '0', '3', '-2', '0'), +('12', '3', '103', '26', 'DEF', '2009-06-21', '0', '3', '-2', '0'), +('13', '3', '104', '26', 'DEF', '2009-06-21', '0', '3', '-2', '0'), +('14', '3', '3400', '26', 'DEF', '2009-06-21', '0', '3', '2', '0'), +('15', '4', '102', '26', 'DEF', '2009-06-21', '0', '4', '-4', '0'), +('16', '4', '103', '26', 'DEF', '2009-06-21', '0', '4', '-4', '0'), +('17', '4', '104', '26', 'DEF', '2009-06-21', '0', '4', '-4', '0'), +('18', '4', '3400', '26', 'DEF', '2009-06-21', '0', '4', '4', '0'), +('19', '2', '102', '26', 'DEF', '2009-06-21', '0', '', '-2', '0'), +('20', '2', '103', '26', 'DEF', '2009-06-21', '0', '', '-2', '0'), +('21', '2', '104', '26', 'DEF', '2009-06-21', '0', '', '-2', '0'), +('22', '1', '3400', '29', 'DEF', '2009-06-21', '0', '', '2', '0'), +('23', '5', '102', '26', 'DEF', '2009-06-21', '0', '5', '-5', '0'), +('24', '5', '103', '26', 'DEF', '2009-06-21', '0', '5', '-5', '0'), +('25', '5', '104', '26', 'DEF', '2009-06-21', '0', '5', '-5', '0'), +('26', '5', '3400', '26', 'DEF', '2009-06-21', '0', '5', '5', '0'), +('27', '6', '102', '26', 'DEF', '2009-06-21', '0', '6', '5', '0'), +('28', '6', '103', '26', 'DEF', '2009-06-21', '0', '6', '5', '0'), +('29', '6', '104', '26', 'DEF', '2009-06-21', '0', '6', '5', '0'), +('30', '6', '3400', '26', 'DEF', '2009-06-21', '0', '6', '-5', '0'), +('31', '7', '102', '26', 'DEF', '2009-06-21', '0', '7', '2', '0'), +('32', '7', '103', '26', 'DEF', '2009-06-21', '0', '7', '2', '0'), +('33', '7', '104', '26', 'DEF', '2009-06-21', '0', '7', '2', '0'), +('34', '7', '3400', '26', 'DEF', '2009-06-21', '0', '7', '-2', '0'), +('35', '5', '102', '13', 'DEF', '2009-06-21', '50', 'auto', '-1', '10'), +('36', '3', '102', '11', 'DEF', '2009-06-21', '37.68', 'Return Ex Inv: 18', '1', '10'); ### Structure of table `0_supp_allocations` ###