---
--- Dumping data for table `0_sys_prefs`
---
-
-INSERT INTO `0_sys_prefs` VALUES ('coy_name', 'setup.company', 'varchar', 60, 'Company name');
-INSERT INTO `0_sys_prefs` VALUES ('gst_no', 'setup.company', 'varchar', 25, '');
-INSERT INTO `0_sys_prefs` VALUES ('coy_no', 'setup.company', 'varchar', 25, '');
-INSERT INTO `0_sys_prefs` VALUES ('tax_prd', 'setup.company', 'int', 11, '1');
-INSERT INTO `0_sys_prefs` VALUES ('tax_last', 'setup.company', 'int', 11, '1');
-INSERT INTO `0_sys_prefs` VALUES ('postal_address', 'setup.company', 'tinytext', 0, 'N/A');
-INSERT INTO `0_sys_prefs` VALUES ('phone', 'setup.company', 'varchar', 30, '');
-INSERT INTO `0_sys_prefs` VALUES ('fax', 'setup.company', 'varchar', 30, '');
-INSERT INTO `0_sys_prefs` VALUES ('email', 'setup.company', 'varchar', 100, '');
-INSERT INTO `0_sys_prefs` VALUES ('coy_logo', 'setup.company', 'varchar', 100, '');
-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, '1');
-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 ('base_sales', 'setup.company', 'int', 11, '1');
-INSERT INTO `0_sys_prefs` VALUES ('time_zone', 'setup.company', 'tinyint', 1, '0');
-INSERT INTO `0_sys_prefs` VALUES ('add_pct', 'setup.company', 'int', 5, '-1');
-INSERT INTO `0_sys_prefs` VALUES ('round_to', 'setup.company', 'int', 5, '1');
-INSERT INTO `0_sys_prefs` VALUES ('login_tout', 'setup.company', 'smallint', 6, '600');
-INSERT INTO `0_sys_prefs` VALUES ('past_due_days', 'glsetup.general', 'int', 11, '30');
-INSERT INTO `0_sys_prefs` VALUES ('profit_loss_year_act', 'glsetup.general', 'varchar', 15, '9990');
-INSERT INTO `0_sys_prefs` VALUES ('retained_earnings_act', 'glsetup.general', 'varchar', 15, '3590');
-INSERT INTO `0_sys_prefs` VALUES ('bank_charge_act', 'glsetup.general', 'varchar', 15, '5690');
-INSERT INTO `0_sys_prefs` VALUES ('exchange_diff_act', 'glsetup.general', 'varchar', 15, '4450');
-INSERT INTO `0_sys_prefs` VALUES ('tax_algorithm', 'glsetup.customer', 'tinyint', 1, '1');
-INSERT INTO `0_sys_prefs` VALUES ('default_credit_limit', 'glsetup.customer', 'int', 11, '1000');
-INSERT INTO `0_sys_prefs` VALUES ('accumulate_shipping', 'glsetup.customer', 'tinyint', 1, '0');
-INSERT INTO `0_sys_prefs` VALUES ('legal_text', 'glsetup.customer', 'tinytext', 0, '');
-INSERT INTO `0_sys_prefs` VALUES ('freight_act', 'glsetup.customer', 'varchar', 15, '4430');
-INSERT INTO `0_sys_prefs` VALUES ('debtors_act', 'glsetup.sales', 'varchar', 15, '1200');
-INSERT INTO `0_sys_prefs` VALUES ('default_sales_act', 'glsetup.sales', 'varchar', 15, '4010');
-INSERT INTO `0_sys_prefs` VALUES ('default_sales_discount_act', 'glsetup.sales', 'varchar', 15, '4510');
-INSERT INTO `0_sys_prefs` VALUES ('default_prompt_payment_act', 'glsetup.sales', 'varchar', 15, '4500');
-INSERT INTO `0_sys_prefs` VALUES ('default_delivery_required', 'glsetup.sales', 'smallint', 6, '1');
-INSERT INTO `0_sys_prefs` VALUES ('default_receival_required', 'glsetup.purchase', 'smallint', 6, '10');
-INSERT INTO `0_sys_prefs` VALUES ('default_quote_valid_days', 'glsetup.sales', 'smallint', 6, '30');
-INSERT INTO `0_sys_prefs` VALUES ('default_dim_required', 'glsetup.dims', 'int', 11, '20');
-INSERT INTO `0_sys_prefs` VALUES ('pyt_discount_act', 'glsetup.purchase', 'varchar', 15, '5060');
-INSERT INTO `0_sys_prefs` VALUES ('creditors_act', 'glsetup.purchase', 'varchar', 15, '2100');
-INSERT INTO `0_sys_prefs` VALUES ('po_over_receive', 'glsetup.purchase', 'int', 11, '10');
-INSERT INTO `0_sys_prefs` VALUES ('po_over_charge', 'glsetup.purchase', 'int', 11, '10');
-INSERT INTO `0_sys_prefs` VALUES ('allow_negative_stock', 'glsetup.inventory', 'tinyint', 1, '0');
-INSERT INTO `0_sys_prefs` VALUES ('default_inventory_act', 'glsetup.items', 'varchar', 15, '1510');
-INSERT INTO `0_sys_prefs` VALUES ('default_cogs_act', 'glsetup.items', 'varchar', 15, '5010');
-INSERT INTO `0_sys_prefs` VALUES ('default_adj_act', 'glsetup.items', 'varchar', 15, '5040');
-INSERT INTO `0_sys_prefs` VALUES ('default_inv_sales_act', 'glsetup.items', 'varchar', 15, '4010');
-INSERT INTO `0_sys_prefs` VALUES ('default_wip_act', 'glsetup.items', 'varchar', 15, '1530');
-INSERT INTO `0_sys_prefs` VALUES ('default_workorder_required', 'glsetup.manuf', 'int', 11, '20');
-INSERT INTO `0_sys_prefs` VALUES ('version_id', 'system', 'varchar', 11, '2.4.1');
-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, '');
-INSERT INTO `0_sys_prefs` VALUES ('alternative_tax_include_on_docs','setup.company', 'tinyint', 1, '0');
-INSERT INTO `0_sys_prefs` VALUES ('no_zero_lines_amount','glsetup.sales', 'tinyint', 1, '1');
-INSERT INTO `0_sys_prefs` VALUES ('show_po_item_codes','glsetup.purchase', 'tinyint', 1, '0');
-INSERT INTO `0_sys_prefs` VALUES ('accounts_alpha','glsetup.general', 'tinyint', 1, '0');
-INSERT INTO `0_sys_prefs` VALUES ('loc_notification','glsetup.inventory', 'tinyint', 1, '0');
-INSERT INTO `0_sys_prefs` VALUES ('print_invoice_no','glsetup.sales', 'tinyint', 1, '0');
-INSERT INTO `0_sys_prefs` VALUES ('allow_negative_prices','glsetup.inventory', 'tinyint', 1, '1');
-INSERT INTO `0_sys_prefs` VALUES ('print_item_images_on_quote','glsetup.inventory', 'tinyint', 1, '0');
-INSERT INTO `0_sys_prefs` VALUES ('suppress_tax_rates','setup.company', 'tinyint', 1, '0');
-INSERT INTO `0_sys_prefs` VALUES ('default_loss_on_asset_disposal_act', 'glsetup.items', 'varchar', '15', '5660');
-INSERT INTO `0_sys_prefs` VALUES ('depreciation_period', 'glsetup.company', 'tinyint', '1', '1');
-INSERT INTO `0_sys_prefs` VALUES ('use_manufacturing','setup.company', 'tinyint', 1, '1');
-INSERT INTO `0_sys_prefs` VALUES ('use_fixed_assets','setup.company', 'tinyint', 1, '1');
-
--- --------------------------------------------------------
-
---
--- Table structure for table `0_tags`
---
+-- Data of table `0_sys_prefs` --
+
+INSERT INTO `0_sys_prefs` VALUES
+('coy_name', 'setup.company', 'varchar', 60, 'Company name'),
+('gst_no', 'setup.company', 'varchar', 25, ''),
+('coy_no', 'setup.company', 'varchar', 25, ''),
+('tax_prd', 'setup.company', 'int', 11, '1'),
+('tax_last', 'setup.company', 'int', 11, '1'),
+('postal_address', 'setup.company', 'tinytext', 0, 'N/A'),
+('phone', 'setup.company', 'varchar', 30, ''),
+('fax', 'setup.company', 'varchar', 30, ''),
+('email', 'setup.company', 'varchar', 100, ''),
+('coy_logo', 'setup.company', 'varchar', 100, ''),
+('domicile', 'setup.company', 'varchar', 55, ''),
+('curr_default', 'setup.company', 'char', 3, 'USD'),
+('use_dimension', 'setup.company', 'tinyint', 1, '1'),
+('f_year', 'setup.company', 'int', 11, '1'),
+('shortname_name_in_list','setup.company', 'tinyint', 1, '0'),
+('no_item_list', 'setup.company', 'tinyint', 1, '0'),
+('no_customer_list', 'setup.company', 'tinyint', 1, '0'),
+('no_supplier_list', 'setup.company', 'tinyint', 1, '0'),
+('base_sales', 'setup.company', 'int', 11, '1'),
+('time_zone', 'setup.company', 'tinyint', 1, '0'),
+('add_pct', 'setup.company', 'int', 5, '-1'),
+('round_to', 'setup.company', 'int', 5, '1'),
+('login_tout', 'setup.company', 'smallint', 6, '600'),
+('past_due_days', 'glsetup.general', 'int', 11, '30'),
+('profit_loss_year_act', 'glsetup.general', 'varchar', 15, '9990'),
+('retained_earnings_act', 'glsetup.general', 'varchar', 15, '3590'),
+('bank_charge_act', 'glsetup.general', 'varchar', 15, '5690'),
+('exchange_diff_act', 'glsetup.general', 'varchar', 15, '4450'),
+('tax_algorithm', 'glsetup.customer', 'tinyint', 1, '1'),
+('default_credit_limit', 'glsetup.customer', 'int', 11, '1000'),
+('accumulate_shipping', 'glsetup.customer', 'tinyint', 1, '0'),
+('legal_text', 'glsetup.customer', 'tinytext', 0, ''),
+('freight_act', 'glsetup.customer', 'varchar', 15, '4430'),
+('debtors_act', 'glsetup.sales', 'varchar', 15, '1200'),
+('default_sales_act', 'glsetup.sales', 'varchar', 15, '4010'),
+('default_sales_discount_act', 'glsetup.sales', 'varchar', 15, '4510'),
+('default_prompt_payment_act', 'glsetup.sales', 'varchar', 15, '4500'),
+('default_delivery_required', 'glsetup.sales', 'smallint', 6, '1'),
+('default_receival_required', 'glsetup.purchase', 'smallint', 6, '10'),
+('default_quote_valid_days', 'glsetup.sales', 'smallint', 6, '30'),
+('default_dim_required', 'glsetup.dims', 'int', 11, '20'),
+('pyt_discount_act', 'glsetup.purchase', 'varchar', 15, '5060'),
+('creditors_act', 'glsetup.purchase', 'varchar', 15, '2100'),
+('po_over_receive', 'glsetup.purchase', 'int', 11, '10'),
+('po_over_charge', 'glsetup.purchase', 'int', 11, '10'),
+('allow_negative_stock', 'glsetup.inventory', 'tinyint', 1, '0'),
+('default_inventory_act', 'glsetup.items', 'varchar', 15, '1510'),
+('default_cogs_act', 'glsetup.items', 'varchar', 15, '5010'),
+('default_adj_act', 'glsetup.items', 'varchar', 15, '5040'),
+('default_inv_sales_act', 'glsetup.items', 'varchar', 15, '4010'),
+('default_wip_act', 'glsetup.items', 'varchar', 15, '1530'),
+('default_workorder_required', 'glsetup.manuf', 'int', 11, '20'),
+('version_id', 'system', 'varchar', 11, '2.4.1'),
+('auto_curr_reval', 'setup.company', 'smallint', 6, '1'),
+('grn_clearing_act', 'glsetup.purchase', 'varchar', 15, '1550'),
+('bcc_email', 'setup.company', 'varchar', 100, ''),
+('deferred_income_act', 'glsetup.sales', 'varchar', '15', '2105'),
+('gl_closing_date','setup.closing_date', 'date', 8, ''),
+('alternative_tax_include_on_docs','setup.company', 'tinyint', 1, '0'),
+('no_zero_lines_amount','glsetup.sales', 'tinyint', 1, '1'),
+('show_po_item_codes','glsetup.purchase', 'tinyint', 1, '0'),
+('accounts_alpha','glsetup.general', 'tinyint', 1, '0'),
+('loc_notification','glsetup.inventory', 'tinyint', 1, '0'),
+('print_invoice_no','glsetup.sales', 'tinyint', 1, '0'),
+('allow_negative_prices','glsetup.inventory', 'tinyint', 1, '1'),
+('print_item_images_on_quote','glsetup.inventory', 'tinyint', 1, '0'),
+('suppress_tax_rates','setup.company', 'tinyint', 1, '0'),
+('company_logo_report','setup.company', 'tinyint', 1, '0'),
+('barcodes_on_stock','setup.company', 'tinyint', 1, '0'),
+('print_dialog_direct','setup.company', 'tinyint', 1, '0'),
+('ref_no_auto_increase','setup.company', 'tinyint', 1, '0'),
+('default_loss_on_asset_disposal_act', 'glsetup.items', 'varchar', '15', '5660'),
+('depreciation_period', 'glsetup.company', 'tinyint', '1', '1'),
+('use_manufacturing','setup.company', 'tinyint', 1, '1'),
+('dim_on_recurrent_invoice','setup.company', 'tinyint', 1, '0'),
+('long_description_invoice','setup.company', 'tinyint', 1, '0'),
+('max_days_in_docs','setup.company', 'smallint', 5, '180'),
+('use_fixed_assets','setup.company', 'tinyint', 1, '1');
+
+-- Structure of table `0_tag_associations` --
+
+DROP TABLE IF EXISTS `0_tag_associations`;
+
+CREATE TABLE `0_tag_associations` (
+ `record_id` varchar(15) NOT NULL,
+ `tag_id` int(11) NOT NULL,
+ PRIMARY KEY (`record_id`,`tag_id`)
+) ENGINE=InnoDB ;
+
+-- Data of table `0_tag_associations` --
+
+-- Structure of table `0_tags` --