All pastes #904926 Raw Edit

Someone

public text v1 · immutable
·published 2008-02-15 12:03 UTC
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`
--