-- phpMyAdmin SQL Dump -- version 2.11.10 -- http://www.phpmyadmin.net -- http://wap.ureklerde.biz -- Anamakine: localhost -- Üretim Zamanı: 1 may 2008 saat 14:15:43 -- Sunucu sürümü: 5.0.51 -- PHP Sürümü: 5.2.12 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 */; -- -- Veritabanı: `urekler_ferid` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `anekdot` -- CREATE TABLE IF NOT EXISTS `anekdot` ( `klu4` int(11) NOT NULL auto_increment, `message` blob NOT NULL, `who` int(11) NOT NULL default '0', PRIMARY KEY (`klu4`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Tablo döküm verisi `anekdot` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `bannlist` -- CREATE TABLE IF NOT EXISTS `bannlist` ( `klu4` int(11) NOT NULL auto_increment, `ip` varchar(255) character set latin1 collate latin1_bin NOT NULL default '', `soft` varchar(255) character set latin1 collate latin1_bin NOT NULL default '', `user` varchar(255) character set latin1 collate latin1_bin NOT NULL default '', PRIMARY KEY (`klu4`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Tablo döküm verisi `bannlist` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `bomj` -- CREATE TABLE IF NOT EXISTS `bomj` ( `klu4` int(11) NOT NULL default '0', `night_act` text NOT NULL, PRIMARY KEY (`klu4`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Tablo döküm verisi `bomj` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `bots` -- CREATE TABLE IF NOT EXISTS `bots` ( `number` int(5) NOT NULL default '0', `vopros` blob NOT NULL, `answer` varchar(100) NOT NULL default '', `tran` varchar(60) NOT NULL default '', PRIMARY KEY (`number`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Tablo döküm verisi `bots` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `bot_dialog` -- CREATE TABLE IF NOT EXISTS `bot_dialog` ( `id` int(11) NOT NULL auto_increment, `message` blob NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Tablo döküm verisi `bot_dialog` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `chat_banned` -- CREATE TABLE IF NOT EXISTS `chat_banned` ( `id` int(11) NOT NULL auto_increment, `ip` varchar(25) character set latin1 collate latin1_bin NOT NULL default '', `ua` varchar(200) character set latin1 collate latin1_bin NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Tablo döküm verisi `chat_banned` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `chat_letters` -- CREATE TABLE IF NOT EXISTS `chat_letters` ( `lid` int(11) unsigned NOT NULL auto_increment, `id` int(11) NOT NULL default '0', `to` int(11) unsigned NOT NULL default '0', `from` int(11) unsigned NOT NULL default '0', `photo` varchar(25) default NULL, `subject` tinyblob NOT NULL, `body` blob NOT NULL, `date` tinyblob NOT NULL, `time` int(11) unsigned NOT NULL default '0', `read` tinyint(1) NOT NULL default '0', PRIMARY KEY (`lid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Tablo döküm verisi `chat_letters` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `chat_logs` -- CREATE TABLE IF NOT EXISTS `chat_logs` ( `id` int(11) NOT NULL auto_increment, `moder` varchar(25) character set latin1 collate latin1_bin NOT NULL default '', `action` tinyint(1) NOT NULL default '0', `object` varchar(25) character set latin1 collate latin1_bin NOT NULL default '', `blob` blob NOT NULL, `date` varchar(20) character set latin1 collate latin1_bin NOT NULL default '', `time` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Tablo döküm verisi `chat_logs` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `chat_renglinik` -- CREATE TABLE IF NOT EXISTS `chat_renglinik` ( `lid` int(11) unsigned NOT NULL auto_increment, `id` int(11) NOT NULL default '0', `to` int(11) unsigned NOT NULL default '0', `from` int(11) unsigned NOT NULL default '0', `photo` varchar(25) default NULL, `subject` tinyblob NOT NULL, `body` blob NOT NULL, `date` tinyblob NOT NULL, `time` int(11) unsigned NOT NULL default '0', `read` tinyint(1) NOT NULL default '0', PRIMARY KEY (`lid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Tablo döküm verisi `chat_renglinik` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `chat_tel` -- CREATE TABLE IF NOT EXISTS `chat_tel` ( `id` int(11) NOT NULL auto_increment, `moder` varchar(25) character set latin1 collate latin1_bin NOT NULL default '', `action` tinyint(1) NOT NULL default '0', `object` varchar(25) character set latin1 collate latin1_bin NOT NULL default '', `blob` blob NOT NULL, `date` varchar(20) character set latin1 collate latin1_bin NOT NULL default '', `time` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Tablo döküm verisi `chat_tel` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `doktor` -- CREATE TABLE IF NOT EXISTS `doktor` ( `klu4` int(11) NOT NULL default '0', `night_act` text NOT NULL, PRIMARY KEY (`klu4`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Tablo döküm verisi `doktor` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `elan` -- CREATE TABLE IF NOT EXISTS `elan` ( `id` int(11) NOT NULL auto_increment, `login` text NOT NULL, `title` text NOT NULL, `content` text NOT NULL, `date` varchar(25) default NULL, `saat` int(11) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Tablo döküm verisi `elan` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `frazi` -- CREATE TABLE IF NOT EXISTS `frazi` ( `klu4` int(11) NOT NULL auto_increment, `message` blob NOT NULL, PRIMARY KEY (`klu4`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Tablo döküm verisi `frazi` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `friends` -- CREATE TABLE IF NOT EXISTS `friends` ( `klu4` int(11) NOT NULL auto_increment, `id` int(11) NOT NULL default '0', `usid` int(11) NOT NULL default '0', PRIMARY KEY (`klu4`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Tablo döküm verisi `friends` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `gb` -- CREATE TABLE IF NOT EXISTS `gb` ( `id` int(11) NOT NULL auto_increment, `uid` int(11) NOT NULL default '0', `msg` text NOT NULL, `date` varchar(25) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 PACK_KEYS=0 AUTO_INCREMENT=1 ; -- -- Tablo döküm verisi `gb` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `golos` -- CREATE TABLE IF NOT EXISTS `golos` ( `id` int(11) NOT NULL auto_increment, `user` int(11) NOT NULL default '0', `who` int(11) NOT NULL default '0', `ip` varchar(20) NOT NULL default '', `ses` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Tablo döküm verisi `golos` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `hediyye` -- CREATE TABLE IF NOT EXISTS `hediyye` ( `hid` int(11) unsigned NOT NULL auto_increment, `hediye` text NOT NULL, `kime` text NOT NULL, `kim` text NOT NULL, `tarix` text NOT NULL, PRIMARY KEY (`hid`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ; -- -- Tablo döküm verisi `hediyye` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `help` -- CREATE TABLE IF NOT EXISTS `help` ( `rm` int(2) NOT NULL default '0', `who` int(10) NOT NULL default '0', `var` int(1) NOT NULL default '0', PRIMARY KEY (`rm`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Tablo döküm verisi `help` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `ignor` -- CREATE TABLE IF NOT EXISTS `ignor` ( `klu4` int(11) NOT NULL auto_increment, `id` int(11) NOT NULL default '0', `usid` int(11) NOT NULL default '0', PRIMARY KEY (`klu4`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Tablo döküm verisi `ignor` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `ingame23` -- CREATE TABLE IF NOT EXISTS `ingame23` ( `gamer_id` int(11) NOT NULL default '0', `role` varchar(100) NOT NULL default '', `gamer_act` varchar(50) NOT NULL default '', `id_in_game` int(11) NOT NULL default '0', `dvote` int(11) NOT NULL default '0', `wholin` int(11) NOT NULL default '0', `onl` int(12) NOT NULL default '0', `state` tinyint(1) NOT NULL default '0', PRIMARY KEY (`gamer_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Tablo döküm verisi `ingame23` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `journals` -- CREATE TABLE IF NOT EXISTS `journals` ( `id` int(11) NOT NULL auto_increment, `uid` int(11) NOT NULL default '0', `msg` text NOT NULL, `date` varchar(25) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 PACK_KEYS=0 AUTO_INCREMENT=1 ; -- -- Tablo döküm verisi `journals` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `komissar` -- CREATE TABLE IF NOT EXISTS `komissar` ( `klu4` int(11) NOT NULL default '0', `night_act` text NOT NULL, PRIMARY KEY (`klu4`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Tablo döküm verisi `komissar` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `levels` -- CREATE TABLE IF NOT EXISTS `levels` ( `level` smallint(5) NOT NULL default '0', `name` blob, PRIMARY KEY (`level`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Tablo döküm verisi `levels` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `mafaction23` -- CREATE TABLE IF NOT EXISTS `mafaction23` ( `klu4` tinyint(1) NOT NULL default '0', `action` varchar(100) NOT NULL default '', `nexttime` int(11) NOT NULL default '0', `kiked` tinyint(1) NOT NULL default '0', `prevprev` int(11) NOT NULL default '0', `prev` int(11) NOT NULL default '0', `current` int(11) NOT NULL default '0', `cround` smallint(2) NOT NULL default '0', PRIMARY KEY (`klu4`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Tablo döküm verisi `mafaction23` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `mafia` -- CREATE TABLE IF NOT EXISTS `mafia` ( `klu4` int(11) NOT NULL default '0', `night_act` text NOT NULL, PRIMARY KEY (`klu4`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Tablo döküm verisi `mafia` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `maniac` -- CREATE TABLE IF NOT EXISTS `maniac` ( `klu4` int(11) NOT NULL default '0', `night_act` text NOT NULL, PRIMARY KEY (`klu4`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Tablo döküm verisi `maniac` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `news` -- CREATE TABLE IF NOT EXISTS `news` ( `id` int(11) NOT NULL auto_increment, `login` varchar(50) NOT NULL default '', `content` blob NOT NULL, `date` varchar(10) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=0 AUTO_INCREMENT=1 ; -- -- Tablo döküm verisi `news` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `obiav` -- CREATE TABLE IF NOT EXISTS `obiav` ( `id` int(11) NOT NULL auto_increment, `login` text NOT NULL, `title` text NOT NULL, `content` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Tablo döküm verisi `obiav` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `optim` -- CREATE TABLE IF NOT EXISTS `optim` ( `klu4` tinyint(1) NOT NULL default '0', `go` int(11) NOT NULL default '0', `anekdot` int(11) NOT NULL default '0', PRIMARY KEY (`klu4`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Tablo döküm verisi `optim` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `reklama` -- CREATE TABLE IF NOT EXISTS `reklama` ( `id` int(11) NOT NULL auto_increment, `text` varchar(255) NOT NULL default '', `views` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Tablo döküm verisi `reklama` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `room0` -- CREATE TABLE IF NOT EXISTS `room0` ( `klu4` int(8) NOT NULL default '0', `time` varchar(5) NOT NULL default '', `who` varchar(40) NOT NULL default '', `message` blob NOT NULL, `messagewosm` blob NOT NULL, `messagewoasm` blob NOT NULL, `id` double NOT NULL default '0', `towhom` varchar(12) NOT NULL default '', `hid` smallint(1) NOT NULL default '0', `usid` int(12) NOT NULL default '0', `komu` varchar(40) NOT NULL default '', PRIMARY KEY (`klu4`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Tablo döküm verisi `room0` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `room1` -- CREATE TABLE IF NOT EXISTS `room1` ( `klu4` int(8) NOT NULL default '0', `time` varchar(5) NOT NULL default '', `who` varchar(40) NOT NULL default '', `message` blob NOT NULL, `messagewosm` blob NOT NULL, `messagewoasm` blob NOT NULL, `id` double NOT NULL default '0', `towhom` varchar(12) NOT NULL default '', `hid` smallint(1) NOT NULL default '0', `usid` int(12) NOT NULL default '0', `komu` varchar(40) NOT NULL default '', PRIMARY KEY (`klu4`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Tablo döküm verisi `room1` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `room2` -- CREATE TABLE IF NOT EXISTS `room2` ( `klu4` int(8) NOT NULL default '0', `time` varchar(5) NOT NULL default '', `who` varchar(40) NOT NULL default '', `message` blob NOT NULL, `messagewosm` blob NOT NULL, `messagewoasm` blob NOT NULL, `id` double NOT NULL default '0', `towhom` varchar(12) NOT NULL default '', `hid` smallint(1) NOT NULL default '0', `usid` int(12) NOT NULL default '0', `komu` varchar(40) NOT NULL default '', PRIMARY KEY (`klu4`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Tablo döküm verisi `room2` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `room3` -- CREATE TABLE IF NOT EXISTS `room3` ( `klu4` int(8) NOT NULL default '0', `time` varchar(5) NOT NULL default '', `who` varchar(40) NOT NULL default '', `message` blob NOT NULL, `messagewosm` blob NOT NULL, `messagewoasm` blob NOT NULL, `id` double NOT NULL default '0', `towhom` varchar(12) NOT NULL default '', `hid` smallint(1) NOT NULL default '0', `usid` int(12) NOT NULL default '0', `komu` varchar(40) NOT NULL default '', PRIMARY KEY (`klu4`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Tablo döküm verisi `room3` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `room4` -- CREATE TABLE IF NOT EXISTS `room4` ( `klu4` int(8) NOT NULL default '0', `time` varchar(5) NOT NULL default '', `who` varchar(40) NOT NULL default '', `message` blob NOT NULL, `messagewosm` blob NOT NULL, `messagewoasm` blob NOT NULL, `id` double NOT NULL default '0', `towhom` varchar(12) NOT NULL default '', `hid` smallint(1) NOT NULL default '0', `usid` int(12) NOT NULL default '0', `komu` varchar(40) NOT NULL default '', PRIMARY KEY (`klu4`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Tablo döküm verisi `room4` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `room5` -- CREATE TABLE IF NOT EXISTS `room5` ( `klu4` int(8) NOT NULL default '0', `time` varchar(5) NOT NULL default '', `who` varchar(40) NOT NULL default '', `message` blob NOT NULL, `messagewosm` blob NOT NULL, `messagewoasm` blob NOT NULL, `id` double NOT NULL default '0', `towhom` varchar(12) NOT NULL default '', `hid` smallint(1) NOT NULL default '0', `usid` int(12) NOT NULL default '0', `komu` varchar(40) NOT NULL default '', PRIMARY KEY (`klu4`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Tablo döküm verisi `room5` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `room6` -- CREATE TABLE IF NOT EXISTS `room6` ( `klu4` int(8) NOT NULL default '0', `time` varchar(5) NOT NULL default '', `who` varchar(40) NOT NULL default '', `message` blob NOT NULL, `messagewosm` blob NOT NULL, `messagewoasm` blob NOT NULL, `id` double NOT NULL default '0', `towhom` varchar(12) NOT NULL default '', `hid` smallint(1) NOT NULL default '0', `usid` int(12) NOT NULL default '0', `komu` varchar(40) NOT NULL default '', PRIMARY KEY (`klu4`), KEY `id` (`id`), KEY `id_2` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Tablo döküm verisi `room6` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `room7` -- CREATE TABLE IF NOT EXISTS `room7` ( `klu4` int(8) NOT NULL default '0', `time` varchar(5) NOT NULL default '', `who` varchar(40) NOT NULL default '', `message` blob NOT NULL, `messagewosm` blob NOT NULL, `messagewoasm` blob NOT NULL, `id` double NOT NULL default '0', `towhom` varchar(12) NOT NULL default '', `hid` smallint(1) NOT NULL default '0', `usid` int(12) NOT NULL default '0', `komu` varchar(40) NOT NULL default '', PRIMARY KEY (`klu4`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Tablo döküm verisi `room7` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `room8` -- CREATE TABLE IF NOT EXISTS `room8` ( `klu4` int(8) NOT NULL default '0', `time` varchar(5) NOT NULL default '', `who` varchar(40) NOT NULL default '', `message` blob NOT NULL, `messagewosm` blob NOT NULL, `messagewoasm` blob NOT NULL, `id` double NOT NULL default '0', `towhom` varchar(12) NOT NULL default '', `hid` smallint(1) NOT NULL default '0', `usid` int(12) NOT NULL default '0', `komu` varchar(40) NOT NULL default '', PRIMARY KEY (`klu4`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Tablo döküm verisi `room8` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `room9` -- CREATE TABLE IF NOT EXISTS `room9` ( `klu4` int(8) NOT NULL default '0', `time` varchar(5) NOT NULL default '', `who` varchar(40) NOT NULL default '', `message` blob NOT NULL, `messagewosm` blob NOT NULL, `messagewoasm` blob NOT NULL, `id` double NOT NULL default '0', `towhom` varchar(12) NOT NULL default '', `hid` smallint(1) NOT NULL default '0', `usid` int(12) NOT NULL default '0', `komu` varchar(40) NOT NULL default '', PRIMARY KEY (`klu4`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Tablo döküm verisi `room9` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `room10` -- CREATE TABLE IF NOT EXISTS `room10` ( `klu4` int(8) NOT NULL default '0', `time` varchar(5) character set latin1 collate latin1_bin NOT NULL default '', `who` varchar(40) NOT NULL default '', `message` blob NOT NULL, `messagewosm` blob NOT NULL, `messagewoasm` blob NOT NULL, `id` double NOT NULL default '0', `towhom` varchar(12) character set latin1 collate latin1_bin NOT NULL default '', `hid` smallint(1) NOT NULL default '0', `usid` int(12) NOT NULL default '0', `pwd` varchar(255) NOT NULL default '', `komu` varchar(40) NOT NULL default '', PRIMARY KEY (`klu4`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Tablo döküm verisi `room10` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `room11` -- CREATE TABLE IF NOT EXISTS `room11` ( `klu4` int(8) NOT NULL default '0', `time` varchar(5) NOT NULL default '', `who` varchar(40) NOT NULL default '', `message` blob NOT NULL, `messagewosm` blob NOT NULL, `messagewoasm` blob NOT NULL, `id` double NOT NULL default '0', `towhom` varchar(12) NOT NULL default '', `hid` smallint(1) NOT NULL default '0', `usid` int(12) NOT NULL default '0', `komu` varchar(40) NOT NULL default '', PRIMARY KEY (`klu4`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Tablo döküm verisi `room11` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `room12` -- CREATE TABLE IF NOT EXISTS `room12` ( `klu4` int(8) NOT NULL default '0', `time` varchar(5) NOT NULL default '', `who` varchar(40) NOT NULL default '', `message` blob NOT NULL, `messagewosm` blob NOT NULL, `messagewoasm` blob NOT NULL, `id` double NOT NULL default '0', `towhom` varchar(12) NOT NULL default '', `hid` smallint(1) NOT NULL default '0', `usid` int(12) NOT NULL default '0', `komu` varchar(40) NOT NULL default '', PRIMARY KEY (`klu4`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Tablo döküm verisi `room12` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `room13` -- CREATE TABLE IF NOT EXISTS `room13` ( `klu4` int(8) NOT NULL default '0', `time` varchar(5) NOT NULL default '', `who` varchar(40) NOT NULL default '', `message` blob NOT NULL, `messagewosm` blob NOT NULL, `messagewoasm` blob NOT NULL, `id` double NOT NULL default '0', `towhom` varchar(12) NOT NULL default '', `hid` smallint(1) NOT NULL default '0', `usid` int(12) NOT NULL default '0', `komu` varchar(40) NOT NULL default '', PRIMARY KEY (`klu4`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Tablo döküm verisi `room13` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `room14` -- CREATE TABLE IF NOT EXISTS `room14` ( `klu4` int(8) NOT NULL default '0', `time` varchar(5) NOT NULL default '', `who` varchar(40) NOT NULL default '', `message` blob NOT NULL, `messagewosm` blob NOT NULL, `messagewoasm` blob NOT NULL, `id` double NOT NULL default '0', `towhom` varchar(12) NOT NULL default '', `hid` smallint(1) NOT NULL default '0', `usid` int(12) NOT NULL default '0', `komu` varchar(40) NOT NULL default '', PRIMARY KEY (`klu4`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Tablo döküm verisi `room14` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `room15` -- CREATE TABLE IF NOT EXISTS `room15` ( `klu4` int(8) NOT NULL default '0', `time` varchar(5) NOT NULL default '', `who` varchar(40) NOT NULL default '', `message` blob NOT NULL, `messagewosm` blob NOT NULL, `messagewoasm` blob NOT NULL, `id` double NOT NULL default '0', `towhom` varchar(12) NOT NULL default '', `hid` smallint(1) NOT NULL default '0', `usid` int(12) NOT NULL default '0', `komu` varchar(40) NOT NULL default '', PRIMARY KEY (`klu4`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Tablo döküm verisi `room15` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `room16` -- CREATE TABLE IF NOT EXISTS `room16` ( `klu4` int(8) NOT NULL default '0', `time` varchar(5) NOT NULL default '', `who` varchar(40) NOT NULL default '', `message` blob NOT NULL, `messagewosm` blob NOT NULL, `messagewoasm` blob NOT NULL, `id` double NOT NULL default '0', `towhom` varchar(12) NOT NULL default '', `hid` smallint(1) NOT NULL default '0', `usid` int(12) NOT NULL default '0', `komu` varchar(40) NOT NULL default '', PRIMARY KEY (`klu4`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Tablo döküm verisi `room16` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `room17` -- CREATE TABLE IF NOT EXISTS `room17` ( `klu4` int(8) NOT NULL default '0', `time` varchar(5) NOT NULL default '', `who` varchar(40) NOT NULL default '', `message` blob NOT NULL, `messagewosm` blob NOT NULL, `messagewoasm` blob NOT NULL, `id` double NOT NULL default '0', `towhom` varchar(12) NOT NULL default '', `hid` smallint(1) NOT NULL default '0', `usid` int(12) NOT NULL default '0', `komu` varchar(40) NOT NULL default '', PRIMARY KEY (`klu4`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Tablo döküm verisi `room17` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `room18` -- CREATE TABLE IF NOT EXISTS `room18` ( `klu4` int(8) NOT NULL default '0', `time` varchar(5) NOT NULL default '', `who` varchar(40) NOT NULL default '', `message` blob NOT NULL, `messagewosm` blob NOT NULL, `messagewoasm` blob NOT NULL, `id` double NOT NULL default '0', `towhom` varchar(12) NOT NULL default '', `hid` smallint(1) NOT NULL default '0', `usid` int(12) NOT NULL default '0', `komu` varchar(40) NOT NULL default '', PRIMARY KEY (`klu4`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Tablo döküm verisi `room18` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `room19` -- CREATE TABLE IF NOT EXISTS `room19` ( `klu4` int(8) NOT NULL default '0', `time` varchar(5) NOT NULL default '', `who` varchar(40) NOT NULL default '', `message` blob NOT NULL, `messagewosm` blob NOT NULL, `messagewoasm` blob NOT NULL, `id` double NOT NULL default '0', `towhom` varchar(12) NOT NULL default '', `hid` smallint(1) NOT NULL default '0', `usid` int(12) NOT NULL default '0', `komu` varchar(40) NOT NULL default '', PRIMARY KEY (`klu4`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Tablo döküm verisi `room19` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `room20` -- CREATE TABLE IF NOT EXISTS `room20` ( `klu4` int(8) NOT NULL default '0', `time` varchar(5) NOT NULL default '', `who` varchar(40) NOT NULL default '', `message` blob NOT NULL, `messagewosm` blob NOT NULL, `messagewoasm` blob NOT NULL, `id` double NOT NULL default '0', `towhom` varchar(12) NOT NULL default '', `hid` smallint(1) NOT NULL default '0', `usid` int(12) NOT NULL default '0', `komu` varchar(40) NOT NULL default '', PRIMARY KEY (`klu4`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Tablo döküm verisi `room20` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `room21` -- CREATE TABLE IF NOT EXISTS `room21` ( `klu4` int(8) NOT NULL default '0', `time` varchar(5) NOT NULL default '', `who` varchar(40) NOT NULL default '', `message` blob NOT NULL, `messagewosm` blob NOT NULL, `messagewoasm` blob NOT NULL, `id` double NOT NULL default '0', `towhom` varchar(12) NOT NULL default '', `hid` smallint(1) NOT NULL default '0', `usid` int(12) NOT NULL default '0', `komu` varchar(40) NOT NULL default '', PRIMARY KEY (`klu4`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Tablo döküm verisi `room21` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `room22` -- CREATE TABLE IF NOT EXISTS `room22` ( `klu4` int(8) NOT NULL default '0', `time` varchar(5) NOT NULL default '', `who` varchar(40) NOT NULL default '', `message` blob NOT NULL, `messagewosm` blob NOT NULL, `messagewoasm` blob NOT NULL, `id` double NOT NULL default '0', `towhom` varchar(12) NOT NULL default '', `hid` smallint(1) NOT NULL default '0', `usid` int(12) NOT NULL default '0', `komu` varchar(40) NOT NULL default '', PRIMARY KEY (`klu4`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Tablo döküm verisi `room22` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `room23` -- CREATE TABLE IF NOT EXISTS `room23` ( `klu4` int(8) NOT NULL default '0', `time` varchar(5) NOT NULL default '', `who` varchar(100) NOT NULL default '', `message` text NOT NULL, `messagewosm` text NOT NULL, `messagewoasm` text NOT NULL, `id` double NOT NULL default '0', `towhom` varchar(12) NOT NULL default '', `hid` smallint(1) NOT NULL default '0', `usid` int(12) NOT NULL default '0', `gamemes` tinyint(1) NOT NULL default '0', `komu` varchar(40) NOT NULL default '', PRIMARY KEY (`klu4`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Tablo döküm verisi `room23` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `rooms` -- CREATE TABLE IF NOT EXISTS `rooms` ( `rm` smallint(5) NOT NULL auto_increment, `name` blob, `topic` blob, `pos` tinyint(2) NOT NULL default '0', PRIMARY KEY (`rm`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=0 AUTO_INCREMENT=1 ; -- -- Tablo döküm verisi `rooms` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `scores23` -- CREATE TABLE IF NOT EXISTS `scores23` ( `gamer_id` int(11) NOT NULL default '0', `score` int(11) NOT NULL default '0', PRIMARY KEY (`gamer_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Tablo döküm verisi `scores23` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `setting` -- CREATE TABLE IF NOT EXISTS `setting` ( `klu4` smallint(1) NOT NULL default '0', `shut` smallint(1) NOT NULL default '0', `vict` smallint(1) NOT NULL default '0', `shutint` smallint(4) NOT NULL default '0', `victint` smallint(4) NOT NULL default '0', `roomon` smallint(2) NOT NULL default '0', `roomoff` smallint(2) NOT NULL default '0', `prod` smallint(1) NOT NULL default '0', `link1` varchar(200) NOT NULL default '', `link2` varchar(200) NOT NULL default '', `link3` varchar(200) NOT NULL default '', `link1_name` varchar(50) character set latin1 collate latin1_bin NOT NULL default '', `link2_name` varchar(50) character set latin1 collate latin1_bin NOT NULL default '', `link3_name` varchar(50) character set latin1 collate latin1_bin NOT NULL default '', `rus` smallint(1) NOT NULL default '0', `reg` smallint(1) NOT NULL default '0', `ch_filtr` smallint(1) NOT NULL default '0', `delmsg` smallint(1) NOT NULL default '0', `m_delmsg` smallint(1) NOT NULL default '0', `computer` smallint(1) NOT NULL default '1', `komputer` smallint(1) NOT NULL default '1', PRIMARY KEY (`klu4`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Tablo döküm verisi `setting` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `shutki` -- CREATE TABLE IF NOT EXISTS `shutki` ( `klu4` int(11) NOT NULL auto_increment, `message` blob NOT NULL, PRIMARY KEY (`klu4`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Tablo döküm verisi `shutki` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `svadbi` -- CREATE TABLE IF NOT EXISTS `svadbi` ( `id` int(11) NOT NULL auto_increment, `zhenih` text NOT NULL, `nevesta` text NOT NULL, `frzhenih` blob NOT NULL, `frnevesta` blob NOT NULL, `date` varchar(10) character set latin1 collate latin1_bin default NULL, `vremya` varchar(10) character set latin1 collate latin1_bin default NULL, `organizatory` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Tablo döküm verisi `svadbi` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `users` -- CREATE TABLE IF NOT EXISTS `users` ( `id` int(11) NOT NULL auto_increment, `user` varchar(50) character set latin1 collate latin1_bin NOT NULL default '', `pass` varchar(30) character set latin1 collate latin1_bin default NULL, `name` varchar(30) character set latin1 collate latin1_bin default NULL, `sex` varchar(6) character set latin1 collate latin1_bin default NULL, `birth` varchar(10) default NULL, `city` varchar(100) default NULL, `mail` varchar(200) default NULL, `site` varchar(200) NOT NULL default '', `icq` varchar(100) default NULL, `infa` blob, `posts` int(11) NOT NULL default '0', `status` varchar(100) character set latin1 collate latin1_bin NOT NULL default 'Qonaq', `date` varchar(10) character set latin1 collate latin1_bin default NULL, `avr` smallint(3) NOT NULL default '300', `max` smallint(2) NOT NULL default '10', `op` varchar(100) character set latin1 collate latin1_bin default NULL, `mob` varchar(100) character set latin1 collate latin1_bin default NULL, `level` smallint(6) NOT NULL default '0', `kik` int(20) NOT NULL default '0', `whokik` varchar(20) character set latin1 collate latin1_bin NOT NULL default '', `whykik` varchar(200) character set latin1 collate latin1_bin NOT NULL default '', `user_ip` varchar(20) character set latin1 collate latin1_bin NOT NULL default '', `user_soft` varchar(200) character set latin1 collate latin1_bin NOT NULL default '', `inv` tinyint(1) NOT NULL default '0', `say` smallint(6) NOT NULL default '0', `credits` int(11) NOT NULL default '0', `gposts` int(11) NOT NULL default '0', `img` varchar(50) character set latin1 collate latin1_bin NOT NULL default '', `translit` tinyint(1) NOT NULL default '0', `visit` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `ruser` varchar(30) character set latin1 collate latin1_bin NOT NULL default '', `latuser` varchar(30) character set latin1 collate latin1_bin NOT NULL default '', `onl` int(11) NOT NULL default '0', `room` varchar(10) character set latin1 collate latin1_bin NOT NULL default '', `smiles` tinyint(1) NOT NULL default '2', `safe` tinyint(1) NOT NULL default '1', `fsize` varchar(10) NOT NULL default 'medium', `number` text NOT NULL, `kn_say` tinyint(1) NOT NULL default '0', `kn_update` tinyint(1) NOT NULL default '0', `kn_letters` tinyint(1) NOT NULL default '0', `kn_whochat` tinyint(1) NOT NULL default '1', `kn_whoroom` tinyint(1) NOT NULL default '0', `kn_holl` tinyint(1) NOT NULL default '0', `kn_stats` tinyint(1) NOT NULL default '0', `kn_topic` tinyint(1) NOT NULL default '0', `kn_kommands` tinyint(1) NOT NULL default '1', `nastroi` varchar(100) NOT NULL default '0', `bal` int(11) NOT NULL default '0', `alltraf` varchar(255) NOT NULL default '0', `lasttraf` varchar(255) NOT NULL default '0', `costtraf` int(255) NOT NULL default '0', `banned` tinyint(1) NOT NULL default '0', `trade` tinyint(1) NOT NULL default '0', `kn_nood` tinyint(1) NOT NULL default '1', `creditsingame` int(11) NOT NULL default '0', `mafcredits` int(11) NOT NULL default '0', `avtootvet` blob NOT NULL, `emocmenu` tinyint(1) NOT NULL default '0', `emoc1` varchar(25) NOT NULL default '', `emoc2` varchar(25) NOT NULL default '', `emoc3` varchar(25) NOT NULL default '', `emoc4` varchar(25) NOT NULL default '', `emoc5` varchar(25) NOT NULL default '', `emoc6` varchar(25) NOT NULL default '', `emoc7` varchar(25) NOT NULL default '', `emoc8` varchar(25) NOT NULL default '', `emoc9` varchar(25) NOT NULL default '', `emoc10` varchar(25) NOT NULL default '', `selemoc` varchar(25) NOT NULL default '1', `mysmile` varchar(50) NOT NULL default '', `bind4` tinyint(1) NOT NULL default '0', `bind3` tinyint(1) NOT NULL default '8', `bind2` tinyint(1) NOT NULL default '2', `bind1` tinyint(1) NOT NULL default '1', `kn_sos` tinyint(1) NOT NULL default '1', `kn_cabinet` tinyint(1) NOT NULL default '0', `kn_clroom` tinyint(1) NOT NULL default '1', `votefoto` int(11) NOT NULL default '0', `para` varchar(50) NOT NULL default '', `kn_privat` tinyint(1) NOT NULL default '0', `myavatar` varchar(50) NOT NULL default '', `version` smallint(1) NOT NULL default '0', `anketa` tinyint(1) NOT NULL default '1', `prvt_view` tinyint(1) NOT NULL default '1', `postbali` int(11) NOT NULL default '0', `sualbali` int(11) NOT NULL default '0', `sualpostbali` int(11) NOT NULL default '0', `konturbali` int(11) NOT NULL default '0', `voteses` int(11) NOT NULL default '0', `reng` tinyint(1) NOT NULL default '1', `umnik` int(1) NOT NULL default '1', `mektub_qebulu` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=0 AUTO_INCREMENT=609 ; -- -- Tablo döküm verisi `users` -- INSERT INTO `users` (`id`, `user`, `pass`, `name`, `sex`, `birth`, `city`, `mail`, `site`, `icq`, `infa`, `posts`, `status`, `date`, `avr`, `max`, `op`, `mob`, `level`, `kik`, `whokik`, `whykik`, `user_ip`, `user_soft`, `inv`, `say`, `credits`, `gposts`, `img`, `translit`, `visit`, `ruser`, `latuser`, `onl`, `room`, `smiles`, `safe`, `fsize`, `number`, `kn_say`, `kn_update`, `kn_letters`, `kn_whochat`, `kn_whoroom`, `kn_holl`, `kn_stats`, `kn_topic`, `kn_kommands`, `nastroi`, `bal`, `alltraf`, `lasttraf`, `costtraf`, `banned`, `trade`, `kn_nood`, `creditsingame`, `mafcredits`, `avtootvet`, `emocmenu`, `emoc1`, `emoc2`, `emoc3`, `emoc4`, `emoc5`, `emoc6`, `emoc7`, `emoc8`, `emoc9`, `emoc10`, `selemoc`, `mysmile`, `bind4`, `bind3`, `bind2`, `bind1`, `kn_sos`, `kn_cabinet`, `kn_clroom`, `votefoto`, `para`, `kn_privat`, `myavatar`, `version`, `anketa`, `prvt_view`, `postbali`, `sualbali`, `sualpostbali`, `konturbali`, `voteses`, `reng`, `umnik`, `mektub_qebulu`) VALUES (1, 'Sistem', 'MENEeleBAXMA', 'A', 'K', '01-01-1970', 'Agcabedi', '', '', '150 sm', 0x73617361, 24, 'Qonaq', '07-04-2008', 300, 60, 'Qoch', '40 kq', 2321, 0, '', '', '77.244.112.177', 'SonyEricssonK700i/R2AA SEMC-Browser/4.0.2 Profile/MIDP-2.0 Configuration/CLDC-1.1', 0, 0, 0, 0, '', 0, '2008-08-16 23:01:55', '', 'sistem', 1218874317, 'holl', 2, 1, 'medium', '', 0, 0, 0, 1, 0, 0, 0, 0, 1, '0', 100, '63.3', '0.5', 0, 0, 0, 1, 0, 0, '', 0, '', '', '', '', '', '', '', '', '', '', '1', '', 0, 8, 2, 1, 1, 0, 1, 0, '', 0, '', 1, 1, 1, 0, 0, 0, 0, 0, 1, 1, 0), (3, 'Prikol_QiZ', 'dsadsa', 'sas', 'K', '01-01-1970', 'Agcabedi', '', '', '150 sm', 0x73617361, 0, 'Qonaq', '07-04-2008', 300, 10, 'Qoch', '40 kq', 0, 0, '', '', '217.25.19.222', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 6.0; ru) Opera 8.54', 0, 0, 0, 0, '', 0, '2008-08-18 01:07:58', '', 'sasas', 0, '', 2, 1, 'medium', '', 0, 0, 0, 1, 0, 0, 0, 0, 1, '0', 0, '0', '0', 0, 0, 0, 1, 0, 0, '', 0, '', '', '', '', '', '', '', '', '', '', '1', '', 0, 8, 2, 1, 1, 0, 1, 0, '', 0, '', 0, 1, 1, 0, 0, 0, 0, 0, 1, 1, 0), (4, 'Satici', 'dsadsa', 'sas', 'K', '01-01-1970', 'Agcabedi', '', '', '150 sm', 0x73617361, 0, 'Qonaq', '07-04-2008', 300, 10, 'Qoch', '40 kq', 0, 0, '', '', '217.25.19.222', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 6.0; ru) Opera 8.54', 0, 0, 0, 0, '', 0, '2008-04-07 02:03:25', '', 'sadad', 0, '', 2, 1, 'medium', '', 0, 0, 0, 1, 0, 0, 0, 0, 1, '0', 0, '0', '0', 0, 0, 0, 1, 0, 0, '', 0, '', '', '', '', '', '', '', '', '', '', '1', '', 0, 8, 2, 1, 1, 0, 1, 0, '', 0, '', 0, 1, 1, 0, 0, 0, 0, 0, 1, 1, 0), (5, 'Mafiya', 'dsadsa', 'sas', 'K', '01-01-1970', 'Agcabedi', '', '', '150 sm', 0x73617361, 3, 'Qonaq', '07-04-2008', 300, 10, 'Qoch', '40 kq', 0, 0, '', '', '217.25.19.222', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 6.0; ru) Opera 8.54', 0, 0, 0, 0, '', 0, '2008-08-16 16:18:00', '', 'dsaffa', 0, '', 2, 1, 'medium', '', 0, 0, 0, 1, 0, 0, 0, 0, 1, '0', 0, '0', '0', 0, 0, 0, 1, 0, 0, '', 0, '', '', '', '', '', '', '', '', '', '', '1', '', 0, 8, 2, 1, 1, 0, 1, 0, '', 0, '', 0, 1, 1, 0, 0, 0, 0, 0, 1, 1, 0), (6, 'Anekdot', 'dsadsa', 'sas', 'K', '01-01-1970', 'Agcabedi', '', '', '150 sm', 0x73617361, 0, 'Qonaq', '07-04-2008', 300, 10, 'Qoch', '40 kq', 0, 0, '', '', '217.25.19.222', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 6.0; ru) Opera 8.54', 0, 0, 0, 0, '', 0, '2008-08-08 01:41:41', '', 'dfafsaf', 0, '', 2, 1, 'medium', '', 0, 0, 0, 1, 0, 0, 0, 0, 1, '0', 0, '0', '0', 0, 0, 0, 1, 0, 0, '', 0, '', '', '', '', '', '', '', '', '', '', '1', '', 0, 8, 2, 1, 1, 0, 1, 0, '', 0, '', 0, 1, 1, 0, 0, 0, 0, 0, 1, 1, 0), (7, 'Nezaretci', 'dsadsa', 'sas', 'K', '01-01-1970', 'Agcabedi', '', '', '150 sm', 0x73617361, 0, 'Qonaq', '07-04-2008', 300, 10, 'Qoch', '40 kq', 0, 0, '', '', '217.25.19.222', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 6.0; ru) Opera 8.54', 0, 0, 0, 0, '', 0, '2008-08-08 01:41:41', '', 'fasfafww', 0, '', 2, 1, 'medium', '', 0, 0, 0, 1, 0, 0, 0, 0, 1, '0', 0, '0', '0', 0, 0, 0, 1, 0, 0, '', 0, '', '', '', '', '', '', '', '', '', '', '1', '', 0, 8, 2, 1, 1, 0, 1, 0, '', 0, '', 0, 1, 1, 0, 0, 0, 0, 0, 1, 1, 0), (2, 'Akademik', '12345', '?', 'Q', '07-01-1982', 'Agstafa', '', '', '162 sm', 0x3f, 1526, 'YOLDAN KECEN', '12-08-2008', 300, 10, 'Baliqlar', '40 kq', 1, 0, '', '', '217.64.29.152', 'Opera/9.25 (Windows NT 5.1; U; en)', 0, 0, 2147483647, 53631826, '', 0, '2010-02-20 14:13:40', '', 'atamin_balasi', 1218971567, '0', 2, 1, 'medium', '', 0, 0, 0, 1, 0, 0, 0, 0, 1, '0', 15, '89.3', '3.3', 0, 0, 0, 1, 0, 2147483647, '', 0, '', '', '', '', '', '', '', '', '', '', '1', '', 0, 8, 2, 1, 1, 0, 1, 45, '', 0, '', 1, 1, 1, 15, 0, 0, -53631826, 0, 1, 1, 0); -- -------------------------------------------------------- -- -- Tablo yapısı: `vis_games` -- CREATE TABLE IF NOT EXISTS `vis_games` ( `id` int(11) NOT NULL auto_increment, `uid` int(11) NOT NULL default '0', `word` varchar(30) NOT NULL default '', `us_word` varchar(30) NOT NULL default '', `letters` text NOT NULL, `step` int(11) NOT NULL default '0', `stavka` int(11) NOT NULL default '0', `time` int(10) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ; -- -- Tablo döküm verisi `vis_games` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `vis_words` -- CREATE TABLE IF NOT EXISTS `vis_words` ( `id` int(11) NOT NULL auto_increment, `word` varchar(30) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ; -- -- Tablo döküm verisi `vis_words` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `vopros` -- CREATE TABLE IF NOT EXISTS `vopros` ( `klu4` tinyint(1) NOT NULL default '0', `number` int(11) NOT NULL default '0', `time` int(11) NOT NULL default '0', `question` blob NOT NULL, `answer` varchar(100) character set latin1 collate latin1_bin NOT NULL default '', `tran` varchar(100) character set latin1 collate latin1_bin NOT NULL default '', PRIMARY KEY (`klu4`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Tablo döküm verisi `vopros` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `vstrechi` -- CREATE TABLE IF NOT EXISTS `vstrechi` ( `id` int(11) NOT NULL auto_increment, `login` text NOT NULL, `title` text NOT NULL, `content` text NOT NULL, `organizatory` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Tablo döküm verisi `vstrechi` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `wluha` -- CREATE TABLE IF NOT EXISTS `wluha` ( `klu4` int(11) NOT NULL default '0', `night_act` text NOT NULL, PRIMARY KEY (`klu4`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Tablo döküm verisi `wluha` -- -- -------------------------------------------------------- -- -- Tablo yapısı: `zapiski` -- CREATE TABLE IF NOT EXISTS `zapiski` ( `klu4` int(8) NOT NULL default '0', `who` varchar(40) character set latin1 collate latin1_bin NOT NULL default '', `idwho` int(12) NOT NULL default '0', `message` blob NOT NULL, `towhom` varchar(40) character set latin1 collate latin1_bin NOT NULL default '', `idtowhom` int(12) NOT NULL default '0', `time` int(11) NOT NULL default '0', `readd` tinyint(1) NOT NULL default '0', `topic` varchar(80) character set latin1 collate latin1_bin NOT NULL default '', `date` varchar(50) character set latin1 collate latin1_bin NOT NULL default '', `insend` tinyint(1) NOT NULL default '1', `ininc` tinyint(1) NOT NULL default '1', PRIMARY KEY (`klu4`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Tablo döküm verisi `zapiski` --