Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT avg(vote) FROM votes WHERE uid = $uid AND gid = $gid;
- SELECT count(uid) FROM votes WHERE uid = $uid AND gid = $gid;
- CREATE TABLE IF NOT EXISTS `games` (
- `id` int(8) NOT NULL auto_increment,
- `title` varchar(50) NOT NULL,
- PRIMARY KEY (`id`)
- ) AUTO_INCREMENT=1 ;
- CREATE TABLE IF NOT EXISTS `users` (
- `id` int(8) NOT NULL auto_increment,
- `username` varchar(20) NOT NULL,
- PRIMARY KEY (`id`)
- ) AUTO_INCREMENT=1 ;
- CREATE TABLE IF NOT EXISTS `votes` (
- `uid` int(8) NOT NULL,
- `gid` int(8) NOT NULL,
- `vote` int(1) NOT NULL,
- KEY `uid` (`uid`,`gid`)
- ) ;
- CREATE TABLE IF NOT EXISTS `votes` (
- `uid` int(8) unsigned NOT NULL,
- `gid` int(8) unsigned NOT NULL,
- `vote` int(1) NOT NULL,
- PRIMARY KEY (`gid`, `uid`)
- ) ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement