X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;ds=sidebyside;f=sql%2Fen_US-demo.sql;h=0d2cc25a2e77e31f618b15a569c3803b5aa62e34;hb=8273b6b981c008c7968a7f7c8eaea640d453c3f2;hp=8b80ee29b093cba6bcfdb9fd2aa2d8156f5798b1;hpb=4e1ede871ac4f57ef38be297bb0d4693341f7c07;p=fa-stable.git diff --git a/sql/en_US-demo.sql b/sql/en_US-demo.sql index 8b80ee29..0d2cc25a 100644 --- a/sql/en_US-demo.sql +++ b/sql/en_US-demo.sql @@ -347,12 +347,6 @@ CREATE TABLE `0_company` ( `default_inv_sales_act` varchar(11) NOT NULL default '', `default_assembly_act` varchar(11) NOT NULL default '', `payroll_act` varchar(11) NOT NULL default '', - `custom1_name` varchar(60) NOT NULL default '', - `custom2_name` varchar(60) NOT NULL default '', - `custom3_name` varchar(60) NOT NULL default '', - `custom1_value` varchar(100) NOT NULL default '', - `custom2_value` varchar(100) NOT NULL default '', - `custom3_value` varchar(100) NOT NULL default '', `allow_negative_stock` tinyint(1) NOT NULL default '0', `po_over_receive` int(11) NOT NULL default '10', `po_over_charge` int(11) NOT NULL default '10', @@ -369,13 +363,14 @@ CREATE TABLE `0_company` ( `foreign_codes` tinyint(1) NOT NULL default '0', `accumulate_shipping` tinyint(1) NOT NULL default '0', `legal_text` tinytext NOT NULL, + `default_delivery_required` smallint(6) NOT NULL default '1', PRIMARY KEY (`coy_code`) ) TYPE=MyISAM ; ### Data of table `0_company` ### -INSERT INTO `0_company` VALUES ('1', 'Training Co.', '987654321', '123123123', '1', '1', 'N/A', '202-122320', '202-18889123', 'delta@delta.com', 'logo_frontaccounting.jpg', 'DownTown', 'USD', '1500', '4250', '2630', '1430', '4260', '4220', '2050', '3800', '3000', '3000', '3200', '1420', '4010', '4210', '3000', '1410', '5000', '', '', '', '', '', '', '0', '10', '10', '1000', '20', '20', '30', '1', '7', '0', '0', '0', '0', '0', '0', ''); +INSERT INTO `0_company` VALUES ('1', 'Training Co.', '987654321', '123123123', '1', '1', 'N/A', '202-122320', '202-18889123', 'delta@delta.com', 'logo_frontaccounting.jpg', 'DownTown', 'USD', '1500', '4250', '2630', '1430', '4260', '4220', '2050', '3800', '3000', '3000', '3200', '1420', '4010', '4210', '3000', '1410', '5000', '0', '10', '10', '1000', '20', '20', '30', '1', '7', '0', '0', '0', '0', '0', '0', '', '1'); ### Structure of table `0_credit_status` ### @@ -475,6 +470,7 @@ CREATE TABLE `0_cust_branch` ( `disable_trans` tinyint(4) NOT NULL default '0', `br_post_address` tinytext NOT NULL, `group_no` int(11) NOT NULL default '0', + `inactive` tinyint(1) NOT NULL default '0', PRIMARY KEY (`branch_code`,`debtor_no`), KEY `branch_code` (`branch_code`), KEY `br_name` (`br_name`) @@ -483,12 +479,12 @@ CREATE TABLE `0_cust_branch` ( ### Data of table `0_cust_branch` ### -INSERT INTO `0_cust_branch` VALUES ('1', '1', 'Main', '', '1', '1', '', '', 'Lucky Luke Inc.', 'lucky@luke.com', 'DEF', '1', '3000', '3000', '1500', '3200', '1', '0', 'The Road', '0'); -INSERT INTO `0_cust_branch` VALUES ('2', '1', 'Service divison', '', '4', '1', '', '', '', '', 'DEF', '2', '3000', '3000', '1500', '3200', '1', '0', 'Another Road', '0'); -INSERT INTO `0_cust_branch` VALUES ('3', '2', 'Main', '', '4', '2', '', '', 'Money Makers Ltd.', '', 'DEF', '2', '3000', '3000', '1500', '3200', '1', '0', '', '0'); -INSERT INTO `0_cust_branch` VALUES ('5', '3', 'Main', '', '4', '1', '', '', 'Junk Beer ApS', '', 'CWA', '2', '3000', '3000', '1500', '3200', '1', '0', '', '0'); -INSERT INTO `0_cust_branch` VALUES ('6', '4', 'Johny Bravo', 'Never Mind 13', '1', '1', '123', '', 'Johny Bravo', '', 'DEF', '1', '3000', '3000', '1500', '3200', '1', '0', 'Never Mind 13', '0'); -INSERT INTO `0_cust_branch` VALUES ('7', '3', 'Junk Beer ApS', 'N/A', '1', '1', '1223123', '', 'junk@junkbeer.dk', '', 'DEF', '5', '3000', '3000', '1500', '3200', '1', '0', 'N/A', '0'); +INSERT INTO `0_cust_branch` VALUES ('1', '1', 'Main', '', '1', '1', '', '', 'Lucky Luke Inc.', 'lucky@luke.com', 'DEF', '1', '3000', '3000', '1500', '3200', '1', '0', 'The Road', '0', '0'); +INSERT INTO `0_cust_branch` VALUES ('2', '1', 'Service divison', '', '4', '1', '', '', '', '', 'DEF', '2', '3000', '3000', '1500', '3200', '1', '0', 'Another Road', '0', '0'); +INSERT INTO `0_cust_branch` VALUES ('3', '2', 'Main', '', '4', '2', '', '', 'Money Makers Ltd.', '', 'DEF', '2', '3000', '3000', '1500', '3200', '1', '0', '', '0', '0'); +INSERT INTO `0_cust_branch` VALUES ('5', '3', 'Main', '', '4', '1', '', '', 'Junk Beer ApS', '', 'CWA', '2', '3000', '3000', '1500', '3200', '1', '0', '', '0', '0'); +INSERT INTO `0_cust_branch` VALUES ('6', '4', 'Johny Bravo', 'Never Mind 13', '1', '1', '123', '', 'Johny Bravo', '', 'DEF', '1', '3000', '3000', '1500', '3200', '1', '0', 'Never Mind 13', '0', '0'); +INSERT INTO `0_cust_branch` VALUES ('7', '3', 'Junk Beer ApS', 'N/A', '1', '1', '1223123', '', 'junk@junkbeer.dk', '', 'DEF', '5', '3000', '3000', '1500', '3200', '1', '0', 'N/A', '0', '0'); ### Structure of table `0_debtor_trans` ### @@ -675,7 +671,7 @@ DROP TABLE IF EXISTS `0_debtors_master`; CREATE TABLE `0_debtors_master` ( `debtor_no` int(11) NOT NULL auto_increment, - `name` varchar(60) NOT NULL default '', + `name` varchar(80) NOT NULL default '', `address` tinytext, `email` varchar(100) NOT NULL default '', `tax_id` varchar(55) NOT NULL default '', @@ -1791,22 +1787,27 @@ DROP TABLE IF EXISTS `0_stock_category`; CREATE TABLE `0_stock_category` ( `category_id` int(11) NOT NULL auto_increment, `description` varchar(60) NOT NULL default '', - `stock_act` varchar(11) default NULL, - `cogs_act` varchar(11) default NULL, - `adj_gl_act` varchar(11) default NULL, - `purch_price_var_act` varchar(11) default NULL, + `dflt_tax_type` int(11) NOT NULL default '1', + `dflt_units` varchar(20) NOT NULL default 'each', + `dflt_mb_flag` char(1) NOT NULL default 'B', + `dflt_sales_act` varchar(11) NOT NULL default '', + `dflt_cogs_act` varchar(11) NOT NULL default '', + `dflt_inventory_act` varchar(11) NOT NULL default '', + `dflt_adjustment_act` varchar(11) NOT NULL default '', + `dflt_assembly_act` varchar(11) NOT NULL default '', + `dflt_dim1` int(11) default NULL, + `dflt_dim2` int(11) default NULL, `inactive` tinyint(1) NOT NULL default '0', PRIMARY KEY (`category_id`), UNIQUE KEY `description` (`description`) ) TYPE=MyISAM AUTO_INCREMENT=5 AUTO_INCREMENT=5 ; - ### Data of table `0_stock_category` ### -INSERT INTO `0_stock_category` VALUES ('1', 'Components', '', '', '', '', '0'); -INSERT INTO `0_stock_category` VALUES ('2', 'Charges', '', '', '', '', '0'); -INSERT INTO `0_stock_category` VALUES ('3', 'Systems', '', '', '', '', '0'); -INSERT INTO `0_stock_category` VALUES ('4', 'Services', '', '', '', '', '0'); +INSERT INTO `0_stock_category` VALUES ('1', 'Components', '1', 'each', 'B', '3000', '4010', '1420', '4210', '1410', '1', '1', '0'); +INSERT INTO `0_stock_category` VALUES ('2', 'Charges', '1', 'each', 'D', '3000', '4010', '1420', '4210', '1410', '1', '1', '0'); +INSERT INTO `0_stock_category` VALUES ('3', 'Systems', '1', 'each', 'M', '3000', '4010', '1420', '4210', '1410', '1', '1', '0'); +INSERT INTO `0_stock_category` VALUES ('4', 'Services', '1', 'hrs', 'D', '3000', '4010', '1420', '4210', '1410', '1', '1', '0'); ### Structure of table `0_stock_master` ### @@ -2267,14 +2268,15 @@ CREATE TABLE `0_users` ( `pos` smallint(6) default '1', `print_profile` varchar(30) NOT NULL default '1', `rep_popup` tinyint(1) default '1', + `sticky_doc_date` tinyint(1) default '0', PRIMARY KEY (`user_id`) ) TYPE=MyISAM ; ### Data of table `0_users` ### -INSERT INTO `0_users` VALUES ('demouser', '5f4dcc3b5aa765d61d8327deb882cf99', 'Demo User', '1', '999-999-999', 'demo@demo.nu', 'en_US', '0', '0', '0', '0', 'default', 'Letter', '2', '2', '3', '1', '1', '0', '0', '2008-02-06 19:02:35', '10', '1', '1', '1', '1'); -INSERT INTO `0_users` VALUES ('admin', '5f4dcc3b5aa765d61d8327deb882cf99', 'Administrator', '2', '', 'adm@adm.com', 'en_US', '0', '0', '0', '0', 'default', 'Letter', '2', '2', '4', '1', '1', '0', '0', '2009-01-30 09:39:03', '10', '1', '1', '', '1'); +INSERT INTO `0_users` VALUES ('demouser', '5f4dcc3b5aa765d61d8327deb882cf99', 'Demo User', '1', '999-999-999', 'demo@demo.nu', 'en_US', '0', '0', '0', '0', 'default', 'Letter', '2', '2', '3', '1', '1', '0', '0', '2008-02-06 19:02:35', '10', '1', '1', '1', '1', '0'); +INSERT INTO `0_users` VALUES ('admin', '5f4dcc3b5aa765d61d8327deb882cf99', 'Administrator', '2', '', 'adm@adm.com', 'en_US', '0', '0', '0', '0', 'default', 'Letter', '2', '2', '4', '1', '1', '0', '0', '2009-01-30 09:39:03', '10', '1', '1', '', '1', '0'); ### Structure of table `0_voided` ###