Файл: sys/db_tables/strip.sql
Строк: 141
CREATE TABLE IF NOT EXISTS `strip_bar_area` (
`lvl` int(3) NOT NULL,
`money_x` int(10) NOT NULL,
`money_y` int(10) NOT NULL,
PRIMARY KEY
(`lvl`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table
`strip_bar_area`
--
INSERT INTO `strip_bar_area` (`lvl`, `money_x`,
`money_y`) VALUES
(1, 500, 500),
(2, 500, 500),
(3, 500, 500),
(4, 500,
500),
(5, 1000, 1200),
(6, 3800, 4200),
(7, 7300, 8000),
(8, 12000,
13200),
(9, 18000, 22400),
(10, 24500, 30000),
(11, 32400, 35600),
(12,
38600, 40000),
(13, 48000, 51000),
(14, 57300, 60000),
(15, 64600,
68350),
(16, 70000, 73600),
(17, 74800, 80000),
(18, 80000, 85800),
(19,
90000, 94300),
(20, 100000, 103400),
(21, 110000, 114300),
(22, 120000,
127800),
(23, 130000, 132600),
(24, 140000, 142000),
(25, 150000,
150000),
(26, 200000, 200000),
(27, 250000, 250000),
(28, 300000,
300000),
(29, 400000, 400000),
(30, 500000, 500000);
CREATE TABLE IF NOT
EXISTS `strip_bar_bar` (
`lvl` int(3) NOT NULL,
`money` int(10) NOT
NULL,
`money_up` int(10) NOT NULL,
`rating` int(10) NOT NULL,
`cocktail` int(10) NOT NULL,
PRIMARY KEY (`lvl`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
--
-- Dumping data for table `strip_bar_bar`
--
INSERT INTO
`strip_bar_bar` (`lvl`, `money`, `money_up`, `rating`, `cocktail`)
VALUES
(0, 200, 300, 1, 10),
(1, 300, 900, 2, 15),
(2, 900, 1300, 3,
20),
(3, 1300, 1900, 5, 25),
(4, 1900, 2400, 8, 30),
(5, 2400, 2850, 10,
35),
(6, 2850, 3400, 14, 40),
(7, 3400, 4000, 18, 45),
(8, 4000, 5000, 25,
50),
(9, 5000, 6200, 34, 55),
(10, 6200, 7000, 40, 60),
(11, 7000, 8500,
48, 65),
(12, 8500, 10000, 55, 70),
(13, 10000, 13600, 63, 75),
(14, 13600,
15000, 70, 80),
(15, 15000, 23800, 75, 85),
(16, 23800, 28500, 83,
90),
(17, 28500, 40000, 89, 95),
(18, 40000, 60000, 92, 100),
(19, 60000,
100000, 96, 120),
(20, 100000, 0, 100, 150);
CREATE TABLE IF NOT EXISTS
`strip_bar_desk` (
`lvl` int(3) NOT NULL,
`money` int(10) NOT NULL,
`money_up` int(10) NOT NULL,
`rating` int(10) NOT NULL,
`place` int(10)
NOT NULL,
PRIMARY KEY (`lvl`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
--
-- Dumping data for table `strip_bar_desk`
--
INSERT
INTO `strip_bar_desk` (`lvl`, `money`, `money_up`, `rating`, `place`)
VALUES
(0, 250, 335, 1, 2),
(1, 335, 800, 3, 2),
(2, 800, 1250, 5, 2),
(3,
1250, 1680, 8, 3),
(4, 1680, 2140, 10, 4),
(5, 2140, 2540, 14, 4),
(6,
2540, 3000, 16, 4),
(7, 3000, 3600, 19, 5),
(8, 3600, 4300, 24, 6),
(9,
4300, 5000, 31, 6),
(10, 5000, 5800, 37, 6),
(11, 5800, 6400, 45, 6),
(12,
6400, 7200, 50, 7),
(13, 7200, 8800, 58, 7),
(14, 8800, 10000, 66, 8),
(15,
10000, 14000, 72, 8),
(16, 14000, 17000, 77, 8),
(17, 17000, 22000, 86,
8),
(18, 22000, 30000, 90, 9),
(19, 30000, 50000, 95, 10),
(20, 50000, 0,
100, 10);
CREATE TABLE IF NOT EXISTS `strip_bar_lvl` (
`lvl` int(3) NOT
NULL AUTO_INCREMENT,
`exp` int(20) NOT NULL,
`bar_lvl` int(3) NOT
NULL,
`pole_kol` int(3) NOT NULL,
`desk_lvl` int(3) NOT NULL,
`area_x` int(3) NOT NULL,
`area_y` int(3) NOT NULL,
`scene_lvl` int(3)
NOT NULL,
`p_w_c_lvl` int(3) NOT NULL,
PRIMARY KEY (`lvl`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=101 ;
--
-- Dumping
data for table `strip_bar_lvl`
--
INSERT INTO `strip_bar_lvl` (`lvl`,
`exp`, `bar_lvl`, `pole_kol`, `desk_lvl`, `area_x`, `area_y`, `scene_lvl`,
`p_w_c_lvl`) VALUES
(1, 50, 1, 1, 2, 6, 6, 1, 1),
(2, 80, 1, 1, 2, 6, 6, 1,
1),
(3, 160, 1, 1, 2, 7, 6, 1, 1),
(4, 230, 1, 1, 2, 7, 6, 1, 1),
(5, 450,
1, 1, 3, 7, 7, 1, 2),
(6, 760, 1, 1, 3, 7, 7, 1, 2),
(7, 950, 2, 1, 3, 8,
7, 1, 2),
(8, 1250, 2, 1, 4, 8, 7, 1, 2),
(9, 1470, 2, 1, 4, 8, 8, 1,
2),
(10, 1730, 2, 2, 4, 8, 8, 2, 3),
(11, 1950, 2, 2, 4, 9, 8, 2, 3),
(12,
2340, 2, 2, 4, 9, 8, 2, 3),
(13, 2610, 3, 2, 5, 9, 9, 2, 3),
(14, 2880, 3,
2, 5, 9, 9, 2, 3),
(15, 3060, 3, 2, 5, 10, 9, 2, 4),
(16, 3330, 3, 2, 5,
10, 9, 2, 4),
(17, 3670, 4, 2, 5, 10, 10, 2, 4),
(18, 4100, 4, 2, 6, 10,
10, 2, 4),
(19, 4460, 4, 2, 6, 11, 10, 2, 4),
(20, 5000, 4, 3, 6, 11, 10,
3, 5),
(21, 10000, 4, 3, 6, 11, 11, 3, 5),
(22, 16000, 5, 3, 7, 11, 11, 3,
5),
(23, 23000, 5, 3, 7, 12, 11, 3, 5),
(24, 30000, 5, 3, 7, 12, 11, 3,
5),
(25, 35000, 6, 3, 7, 12, 12, 3, 6),
(26, 42000, 6, 3, 8, 12, 12, 3,
6),
(27, 50000, 6, 3, 8, 13, 12, 3, 6),
(28, 54000, 7, 3, 8, 13, 12, 3,
6),
(29, 65000, 7, 3, 9, 13, 13, 3, 6),
(30, 100000, 7, 4, 9, 13, 13, 4,
7),
(31, 110000, 7, 4, 9, 14, 13, 4, 7),
(32, 120000, 7, 4, 9, 14, 13, 4,
7),
(33, 130000, 7, 4, 10, 14, 14, 4, 7),
(34, 140000, 7, 4, 11, 14, 14, 4,
7),
(35, 150000, 7, 4, 12, 15, 14, 4, 8),
(36, 160000, 8, 4, 13, 15, 14, 4,
8),
(37, 170000, 8, 4, 14, 15, 15, 4, 8),
(38, 180000, 8, 4, 15, 15, 15, 4,
8),
(39, 190000, 8, 4, 15, 16, 15, 4, 8),
(40, 200000, 8, 5, 15, 16, 15, 5,
9),
(41, 210000, 8, 5, 15, 16, 16, 5, 9),
(42, 220000, 8, 5, 15, 16, 16, 5,
9),
(43, 230000, 8, 5, 15, 17, 16, 5, 9),
(44, 240000, 9, 5, 15, 17, 16, 5,
9),
(45, 250000, 9, 5, 15, 17, 17, 5, 9),
(46, 260000, 9, 5, 15, 17, 17, 5,
9),
(47, 270000, 9, 5, 15, 18, 17, 5, 9),
(48, 280000, 9, 5, 15, 18, 17, 5,
9),
(49, 290000, 9, 5, 15, 18, 18, 5, 9),
(50, 350000, 9, 6, 16, 18, 18, 6,
10),
(51, 400000, 9, 6, 16, 19, 18, 6, 10),
(52, 450000, 10, 6, 16, 19, 18,
6, 10),
(53, 500000, 10, 6, 16, 19, 19, 6, 10),
(54, 550000, 10, 6, 16, 19,
19, 6, 10),
(55, 600000, 10, 6, 16, 20, 19, 6, 11),
(56, 650000, 10, 6, 17,
20, 19, 6, 11),
(57, 700000, 10, 6, 17, 20, 20, 6, 11),
(58, 750000, 10, 6,
17, 20, 20, 6, 11),
(59, 800000, 10, 6, 17, 21, 20, 6, 11),
(60, 850000,
11, 7, 17, 21, 20, 7, 12),
(61, 900000, 11, 7, 18, 21, 21, 7, 12),
(62,
950000, 11, 7, 18, 21, 21, 7, 12),
(63, 1000000, 11, 7, 19, 22, 21, 7,
12),
(64, 1000000, 11, 7, 19, 22, 21, 7, 12),
(65, 1000000, 11, 7, 19, 22,
22, 7, 13),
(66, 2000000, 11, 7, 19, 22, 22, 7, 13),
(67, 3000000, 12, 7,
19, 23, 22, 7, 13),
(68, 4000000, 12, 7, 20, 23, 22, 7, 13),
(69, 5000000,
12, 7, 20, 23, 23, 7, 13),
(70, 6000000, 12, 8, 20, 23, 23, 7, 14),
(71,
7000000, 13, 8, 20, 24, 23, 8, 14),
(72, 8000000, 13, 8, 20, 24, 23, 8,
14),
(73, 9000000, 13, 8, 20, 24, 24, 8, 14),
(74, 10000000, 13, 8, 20, 24,
24, 8, 14),
(75, 11000000, 14, 8, 21, 25, 24, 8, 15),
(76, 13000000, 14, 8,
21, 25, 24, 8, 15),
(77, 15000000, 14, 8, 22, 25, 25, 8, 15),
(78,
17000000, 14, 8, 22, 25, 25, 8, 15),
(79, 19000000, 15, 8, 23, 26, 25, 8,
15),
(80, 50000000, 15, 9, 23, 26, 25, 8, 16),
(81, 100000000, 15, 9, 24,
26, 26, 9, 16),
(82, 200000000, 15, 9, 24, 26, 26, 9, 16),
(83, 300000000,
16, 9, 25, 27, 26, 9, 16),
(84, 400000000, 16, 9, 25, 27, 26, 9, 16),
(85,
500000000, 16, 9, 26, 27, 27, 9, 17),
(86, 600000000, 17, 9, 26, 27, 27, 9,
17),
(87, 700000000, 17, 9, 26, 28, 27, 9, 17),
(88, 800000000, 17, 9, 27,
28, 27, 9, 17),
(89, 900000000, 18, 9, 27, 28, 28, 9, 17),
(90, 1000000000,
18, 10, 27, 28, 28, 10, 19),
(91, 2000000000, 18, 10, 28, 29, 28, 10,
19),
(92, 2147483647, 18, 10, 28, 29, 28, 10, 19),
(93, 2147483647, 18, 10,
28, 29, 29, 10, 19),
(94, 2147483647, 19, 10, 28, 29, 29, 10, 19),
(95,
2147483647, 19, 10, 30, 30, 29, 10, 20),
(96, 2147483647, 19, 10, 30, 30,
29, 10, 20),
(97, 2147483647, 19, 10, 30, 30, 30, 10, 20),
(98, 2147483647,
19, 10, 30, 30, 30, 10, 20),
(99, 2147483647, 19, 10, 30, 30, 30, 10,
20),
(100, 2147483647, 20, 10, 30, 30, 30, 10, 20);
CREATE TABLE IF NOT
EXISTS `strip_bar_pole` (
`id` int(3) NOT NULL AUTO_INCREMENT,
`login`
varchar(32) NOT NULL,
`num_pole` int(10) NOT NULL,
`time_n` int(11) NOT
NULL,
`time_k` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS
`strip_bar_p_w_c` (
`lvl` int(3) NOT NULL,
`money` int(10) NOT NULL,
PRIMARY KEY (`lvl`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping
data for table `strip_bar_p_w_c`
--
INSERT INTO `strip_bar_p_w_c` (`lvl`,
`money`) VALUES
(1, 1000),
(2, 2500),
(3, 5000),
(4, 7000),
(5, 10000),
(6,
13000),
(7, 16000),
(8, 20000),
(9, 23000),
(10, 27000),
(11, 30000),
(12,
35000),
(13, 38000),
(14, 40000),
(15, 43000),
(16, 45000),
(17,
48000),
(18, 50000),
(19, 70000),
(20, 100000);
CREATE TABLE IF NOT
EXISTS `strip_bar_settings` (
`id` int(10) NOT NULL,
`initial_money`
int(10) NOT NULL,
`c_money` int(10) NOT NULL,
`pole_money` int(10) NOT
NULL,
`scene_for` int(10) NOT NULL,
`paul_for` int(10) NOT NULL,
`wall_for` int(10) NOT NULL,
`ceiling_for` int(10) NOT NULL,
`scene_rat` int(10) NOT NULL,
`paul_rat` int(10) NOT NULL,
`wall_rat`
int(10) NOT NULL,
`ceiling_rat` int(10) NOT NULL,
`bar_area` int(10)
NOT NULL,
`desk_area` int(10) NOT NULL,
`bonus_g_n` int(20) NOT NULL,
`bonus_g_k` int(20) NOT NULL,
`bonus_gold` int(20) NOT NULL,
`bonus_bals` int(20) NOT NULL,
`gold_name` int(20) NOT NULL,
`pole_money_n` int(20) NOT NULL,
`pole_gold` int(20) NOT NULL,
`time_money` int(20) NOT NULL,
`money_bilet` int(20) NOT NULL,
`money_cock` int(20) NOT NULL,
`money_exp` int(20) NOT NULL,
`rating_name` int(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `strip_bar_user` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`login` varchar(32) NOT NULL,
`name_strip_bar` varchar(20) NOT NULL,
`money` int(50) NOT NULL,
`gold`
int(20) NOT NULL DEFAULT '0',
`lvl` int(10) NOT NULL DEFAULT '1',
`exp`
varchar(20) NOT NULL DEFAULT '0',
`rating` int(20) NOT NULL DEFAULT '0',
`cocktail` int(20) NOT NULL DEFAULT '0',
`cocktail_max` int(20) NOT NULL
DEFAULT '0',
`place` int(20) NOT NULL DEFAULT '0',
`bar_lvl` int(10)
NOT NULL DEFAULT '0',
`bar_kol` int(10) NOT NULL DEFAULT '2',
`desk_lvl` int(10) NOT NULL DEFAULT '0',
`desk_kol` int(10) NOT NULL
DEFAULT '2',
`area_x` int(10) NOT NULL DEFAULT '5',
`area_y` int(10)
NOT NULL DEFAULT '5',
`pole_kol` int(10) NOT NULL DEFAULT '1',
`scene_lvl` int(10) NOT NULL DEFAULT '1',
`paul_lvl` int(10) NOT NULL
DEFAULT '1',
`wall_lvl` int(10) NOT NULL DEFAULT '1',
`ceiling_lvl`
int(10) NOT NULL DEFAULT '1',
`date_money` int(11) NOT NULL,
`date_bonus` int(11) NOT NULL,
`kol_d` int(11) NOT NULL DEFAULT '0',
`date` int(11) NOT NULL,
`time` int(11) NOT NULL,
`online` int(2) NOT
NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=2 ;