Changeset 451 for trunk/sql/updates/446.sql

Timestamp:

Oct 24, 2012, 10:42:58 PM (12 years ago)

Author:

chronos

Message:

• Upraveno: Korekce tabulek Product a StockItem.

File:

• trunk/sql/updates/446.sql (modified) (2 diffs)

trunk/sql/updates/446.sql

@@ -4 +4 @@
 RENAME TABLE `StockCard` TO `Product` ;
 ALTER TABLE `Product` CHANGE `Code` `Code` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ;
+ALTER TABLE `Product` ADD `BuyPrice` FLOAT NOT NULL AFTER `SellPrice`;
 
 DROP TABLE IF EXISTS `StockItem`;
@@ -31 +32 @@
 ALTER TABLE `StockItem` CHANGE `Segment` `Segment` INT( 11 ) NULL;
 ALTER TABLE `StockItem` ADD `Info` TEXT NOT NULL ;
+ALTER TABLE `StockItem` CHANGE `TimeElimination` `TimeElimination` DATE NULL;
 
 ALTER TABLE `Stock` ADD `Location` INT NULL , ADD INDEX ( `Location` );