rendered paste body-- phpMyAdmin SQL Dump
-- version 2.9.1.1-Debian-2ubuntu1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Sep 21, 2007 at 03:48 PM
-- Server version: 5.0.38
-- PHP Version: 5.2.1
--
-- Database: `mapatorium`
--
-- --------------------------------------------------------
--
-- Table structure for table `maps`
--
CREATE TABLE `maps` (
`id` int(5) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`description` text NOT NULL,
`filename` varchar(50) NOT NULL default '',
`size` int(10) NOT NULL default '0',
`client` varchar(10) NOT NULL default '',
`gameplay` varchar(50) NOT NULL,
`group` varchar(6) NOT NULL default '',
`user` varchar(50) NOT NULL default '0',
`date` int(15) NOT NULL default '0',
`downloads` int(6) NOT NULL default '0',
`rating` float NOT NULL default '0',
`votes` int(6) NOT NULL default '0',
`screenfiles` varchar(200) NOT NULL,
`license` varchar(50)rchar(50) NOT NULL,
`textures` tinyint(1) NOT NULL default '0',
`plugins` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `maps`
--
-- --------------------------------------------------------
--
-- Table structure for table `rate`
--
CREATE TABLE `rate` (
`id` int(11) NOT NULL auto_increment,
`map` int(11) NOT NULL,
`rating` int(1) NOT NULL default '1',
`ip` varchar(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `rate`
--