Файл: mers758_l2.sql
Строк: 409
-- MySQL dump 10.11
--
-- Host: localhost Database: mers758_l2
--
------------------------------------------------------
-- Server
version 5.0.51a-24+lenny5
/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET
TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS,
UNIQUE_CHECKS=0 */;
/*!40014 SET
@OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0
*/;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO'
*/;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table
structure for table `tabe_rega`
--
DROP TABLE IF EXISTS `tabe_rega`;
SET
@saved_cs_client = @@character_set_client;
SET character_set_client =
utf8;
CREATE TABLE `tabe_rega` (
`rega` int(11) NOT NULL,
`chat`
int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8
COLLATE=utf8_unicode_ci;
SET character_set_client =
@saved_cs_client;
--
-- Dumping data for table `tabe_rega`
--
LOCK TABLES
`tabe_rega` WRITE;
/*!40000 ALTER TABLE `tabe_rega` DISABLE KEYS */;
INSERT
INTO `tabe_rega` VALUES (0,0);
/*!40000 ALTER TABLE `tabe_rega` ENABLE KEYS
*/;
UNLOCK TABLES;
--
-- Table structure for table `table_admin`
--
DROP
TABLE IF EXISTS `table_admin`;
SET @saved_cs_client =
@@character_set_client;
SET character_set_client = utf8;
CREATE TABLE
`table_admin` (
`nick` varchar(30) collate utf8_unicode_ci NOT NULL
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
SET
character_set_client = @saved_cs_client;
--
-- Dumping data for table
`table_admin`
--
LOCK TABLES `table_admin` WRITE;
/*!40000 ALTER TABLE
`table_admin` DISABLE KEYS */;
INSERT INTO `table_admin` VALUES
('Canab1s');
/*!40000 ALTER TABLE `table_admin` ENABLE KEYS */;
UNLOCK
TABLES;
--
-- Table structure for table `table_anketa`
--
DROP TABLE IF
EXISTS `table_anketa`;
SET @saved_cs_client =
@@character_set_client;
SET character_set_client = utf8;
CREATE TABLE
`table_anketa` (
`id` int(11) NOT NULL auto_increment,
`usr`
varchar(15) collate utf8_unicode_ci NOT NULL,
`Imya` text collate
utf8_unicode_ci NOT NULL,
`familia` text collate utf8_unicode_ci NOT
NULL,
`god` text collate utf8_unicode_ci NOT NULL,
`strana` text
collate utf8_unicode_ci NOT NULL,
`gorod` text collate utf8_unicode_ci
NOT NULL,
`muz` text collate utf8_unicode_ci NOT NULL,
`interes` text
collate utf8_unicode_ci NOT NULL,
`info` text collate utf8_unicode_ci NOT
NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
COLLATE=utf8_unicode_ci;
SET character_set_client =
@saved_cs_client;
--
-- Dumping data for table `table_anketa`
--
LOCK
TABLES `table_anketa` WRITE;
/*!40000 ALTER TABLE `table_anketa` DISABLE
KEYS */;
/*!40000 ALTER TABLE `table_anketa` ENABLE KEYS */;
UNLOCK
TABLES;
--
-- Table structure for table `table_block`
--
DROP TABLE IF
EXISTS `table_block`;
SET @saved_cs_client =
@@character_set_client;
SET character_set_client = utf8;
CREATE TABLE
`table_block` (
`nick` varchar(30) collate utf8_unicode_ci NOT NULL,
`pricina` varchar(500) collate utf8_unicode_ci NOT NULL
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
SET character_set_client =
@saved_cs_client;
--
-- Dumping data for table `table_block`
--
LOCK
TABLES `table_block` WRITE;
/*!40000 ALTER TABLE `table_block` DISABLE KEYS
*/;
/*!40000 ALTER TABLE `table_block` ENABLE KEYS */;
UNLOCK
TABLES;
--
-- Table structure for table `table_forummsgs`
--
DROP TABLE
IF EXISTS `table_forummsgs`;
SET @saved_cs_client =
@@character_set_client;
SET character_set_client = utf8;
CREATE TABLE
`table_forummsgs` (
`oid` int(30) NOT NULL,
`uid` int(30) NOT NULL,
`aid` int(30) NOT NULL,
`autor` varchar(30) NOT NULL,
`time`
varchar(30) NOT NULL,
`msg` varchar(500) NOT NULL
) ENGINE=MyISAM DEFAULT
CHARSET=cp1251;
SET character_set_client = @saved_cs_client;
--
-- Dumping
data for table `table_forummsgs`
--
LOCK TABLES `table_forummsgs`
WRITE;
/*!40000 ALTER TABLE `table_forummsgs` DISABLE KEYS */;
/*!40000
ALTER TABLE `table_forummsgs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table
structure for table `table_forumosts`
--
DROP TABLE IF EXISTS
`table_forumosts`;
SET @saved_cs_client = @@character_set_client;
SET
character_set_client = utf8;
CREATE TABLE `table_forumosts` (
`nick`
varchar(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
SET
character_set_client = @saved_cs_client;
--
-- Dumping data for table
`table_forumosts`
--
LOCK TABLES `table_forumosts` WRITE;
/*!40000 ALTER
TABLE `table_forumosts` DISABLE KEYS */;
/*!40000 ALTER TABLE
`table_forumosts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for
table `table_forums`
--
DROP TABLE IF EXISTS `table_forums`;
SET
@saved_cs_client = @@character_set_client;
SET character_set_client =
utf8;
CREATE TABLE `table_forums` (
`id` int(30) NOT NULL
auto_increment,
`forumname` varchar(30) NOT NULL,
`forumthemes` int(30)
NOT NULL,
`forummsg` int(30) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=cp1251;
SET
character_set_client = @saved_cs_client;
--
-- Dumping data for table
`table_forums`
--
LOCK TABLES `table_forums` WRITE;
/*!40000 ALTER TABLE
`table_forums` DISABLE KEYS */;
INSERT INTO `table_forums` VALUES
(1,'Общение',3,10),(2,'Технический',0,0),(3,'Услуги/проблемы
с услугами',2,3),(4,'Вопросы по
игре/FAQ',0,0),(5,'Эвенты/Конкурсы',0,0),(6,'Кланы',0,0),(7,'Альянсы',0,0),(8,'Торговля',0,0),(9,'Предложения
по улучшению игры',3,7);
/*!40000 ALTER TABLE `table_forums`
ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table
`table_komentarai2`
--
DROP TABLE IF EXISTS `table_komentarai2`;
SET
@saved_cs_client = @@character_set_client;
SET character_set_client =
utf8;
CREATE TABLE `table_komentarai2` (
`id` int(15) NOT NULL
auto_increment,
`nick` varchar(30) collate utf8_unicode_ci NOT NULL,
`komentaras2` text collate utf8_unicode_ci NOT NULL,
`kada` varchar(15)
collate utf8_unicode_ci NOT NULL,
`time` varchar(15) collate
utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 COLLATE=utf8_unicode_ci;
SET character_set_client =
@saved_cs_client;
--
-- Dumping data for table
`table_komentarai2`
--
LOCK TABLES `table_komentarai2` WRITE;
/*!40000
ALTER TABLE `table_komentarai2` DISABLE KEYS */;
/*!40000 ALTER TABLE
`table_komentarai2` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure
for table `table_koments`
--
DROP TABLE IF EXISTS `table_koments`;
SET
@saved_cs_client = @@character_set_client;
SET character_set_client =
utf8;
CREATE TABLE `table_koments` (
`id` tinyint(30) NOT NULL,
`nick`
varchar(30) collate utf8_unicode_ci NOT NULL,
`aid` tinyint(30) NOT NULL
auto_increment,
`msg` varchar(1000) collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
COLLATE=utf8_unicode_ci;
SET character_set_client =
@saved_cs_client;
--
-- Dumping data for table `table_koments`
--
LOCK
TABLES `table_koments` WRITE;
/*!40000 ALTER TABLE `table_koments` DISABLE
KEYS */;
/*!40000 ALTER TABLE `table_koments` ENABLE KEYS */;
UNLOCK
TABLES;
--
-- Table structure for table `table_konsultant`
--
DROP TABLE
IF EXISTS `table_konsultant`;
SET @saved_cs_client =
@@character_set_client;
SET character_set_client = utf8;
CREATE TABLE
`table_konsultant` (
`nick` varchar(30) collate utf8_unicode_ci NOT
NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
SET
character_set_client = @saved_cs_client;
--
-- Dumping data for table
`table_konsultant`
--
LOCK TABLES `table_konsultant` WRITE;
/*!40000 ALTER
TABLE `table_konsultant` DISABLE KEYS */;
/*!40000 ALTER TABLE
`table_konsultant` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure
for table `table_loves`
--
DROP TABLE IF EXISTS `table_loves`;
SET
@saved_cs_client = @@character_set_client;
SET character_set_client =
utf8;
CREATE TABLE `table_loves` (
`nick` varchar(30) collate
utf8_unicode_ci NOT NULL,
`para` varchar(30) collate utf8_unicode_ci NOT
NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
SET
character_set_client = @saved_cs_client;
--
-- Dumping data for table
`table_loves`
--
LOCK TABLES `table_loves` WRITE;
/*!40000 ALTER TABLE
`table_loves` DISABLE KEYS */;
/*!40000 ALTER TABLE `table_loves` ENABLE
KEYS */;
UNLOCK TABLES;
--
-- Table structure for table
`table_moder`
--
DROP TABLE IF EXISTS `table_moder`;
SET @saved_cs_client
= @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE
`table_moder` (
`nick` varchar(30) collate utf8_unicode_ci NOT NULL
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
SET
character_set_client = @saved_cs_client;
--
-- Dumping data for table
`table_moder`
--
LOCK TABLES `table_moder` WRITE;
/*!40000 ALTER TABLE
`table_moder` DISABLE KEYS */;
/*!40000 ALTER TABLE `table_moder` ENABLE
KEYS */;
UNLOCK TABLES;
--
-- Table structure for table
`table_news`
--
DROP TABLE IF EXISTS `table_news`;
SET @saved_cs_client
= @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE
`table_news` (
`id` int(10) NOT NULL auto_increment,
`zag` varchar(30)
character set cp1251 collate cp1251_general_cs NOT NULL,
`novost` text
NOT NULL,
`autor` varchar(20) NOT NULL,
`time` varchar(25) default
NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET
character_set_client = @saved_cs_client;
--
-- Dumping data for table
`table_news`
--
LOCK TABLES `table_news` WRITE;
/*!40000 ALTER TABLE
`table_news` DISABLE KEYS */;
/*!40000 ALTER TABLE `table_news` ENABLE KEYS
*/;
UNLOCK TABLES;
--
-- Table structure for table `table_online`
--
DROP
TABLE IF EXISTS `table_online`;
SET @saved_cs_client =
@@character_set_client;
SET character_set_client = utf8;
CREATE TABLE
`table_online` (
`nick` varchar(30) collate utf8_unicode_ci NOT NULL,
`laikas` int(20) default NULL,
PRIMARY KEY (`nick`),
KEY `laikas`
(`laikas`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
COLLATE=utf8_unicode_ci;
SET character_set_client =
@saved_cs_client;
--
-- Dumping data for table `table_online`
--
LOCK
TABLES `table_online` WRITE;
/*!40000 ALTER TABLE `table_online` DISABLE
KEYS */;
INSERT INTO `table_online` VALUES
('WiHdOvS',1332009603),('',1332009613);
/*!40000 ALTER TABLE `table_online`
ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table
`table_partners`
--
DROP TABLE IF EXISTS `table_partners`;
SET
@saved_cs_client = @@character_set_client;
SET character_set_client =
utf8;
CREATE TABLE `table_partners` (
`id` int(30) NOT NULL,
`sait`
varchar(30) NOT NULL,
`names` varchar(30) NOT NULL,
`opis` varchar(30)
NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
SET character_set_client =
@saved_cs_client;
--
-- Dumping data for table `table_partners`
--
LOCK
TABLES `table_partners` WRITE;
/*!40000 ALTER TABLE `table_partners`
DISABLE KEYS */;
/*!40000 ALTER TABLE `table_partners` ENABLE KEYS
*/;
UNLOCK TABLES;
--
-- Table structure for table
`table_resends`
--
DROP TABLE IF EXISTS `table_resends`;
SET
@saved_cs_client = @@character_set_client;
SET character_set_client =
utf8;
CREATE TABLE `table_resends` (
`id` int(30) NOT NULL
auto_increment,
`nick` varchar(30) NOT NULL,
`nik` varchar(30) NOT
NULL,
`time` varchar(30) NOT NULL,
`msg` varchar(1000) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
SET
character_set_client = @saved_cs_client;
--
-- Dumping data for table
`table_resends`
--
LOCK TABLES `table_resends` WRITE;
/*!40000 ALTER TABLE
`table_resends` DISABLE KEYS */;
/*!40000 ALTER TABLE `table_resends`
ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table
`table_sendcloses`
--
DROP TABLE IF EXISTS `table_sendcloses`;
SET
@saved_cs_client = @@character_set_client;
SET character_set_client =
utf8;
CREATE TABLE `table_sendcloses` (
`nick` varchar(30) NOT NULL
)
ENGINE=MyISAM DEFAULT CHARSET=cp1251;
SET character_set_client =
@saved_cs_client;
--
-- Dumping data for table `table_sendcloses`
--
LOCK
TABLES `table_sendcloses` WRITE;
/*!40000 ALTER TABLE `table_sendcloses`
DISABLE KEYS */;
/*!40000 ALTER TABLE `table_sendcloses` ENABLE KEYS
*/;
UNLOCK TABLES;
--
-- Table structure for table `table_sends`
--
DROP
TABLE IF EXISTS `table_sends`;
SET @saved_cs_client =
@@character_set_client;
SET character_set_client = utf8;
CREATE TABLE
`table_sends` (
`id` int(30) NOT NULL auto_increment,
`nick`
varchar(30) NOT NULL,
`nik` varchar(30) NOT NULL,
`time` varchar(30)
NOT NULL,
`msg` varchar(1000) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=cp1251;
SET character_set_client =
@saved_cs_client;
--
-- Dumping data for table `table_sends`
--
LOCK
TABLES `table_sends` WRITE;
/*!40000 ALTER TABLE `table_sends` DISABLE KEYS
*/;
/*!40000 ALTER TABLE `table_sends` ENABLE KEYS */;
UNLOCK
TABLES;
--
-- Table structure for table `table_spams`
--
DROP TABLE IF
EXISTS `table_spams`;
SET @saved_cs_client =
@@character_set_client;
SET character_set_client = utf8;
CREATE TABLE
`table_spams` (
`id` int(30) NOT NULL auto_increment,
`nick`
varchar(30) NOT NULL,
`name` varchar(30) NOT NULL,
`time` varchar(30)
NOT NULL,
`msg` varchar(1000) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=cp1251;
SET character_set_client =
@saved_cs_client;
--
-- Dumping data for table `table_spams`
--
LOCK
TABLES `table_spams` WRITE;
/*!40000 ALTER TABLE `table_spams` DISABLE KEYS
*/;
/*!40000 ALTER TABLE `table_spams` ENABLE KEYS */;
UNLOCK
TABLES;
--
-- Table structure for table `table_status`
--
DROP TABLE IF
EXISTS `table_status`;
SET @saved_cs_client =
@@character_set_client;
SET character_set_client = utf8;
CREATE TABLE
`table_status` (
`id` int(11) NOT NULL,
`usr` varchar(30) NOT NULL,
`Imya` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
SET
character_set_client = @saved_cs_client;
--
-- Dumping data for table
`table_status`
--
LOCK TABLES `table_status` WRITE;
/*!40000 ALTER TABLE
`table_status` DISABLE KEYS */;
/*!40000 ALTER TABLE `table_status` ENABLE
KEYS */;
UNLOCK TABLES;
--
-- Table structure for table
`table_stena`
--
DROP TABLE IF EXISTS `table_stena`;
SET @saved_cs_client
= @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE
`table_stena` (
`id` varchar(30) collate utf8_unicode_ci NOT NULL,
`nick` varchar(30) collate utf8_unicode_ci NOT NULL,
`aid` tinyint(30)
NOT NULL auto_increment,
`msg` varchar(1000) collate utf8_unicode_ci NOT
NULL,
PRIMARY KEY (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
COLLATE=utf8_unicode_ci;
SET character_set_client =
@saved_cs_client;
--
-- Dumping data for table `table_stena`
--
LOCK
TABLES `table_stena` WRITE;
/*!40000 ALTER TABLE `table_stena` DISABLE KEYS
*/;
/*!40000 ALTER TABLE `table_stena` ENABLE KEYS */;
UNLOCK
TABLES;
--
-- Table structure for table `table_themes`
--
DROP TABLE IF
EXISTS `table_themes`;
SET @saved_cs_client =
@@character_set_client;
SET character_set_client = utf8;
CREATE TABLE
`table_themes` (
`id` int(30) NOT NULL,
`uid` int(30) NOT NULL
auto_increment,
`name` varchar(30) NOT NULL,
`autor` varchar(30) NOT
NULL,
`time` varchar(30) NOT NULL,
`onoff` varchar(1) NOT NULL,
`msg`
int(30) NOT NULL,
`posl` varchar(30) NOT NULL,
PRIMARY KEY (`uid`),
UNIQUE KEY `name` (`name`),
UNIQUE KEY `name_2` (`name`)
) ENGINE=MyISAM
DEFAULT CHARSET=cp1251;
SET character_set_client = @saved_cs_client;
--
--
Dumping data for table `table_themes`
--
LOCK TABLES `table_themes`
WRITE;
/*!40000 ALTER TABLE `table_themes` DISABLE KEYS */;
/*!40000 ALTER
TABLE `table_themes` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure
for table `table_ticketmsgs`
--
DROP TABLE IF EXISTS
`table_ticketmsgs`;
SET @saved_cs_client = @@character_set_client;
SET
character_set_client = utf8;
CREATE TABLE `table_ticketmsgs` (
`nick`
varchar(30) NOT NULL,
`id` int(30) NOT NULL,
`fid` int(30) NOT NULL
auto_increment,
`autor` varchar(30) NOT NULL,
`msg` varchar(1000) NOT
NULL,
`time` varchar(30) NOT NULL,
PRIMARY KEY (`fid`)
) ENGINE=MyISAM
DEFAULT CHARSET=cp1251;
SET character_set_client = @saved_cs_client;
--
--
Dumping data for table `table_ticketmsgs`
--
LOCK TABLES
`table_ticketmsgs` WRITE;
/*!40000 ALTER TABLE `table_ticketmsgs` DISABLE
KEYS */;
/*!40000 ALTER TABLE `table_ticketmsgs` ENABLE KEYS */;
UNLOCK
TABLES;
--
-- Table structure for table `table_tickets`
--
DROP TABLE IF
EXISTS `table_tickets`;
SET @saved_cs_client =
@@character_set_client;
SET character_set_client = utf8;
CREATE TABLE
`table_tickets` (
`nick` varchar(30) NOT NULL,
`id` int(30) NOT NULL
auto_increment,
`name` varchar(30) NOT NULL,
`time` varchar(30) NOT
NULL,
`status` int(1) NOT NULL,
`onoff` int(1) NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
SET character_set_client =
@saved_cs_client;
--
-- Dumping data for table `table_tickets`
--
LOCK
TABLES `table_tickets` WRITE;
/*!40000 ALTER TABLE `table_tickets` DISABLE
KEYS */;
/*!40000 ALTER TABLE `table_tickets` ENABLE KEYS */;
UNLOCK
TABLES;
--
-- Table structure for table `table_tmploves`
--
DROP TABLE IF
EXISTS `table_tmploves`;
SET @saved_cs_client =
@@character_set_client;
SET character_set_client = utf8;
CREATE TABLE
`table_tmploves` (
`nick` varchar(30) collate utf8_unicode_ci NOT NULL,
`para` varchar(30) collate utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 COLLATE=utf8_unicode_ci;
SET character_set_client =
@saved_cs_client;
--
-- Dumping data for table `table_tmploves`
--
LOCK
TABLES `table_tmploves` WRITE;
/*!40000 ALTER TABLE `table_tmploves`
DISABLE KEYS */;
/*!40000 ALTER TABLE `table_tmploves` ENABLE KEYS
*/;
UNLOCK TABLES;
--
-- Table structure for table `table_vip`
--
DROP
TABLE IF EXISTS `table_vip`;
SET @saved_cs_client =
@@character_set_client;
SET character_set_client = utf8;
CREATE TABLE
`table_vip` (
`nick` varchar(30) collate utf8_unicode_ci NOT NULL,
`time` varchar(30) collate utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 COLLATE=utf8_unicode_ci;
SET character_set_client =
@saved_cs_client;
--
-- Dumping data for table `table_vip`
--
LOCK TABLES
`table_vip` WRITE;
/*!40000 ALTER TABLE `table_vip` DISABLE KEYS
*/;
/*!40000 ALTER TABLE `table_vip` ENABLE KEYS */;
UNLOCK TABLES;
--
--
Table structure for table `table_zametki`
--
DROP TABLE IF EXISTS
`table_zametki`;
SET @saved_cs_client = @@character_set_client;
SET
character_set_client = utf8;
CREATE TABLE `table_zametki` (
`id` int(11)
NOT NULL auto_increment,
`zam0` text NOT NULL,
`zam1` text NOT NULL,
`zam2` text NOT NULL,
`zam3` text NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id_3` (`id`),
KEY `id` (`id`),
KEY `id_2` (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=cp1251;
SET character_set_client =
@saved_cs_client;
--
-- Dumping data for table `table_zametki`
--
LOCK
TABLES `table_zametki` WRITE;
/*!40000 ALTER TABLE `table_zametki` DISABLE
KEYS */;
/*!40000 ALTER TABLE `table_zametki` ENABLE KEYS */;
UNLOCK
TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET
SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET
FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET
UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET
CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET
CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET
COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET
SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2012-04-25 23:12:47