table consoles.txt

codding for pszone one can use it at playstation zones

CREATE TABLE CONSOLES(CONDITION CHAR(12) NOT NULL PRIMARY KEY,PLAYSTATION1 NUMBER NOT NULL,PLAYSTATION2 NUMBER NOT NULL,PSP NUMBER NOT NULL);
INSERT INTO CONSOLES VALUES('NEW',10,20,15);
INSERT INTO CONSOLES VALUES('SEMI-NEW',7,15,6);
INSERT INTO CONSOLES VALUES('SECOND-HAND',12,10,2);