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

[2000] Fix | Delete

[2001] Fix | Delete

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

[2002] Fix | Delete

[2003] Fix | Delete

--

[2004] Fix | Delete

-- Table structure for table `0_wo_issue_items`

[2005] Fix | Delete

--

[2006] Fix | Delete

[2007] Fix | Delete

CREATE TABLE `0_wo_issue_items` (

[2008] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[2009] Fix | Delete

`stock_id` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

[2010] Fix | Delete

`issue_id` int(11) DEFAULT NULL,

[2011] Fix | Delete

`qty_issued` double DEFAULT NULL,

[2012] Fix | Delete

`unit_cost` double NOT NULL DEFAULT '0',

[2013] Fix | Delete

PRIMARY KEY (`id`)

[2014] Fix | Delete

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

[2015] Fix | Delete

[2016] Fix | Delete

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

[2017] Fix | Delete

[2018] Fix | Delete

--

[2019] Fix | Delete

-- Table structure for table `0_wo_manufacture`

[2020] Fix | Delete

--

[2021] Fix | Delete

[2022] Fix | Delete

CREATE TABLE `0_wo_manufacture` (

[2023] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[2024] Fix | Delete

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

[2025] Fix | Delete

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

[2026] Fix | Delete

`quantity` double NOT NULL DEFAULT '0',

[2027] Fix | Delete

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

[2028] Fix | Delete

PRIMARY KEY (`id`),

[2029] Fix | Delete

KEY `workorder_id` (`workorder_id`)

[2030] Fix | Delete

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

[2031] Fix | Delete

[2032] Fix | Delete

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

[2033] Fix | Delete

[2034] Fix | Delete

--

[2035] Fix | Delete

-- Table structure for table `0_wo_requirements`

[2036] Fix | Delete

--

[2037] Fix | Delete

[2038] Fix | Delete

CREATE TABLE `0_wo_requirements` (

[2039] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[2040] Fix | Delete

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

[2041] Fix | Delete

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

[2042] Fix | Delete

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

[2043] Fix | Delete

`units_req` double NOT NULL DEFAULT '1',

[2044] Fix | Delete

`unit_cost` double NOT NULL DEFAULT '0',

[2045] Fix | Delete

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

[2046] Fix | Delete

`units_issued` double NOT NULL DEFAULT '0',

[2047] Fix | Delete

PRIMARY KEY (`id`),

[2048] Fix | Delete

KEY `workorder_id` (`workorder_id`)

[2049] Fix | Delete

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

[2050] Fix | Delete

[2051] Fix | Delete

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

[2052] Fix | Delete

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

[2053] Fix | Delete

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

[2054] Fix | Delete

[2055] Fix | Delete