Cod: Selectaţi tot

CREATE TABLE `surprisebox` (
`id`  int(5) NOT NULL AUTO_INCREMENT ,
`openorclose`  int(5) NOT NULL ,
`box1`  int(8) NULL DEFAULT NULL ,
`box2`  int(8) NULL DEFAULT NULL ,
`box3`  int(8) NULL DEFAULT NULL ,
`box4`  int(8) NULL DEFAULT NULL ,
`box5`  int(8) NULL DEFAULT NULL ,
`date`  varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL ,
`hour`  varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
AUTO_INCREMENT=47
CHECKSUM=0
ROW_FORMAT=DYNAMIC
DELAY_KEY_WRITE=0
;

Cod: Selectaţi tot

INSERT INTO `surprisebox` (`openorclose`,`box1`,`box2`,`box3`,`box4`,`box5`,`date`,`hour`) VALUES (1, ITEM_ID_1, ITEM_ID_2, ITEM_ID_3, ITEM_ID_4, ITEM_ID_5, '<date>', '<hour>');