MySQL Forums
Forum List  »  Newbie

Re: Help with a Left Join
Posted by: Brandon Rodriguez
Date: August 15, 2004 03:12PM

games_files CREATE TABLE `games_files` (
`id` int(11) NOT NULL auto_increment,
`trackname` varchar(100) NOT NULL default '',
`filename` varchar(100) NOT NULL default '',
`description` text NOT NULL,
`screenshot` varchar(60) NOT NULL default '',
`user` varchar(100) NOT NULL default '',
`type` tinyint(4) NOT NULL default '0',
`park` text NOT NULL,
`time` varchar(20) NOT NULL default '',
`original` tinyint(4) NOT NULL default '0',
`totvotes` int(11) NOT NULL default '0',
`totviews` int(11) NOT NULL default '0',
`downloads` int(11) NOT NULL default '0',
`genre` varchar(20) NOT NULL default '',
`contestid` varchar(4) NOT NULL default '0',
`suppfile` varchar(75) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `id` (`id`)
) TYPE=MyISAM

CREATE TABLE `games_ratings` (
`id` int(11) NOT NULL auto_increment,
`trackid` int(11) NOT NULL default '0',
`username` varchar(50) NOT NULL default '',
`ip` varchar(20) NOT NULL default '',
`rating` float NOT NULL default '0',
`comments` text NOT NULL,
`timestamp` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `id` (`id`)
) TYPE=MyISAM

Options: ReplyQuote


Subject
Written By
Posted
August 15, 2004 12:25AM
August 15, 2004 03:01AM
August 15, 2004 02:50PM
Re: Help with a Left Join
August 15, 2004 03:12PM
August 15, 2004 03:31PM
August 15, 2004 03:38PM
August 16, 2004 02:20AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.