Implemented customizable authentication timeout.

[fa-stable.git] / sql / en_US-new.sql

diff --git a/sql/en_US-new.sql b/sql/en_US-new.sql
index 74b90a10177d8d512846fd63bc626fb33e569b5a..d2266787b1cbb1d5fcf7329832bd18386427c99e 100644 (file)
--- a/sql/en_US-new.sql
+++ b/sql/en_US-new.sql
@@ -178,8 +178,7 @@ DROP TABLE IF EXISTS `0_chart_class`;
 CREATE TABLE `0_chart_class` (
   `cid` int(11) NOT NULL default '0',
   `class_name` varchar(60) NOT NULL default '',
-  `balance_sheet` tinyint(1) NOT NULL default '0',
-  `sign_convert` tinyint(1) NOT NULL default '0',
+  `ctype` tinyint(1) NOT NULL default '0',
   `inactive` tinyint(1) NOT NULL default '0',
   PRIMARY KEY  (`cid`)
 ) TYPE=MyISAM  ;
@@ -187,10 +186,10 @@ CREATE TABLE `0_chart_class` (
 
 ### Data of table `0_chart_class` ###
 
-INSERT INTO `0_chart_class` VALUES ('1', 'Assets', '1', '0', '0');
-INSERT INTO `0_chart_class` VALUES ('2', 'Liabilities', '2', '1', '0');
-INSERT INTO `0_chart_class` VALUES ('3', 'Income', '4', '1', '0');
-INSERT INTO `0_chart_class` VALUES ('4', 'Costs', '6', '1', '0');
+INSERT INTO `0_chart_class` VALUES ('1', 'Assets', '1', '0');
+INSERT INTO `0_chart_class` VALUES ('2', 'Liabilities', '2', '0');
+INSERT INTO `0_chart_class` VALUES ('3', 'Income', '4', '0');
+INSERT INTO `0_chart_class` VALUES ('4', 'Costs', '6', '0');
 
 ### Structure of table `0_chart_master` ###
 
@@ -318,7 +317,7 @@ INSERT INTO `0_chart_types` VALUES ('8', 'Sales Revenue', '3', '-1', '0');
 INSERT INTO `0_chart_types` VALUES ('9', 'Other Revenue', '3', '-1', '0');
 INSERT INTO `0_chart_types` VALUES ('10', 'Cost of Goods Sold', '4', '-1', '0');
 INSERT INTO `0_chart_types` VALUES ('11', 'Payroll Expenses', '4', '-1', '0');
-INSERT INTO `0_chart_types` VALUES ('12', 'General & Administrative expenses', '4', '0');
+INSERT INTO `0_chart_types` VALUES ('12', 'General & Administrative expenses', '4', -1, '0');
 
 
 ### Structure of table `0_comments` ###
@@ -358,7 +357,7 @@ CREATE TABLE `0_company` (
   `debtors_act` varchar(11) NOT NULL default '',
   `pyt_discount_act` varchar(11) NOT NULL default '',
   `creditors_act` varchar(11) NOT NULL default '',
-  `grn_act` varchar(11) NOT NULL default '',
+  `bank_charge_act` varchar(11) NOT NULL default '',
   `exchange_diff_act` varchar(11) NOT NULL default '',
   `profit_loss_year_act` varchar(11) NOT NULL default '',
   `retained_earnings_act` varchar(11) NOT NULL default '',
@@ -391,13 +390,16 @@ CREATE TABLE `0_company` (
   `default_delivery_required` smallint(6) NOT NULL default '1',
   `version_id` varchar(11) NOT NULL default '',
   `time_zone` tinyint(1) NOT NULL default '0',
+  `add_pct` int(5) NOT NULL default '-1',
+  `round_to` int(5) NOT NULL default '1',
+  `login_tout` SMALLINT(6) NOT NULL DEFAULT '600',
   PRIMARY KEY  (`coy_code`)
 ) TYPE=MyISAM  ;
 
 
 ### Data of table `0_company` ###
 
-INSERT INTO `0_company` VALUES ('1', 'Company name', '', '', '1', '1', 'N/A', '', '', '', '', '', 'USD', '1200', '5060', '2100', '1430', '4450', '4220', '2050', '4430', '4010', '4510', '4500', '1510', '5010', '5040', '4010', '1530', '5000', '', '', '', '', '', '', '0', '10', '10', '1000', '20', '20', '30', '1', '1', '0', '0', '0', '1', '0', '0', '', '1', '2.2', '0');
+INSERT INTO `0_company` VALUES ('1', 'Company name', '', '', '1', '1', 'N/A', '', '', '', '', '', 'USD', '1200', '5060', '2100', '5690', '4450', '9990', '3590', '4430', '4010', '4510', '4500', '1510', '5010', '5040', '4010', '1530', '5000', '0', '10', '10', '1000', '20', '20', '30', '1', '1', '0', '0', '0', '1', '0', '0', '', '1', '2.2', '0', '-1', '1', '600');
 
 ### Structure of table `0_credit_status` ###
 
@@ -471,6 +473,7 @@ CREATE TABLE `0_cust_branch` (
   `branch_code` int(11) NOT NULL auto_increment,
   `debtor_no` int(11) NOT NULL default '0',
   `br_name` varchar(60) NOT NULL default '',
+  `branch_ref`         varchar(30) NOT NULL default '',
   `br_address` tinytext NOT NULL,
   `area` int(11) default NULL,
   `salesman` int(11) NOT NULL default '0',
@@ -565,6 +568,7 @@ DROP TABLE IF EXISTS `0_debtors_master`;
 CREATE TABLE `0_debtors_master` (
   `debtor_no` int(11) NOT NULL auto_increment,
   `name` varchar(80) NOT NULL default '',
+  `debtor_ref` varchar(30) NOT NULL,
   `address` tinytext,
   `email` varchar(100) NOT NULL default '',
   `tax_id` varchar(55) NOT NULL default '',
@@ -782,7 +786,7 @@ CREATE TABLE `0_item_tax_types` (
 
 ### Data of table `0_item_tax_types` ###
 
-INSERT INTO `0_item_tax_types` VALUES ('1', 'Regular', '0');
+INSERT INTO `0_item_tax_types` VALUES ('1', 'Regular', '0', '0');
 
 
 ### Structure of table `0_item_units` ###
@@ -1281,6 +1285,7 @@ CREATE TABLE `0_stock_category` (
   `dflt_dim1` int(11) default NULL,
   `dflt_dim2` int(11) default NULL,
   `inactive` tinyint(1) NOT NULL default '0',
+  `dflt_no_sale` tinyint(1) NOT NULL default '0',
   PRIMARY KEY  (`category_id`),
   UNIQUE KEY `description` (`description`)
 ) TYPE=MyISAM AUTO_INCREMENT=5 ;
@@ -1288,10 +1293,10 @@ CREATE TABLE `0_stock_category` (
 
 ### 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', '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');
 
 
 ### Structure of table `0_stock_master` ###
@@ -1319,6 +1324,7 @@ CREATE TABLE `0_stock_master` (
   `labour_cost` double NOT NULL default '0',
   `overhead_cost` double NOT NULL default '0',
   `inactive` tinyint(1) NOT NULL default '0',
+  `no_sale` tinyint(1) NOT NULL default '0',
   PRIMARY KEY  (`stock_id`)
 ) TYPE=InnoDB  ;
 
@@ -1434,6 +1440,7 @@ DROP TABLE IF EXISTS `0_suppliers`;
 CREATE TABLE `0_suppliers` (
   `supplier_id` int(11) NOT NULL auto_increment,
   `supp_name` varchar(60) NOT NULL default '',
+  `supp_ref` varchar(30) NOT NULL default '',
   `address` tinytext NOT NULL,
   `supp_address` tinytext NOT NULL,
   `phone` varchar(30) NOT NULL default '',
@@ -1534,8 +1541,8 @@ CREATE TABLE `0_tax_groups` (
 
 ### Data of table `0_tax_groups` ###
 
-INSERT INTO `0_tax_groups` VALUES ('1', 'Tax', '0');
-INSERT INTO `0_tax_groups` VALUES ('2', 'Tax Exempt', '0');
+INSERT INTO `0_tax_groups` VALUES ('1', 'Tax', '0', '0');
+INSERT INTO `0_tax_groups` VALUES ('2', 'Tax Exempt', '0', '0');
 
 
 ### Structure of table `0_tax_types` ###
@@ -1556,7 +1563,7 @@ CREATE TABLE `0_tax_types` (
 
 ### Data of table `0_tax_types` ###
 
-INSERT INTO `0_tax_types` VALUES ('1', '5', '2150', '2150', 'Tax');
+INSERT INTO `0_tax_types` VALUES ('1', '5', '2150', '2150', 'Tax', '0');
 
 
 ### Structure of table `0_trans_tax_details` ###