Advertisement
Guest User

Untitled

a guest
Feb 15th, 2016
3,351
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.77 KB | None | 0 0
  1. -- Adminer 3.5.1 MySQL dump
  2.  
  3. SET NAMES utf8;
  4. SET foreign_key_checks = 0;
  5. SET time_zone = 'SYSTEM';
  6. SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
  7.  
  8. DROP TABLE IF EXISTS `users`;
  9. CREATE 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.  
  20. INSERT 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement