Changeset 71

Show
Ignore:
Timestamp:
03/30/08 02:58:37 (6 months ago)
Author:
wriewra2
Message:

Fixing sucrose.tables so that the combination of (machine_tray_id, machine) will be forced to UNIQUE.

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • sucrose/trunk/mysql/sucrose.tables.sql

    r68 r71  
    3232                machine ENUM('caffeine','sucrose') NOT NULL, 
    3333                cur_price DECIMAL(4,2) NOT NULL, 
     34                UNIQUE(machine_tray_id, machine), 
    3435                CONSTRAINT tray_item_id_fk FOREIGN KEY (item_id) REFERENCES items 
    3536                (item_id) ON DELETE SET NULL ON UPDATE CASCADE