DROP TABLE IF EXISTS `0_item_units`;
-- --------------------------------------------------------
--
-- Table structure for table `0_item_units`
--
CREATE TABLE `0_item_units` (
`abbr` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`name` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
`decimals` tinyint(2) NOT NULL,
`inactive` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `0_item_units`
--
INSERT INTO `0_item_units` (`abbr`, `name`, `decimals`, `inactive`) VALUES
('BAG', 'Bags', 0, 0),
('BAL', 'Bale', 0, 0),
('BDL', 'Bundles', 0, 0),
('BKL', 'Buckles', 0, 0),
('BOU', 'Billions Of Units', 0, 0),
('BOX', 'Box', 0, 0),
('BTL', 'Bottles', 0, 0),
('BUN', 'Bunches', 0, 0),
('CAN', 'Cans', 0, 0),
('CBM', 'Cubic Meter', 2, 0),
('CCM', 'Cubic Centimeter', 2, 0),
('CMS', 'Centimeter', 2, 0),
('CTN', 'Cartons', 1, 0),
('DOZ', 'Dozen', 1, 0),
('DRM', 'Drum', 1, 0),
('GGR', 'Great Gross', 1, 0),
('GMS', 'Grams', 3, 0),
('GRS', 'Gross', 1, 0),
('GYD', 'Gross Yards', 2, 0),
('KGS', 'Kilograms', 3, 0),
('KLR', 'Kiloliter', 3, 0),
('KME', 'Kilometre', 2, 0),
('MLT', 'Millilitre', 3, 0),
('MTR', 'Meters', 2, 0),
('NOS', 'Numbers', 0, 0),
('OTH', 'Others', 0, 0),
('PAC', 'Packs', 0, 0),
('PCS', 'Pieces', 0, 0),
('PRS', 'Pairs', 0, 0),
('QTL', 'Quintal', 3, 0),
('ROL', 'Rolls', 1, 0),
('SET', 'Sets', 1, 0),
('SQF', 'Square Feet', 3, 0),
('SQM', 'Square Meters', 3, 0),
('SQY', 'Square Yards', 3, 0),
('TBS', 'Tablets', 0, 0),
('TGM', 'Ten Gross', 0, 0),
('THD', 'Thousands', 2, 0),
('TON', 'Tonnes', 3, 0),
('TUB', 'Tubes', 1, 0),
('UGS', 'US Gallons', 2, 0),
('UNT', 'Units', 0, 0),
('YDS', 'Yards', 2, 0);
--
-- Indexes for dumped tables
--
--
-- Indexes for table `0_item_units`
--
ALTER TABLE `0_item_units`
ADD PRIMARY KEY (`abbr`),
ADD UNIQUE KEY `name` (`name`);
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
