Para620

|
Posted:
Sun Sep 12, 2004 8:29 pm |
|
Thanks for the help there Nukeum66. I have got it to show correctly in the Admin section but still having a little trouble with the SQL Tables I think because I am getting the access Denied. Here is the SQL Tables that I have added.
# --------------------------------------------------------
#
# Table structure for table `nuke_downloads2_categories`
#
CREATE TABLE `nuke_downloads2_categories` (
`cid` int(11) NOT NULL auto_increment,
`title` varchar(50) NOT NULL default '',
`cdescription` text NOT NULL,
`parentid` int(11) NOT NULL default '0',
PRIMARY KEY (`cid`),
KEY `cid` (`cid`),
KEY `title` (`title`)
) TYPE=MyISAM AUTO_INCREMENT=8 ;
# --------------------------------------------------------
#
# Table structure for table `nuke_downloads2_downloads`
#
CREATE TABLE `nuke_downloads2_downloads` (
`lid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`sid` int(11) NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`url` varchar(100) NOT NULL default '',
`description` text NOT NULL,
`date` datetime default NULL,
`name` varchar(100) NOT NULL default '',
`email` varchar(100) NOT NULL default '',
`hits` int(11) NOT NULL default '0',
`submitter` varchar(60) NOT NULL default '',
`downloadratingsummary` double(6,4) NOT NULL default '0.0000',
`totalvotes` int(11) NOT NULL default '0',
`totalcomments` int(11) NOT NULL default '0',
`filesize` int(11) NOT NULL default '0',
`version` varchar(10) NOT NULL default '',
`homepage` varchar(200) NOT NULL default '',
PRIMARY KEY (`lid`),
KEY `lid` (`lid`),
KEY `cid` (`cid`),
KEY `sid` (`sid`),
KEY `title` (`title`)
) TYPE=MyISAM AUTO_INCREMENT=81 ;
# --------------------------------------------------------
#
# Table structure for table `nuke_downloads2_editorials`
#
CREATE TABLE `nuke_downloads2_editorials` (
`downloadid` int(11) NOT NULL default '0',
`adminid` varchar(60) NOT NULL default '',
`editorialtimestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`editorialtext` text NOT NULL,
`editorialtitle` varchar(100) NOT NULL default '',
PRIMARY KEY (`downloadid`),
KEY `downloadid` (`downloadid`)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `nuke_downloads2_modrequest`
#
CREATE TABLE `nuke_downloads2_modrequest` (
`requestid` int(11) NOT NULL auto_increment,
`lid` int(11) NOT NULL default '0',
`cid` int(11) NOT NULL default '0',
`sid` int(11) NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`url` varchar(100) NOT NULL default '',
`description` text NOT NULL,
`modifysubmitter` varchar(60) NOT NULL default '',
`brokendownload` int(3) NOT NULL default '0',
`name` varchar(100) NOT NULL default '',
`email` varchar(100) NOT NULL default '',
`filesize` int(11) NOT NULL default '0',
`version` varchar(10) NOT NULL default '',
`homepage` varchar(200) NOT NULL default '',
PRIMARY KEY (`requestid`),
UNIQUE KEY `requestid` (`requestid`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;
# --------------------------------------------------------
#
# Table structure for table `nuke_downloads2_newdownload`
#
CREATE TABLE `nuke_downloads2_newdownload` (
`lid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`sid` int(11) NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`url` varchar(100) NOT NULL default '',
`description` text NOT NULL,
`name` varchar(100) NOT NULL default '',
`email` varchar(100) NOT NULL default '',
`submitter` varchar(60) NOT NULL default '',
`filesize` int(11) NOT NULL default '0',
`version` varchar(10) NOT NULL default '',
`homepage` varchar(200) NOT NULL default '',
PRIMARY KEY (`lid`),
KEY `lid` (`lid`),
KEY `cid` (`cid`),
KEY `sid` (`sid`),
KEY `title` (`title`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
# --------------------------------------------------------
#
# Table structure for table `nuke_downloads2_votedata`
#
CREATE TABLE `nuke_downloads2_votedata` (
`ratingdbid` int(11) NOT NULL auto_increment,
`ratinglid` int(11) NOT NULL default '0',
`ratinguser` varchar(60) NOT NULL default '',
`rating` int(11) NOT NULL default '0',
`ratinghostname` varchar(60) NOT NULL default '',
`ratingcomments` text NOT NULL,
`ratingtimestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`ratingdbid`),
KEY `ratingdbid` (`ratingdbid`)
) TYPE=MyISAM AUTO_INCREMENT=5 ; |
|
|