Вход Регистрация
Файл: install/wgame.sql
Строк: 55
-- phpMyAdmin SQL Dump -- version 4.5.2 -- http://www.phpmyadmin.net -- --
Host: localhost -- Generation Time: Dec 21, 2017 at 11:45 -- Server
version: 10.1.13-MariaDB -- PHP Version: 5.6.23 SET SQL_MODE =
"NO_AUTO_VALUE_ON_ZERO"; SET time_zone =
"+00:00"; /*!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
utf8mb4 */; -- -- Database: `wgame` -- --
-------------------------------------------------------- -- -- Table
structure for table `modules` -- CREATE TABLE `modules` ( `id` int(11)
NOT NULL, `module` varchar(255) NOT NULL, `param` text NOT NULL )
ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table
`modules` -- INSERT INTO `modules` (`id`, `module`, `param`) VALUES (1,
'_system', '{"title":"WGame
Engine","style":"default.css","userSessionLifeTime":6400}'), (2,
'index', '{"close":0,"title":"WGame
Engine"}'), (3, 'auth/signUp',
'{"close":0,"title":"\\u0420\\u0435\\u0433\\u0438\\u0441\\u0442\\u0440\\u0430\\u0446\\u0438\\u044f","rLevel":1,"rStrike":10,"rDefend":10,"rHealth":100,"rMaxHealth":100}'), (4,
'auth/signIn',
'{"close":"0","title":"Вход"}'), (5,
'main', '{"close":0,"title":"WGame
Engine"}'), (6, 'auth/exit',
'{"close":0,"title":"Выход"}'); --
-------------------------------------------------------- -- -- Table
structure for table `users` -- CREATE TABLE `users` ( `id` int(11) NOT
NULL, `login` varchar(50) NOT NULL, `password` varchar(255) NOT NULL,
`session` varchar(255) NOT NULL, `sessionLifeTime` int(11) NOT NULL,
`token` varchar(255) NOT NULL, `access` set('0','1','2') NOT NULL COMMENT
'Права доступа', `level` int(11) NOT NULL, `strike` int(11)
NOT NULL, `defend` int(11) NOT NULL, `health` int(11) NOT NULL,
`maxHealth` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- --
Dumping data for table `users` -- INSERT INTO `users` (`id`, `login`,
`password`, `session`, `sessionLifeTime`, `token`, `access`, `level`,
`strike`, `defend`, `health`, `maxHealth`) VALUES (1, 'admin',
'$2y$10$Y/MgAH2ROGcvZ2wWwf3BF.5uWNDII1snE1rP22/HVgs2MnK7AM95e',
'bc69410ee32f5ba0c93357f7787067c2', 1513901957, '', '2', 1, 10, 10, 100,
100); -- -- Indexes for dumped tables -- -- -- Indexes for table
`modules` -- ALTER TABLE `modules` ADD PRIMARY KEY (`id`); -- -- Indexes
for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- --
AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table
`modules` -- ALTER TABLE `modules` MODIFY `id` int(11) NOT NULL
AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table
`users` -- ALTER TABLE `users` MODIFY `id` int(11) NOT NULL
AUTO_INCREMENT, AUTO_INCREMENT=2; /*!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 */;
Онлайн: 1
Реклама