· 11 years ago · May 06, 2015, 01:18 PM
1/*
2Navicat MySQL Data Transfer
3
4Source Server : sf
5Source Server Version : 50525
6Source Host : localhost:3306
7Source Database : web
8
9Target Server Type : MYSQL
10Target Server Version : 50525
11File Encoding : 65001
12
13Date: 2015-05-06 16:13:09
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for `users`
20-- ----------------------------
21DROP TABLE IF EXISTS `users`;
22CREATE TABLE `users` (
23 `id` int(255) NOT NULL AUTO_INCREMENT,
24 `login` varchar(35) NOT NULL,
25 `email` varchar(35) NOT NULL,
26 `password` varchar(50) NOT NULL,
27 `lastip` varchar(50) NOT NULL,
28 `minxp` varchar(255) NOT NULL,
29 `maxsp` varchar(255) NOT NULL,
30 `nick` varchar(255) NOT NULL,
31 `status` int(10) NOT NULL,
32 `location` varchar(255) NOT NULL,
33 PRIMARY KEY (`id`)
34) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
35
36-- ----------------------------
37-- Records of users
38-- ----------------------------
39INSERT INTO `users` VALUES ('1', 'gragonvlad', 'gragonvlad@gmail.com', 'f04d811e9bc801627d71296d12f5c56b9d07ef8e', '192.168.1.2', '', 'fef', 'darkteam', '0', '1');
40INSERT INTO `users` VALUES ('8', '11111', '1@mail.ru', '3331ef9171f5f01beecbd9ece98986fce20b0a4d', '192.168.1.2', '', 'feef', '', '0', '');
41INSERT INTO `users` VALUES ('9', 'tetetetee', 'tetetetee@mail.ru', '53c1dad4e86b36ee5073cebcc138ef17c3a27606', '192.168.1.2', '', '', '', '0', '');
42INSERT INTO `users` VALUES ('10', 'jomla', 'jomla@mail.ru', '030f792b84510fd42402382521069f4879fceb34', '192.168.1.2', '', '', '', '0', '');