· 4 years ago · Dec 29, 2020, 06:52 AM
1-- Adminer 3.5.1 MySQL dump
2
3SET NAMES utf8;
4SET foreign_key_checks = 0;
5SET time_zone = 'SYSTEM';
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8DROP TABLE IF EXISTS `users`;
9CREATE TABLE `users` (
10 `id` int(11) NOT NULL AUTO_INCREMENT,
11 `username` varchar(15) NOT NULL,
12 `sso` varchar(100) NOT NULL,
13 `diamonds` int(11) NOT NULL DEFAULT '1000',
14 `credits` int(11) NOT NULL DEFAULT '1000',
15 `duckets` int(11) NOT NULL DEFAULT '1000',
16 `figure` varchar(500) NOT NULL,
17 PRIMARY KEY (`id`)
18) ENGINE=InnoDB DEFAULT CHARSET=latin1;
19
20INSERT INTO `users` (`id`, `username`, `sso`, `diamonds`, `credits`, `duckets`, `figure`) VALUES
21(1, 'Test', 'abc', 1000, 1000, 1000, 'sh-3035-82.hd-180-1.ch-3001-82-1408.lg-3290-110.cc-886-110.hr-3278-45-40');
22
23-- 2016-02-15 13:59:22