cms2day Forum - Community & Support rund ums cms2day

Zitat

CREATE TABLE `modul_portfolio` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(255) NOT NULL,
`titel` varchar(255) NOT NULL,
`beschreibung` text NOT NULL,
`aufgaben` varchar(255) NOT NULL,
`webseite` varchar(255) NOT NULL,
`screenshot_1` varchar(255) NOT NULL,
`show_1` varchar(255) NOT NULL,
`thumbnail_1` varchar(255) NOT NULL,
`screenshot_2` varchar(255) NOT NULL,
`show_2` varchar(255) NOT NULL,
`thumbnail_2` varchar(255) NOT NULL,
`screenshot_3` varchar(255) NOT NULL,
`show_3` varchar(255) NOT NULL,
`thumbnail_3` varchar(255) NOT NULL,
`datum` varchar(10) NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `modul_portfolio_bewertung` (
`id` varchar(10) NOT NULL,
`bewertung` varchar(3) NOT NULL
) TYPE=MyISAM;