| 1 | CREATE TABLE `wcf1_dldb_data` ( |
|---|
| 2 | `dataID` int(10) unsigned NOT NULL auto_increment, |
|---|
| 3 | `katID` int(10) NOT NULL default '1', |
|---|
| 4 | `name` varchar(255) NOT NULL, |
|---|
| 5 | `description` mediumtext NOT NULL, |
|---|
| 6 | `previewIMG` varchar(255) default NULL, |
|---|
| 7 | `previewFile` varchar(255) default NULL, |
|---|
| 8 | `fileName` varchar(255) default NULL, |
|---|
| 9 | `fileExtension` varchar(7) default NULL, |
|---|
| 10 | `mimeType` varchar(128) default NULL, |
|---|
| 11 | `link` varchar(255) NOT NULL, |
|---|
| 12 | `groesse` int(10) unsigned NOT NULL default '0', |
|---|
| 13 | `downloads` int(10) unsigned NOT NULL default '0', |
|---|
| 14 | `userID` int(10) unsigned NOT NULL, |
|---|
| 15 | `datum` int(10) unsigned NOT NULL, |
|---|
| 16 | `sortOrder` int(10) unsigned NOT NULL default '1', |
|---|
| 17 | `thread` varchar(255) default NULL, |
|---|
| 18 | `activ` tinyint(1)NOT NULL default '0', |
|---|
| 19 | PRIMARY KEY (`dataID`), |
|---|
| 20 | KEY `katID` (`katID`) |
|---|
| 21 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
|---|
| 22 | |
|---|
| 23 | CREATE TABLE `wcf1_dldb_kats` ( |
|---|
| 24 | `katID` int(10) unsigned NOT NULL auto_increment, |
|---|
| 25 | `topID` int(10) unsigned default NULL, |
|---|
| 26 | `name` varchar(255) NOT NULL, |
|---|
| 27 | `description` mediumtext, |
|---|
| 28 | `groupIDs` varchar(255) default NULL, |
|---|
| 29 | `uploadGroups` varchar(255) default NULL, |
|---|
| 30 | `sortOrder` int(10) unsigned default NULL, |
|---|
| 31 | PRIMARY KEY (`katID`), |
|---|
| 32 | KEY `subID` (`topID`) |
|---|
| 33 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
|---|
