forked from WalkWeb/Browser-MMORPG-Level-System
-
Notifications
You must be signed in to change notification settings - Fork 0
/
level.sql
49 lines (33 loc) · 895 Bytes
/
level.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
-- Таблица Users
CREATE TABLE `users` (
`id` INT AUTO_INCREMENT PRIMARY KEY,
`name` VARCHAR(255),
`lvl`INT DEFAULT 1,
`exp` INT DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- Таблица Levels
CREATE TABLE `levels` (
`lvl` INT DEFAULT NULL,
`exp_to_lvl` INT DEFAULT NULL,
`exp_total` INT DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- Заполняем таблицу User
INSERT INTO `users` (`id`, `name`, `lvl`, `exp`)
VALUES
(NULL, 'Diablo', '1', '0');
-- Заполняем таблицу Levels
INSERT INTO `levels` (`lvl`, `exp_total`, `exp_to_lvl`)
VALUES
('1', '0', '25'),
('2', '25', '66'),
('3', '91', '117'),
('4', '208', '175'),
('5', '383', '239'),
('6', '622', '309'),
('7', '931', '383'),
('8', '1314', '462'),
('9', '1776', '544'),
('10', '2320', '1000000');
-- Удаление таблиц
DROP TABLE `users`;
DROP TABLE `levels`;