Ciao a tutti, sto installando una MOD per phpbb3 e devo creare una tavola sql nel database:
CREATE TABLE `phpbb_paypal_shop` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`item_desc` VARCHAR( 2000 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`price` DECIMAL( 20, 2 ) NOT NULL ,
`image_big` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`image_small` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`catagory` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL
) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_bin
come faccio?
CREATE TABLE `phpbb_paypal_shop` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`item_desc` VARCHAR( 2000 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`price` DECIMAL( 20, 2 ) NOT NULL ,
`image_big` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`image_small` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`catagory` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL
) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_bin
come faccio?