Units of measure moved from config.php into item_units table

[fa-stable.git] / sql / alter.sql

diff --git a/sql/alter.sql b/sql/alter.sql
index 3a98d59f3cd23cdaf80c19bbdd817d0b6b1108d0..ae2fd8176b6e781b4fbaa7390e60a40658dbefc7 100644 (file)
--- a/sql/alter.sql
+++ b/sql/alter.sql
@@ -16,6 +16,16 @@
 -- ALTER TABLE
 -- 
 
+CREATE TABLE `0_item_units` (
+  `abbr` VARCHAR(20) NOT NULL, 
+  `name` VARCHAR(40) NOT NULL, 
+  `decimals` TINYINT(2) NOT NULL,
+  PRIMARY KEY (`abbr`),
+  UNIQUE (`name`)
+)
+TYPE = myisam
+COMMENT = 'units of measure';
+
 DROP TABLE IF EXISTS `0_form_items`; 
 
 ALTER TABLE `0_tax_types` DROP INDEX `name`, ADD UNIQUE `name` ( `name` , `rate` );