Advertisement
Guest User

Untitled

a guest
Jun 25th, 2018
652
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.48 KB | None | 0 0
  1. /*
  2. SQLyog Ultimate v12.4.1 (64 bit)
  3. MySQL - 5.0.67-community-nt : Database - nfsmw
  4. SkelletonX 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 */;
  16. CREATE DATABASE /*!32312 IF NOT EXISTS*/`nfsmw` /*!40100 DEFAULT CHARACTER SET latin1 */;
  17.  
  18. USE `nfsmw`;
  19.  
  20. /*Table structure for table `accounts` */
  21.  
  22. DROP TABLE IF EXISTS `accounts`;
  23.  
  24. CREATE 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.  
  36. insert  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 */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement