[Summary view] [Print] [Text view]

   1  DROP TABLE {$NAMESPACE}_phortune.phortune_producttransaction;
   2  
   3  ALTER TABLE {$NAMESPACE}_phortune.phortune_product
   4    DROP productName;
   5  
   6  ALTER TABLE {$NAMESPACE}_phortune.phortune_product
   7    DROP priceAsCurrency;
   8  
   9  ALTER TABLE {$NAMESPACE}_phortune.phortune_product
  10    ADD productClassKey BINARY(12) NOT NULL;
  11  
  12  ALTER TABLE {$NAMESPACE}_phortune.phortune_product
  13    ADD productClass VARCHAR(128) NOT NULL COLLATE utf8_bin;
  14  
  15  ALTER TABLE {$NAMESPACE}_phortune.phortune_product
  16    ADD productRefKey BINARY(12) NOT NULL;
  17  
  18  ALTER TABLE {$NAMESPACE}_phortune.phortune_product
  19    ADD productRef VARCHAR(128) NOT NULL COLLATE utf8_bin;
  20  
  21  ALTER TABLE {$NAMESPACE}_phortune.phortune_product
  22    ADD UNIQUE KEY `key_product` (productClassKey, productRefKey);