Файл: sql.sql
Строк: 286
-- phpMyAdmin SQL Dump
-- version 3.2.3
-- http://www.phpmyadmin.net
--
--
Host: localhost
-- Generation Time: Apr 13, 2013 at 05:13 PM
-- Server
version: 5.1.40
-- PHP Version: 5.3.13
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 */;
--
-- Database: `kliki`
--
--
--------------------------------------------------------
--
-- Table
structure for table `actia_comm`
--
CREATE TABLE IF NOT EXISTS
`actia_comm` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nid` int(11) NOT
NULL DEFAULT '0',
`date` text NOT NULL,
`login` text NOT NULL,
`text`
text NOT NULL,
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=11 ;
--
-- Dumping data for table `actia_comm`
--
--
--------------------------------------------------------
--
-- Table
structure for table `bir_pokup`
--
CREATE TABLE IF NOT EXISTS `bir_pokup`
(
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_prod` int(11) DEFAULT
NULL,
`id_pok` int(11) DEFAULT NULL,
`login_prod` text,
`login_pok`
text,
`chislo` float(11,1) DEFAULT '0.0',
`summa` float(11,1) NOT
NULL,
`time` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=133 ;
--
-- Dumping
data for table `bir_pokup`
--
INSERT INTO `bir_pokup` (`id`, `id_prod`,
`id_pok`, `login_prod`, `login_pok`, `chislo`, `summa`, `time`) VALUES
(31,
3260, 1, 'ilov', 'XMosTX', 450.0, 9.0, 1308392051),
(32, 3581, 1,
'astaniel', 'XMosTX', 329.0, 6.6, 1308392226),
(33, 2518, 1, 'fL1pE',
'XMosTX', 460.0, 9.2, 1308392303),
(34, 3376, 1, 'Grawer', 'XMosTX', 474.0,
9.5, 1308392382),
(35, 3147, 100173, 'oligarxi', 'diman', 250.0, 5.0,
1308402900),
(36, 100105, 1, 'SEREGA05', 'XMosTX', 640.0, 12.8,
1308686164),
(37, 24, 1, 'kraswap', 'XMosTX', 1000.0, 20.0,
1308686282),
(38, 3677, 1, 'shevchenko-8', 'XMosTX', 936.0, 18.7,
1308686358),
(39, 1201, 1, 'Cabba', 'XMosTX', 791.0, 15.8,
1308686490),
(40, 3537, 1, 'Alhimick666', 'XMosTX', 600.0, 12.0,
1308686659),
(41, 3903, 1, 'alexzombie', 'XMosTX', 600.0, 12.0,
1308686723),
(42, 3839, 1, 'yrik', 'XMosTX', 900.0, 18.0, 1308686808),
(43,
1897, 1, 'Slepoy', 'XMosTX', 700.0, 14.0, 1308686924),
(44, 3121, 1,
'Kitsune', 'XMosTX', 500.0, 10.0, 1308687038),
(45, 3690, 1, 'I-killer',
'XMosTX', 500.0, 10.0, 1308687147),
(46, 3147, 1, 'oligarxi', 'XMosTX',
250.0, 5.0, 1308687234),
(47, 3121, 1, 'Kitsune', 'XMosTX', 880.0, 17.6,
1308687317),
(48, 63, 1, 'yamaha', 'XMosTX', 1000.0, 20.0,
1308687623),
(49, 4042, 1, 'Julia', 'XMosTX', 1000.0, 20.0,
1308687736),
(50, 100115, 1, 'edi123456', 'XMosTX', 1000.0, 20.0,
1308763315),
(51, 24, 1, 'kraswap', 'XMosTX', 1000.0, 20.0,
1308763389),
(52, 3009, 1, 'GAV', 'XMosTX', 1000.0, 20.0, 1308763498),
(53,
3555, 1, 'Artur', 'XMosTX', 1000.0, 20.0, 1308763560),
(54, 3432, 1,
'METR', 'XMosTX', 1000.0, 20.0, 1308763658),
(55, 3615, 1, 'Jeik',
'XMosTX', 1000.0, 20.0, 1308763760),
(56, 3858, 1, 'Jk55', 'XMosTX',
1000.0, 20.0, 1308763835),
(57, 2898, 1, 'evropus', 'XMosTX', 1000.0, 20.0,
1308763951),
(58, 3723, 1, 'WIWA', 'XMosTX', 1000.0, 20.0,
1308764071),
(59, 3248, 1, 'nyusya', 'XMosTX', 1000.0, 20.0,
1308764215),
(60, 3067, 1, 'banzay', 'XMosTX', 1000.0, 20.0,
1308764448),
(61, 3067, 1, 'banzay', 'XMosTX', 1000.0, 20.0,
1308764526),
(62, 3248, 1, 'nyusya', 'XMosTX', 1000.0, 20.0,
1308764632),
(63, 3067, 1, 'banzay', 'XMosTX', 2000.0, 40.0,
1308764901),
(64, 2783, 1, '19slawa81', 'XMosTX', 1000.0, 20.0,
1308807977),
(65, 3044, 1, 'lenchik555', 'XMosTX', 2000.0, 40.0,
1308808111),
(66, 3284, 1, 'addept', 'XMosTX', 8000.0, 160.0,
1308808562),
(67, 272, 1, 'Prof', 'XMosTX', 1170.0, 23.4, 1308808797),
(68,
3087, 1, 'dethhiro', 'XMosTX', 7900.0, 158.0, 1308808948),
(69, 3069, 1,
'natka', 'XMosTX', 1500.0, 30.0, 1308809070),
(70, 2978, 1, 'dronbandit',
'XMosTX', 1950.0, 39.0, 1308809306),
(71, 274, 1, 'nedved', 'XMosTX',
3000.0, 60.0, 1308809496),
(72, 3166, 1, '24AnNa', 'XMosTX', 1395.0, 27.9,
1308809612),
(73, 100002, 100182, 'vlad184319', '5555555555', 560.0, 11.2,
1309186085),
(74, 495, 100182, 'veldem', '5555555555', 529.0, 10.6,
1310539433),
(75, 100215, 3589, 'Emma', 'lyalechka', 250.0, 5.0,
1312218697),
(76, 2667, 238, '4estnuj', 'Signal', 2500.0, 50.0,
1312572280),
(77, 100215, 1, 'Emma', 'XMosTX', 573.0, 11.5,
1312824364),
(78, 495, 1, 'veldem', 'XMosTX', 511.0, 10.2,
1312824524),
(79, 100265, 1, 'schokk', 'XMosTX', 500.0, 10.0,
1312824625),
(80, 100277, 1, 'ladvez', 'XMosTX', 500.0, 10.0,
1312824780),
(81, 100265, 1, 'schokk', 'XMosTX', 519.0, 10.4,
1312824955),
(82, 3067, 1, 'banzay', 'XMosTX', 500.0, 10.0,
1312825033),
(83, 3458, 1, 'Aleks051', 'XMosTX', 500.0, 10.0,
1312825137),
(84, 3420, 1, 'AAV', 'XMosTX', 1000.0, 20.0, 1312825244),
(85,
2212, 1, 'dany', 'XMosTX', 1000.0, 20.0, 1312825372),
(86, 100018, 1,
'mateo', 'XMosTX', 1000.0, 20.0, 1312825472),
(87, 3615, 1, 'Jeik',
'XMosTX', 1000.0, 20.0, 1312825614),
(88, 100115, 1, 'edi123456', 'XMosTX',
1000.0, 20.0, 1312825812),
(89, 4042, 1, 'Julia', 'XMosTX', 1000.0, 20.0,
1312825909),
(90, 100115, 1, 'edi123456', 'XMosTX', 1000.0, 20.0,
1312826118),
(91, 24, 1, 'kraswap', 'XMosTX', 1000.0, 20.0,
1312826456),
(92, 3067, 100360, 'banzay', 'Timon', 1000.0, 20.0,
1313000801),
(93, 2407, 1989, 'Sman15', 'mixa', 1000.0, 20.0,
1313007371),
(94, 4042, 4009, 'Julia', 'buduubivat', 40.0, 0.8,
1313992211),
(95, 3022, 1, '5ugol', 'XMosTX', 4000.0, 80.0,
1314028970),
(96, 100115, 1, 'edi123456', 'XMosTX', 1000.0, 20.0,
1314029195),
(97, 2407, 1, 'Sman15', 'XMosTX', 1329.0, 26.6,
1314029394),
(98, 100277, 1, 'ladvez', 'XMosTX', 500.0, 10.0,
1314029490),
(99, 4042, 1, 'Julia', 'XMosTX', 960.0, 19.2,
1314029977),
(100, 3162, 1, 'Wolviren', 'XMosTX', 900.0, 18.0,
1314030092),
(101, 4034, 1, 'wuzru', 'XMosTX', 1000.0, 20.0,
1314030240),
(102, 3067, 1, 'banzay', 'XMosTX', 500.0, 10.0,
1314030810),
(103, 3420, 1, 'AAV', 'XMosTX', 700.0, 14.0,
1314030935),
(104, 100265, 1, 'schokk', 'XMosTX', 615.0, 12.3,
1314031065),
(105, 2667, 1, '4estnuj', 'XMosTX', 1500.0, 30.0,
1314031260),
(106, 100113, 1, 'GoRuns', 'XMosTX', 2000.0, 40.0,
1314031440),
(107, 2682, 1, 'Gezza', 'XMosTX', 1500.0, 30.0,
1314031531),
(108, 3028, 1, 'strannik47', 'XMosTX', 2000.0, 40.0,
1314031772),
(109, 1556, 1, 'rick7777', 'XMosTX', 1700.0, 34.0,
1314031901),
(110, 3438, 1, 'Kostian82', 'XMosTX', 1300.0, 26.0,
1314032102),
(111, 2667, 1053, '4estnuj', 'edya', 100.0, 2.0,
1314211589),
(112, 2667, 3589, '4estnuj', 'lyalechka', 90.0, 1.8,
1314274651),
(113, 3420, 3818, 'AAV', 'Mediv', 50.0, 1.0,
1314420778),
(114, 495, 3818, 'veldem', 'Mediv', 40.0, 0.8,
1314875990),
(115, 3022, 1989, '5ugol', 'mixa', 1000.0, 20.0,
1314994088),
(116, 2667, 3818, '4estnuj', 'Mediv', 15.0, 0.3,
1315273272),
(117, 3420, 1053, 'AAV', 'edya', 93.0, 1.9, 1315402918),
(118,
3420, 69, 'AAV', 'Slan1', 15.0, 0.3, 1315687028),
(119, 3420, 2691, 'AAV',
'ku4ma', 10.0, 0.2, 1315853705),
(120, 3420, 1053, 'AAV', 'edya', 34.0,
0.7, 1315856504),
(121, 4034, 63, 'wuzru', 'yamaha', 100.0, 2.0,
1315918123),
(122, 4034, 63, 'wuzru', 'yamaha', 80.0, 1.6,
1315918131),
(123, 3420, 1053, 'AAV', 'edya', 26.0, 0.5, 1316169483),
(124,
2667, 3143, '4estnuj', 'hameleon5555', 10.0, 0.2, 1316322831),
(125, 3420,
4088, 'AAV', 'NeOdin', 15.0, 0.3, 1316551330),
(126, 3420, 1053, 'AAV',
'edya', 28.0, 0.6, 1316578211),
(127, 3009, 1053, 'GAV', 'edya', 34.0, 0.7,
1317101914),
(128, 3009, 63, 'GAV', 'yamaha', 60.0, 1.2, 1317207982),
(129,
3009, 1989, 'GAV', 'mixa', 500.0, 10.0, 1317352867),
(130, 4042, 1989,
'Julia', 'mixa', 500.0, 10.0, 1317352884),
(131, 100277, 3897, 'ladvez',
'isq-site', 10.0, 0.2, 1317990832),
(132, 100277, 4009, 'ladvez',
'buduubivat', 50.0, 1.0, 1318095331);
--
--------------------------------------------------------
--
-- Table
structure for table `cclub_actia`
--
CREATE TABLE IF NOT EXISTS
`cclub_actia` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`text` text,
`nazv` text,
`who` text,
`ts` bigint(20) DEFAULT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
--
--
Dumping data for table `cclub_actia`
--
--
--------------------------------------------------------
--
-- Table
structure for table `cclub_ban`
--
CREATE TABLE IF NOT EXISTS `cclub_ban`
(
`reason` varchar(250) NOT NULL,
`who` varchar(100) NOT NULL,
`date`
int(40) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data
for table `cclub_ban`
--
--
--------------------------------------------------------
--
-- Table
structure for table `cclub_birzha`
--
CREATE TABLE IF NOT EXISTS
`cclub_birzha` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user`
int(11) NOT NULL,
`login` text,
`money` float(11,3) DEFAULT '0.000',
`in_money` float(11,1) DEFAULT '0.0',
`out_money` float(11,1) DEFAULT
'0.0',
`wmr` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=56095 ;
--
-- Dumping
data for table `cclub_birzha`
--
INSERT INTO `cclub_birzha` (`id`,
`id_user`, `login`, `money`, `in_money`, `out_money`, `wmr`) VALUES
(56094,
1, 'Admin', 0.000, 0.0, 0.0, 0);
--
--------------------------------------------------------
--
-- Table
structure for table `cclub_bir_hist`
--
CREATE TABLE IF NOT EXISTS
`cclub_bir_hist` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user`
int(11) DEFAULT NULL,
`login` text,
`summa` float(11,1) DEFAULT '0.0',
`stat` int(11) DEFAULT '0',
`time` bigint(20) DEFAULT NULL,
`wmr`
bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=60 ;
--
-- Dumping data for table
`cclub_bir_hist`
--
--
--------------------------------------------------------
--
-- Table
structure for table `cclub_bir_st`
--
CREATE TABLE IF NOT EXISTS
`cclub_bir_st` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user`
int(11) DEFAULT NULL,
`login` tinytext,
`kred` int(11) DEFAULT '0',
`cena` float(11,4) DEFAULT '0.0000',
`time` tinytext,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1125 ;
--
--
Dumping data for table `cclub_bir_st`
--
--
--------------------------------------------------------
--
-- Table
structure for table `cclub_click`
--
CREATE TABLE IF NOT EXISTS
`cclub_click` (
`who` text,
`to` text,
`time` bigint(20) DEFAULT
NULL,
`ip` text,
`ua` text,
`aaa` int(11) DEFAULT '0'
) ENGINE=MyISAM
DEFAULT CHARSET=utf8;
--
-- Dumping data for table `cclub_click`
--
--
--------------------------------------------------------
--
-- Table
structure for table `cclub_clicks`
--
CREATE TABLE IF NOT EXISTS
`cclub_clicks` (
`who` int(11) DEFAULT NULL,
`to` text,
`ts`
bigint(20) DEFAULT NULL,
`id_user` int(11) NOT NULL
) ENGINE=MyISAM
DEFAULT CHARSET=utf8;
--
-- Dumping data for table `cclub_clicks`
--
--
--------------------------------------------------------
--
-- Table
structure for table `cclub_forums`
--
CREATE TABLE IF NOT EXISTS
`cclub_forums` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`name`
varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`position` int(5) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=22 ;
--
-- Dumping data
for table `cclub_forums`
--
--
--------------------------------------------------------
--
-- Table
structure for table `cclub_guest`
--
CREATE TABLE IF NOT EXISTS
`cclub_guest` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`who` text,
`text` text,
`answer` text,
`who_ans` text,
`ts` bigint(20) DEFAULT
NULL,
`ua` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=542 ;
--
-- Dumping data for table
`cclub_guest`
--
--
--------------------------------------------------------
--
-- Table
structure for table `cclub_modlog`
--
CREATE TABLE IF NOT EXISTS
`cclub_modlog` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ts` bigint(20)
DEFAULT NULL,
`login` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`action` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
--
Dumping data for table `cclub_modlog`
--
--
--------------------------------------------------------
--
-- Table
structure for table `cclub_news`
--
CREATE TABLE IF NOT EXISTS
`cclub_news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nazv` text,
`text` text,
`who` text,
`ts` bigint(20) DEFAULT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=47 ;
--
--
Dumping data for table `cclub_news`
--
--
--------------------------------------------------------
--
-- Table
structure for table `cclub_pm`
--
CREATE TABLE IF NOT EXISTS `cclub_pm` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`log_in` text NOT NULL,
`log_out` text NOT NULL,
`date` int(11) NOT NULL,
`tema` text NOT
NULL,
`mess` text NOT NULL,
`status` text NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--
Dumping data for table `cclub_pm`
--
--
--------------------------------------------------------
--
-- Table
structure for table `cclub_pmout`
--
CREATE TABLE IF NOT EXISTS
`cclub_pmout` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`log_in` text NOT
NULL,
`log_out` text NOT NULL,
`date` int(11) NOT NULL,
`tema` text
NOT NULL,
`mess` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table
`cclub_pmout`
--
--
--------------------------------------------------------
--
-- Table
structure for table `cclub_posts`
--
CREATE TABLE IF NOT EXISTS
`cclub_posts` (
`id` int(7) NOT NULL AUTO_INCREMENT,
`id_theme` int(5)
NOT NULL,
`id_forum` int(3) NOT NULL,
`login` text,
`text` text
CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`time` text,
`izmts`
bigint(20) NOT NULL,
`izmkol` int(3) NOT NULL DEFAULT '0',
`izmwho`
text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
-- Dumping data for table `cclub_posts`
--
--
--------------------------------------------------------
--
-- Table
structure for table `cclub_rekl`
--
CREATE TABLE IF NOT EXISTS
`cclub_rekl` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`url` text,
`name` text,
`do` text,
`cvet` text,
`vid` text,
`count` int(11)
NOT NULL DEFAULT '0',
`tip` enum('0','1') NOT NULL DEFAULT '0',
PRIMARY
KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--
Dumping data for table `cclub_rekl`
--
--
--------------------------------------------------------
--
-- Table
structure for table `cclub_stats`
--
CREATE TABLE IF NOT EXISTS
`cclub_stats` (
`who` varchar(60) NOT NULL,
`cn` smallint(6) unsigned
NOT NULL,
`ts` date NOT NULL,
UNIQUE KEY `who` (`who`,`cn`,`ts`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table
`cclub_stats`
--
--
--------------------------------------------------------
--
-- Table
structure for table `cclub_themes`
--
CREATE TABLE IF NOT EXISTS
`cclub_themes` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`id_forum` int(5)
NOT NULL,
`name` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`login` text,
`time` text,
`last_time` text NOT NULL,
`type` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
--
-- Dumping data for table `cclub_themes`
--
--
--------------------------------------------------------
--
-- Table
structure for table `cclub_transfers`
--
CREATE TABLE IF NOT EXISTS
`cclub_transfers` (
`from` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`to` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`ts` bigint(20)
DEFAULT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON
UPDATE CURRENT_TIMESTAMP,
`sum` mediumint(9) NOT NULL,
`komm` text
COLLATE utf8_unicode_ci
) ENGINE=MyISAM DEFAULT CHARSET=utf8
COLLATE=utf8_unicode_ci;
--
-- Dumping data for table
`cclub_transfers`
--
--
--------------------------------------------------------
--
-- Table
structure for table `cclub_url`
--
CREATE TABLE IF NOT EXISTS `cclub_url`
(
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) DEFAULT
NULL,
`login` text,
`url` text,
`nazv` text,
`perehod` bigint(20)
DEFAULT NULL,
`typeclick` int(11) NOT NULL,
`time` bigint(20) DEFAULT
NULL,
`moder` int(11) NOT NULL,
`activ` int(11) NOT NULL DEFAULT '1',
`mesto` int(11) NOT NULL DEFAULT '0',
`capcha` enum('1','2') NOT NULL
DEFAULT '2',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
-- Dumping data for table `cclub_url`
--
--
--------------------------------------------------------
--
-- Table
structure for table `cclub_users`
--
CREATE TABLE IF NOT EXISTS
`cclub_users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`login` text,
`name` text,
`password` text,
`mail` text,
`ts` bigint(20) DEFAULT
NULL,
`cto` bigint(20) DEFAULT NULL,
`cfrom` float DEFAULT NULL,
`ip`
text,
`ua` text,
`ets` bigint(20) DEFAULT '0',
`admin` tinyint(4)
DEFAULT '0',
`moder` tinyint(4) DEFAULT '0',
`typeclick` int(11)
DEFAULT '0',
`pid` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT
NULL,
`bank` float NOT NULL DEFAULT '0',
`comm` bigint(20) DEFAULT
NULL,
`mesto` varchar(255) NOT NULL,
`online` int(11) NOT NULL,
`city` text,
`pol` text,
`icq` int(11) DEFAULT NULL,
`inf` text,
`enter` text,
`enterip` text NOT NULL,
`enterb` text NOT NULL,
`enterdata` text NOT NULL,
`set_show_mail` enum('0','1') NOT NULL DEFAULT
'1',
`diz` int(11) NOT NULL DEFAULT '1',
`numlink` varchar(10) NOT NULL
DEFAULT '100',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=2 ;
--
-- Dumping data for table `cclub_users`
--
INSERT
INTO `cclub_users` (`id`, `login`, `name`, `password`, `mail`, `ts`, `cto`,
`cfrom`, `ip`, `ua`, `ets`, `admin`, `moder`, `typeclick`, `pid`, `bank`,
`comm`, `mesto`, `online`, `city`, `pol`, `icq`, `inf`, `enter`, `enterip`,
`enterb`, `enterdata`, `set_show_mail`, `diz`, `numlink`) VALUES
(1,
'Admin', '', '123456', 'admin@kliki.mobi', 1365858596, 0, 5, '127.0.0.1',
'Opera', 0, 1, 0, 0, '', 0, NULL, 'В кабинете', 1365858695, '',
'Мужской', 0, '', 'Opera/9.80 (Windows NT 5.1) Presto/2.12.388
Version/12.15', '127.0.0.1', 'Комп', '13.04.13 17:10:05', '1', 2,
'100');
-- --------------------------------------------------------
--
--
Table structure for table `counts`
--
CREATE TABLE IF NOT EXISTS `counts`
(
`id` int(11) NOT NULL AUTO_INCREMENT,
`ip` text CHARACTER SET utf8
COLLATE utf8_unicode_ci NOT NULL,
`unique` enum('1','2') CHARACTER SET
utf8 COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
--
-- Dumping data for table
`counts`
--
INSERT INTO `counts` (`id`, `ip`, `unique`) VALUES
(1,
'127.0.0.1', '2'),
(2, '127.0.0.1', '1'),
(3, '127.0.0.1', '1'),
(4,
'127.0.0.1', '1'),
(5, '127.0.0.1', '1'),
(6, '127.0.0.1', '1'),
(7,
'127.0.0.1', '1'),
(8, '127.0.0.1', '1'),
(9, '127.0.0.1', '1'),
(10,
'127.0.0.1', '1');
--
--------------------------------------------------------
--
-- Table
structure for table `nastroyki`
--
CREATE TABLE IF NOT EXISTS `nastroyki`
(
`id` int(11) NOT NULL AUTO_INCREMENT,
`ref_pr` text,
`bonus` text
NOT NULL,
`ploshadki` text NOT NULL,
`proclick` text NOT NULL,
`bank_min_aktiv` text NOT NULL,
`wmr` text NOT NULL,
`obyavl` text NOT
NULL,
`oplata` enum('0','1') NOT NULL DEFAULT '0',
`cena` float(11,3)
NOT NULL DEFAULT '0.000',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=2 ;
--
-- Dumping data for
table `nastroyki`
--
INSERT INTO `nastroyki` (`id`, `ref_pr`, `bonus`,
`ploshadki`, `proclick`, `bank_min_aktiv`, `wmr`, `obyavl`, `oplata`,
`cena`) VALUES
(1, '0.20', '5', '10', '5', '35', 'R', '', '0', 0.000);
--
--------------------------------------------------------
--
-- Table
structure for table `news_comm`
--
CREATE TABLE IF NOT EXISTS `news_comm`
(
`id` int(11) NOT NULL AUTO_INCREMENT,
`nid` int(11) NOT NULL DEFAULT
'0',
`date` text NOT NULL,
`login` text NOT NULL,
`text` text NOT
NULL,
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
-- Dumping data for table `news_comm`
--
--
--------------------------------------------------------
--
-- Table
structure for table `online`
--
CREATE TABLE IF NOT EXISTS `online` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`ip` varchar(40) DEFAULT '0',
`time` varchar(90) DEFAULT NULL,
`ua` varchar(80) DEFAULT NULL,
KEY
`id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0
AUTO_INCREMENT=212153 ;
--
-- Dumping data for table `online`
--
--
--------------------------------------------------------
--
-- Table
structure for table `perevod`
--
CREATE TABLE IF NOT EXISTS `perevod` (
`sid` int(11) NOT NULL AUTO_INCREMENT,
`from` text NOT NULL,
`to` text
NOT NULL,
`kredit` int(11) NOT NULL DEFAULT '0',
`time` text NOT NULL,
`komm` text,
PRIMARY KEY (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
-- Dumping data for table `perevod`
--
--
--------------------------------------------------------
--
-- Table
structure for table `stavki1`
--
CREATE TABLE IF NOT EXISTS `stavki1` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`kr` int(11) DEFAULT NULL,
`pr`
float(11,4) DEFAULT NULL,
`nick` tinytext CHARACTER SET utf8,
`time`
tinytext CHARACTER SET utf8,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=61 ;
--
-- Dumping data for table
`stavki1`
--