Voorbeeld Mysqldump
CREATE TABLE IF NOT EXISTS `tbl_ContentSjabloon` (
`productnaam` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
`referentie` varchar(18) CHARACTER SET utf8 DEFAULT NULL,
`ean` varchar(13) CHARACTER SET utf8 DEFAULT NULL,
`producttype` varchar(255) DEFAULT NULL,
`beschrijving` text CHARACTER SET utf8,
`afbeelding` varchar(55) CHARACTER SET utf8 DEFAULT NULL,
`merk` varchar(255) DEFAULT NULL,
`gewicht` varchar(7) CHARACTER SET utf8 DEFAULT NULL,
`gewichteenheid` varchar(15) DEFAULT NULL,
`mpn` varchar(11) CHARACTER SET utf8 DEFAULT NULL,
`aantalstuks` varchar(29) CHARACTER SET utf8 DEFAULT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Met primary key
create table tbl_main_tool(
pk varchar(100) character set utf8 not null primary key,
merk varchar(100) character set utf8 default null,
apparaat_type varchar(100) character set utf8 default null,
apparaat_versie varchar(100) character set utf8 default null,
soort varchar(100) character set utf8 default null
-- constraint pk primary key (merk,apparaat_type,apparaat_versie) -- Zou dit handig zijn geweest?
);
Bronnen