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

Timestamp:

Oct 18, 2012, 10:51:41 PM (12 years ago)

Author:

chronos

Message:

• Přidáno: Skript pro import starých produktů.

File:

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

trunk/sql/updates/446.sql

@@ -3 +3 @@
 RENAME TABLE `Product` TO `ProductOld` ;
 RENAME TABLE `StockCard` TO `Product` ;
+ALTER TABLE `Product` CHANGE `Code` `Code` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ;
 
 DROP TABLE IF EXISTS `StockItem`;
@@ -28 +29 @@
   ADD CONSTRAINT `StockItem_ibfk_3` FOREIGN KEY (`Location`) REFERENCES `Member` (`Id`),
   ADD CONSTRAINT `StockItem_ibfk_5` FOREIGN KEY (`Product`) REFERENCES `Product` (`Id`);
+ALTER TABLE `StockItem` CHANGE `Segment` `Segment` INT( 11 ) NULL;
+ALTER TABLE `StockItem` ADD `Info` TEXT NOT NULL ;
 
 ALTER TABLE `Stock` ADD `Location` INT NULL , ADD INDEX ( `Location` );
 ALTER TABLE `Stock` ADD FOREIGN KEY ( `Location` ) REFERENCES `Member` (`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT ;
+
+
+