GvHuEnTj

1CREATE TABLE IF NOT EXISTS flatpackstuff (
2    
3    FLATPACKID int AUTO_INCREMENT,
4    NAME varchar (20) NOT NULL,
5    COLOUR varchar (20),
6    TYPE ENUM ("Office", "Kitchen", "Bedroom", "General"),
7    UNITPRICE decimal ,
8      CONSTRAINT CHK_PRICE CHECK (UNITPRICE >=5.00 AND <=500.00),
9    PRIMARY KEY (FLATPACKID),
10    
11);