Edit File by line

[1500] Fix | Delete

[1501] Fix | Delete

CREATE TABLE `0_stock_moves` (

[1502] Fix | Delete

`trans_id` int(11) NOT NULL AUTO_INCREMENT,

[1503] Fix | Delete

`trans_no` int(11) NOT NULL DEFAULT '0',

[1504] Fix | Delete

`stock_id` char(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[1505] Fix | Delete

`type` smallint(6) NOT NULL DEFAULT '0',

[1506] Fix | Delete

`loc_code` char(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[1507] Fix | Delete

`tran_date` date NOT NULL DEFAULT '0000-00-00',

[1508] Fix | Delete

`price` double NOT NULL DEFAULT '0',

[1509] Fix | Delete

`reference` char(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[1510] Fix | Delete

`qty` double NOT NULL DEFAULT '1',

[1511] Fix | Delete

`standard_cost` double NOT NULL DEFAULT '0',

[1512] Fix | Delete

PRIMARY KEY (`trans_id`),

[1513] Fix | Delete

KEY `type` (`type`,`trans_no`),

[1514] Fix | Delete

KEY `Move` (`stock_id`,`loc_code`,`tran_date`)

[1515] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

[1516] Fix | Delete

[1517] Fix | Delete

-- --------------------------------------------------------

[1518] Fix | Delete

[1519] Fix | Delete

[1520] Fix | Delete

-- Table structure for table `0_suppliers`

[1521] Fix | Delete

[1522] Fix | Delete

[1523] Fix | Delete

CREATE TABLE `0_suppliers` (

[1524] Fix | Delete

`supplier_id` int(11) NOT NULL AUTO_INCREMENT,

[1525] Fix | Delete

`supp_name` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[1526] Fix | Delete

`supp_ref` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[1527] Fix | Delete

`address` tinytext COLLATE utf8_unicode_ci NOT NULL,

[1528] Fix | Delete

`supp_address` tinytext COLLATE utf8_unicode_ci NOT NULL,

[1529] Fix | Delete

`gst_no` varchar(25) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[1530] Fix | Delete

`contact` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[1531] Fix | Delete

`supp_account_no` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[1532] Fix | Delete

`website` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[1533] Fix | Delete

`bank_account` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[1534] Fix | Delete

`curr_code` char(3) COLLATE utf8_unicode_ci DEFAULT NULL,

[1535] Fix | Delete

`payment_terms` int(11) DEFAULT NULL,

[1536] Fix | Delete

`tax_included` tinyint(1) NOT NULL DEFAULT '0',

[1537] Fix | Delete

`dimension_id` int(11) DEFAULT '0',

[1538] Fix | Delete

`dimension2_id` int(11) DEFAULT '0',

[1539] Fix | Delete

`tax_group_id` int(11) DEFAULT NULL,

[1540] Fix | Delete

`credit_limit` double NOT NULL DEFAULT '0',

[1541] Fix | Delete

`purchase_account` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[1542] Fix | Delete

`payable_account` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[1543] Fix | Delete

`payment_discount_account` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[1544] Fix | Delete

`notes` tinytext COLLATE utf8_unicode_ci NOT NULL,

[1545] Fix | Delete

`inactive` tinyint(1) NOT NULL DEFAULT '0',

[1546] Fix | Delete

PRIMARY KEY (`supplier_id`),

[1547] Fix | Delete

KEY `supp_ref` (`supp_ref`)

[1548] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

[1549] Fix | Delete

[1550] Fix | Delete

-- --------------------------------------------------------

[1551] Fix | Delete

[1552] Fix | Delete

[1553] Fix | Delete

-- Table structure for table `0_supp_allocations`

[1554] Fix | Delete

[1555] Fix | Delete

[1556] Fix | Delete

CREATE TABLE `0_supp_allocations` (

[1557] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[1558] Fix | Delete

`person_id` int(11) DEFAULT NULL,

[1559] Fix | Delete

`amt` double unsigned DEFAULT NULL,

[1560] Fix | Delete

`date_alloc` date NOT NULL DEFAULT '0000-00-00',

[1561] Fix | Delete

`trans_no_from` int(11) DEFAULT NULL,

[1562] Fix | Delete

`trans_type_from` int(11) DEFAULT NULL,

[1563] Fix | Delete

`trans_no_to` int(11) DEFAULT NULL,

[1564] Fix | Delete

`trans_type_to` int(11) DEFAULT NULL,

[1565] Fix | Delete

PRIMARY KEY (`id`),

[1566] Fix | Delete

UNIQUE KEY `trans_type_from` (`person_id`,`trans_type_from`,`trans_no_from`,`trans_type_to`,`trans_no_to`),

[1567] Fix | Delete

KEY `From` (`trans_type_from`,`trans_no_from`),

[1568] Fix | Delete

KEY `To` (`trans_type_to`,`trans_no_to`)

[1569] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

[1570] Fix | Delete

[1571] Fix | Delete

-- --------------------------------------------------------

[1572] Fix | Delete

[1573] Fix | Delete

[1574] Fix | Delete

-- Table structure for table `0_supp_invoice_items`

[1575] Fix | Delete

[1576] Fix | Delete

[1577] Fix | Delete

CREATE TABLE `0_supp_invoice_items` (

[1578] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[1579] Fix | Delete

`supp_trans_no` int(11) DEFAULT NULL,

[1580] Fix | Delete

`supp_trans_type` int(11) DEFAULT NULL,

[1581] Fix | Delete

`gl_code` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[1582] Fix | Delete

`grn_item_id` int(11) DEFAULT NULL,

[1583] Fix | Delete

`po_detail_item_id` int(11) DEFAULT NULL,

[1584] Fix | Delete

`stock_id` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[1585] Fix | Delete

`description` tinytext COLLATE utf8_unicode_ci,

[1586] Fix | Delete

`quantity` double NOT NULL DEFAULT '0',

[1587] Fix | Delete

`unit_price` double NOT NULL DEFAULT '0',

[1588] Fix | Delete

`unit_tax` double NOT NULL DEFAULT '0',

[1589] Fix | Delete

`memo_` tinytext COLLATE utf8_unicode_ci,

[1590] Fix | Delete

`dimension_id` int(11) NOT NULL DEFAULT '0',

[1591] Fix | Delete

`dimension2_id` int(11) NOT NULL DEFAULT '0',

[1592] Fix | Delete

PRIMARY KEY (`id`),

[1593] Fix | Delete

KEY `Transaction` (`supp_trans_type`,`supp_trans_no`,`stock_id`)

[1594] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

[1595] Fix | Delete

[1596] Fix | Delete

-- --------------------------------------------------------

[1597] Fix | Delete

[1598] Fix | Delete

[1599] Fix | Delete

-- Table structure for table `0_supp_trans`

[1600] Fix | Delete

[1601] Fix | Delete

[1602] Fix | Delete

CREATE TABLE `0_supp_trans` (

[1603] Fix | Delete

`trans_no` int(11) unsigned NOT NULL DEFAULT '0',

[1604] Fix | Delete

`type` smallint(6) unsigned NOT NULL DEFAULT '0',

[1605] Fix | Delete

`supplier_id` int(11) unsigned NOT NULL,

[1606] Fix | Delete

`reference` tinytext COLLATE utf8_unicode_ci NOT NULL,

[1607] Fix | Delete

`supp_reference` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[1608] Fix | Delete

`tran_date` date NOT NULL DEFAULT '0000-00-00',

[1609] Fix | Delete

`due_date` date NOT NULL DEFAULT '0000-00-00',

[1610] Fix | Delete

`ov_amount` double NOT NULL DEFAULT '0',

[1611] Fix | Delete

`ov_discount` double NOT NULL DEFAULT '0',

[1612] Fix | Delete

`ov_gst` double NOT NULL DEFAULT '0',

[1613] Fix | Delete

`rate` double NOT NULL DEFAULT '1',

[1614] Fix | Delete

`alloc` double NOT NULL DEFAULT '0',

[1615] Fix | Delete

`tax_included` tinyint(1) NOT NULL DEFAULT '0',

[1616] Fix | Delete

PRIMARY KEY (`type`,`trans_no`,`supplier_id`),

[1617] Fix | Delete

KEY `supplier_id` (`supplier_id`),

[1618] Fix | Delete

KEY `tran_date` (`tran_date`)

[1619] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

[1620] Fix | Delete

[1621] Fix | Delete

-- --------------------------------------------------------

[1622] Fix | Delete

[1623] Fix | Delete

[1624] Fix | Delete

-- Table structure for table `0_sys_prefs`

[1625] Fix | Delete

[1626] Fix | Delete

[1627] Fix | Delete

CREATE TABLE `0_sys_prefs` (

[1628] Fix | Delete

`name` varchar(35) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[1629] Fix | Delete

`category` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,

[1630] Fix | Delete

`type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[1631] Fix | Delete

`length` smallint(6) DEFAULT NULL,

[1632] Fix | Delete

`value` text COLLATE utf8_unicode_ci NOT NULL,

[1633] Fix | Delete

PRIMARY KEY (`name`),

[1634] Fix | Delete

KEY `category` (`category`)

[1635] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

[1636] Fix | Delete

[1637] Fix | Delete

[1638] Fix | Delete

-- Dumping data for table `0_sys_prefs`

[1639] Fix | Delete

[1640] Fix | Delete

[1641] Fix | Delete

INSERT INTO `0_sys_prefs` VALUES

[1642] Fix | Delete

('accounts_alpha', 'glsetup.general', 'tinyint', 1, '0'),

[1643] Fix | Delete

('accumulate_shipping', 'glsetup.customer', 'tinyint', 1, '0'),

[1644] Fix | Delete

('add_pct', 'setup.company', 'int', 5, '-1'),

[1645] Fix | Delete

('allow_negative_prices', 'glsetup.inventory', 'tinyint', 1, '1'),

[1646] Fix | Delete

('allow_negative_stock', 'glsetup.inventory', 'tinyint', 1, '0'),

[1647] Fix | Delete

('alternative_tax_include_on_docs', 'setup.company', 'tinyint', 1, '0'),

[1648] Fix | Delete

('auto_curr_reval', 'setup.company', 'smallint', 6, '1'),

[1649] Fix | Delete

('bank_charge_act', 'glsetup.general', 'varchar', 15, '5690'),

[1650] Fix | Delete

('barcodes_on_stock', 'setup.company', 'tinyint', 1, '0'),

[1651] Fix | Delete

('base_sales', 'setup.company', 'int', 11, '1'),

[1652] Fix | Delete

('bcc_email', 'setup.company', 'varchar', 100, ''),

[1653] Fix | Delete

('company_logo_on_views', 'setup.company', 'tinyint', 1, '0'),

[1654] Fix | Delete

('company_logo_report', 'setup.company', 'tinyint', 1, '0'),

[1655] Fix | Delete

('coy_logo', 'setup.company', 'varchar', 100, ''),

[1656] Fix | Delete

('coy_name', 'setup.company', 'varchar', 60, '[[site_name]]'),

[1657] Fix | Delete

('coy_no', 'setup.company', 'varchar', 25, ''),

[1658] Fix | Delete

('creditors_act', 'glsetup.purchase', 'varchar', 15, '2100'),

[1659] Fix | Delete

('curr_default', 'setup.company', 'char', 3, 'USD'),

[1660] Fix | Delete

('debtors_act', 'glsetup.sales', 'varchar', 15, '1200'),

[1661] Fix | Delete

('default_adj_act', 'glsetup.items', 'varchar', 15, '5040'),

[1662] Fix | Delete

('default_cogs_act', 'glsetup.items', 'varchar', 15, '5010'),

[1663] Fix | Delete

('default_credit_limit', 'glsetup.customer', 'int', 11, '1000'),

[1664] Fix | Delete

('default_delivery_required', 'glsetup.sales', 'smallint', 6, '1'),

[1665] Fix | Delete

('default_dim_required', 'glsetup.dims', 'int', 11, '20'),

[1666] Fix | Delete

('default_inv_sales_act', 'glsetup.items', 'varchar', 15, '4010'),

[1667] Fix | Delete

('default_inventory_act', 'glsetup.items', 'varchar', 15, '1510'),

[1668] Fix | Delete

('default_loss_on_asset_disposal_act', 'glsetup.items', 'varchar', 15, '5660'),

[1669] Fix | Delete

('default_prompt_payment_act', 'glsetup.sales', 'varchar', 15, '4500'),

[1670] Fix | Delete

('default_quote_valid_days', 'glsetup.sales', 'smallint', 6, '30'),

[1671] Fix | Delete

('default_receival_required', 'glsetup.purchase', 'smallint', 6, '10'),

[1672] Fix | Delete

('default_sales_act', 'glsetup.sales', 'varchar', 15, '4010'),

[1673] Fix | Delete

('default_sales_discount_act', 'glsetup.sales', 'varchar', 15, '4510'),

[1674] Fix | Delete

('default_wip_act', 'glsetup.items', 'varchar', 15, '1530'),

[1675] Fix | Delete

('default_workorder_required', 'glsetup.manuf', 'int', 11, '20'),

[1676] Fix | Delete

('deferred_income_act', 'glsetup.sales', 'varchar', 15, '2105'),

[1677] Fix | Delete

('depreciation_period', 'glsetup.company', 'tinyint', 1, '1'),

[1678] Fix | Delete

('dim_on_recurrent_invoice', 'setup.company', 'tinyint', 1, '0'),

[1679] Fix | Delete

('domicile', 'setup.company', 'varchar', 55, ''),

[1680] Fix | Delete

('email', 'setup.company', 'varchar', 100, ''),

[1681] Fix | Delete

('exchange_diff_act', 'glsetup.general', 'varchar', 15, '4450'),

[1682] Fix | Delete

('f_year', 'setup.company', 'int', 11, '1'),

[1683] Fix | Delete

('fax', 'setup.company', 'varchar', 30, ''),

[1684] Fix | Delete

('freight_act', 'glsetup.customer', 'varchar', 15, '4430'),

[1685] Fix | Delete

('gl_closing_date', 'setup.closing_date', 'date', 8, ''),

[1686] Fix | Delete

('grn_clearing_act', 'glsetup.purchase', 'varchar', 15, '1550'),

[1687] Fix | Delete

('gst_no', 'setup.company', 'varchar', 25, ''),

[1688] Fix | Delete

('legal_text', 'glsetup.customer', 'tinytext', 0, ''),

[1689] Fix | Delete

('loc_notification', 'glsetup.inventory', 'tinyint', 1, '0'),

[1690] Fix | Delete

('login_tout', 'setup.company', 'smallint', 6, '600'),

[1691] Fix | Delete

('long_description_invoice', 'setup.company', 'tinyint', 1, '0'),

[1692] Fix | Delete

('max_days_in_docs', 'setup.company', 'smallint', 5, '180'),

[1693] Fix | Delete

('no_customer_list', 'setup.company', 'tinyint', 1, '0'),

[1694] Fix | Delete

('no_item_list', 'setup.company', 'tinyint', 1, '0'),

[1695] Fix | Delete

('no_supplier_list', 'setup.company', 'tinyint', 1, '0'),

[1696] Fix | Delete

('no_zero_lines_amount', 'glsetup.sales', 'tinyint', 1, '1'),

[1697] Fix | Delete

('past_due_days', 'glsetup.general', 'int', 11, '30'),

[1698] Fix | Delete

('phone', 'setup.company', 'varchar', 30, ''),

[1699] Fix | Delete

('po_over_charge', 'glsetup.purchase', 'int', 11, '10'),

[1700] Fix | Delete

('po_over_receive', 'glsetup.purchase', 'int', 11, '10'),

[1701] Fix | Delete

('postal_address', 'setup.company', 'tinytext', 0, 'N/A'),

[1702] Fix | Delete

('print_dialog_direct', 'setup.company', 'tinyint', 1, '0'),

[1703] Fix | Delete

('print_invoice_no', 'glsetup.sales', 'tinyint', 1, '0'),

[1704] Fix | Delete

('print_item_images_on_quote', 'glsetup.inventory', 'tinyint', 1, '0'),

[1705] Fix | Delete

('profit_loss_year_act', 'glsetup.general', 'varchar', 15, '9990'),

[1706] Fix | Delete

('pyt_discount_act', 'glsetup.purchase', 'varchar', 15, '5060'),

[1707] Fix | Delete

('ref_no_auto_increase', 'setup.company', 'tinyint', 1, '0'),

[1708] Fix | Delete

('retained_earnings_act', 'glsetup.general', 'varchar', 15, '3590'),

[1709] Fix | Delete

('round_to', 'setup.company', 'int', 5, '1'),

[1710] Fix | Delete

('shortname_name_in_list', 'setup.company', 'tinyint', 1, '0'),

[1711] Fix | Delete

('show_po_item_codes', 'glsetup.purchase', 'tinyint', 1, '0'),

[1712] Fix | Delete

('suppress_tax_rates', 'setup.company', 'tinyint', 1, '0'),

[1713] Fix | Delete

('tax_algorithm', 'glsetup.customer', 'tinyint', 1, '1'),

[1714] Fix | Delete

('tax_last', 'setup.company', 'int', 11, '1'),

[1715] Fix | Delete

('tax_prd', 'setup.company', 'int', 11, '1'),

[1716] Fix | Delete

('time_zone', 'setup.company', 'tinyint', 1, '0'),

[1717] Fix | Delete

('use_dimension', 'setup.company', 'tinyint', 1, '1'),

[1718] Fix | Delete

('use_fixed_assets', 'setup.company', 'tinyint', 1, '1'),

[1719] Fix | Delete

('use_manufacturing', 'setup.company', 'tinyint', 1, '1'),

[1720] Fix | Delete

('version_id', 'system', 'varchar', 11, '2.4.1');

[1721] Fix | Delete

[1722] Fix | Delete

-- --------------------------------------------------------

[1723] Fix | Delete

[1724] Fix | Delete

[1725] Fix | Delete

-- Table structure for table `0_tags`

[1726] Fix | Delete

[1727] Fix | Delete

[1728] Fix | Delete

CREATE TABLE `0_tags` (

[1729] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[1730] Fix | Delete

`type` smallint(6) NOT NULL,

[1731] Fix | Delete

`name` varchar(30) COLLATE utf8_unicode_ci NOT NULL,

[1732] Fix | Delete

`description` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,

[1733] Fix | Delete

`inactive` tinyint(1) NOT NULL DEFAULT '0',

[1734] Fix | Delete

PRIMARY KEY (`id`),

[1735] Fix | Delete

UNIQUE KEY `type` (`type`,`name`)

[1736] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

[1737] Fix | Delete

[1738] Fix | Delete

-- --------------------------------------------------------

[1739] Fix | Delete

[1740] Fix | Delete

[1741] Fix | Delete

-- Table structure for table `0_tag_associations`

[1742] Fix | Delete

[1743] Fix | Delete

[1744] Fix | Delete

CREATE TABLE `0_tag_associations` (

[1745] Fix | Delete

`record_id` varchar(15) COLLATE utf8_unicode_ci NOT NULL,

[1746] Fix | Delete

`tag_id` int(11) NOT NULL,

[1747] Fix | Delete

PRIMARY KEY (`record_id`,`tag_id`)

[1748] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

[1749] Fix | Delete

[1750] Fix | Delete

-- --------------------------------------------------------

[1751] Fix | Delete

[1752] Fix | Delete

[1753] Fix | Delete

-- Table structure for table `0_tax_groups`

[1754] Fix | Delete

[1755] Fix | Delete

[1756] Fix | Delete

CREATE TABLE `0_tax_groups` (

[1757] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[1758] Fix | Delete

`name` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[1759] Fix | Delete

`inactive` tinyint(1) NOT NULL DEFAULT '0',

[1760] Fix | Delete

PRIMARY KEY (`id`),

[1761] Fix | Delete

UNIQUE KEY `name` (`name`)

[1762] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

[1763] Fix | Delete

[1764] Fix | Delete

[1765] Fix | Delete

-- Dumping data for table `0_tax_groups`

[1766] Fix | Delete

[1767] Fix | Delete

[1768] Fix | Delete

INSERT INTO `0_tax_groups` VALUES

[1769] Fix | Delete

(1, 'Tax', 0),

[1770] Fix | Delete

(2, 'Tax Exempt', 0);

[1771] Fix | Delete

[1772] Fix | Delete

-- --------------------------------------------------------

[1773] Fix | Delete

[1774] Fix | Delete

[1775] Fix | Delete

-- Table structure for table `0_tax_group_items`

[1776] Fix | Delete

[1777] Fix | Delete

[1778] Fix | Delete

CREATE TABLE `0_tax_group_items` (

[1779] Fix | Delete

`tax_group_id` int(11) NOT NULL DEFAULT '0',

[1780] Fix | Delete

`tax_type_id` int(11) NOT NULL DEFAULT '0',

[1781] Fix | Delete

`tax_shipping` tinyint(1) NOT NULL DEFAULT '0',

[1782] Fix | Delete

PRIMARY KEY (`tax_group_id`,`tax_type_id`)

[1783] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

[1784] Fix | Delete

[1785] Fix | Delete

[1786] Fix | Delete

-- Dumping data for table `0_tax_group_items`

[1787] Fix | Delete

[1788] Fix | Delete

[1789] Fix | Delete

INSERT INTO `0_tax_group_items` VALUES

[1790] Fix | Delete

(1, 1, 1);

[1791] Fix | Delete

[1792] Fix | Delete

-- --------------------------------------------------------

[1793] Fix | Delete

[1794] Fix | Delete

[1795] Fix | Delete

-- Table structure for table `0_tax_types`

[1796] Fix | Delete

[1797] Fix | Delete

[1798] Fix | Delete

CREATE TABLE `0_tax_types` (

[1799] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[1800] Fix | Delete

`rate` double NOT NULL DEFAULT '0',

[1801] Fix | Delete

`sales_gl_code` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[1802] Fix | Delete

`purchasing_gl_code` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[1803] Fix | Delete

`name` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[1804] Fix | Delete

`inactive` tinyint(1) NOT NULL DEFAULT '0',

[1805] Fix | Delete

PRIMARY KEY (`id`)

[1806] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

[1807] Fix | Delete

[1808] Fix | Delete

[1809] Fix | Delete

-- Dumping data for table `0_tax_types`

[1810] Fix | Delete

[1811] Fix | Delete

[1812] Fix | Delete

INSERT INTO `0_tax_types` VALUES

[1813] Fix | Delete

(1, 5, '2150', '2150', 'Tax', 0);

[1814] Fix | Delete

[1815] Fix | Delete

-- --------------------------------------------------------

[1816] Fix | Delete

[1817] Fix | Delete

[1818] Fix | Delete

-- Table structure for table `0_trans_tax_details`

[1819] Fix | Delete

[1820] Fix | Delete

[1821] Fix | Delete

CREATE TABLE `0_trans_tax_details` (

[1822] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[1823] Fix | Delete

`trans_type` smallint(6) DEFAULT NULL,

[1824] Fix | Delete

`trans_no` int(11) DEFAULT NULL,

[1825] Fix | Delete

`tran_date` date NOT NULL,

[1826] Fix | Delete

`tax_type_id` int(11) NOT NULL DEFAULT '0',

[1827] Fix | Delete

`rate` double NOT NULL DEFAULT '0',

[1828] Fix | Delete

`ex_rate` double NOT NULL DEFAULT '1',

[1829] Fix | Delete

`included_in_price` tinyint(1) NOT NULL DEFAULT '0',

[1830] Fix | Delete

`net_amount` double NOT NULL DEFAULT '0',

[1831] Fix | Delete

`amount` double NOT NULL DEFAULT '0',

[1832] Fix | Delete

`memo` tinytext COLLATE utf8_unicode_ci,

[1833] Fix | Delete

`reg_type` tinyint(1) DEFAULT NULL,

[1834] Fix | Delete

PRIMARY KEY (`id`),

[1835] Fix | Delete

KEY `Type_and_Number` (`trans_type`,`trans_no`),

[1836] Fix | Delete

KEY `tran_date` (`tran_date`)

[1837] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

[1838] Fix | Delete

[1839] Fix | Delete

-- --------------------------------------------------------

[1840] Fix | Delete

[1841] Fix | Delete

[1842] Fix | Delete

-- Table structure for table `0_useronline`

[1843] Fix | Delete

[1844] Fix | Delete

[1845] Fix | Delete

CREATE TABLE `0_useronline` (

[1846] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[1847] Fix | Delete

`timestamp` int(15) NOT NULL DEFAULT '0',

[1848] Fix | Delete

`ip` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[1849] Fix | Delete

`file` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[1850] Fix | Delete

PRIMARY KEY (`id`),

[1851] Fix | Delete

KEY `timestamp` (`timestamp`),

[1852] Fix | Delete

KEY `ip` (`ip`)

[1853] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

[1854] Fix | Delete

[1855] Fix | Delete

-- --------------------------------------------------------

[1856] Fix | Delete

[1857] Fix | Delete

[1858] Fix | Delete

-- Table structure for table `0_users`

[1859] Fix | Delete

[1860] Fix | Delete

[1861] Fix | Delete

CREATE TABLE `0_users` (

[1862] Fix | Delete

`id` smallint(6) NOT NULL AUTO_INCREMENT,

[1863] Fix | Delete

`user_id` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[1864] Fix | Delete

`password` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[1865] Fix | Delete

`real_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[1866] Fix | Delete

`role_id` int(11) NOT NULL DEFAULT '1',

[1867] Fix | Delete

`phone` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[1868] Fix | Delete

`email` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

[1869] Fix | Delete

`language` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,

[1870] Fix | Delete

`date_format` tinyint(1) NOT NULL DEFAULT '0',

[1871] Fix | Delete

`date_sep` tinyint(1) NOT NULL DEFAULT '0',

[1872] Fix | Delete

`tho_sep` tinyint(1) NOT NULL DEFAULT '0',

[1873] Fix | Delete

`dec_sep` tinyint(1) NOT NULL DEFAULT '0',

[1874] Fix | Delete

`theme` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'default',

[1875] Fix | Delete

`page_size` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'A4',

[1876] Fix | Delete

`prices_dec` smallint(6) NOT NULL DEFAULT '2',

[1877] Fix | Delete

`qty_dec` smallint(6) NOT NULL DEFAULT '2',

[1878] Fix | Delete

`rates_dec` smallint(6) NOT NULL DEFAULT '4',

[1879] Fix | Delete

`percent_dec` smallint(6) NOT NULL DEFAULT '1',

[1880] Fix | Delete

`show_gl` tinyint(1) NOT NULL DEFAULT '1',

[1881] Fix | Delete

`show_codes` tinyint(1) NOT NULL DEFAULT '0',

[1882] Fix | Delete

`show_hints` tinyint(1) NOT NULL DEFAULT '0',

[1883] Fix | Delete

`last_visit_date` datetime DEFAULT NULL,

[1884] Fix | Delete

`query_size` tinyint(1) unsigned NOT NULL DEFAULT '10',

[1885] Fix | Delete

`graphic_links` tinyint(1) DEFAULT '1',

[1886] Fix | Delete

`pos` smallint(6) DEFAULT '1',

[1887] Fix | Delete

`print_profile` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[1888] Fix | Delete

`rep_popup` tinyint(1) DEFAULT '1',

[1889] Fix | Delete

`sticky_doc_date` tinyint(1) DEFAULT '0',

[1890] Fix | Delete

`startup_tab` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[1891] Fix | Delete

`transaction_days` smallint(6) NOT NULL DEFAULT '30',

[1892] Fix | Delete

`save_report_selections` smallint(6) NOT NULL DEFAULT '0',

[1893] Fix | Delete

`use_date_picker` tinyint(1) NOT NULL DEFAULT '1',

[1894] Fix | Delete

`def_print_destination` tinyint(1) NOT NULL DEFAULT '0',

[1895] Fix | Delete

`def_print_orientation` tinyint(1) NOT NULL DEFAULT '0',

[1896] Fix | Delete

`inactive` tinyint(1) NOT NULL DEFAULT '0',

[1897] Fix | Delete

PRIMARY KEY (`id`),

[1898] Fix | Delete

UNIQUE KEY `user_id` (`user_id`)

[1899] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

[1900] Fix | Delete

[1901] Fix | Delete

[1902] Fix | Delete

-- Dumping data for table `0_users`

[1903] Fix | Delete

[1904] Fix | Delete

[1905] Fix | Delete

INSERT INTO `0_users` VALUES

[1906] Fix | Delete

(1, '[[admin_username]]', '[[admin_pass]]', 'Administrator', 2, '', '[[admin_email]]', 'C', 0, 0, 0, 0, 'default', 'Letter', 2, 2, 4, 1, 1, 0, 0, '2021-05-07 13:58:33', 10, 1, 1, '1', 1, 0, 'orders', 30, 0, 1, 0, 0, 0);

[1907] Fix | Delete

[1908] Fix | Delete

-- --------------------------------------------------------

[1909] Fix | Delete

[1910] Fix | Delete

[1911] Fix | Delete

-- Table structure for table `0_voided`

[1912] Fix | Delete

[1913] Fix | Delete

[1914] Fix | Delete

CREATE TABLE `0_voided` (

[1915] Fix | Delete

`type` int(11) NOT NULL DEFAULT '0',

[1916] Fix | Delete

`id` int(11) NOT NULL DEFAULT '0',

[1917] Fix | Delete

`date_` date NOT NULL DEFAULT '0000-00-00',

[1918] Fix | Delete

`memo_` tinytext COLLATE utf8_unicode_ci NOT NULL,

[1919] Fix | Delete

UNIQUE KEY `id` (`type`,`id`)

[1920] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

[1921] Fix | Delete

[1922] Fix | Delete

-- --------------------------------------------------------

[1923] Fix | Delete

[1924] Fix | Delete

[1925] Fix | Delete

-- Table structure for table `0_workcentres`

[1926] Fix | Delete

[1927] Fix | Delete

[1928] Fix | Delete

CREATE TABLE `0_workcentres` (

[1929] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[1930] Fix | Delete

`name` char(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[1931] Fix | Delete

`description` char(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[1932] Fix | Delete

`inactive` tinyint(1) NOT NULL DEFAULT '0',

[1933] Fix | Delete

PRIMARY KEY (`id`),

[1934] Fix | Delete

UNIQUE KEY `name` (`name`)

[1935] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

[1936] Fix | Delete

[1937] Fix | Delete

[1938] Fix | Delete

-- Dumping data for table `0_workcentres`

[1939] Fix | Delete

[1940] Fix | Delete

[1941] Fix | Delete

INSERT INTO `0_workcentres` VALUES

[1942] Fix | Delete

(1, 'Work Centre', '', 0);

[1943] Fix | Delete

[1944] Fix | Delete

-- --------------------------------------------------------

[1945] Fix | Delete

[1946] Fix | Delete

[1947] Fix | Delete

-- Table structure for table `0_workorders`

[1948] Fix | Delete

[1949] Fix | Delete

[1950] Fix | Delete

CREATE TABLE `0_workorders` (

[1951] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[1952] Fix | Delete

`wo_ref` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[1953] Fix | Delete

`loc_code` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[1954] Fix | Delete

`units_reqd` double NOT NULL DEFAULT '1',

[1955] Fix | Delete

`stock_id` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[1956] Fix | Delete

`date_` date NOT NULL DEFAULT '0000-00-00',

[1957] Fix | Delete

`type` tinyint(4) NOT NULL DEFAULT '0',

[1958] Fix | Delete

`required_by` date NOT NULL DEFAULT '0000-00-00',

[1959] Fix | Delete

`released_date` date NOT NULL DEFAULT '0000-00-00',

[1960] Fix | Delete

`units_issued` double NOT NULL DEFAULT '0',

[1961] Fix | Delete

`closed` tinyint(1) NOT NULL DEFAULT '0',

[1962] Fix | Delete

`released` tinyint(1) NOT NULL DEFAULT '0',

[1963] Fix | Delete

`additional_costs` double NOT NULL DEFAULT '0',

[1964] Fix | Delete

PRIMARY KEY (`id`),

[1965] Fix | Delete

UNIQUE KEY `wo_ref` (`wo_ref`)

[1966] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

[1967] Fix | Delete

[1968] Fix | Delete

-- --------------------------------------------------------

[1969] Fix | Delete

[1970] Fix | Delete

[1971] Fix | Delete

-- Table structure for table `0_wo_costing`

[1972] Fix | Delete

[1973] Fix | Delete

[1974] Fix | Delete

CREATE TABLE `0_wo_costing` (

[1975] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[1976] Fix | Delete

`workorder_id` int(11) NOT NULL DEFAULT '0',

[1977] Fix | Delete

`cost_type` tinyint(1) NOT NULL DEFAULT '0',

[1978] Fix | Delete

`trans_type` int(11) NOT NULL DEFAULT '0',

[1979] Fix | Delete

`trans_no` int(11) NOT NULL DEFAULT '0',

[1980] Fix | Delete

`factor` double NOT NULL DEFAULT '1',

[1981] Fix | Delete

PRIMARY KEY (`id`)

[1982] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

[1983] Fix | Delete

[1984] Fix | Delete

-- --------------------------------------------------------

[1985] Fix | Delete

[1986] Fix | Delete

[1987] Fix | Delete

-- Table structure for table `0_wo_issues`

[1988] Fix | Delete

[1989] Fix | Delete

[1990] Fix | Delete

CREATE TABLE `0_wo_issues` (

[1991] Fix | Delete

`issue_no` int(11) NOT NULL AUTO_INCREMENT,

[1992] Fix | Delete

`workorder_id` int(11) NOT NULL DEFAULT '0',

[1993] Fix | Delete

`reference` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

[1994] Fix | Delete

`issue_date` date DEFAULT NULL,

[1995] Fix | Delete

`loc_code` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,

[1996] Fix | Delete

`workcentre_id` int(11) DEFAULT NULL,

[1997] Fix | Delete

PRIMARY KEY (`issue_no`),

[1998] Fix | Delete

KEY `workorder_id` (`workorder_id`)

[1999] Fix | Delete

1 2 345