· 8 years ago · Jul 13, 2018, 04:36 AM
1CREATE TABLE IF NOT EXISTS `cms_pictures` (
2 `pictureID` int(11) NOT NULL AUTO_INCREMENT,
3 `pictureInfo` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'F/10 | 1/60 Sek. | ISO 100 | 11mm | Photoshop',
4 `pictureTitle` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
5 `pictureCat` enum('strasse','portrait','gestaltung','sonstiges') COLLATE utf8_unicode_ci NOT NULL,
6 `pictureFilename` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
7 PRIMARY KEY (`pictureID`)
8) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;