Ignore:
Timestamp:
Oct 18, 2012, 10:51:41 PM (12 years ago)
Author:
chronos
Message:
  • Přidáno: Skript pro import starých produktů.
File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/sql/updates/446.sql

    r447 r450  
    33RENAME TABLE `Product` TO `ProductOld` ;
    44RENAME TABLE `StockCard` TO `Product` ;
     5ALTER TABLE `Product` CHANGE `Code` `Code` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ;
    56
    67DROP TABLE IF EXISTS `StockItem`;
     
    2829  ADD CONSTRAINT `StockItem_ibfk_3` FOREIGN KEY (`Location`) REFERENCES `Member` (`Id`),
    2930  ADD CONSTRAINT `StockItem_ibfk_5` FOREIGN KEY (`Product`) REFERENCES `Product` (`Id`);
     31ALTER TABLE `StockItem` CHANGE `Segment` `Segment` INT( 11 ) NULL;
     32ALTER TABLE `StockItem` ADD `Info` TEXT NOT NULL ;
    3033
    3134ALTER TABLE `Stock` ADD `Location` INT NULL , ADD INDEX ( `Location` );
    3235ALTER TABLE `Stock` ADD FOREIGN KEY ( `Location` ) REFERENCES `Member` (`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT ;
     36
     37
     38
    3339
    3440
Note: See TracChangeset for help on using the changeset viewer.