· 8 years ago · Jun 25, 2018, 08:02 PM
1/*
2SQLyog Ultimate v12.4.1 (64 bit)
3MySQL - 5.0.67-community-nt : Database - nfsmw
4SkelletonX https://www.instagram.com/gui_t99/
5*********************************************************************
6*/
7
8/*!40101 SET NAMES utf8 */;
9
10/*!40101 SET SQL_MODE=''*/;
11
12/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
13/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
14/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
15/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
16CREATE DATABASE /*!32312 IF NOT EXISTS*/`nfsmw` /*!40100 DEFAULT CHARACTER SET latin1 */;
17
18USE `nfsmw`;
19
20/*Table structure for table `accounts` */
21
22DROP TABLE IF EXISTS `accounts`;
23
24CREATE TABLE `accounts` (
25 `ID` int(11) NOT NULL auto_increment,
26 `Login` varchar(225) NOT NULL,
27 `Pass` varchar(225) NOT NULL,
28 `NickName` varchar(225) NOT NULL,
29 `Email` varchar(225) default 'nfsmw@skell.com',
30 `IsOnline` int(11) default '0',
31 PRIMARY KEY (`ID`)
32) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
33
34/*Data for the table `accounts` */
35
36insert into `accounts`(`ID`,`Login`,`Pass`,`NickName`,`Email`,`IsOnline`) values
37(1,'Skell','123','SkelletonX','nfsmw@skell.com',1),
38(2,'Skell2','123','Player','nfsmw@skell.com',0);
39
40/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
41/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
42/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
43/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;