-- phpMyAdmin SQL Dump
-- version 3.2.0.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 07, 2009 at 09:54 PM
-- Server version: 5.1.36
-- PHP Version: 5.3.0
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `s1`
--
-- --------------------------------------------------------
--
-- Table structure for table `s1_active`
--
CREATE TABLE IF NOT EXISTS `s1_active` (
`username` varchar(15) NOT NULL,
`timestamp` int(11) unsigned NOT NULL,
PRIMARY KEY (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `s1_active`
--
-- --------------------------------------------------------
--
-- Table structure for table `s1_baselog`
--
CREATE TABLE IF NOT EXISTS `s1_baselog` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`vid` int(10) unsigned NOT NULL,
`comment` text NOT NULL,
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `s1_baselog`
--
-- --------------------------------------------------------
--
-- Table structure for table `s1_fdata`
--
CREATE TABLE IF NOT EXISTS `s1_fdata` (
`vref` int(10) unsigned NOT NULL,
`f1` tinyint(2) unsigned NOT NULL,
`f2` tinyint(2) unsigned NOT NULL,
`f3` tinyint(2) unsigned NOT NULL,
`f4` tinyint(2) unsigned NOT NULL,
`f5` tinyint(2) unsigned NOT NULL,
`f6` tinyint(2) unsigned NOT NULL,
`f7` tinyint(2) unsigned NOT NULL,
`f8` tinyint(2) unsigned NOT NULL,
`f9` tinyint(2) unsigned NOT NULL,
`f10` tinyint(2) unsigned NOT NULL,
`f11` tinyint(2) unsigned NOT NULL,
`f12` tinyint(2) unsigned NOT NULL,
`f13` tinyint(2) unsigned NOT NULL,
`f14` tinyint(2) unsigned NOT NULL,
`f15` tinyint(2) unsigned NOT NULL,
`f16` tinyint(2) unsigned NOT NULL,
`f17` tinyint(2) unsigned NOT NULL,
`f18` tinyint(2) unsigned NOT NULL,
`starttime` int(11) unsigned NOT NULL,
`endtime` int(11) unsigned NOT NULL,
`upgrading` tinyint(2) unsigned NOT NULL,
PRIMARY KEY (`vref`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
--
-- Dumping data for table `s1_fdata`
--
-- --------------------------------------------------------
--
-- Table structure for table `s1_users`
--
CREATE TABLE IF NOT EXISTS `s1_users` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(15) NOT NULL,
`password` varchar(32) NOT NULL,
`access` tinyint(1) unsigned NOT NULL,
`email` varchar(50) NOT NULL,
`timestamp` int(11) unsigned NOT NULL DEFAULT '0',
`tribe` tinyint(1) unsigned NOT NULL,
`act` varchar(10) NOT NULL,
`sessid` varchar(45) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `s1_users`
--
-- --------------------------------------------------------
--
-- Table structure for table `s1_vdata`
--
CREATE TABLE IF NOT EXISTS `s1_vdata` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`wref` int(10) unsigned NOT NULL,
`owner` int(10) unsigned NOT NULL,
`name` varchar(45) NOT NULL,
`capital` tinyint(1) unsigned NOT NULL,
`pop` int(10) unsigned NOT NULL,
`maxpop` int(10) NOT NULL,
`wood` float(12,2) NOT NULL,
`clay` float(12,2) NOT NULL,
`iron` float(12,2) NOT NULL,
`maxstore` int(10) unsigned NOT NULL,
`crop` float(12,2) NOT NULL,
`maxcrop` int(10) unsigned NOT NULL,
`lastupdate` int(11) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `s1_vdata`
--
-- --------------------------------------------------------
--
-- Table structure for table `s1_wdata`
--
CREATE TABLE IF NOT EXISTS `s1_wdata` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`fieldtype` tinyint(2) unsigned NOT NULL,
`x` int(11) NOT NULL,
`y` int(11) NOT NULL,
`occupied` tinyint(1) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=26 ;
--
-- Dumping data for table `s1_wdata`
--
INSERT INTO `s1_wdata` (`id`, `fieldtype`, `x`, `y`, `occupied`) VALUES
(1, 1, -2, 2, 0),
(2, 1, -1, 2, 0),
(3, 11, 0, 2, 0),
(4, 1, 1, 2, 0),
(5, 1, 2, 2, 0),
(6, 1, -2, 1, 0),
(7, 1, -1, 1, 0),
(8, 2, 0, 1, 0),
(9, 1, 1, 1, 0),
(10, 1, 2, 1, 0),
(11, 1, -2, 0, 0),
(12, 3, -1, 0, 0),
(13, 2, 0, 0, 0),
(14, 1, 1, 0, 0),
(15, 1, 2, 0, 0),
(16, 2, -2, -1, 0),
(17, 1, -1, -1, 0),
(18, 1, 0, -1, 0),
(19, 1, 1, -1, 0),
(20, 3, 2, -1, 0),
(21, 3, -2, -2, 0),
(22, 3, -1, -2, 0),
(23, 3, 0, -2, 0),
(24, 3, 1, -2, 0),
(25, 3, 2, -2, 0);