Abi vaja viimane tabel ei tööta miskipärast :S
siis töötavad kui võtan tabelist g_armor ja g_gun -i ära aga neid vaja mul!
-- phpMyAdmin SQL Dump
-- version 3.3.8
-- http://www.phpmyadmin.net
--
-- Masin: localhost
-- Tegemisaeg: 05.01.2011 kell 19:13:45
-- Serveri versioon: 5.1.53
-- PHP versioon: 5.2.14
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
-- --------------------------------------------------------
--
-- Struktuur tabelile `game_house`
--
CREATE TABLE IF NOT EXISTS `game_house` (
`g_nimi` text NOT NULL,
`korter1` text NOT NULL,
`korter2` text NOT NULL,
`korter3` text NOT NULL,
`korter4` text NOT NULL,
`korter5` text NOT NULL,
`korter6` text NOT NULL,
`maja1` text NOT NULL,
`maja2` text NOT NULL,
`maja3` text NOT NULL,
`maja4` text NOT NULL,
`maja5` text NOT NULL,
`maja6` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Struktuur tabelile `game_car`
--
CREATE TABLE IF NOT EXISTS `game_car` (
`g_nimi` text NOT NULL,
`k1` text NOT NULL,
`k2` text NOT NULL,
`k3` text NOT NULL,
`k4` text NOT NULL,
`k5` text NOT NULL,
`k6` text NOT NULL,
`m1` text NOT NULL,
`m2` text NOT NULL,
`m3` text NOT NULL,
`m4` text NOT NULL,
`m5` text NOT NULL,
`m6` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Struktuur tabelile `game_login`
--
CREATE TABLE IF NOT EXISTS `game_login` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`p_nimi` text NOT NULL,
`p_pnimi` text NOT NULL,
`m_nimi` text NOT NULL,
`m_parool` text NOT NULL,
`m_email` text NOT NULL,
`m_vanus` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
--
-- Struktuur tabelile `game_mailbox`
--
CREATE TABLE IF NOT EXISTS `game_mailbox` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`kellelt` text NOT NULL,
`kellele` text NOT NULL,
`teema` text NOT NULL,
`sisu` longtext NOT NULL,
`millal` text NOT NULL,
`uuskiri` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
--
-- Tabeli andmete salvestamine `game_mailbox`
--
-- --------------------------------------------------------
--
-- Struktuur tabelile `game_shoutbox`
--
CREATE TABLE IF NOT EXISTS `game_shoutbox` (
`g_nimi` text NOT NULL,
`date` text NOT NULL,
`text` longtext NOT NULL,
`id` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=49 ;
--
-- Struktuur tabelile `game_stats2`
--
CREATE TABLE IF NOT EXISTS `game_stats2` (
`g_nimi` text NOT NULL,
`g_strenght` text NOT NULL,
`g_defense` text NOT NULL,
`g_energy` text NOT NULL,
`g_gun` text NOT NULL,
`g_armor` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
