Advertisement
Guest User

Database Emulator Warface

a guest
May 10th, 2017
1,268
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 3.64 KB | None | 0 0
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.6.5.2
  3. -- https://www.phpmyadmin.net/
  4. --
  5. -- Host: 127.0.0.1
  6. -- Generation Time: 06-Maio-2017 às 17:06
  7. -- Versão do servidor: 10.1.21-MariaDB
  8. -- PHP Version: 5.6.30
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET time_zone = "+00:00";
  12.  
  13.  
  14. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  15. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  16. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  17. /*!40101 SET NAMES utf8mb4 */;
  18.  
  19. --
  20. -- Database: `warface_emulator`
  21. --
  22.  
  23. -- --------------------------------------------------------
  24.  
  25. --
  26. -- Estrutura da tabela `emul_profile`
  27. --
  28.  
  29. CREATE TABLE `emul_profile` (
  30.   `id` int(11) NOT NULL,
  31.   `profileid` int(11) NOT NULL,
  32.   `nickname` varchar(255) NOT NULL,
  33.   `gender` varchar(50) NOT NULL,
  34.   `height` int(11) NOT NULL,
  35.   `fatness` int(11) NOT NULL,
  36.   `head` varchar(100) NOT NULL,
  37.   `current_class` int(11) NOT NULL,
  38.   `experience` int(11) NOT NULL,
  39.   `pvp_rating_points` int(11) NOT NULL,
  40.   `banner_badge` int(11) NOT NULL,
  41.   `banner_mark` int(11) NOT NULL,
  42.   `banner_stripe` int(11) NOT NULL,
  43.   `game_money` int(11) NOT NULL,
  44.   `cry_money` int(11) NOT NULL,
  45.   `crown_money` int(11) NOT NULL
  46. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  47.  
  48. --
  49. -- Extraindo dados da tabela `emul_profile`
  50. --
  51.  
  52. INSERT INTO `emul_profile` (`id`, `profileid`, `nickname`, `gender`, `height`, `fatness`, `head`, `current_class`, `experience`, `pvp_rating_points`, `banner_badge`, `banner_mark`, `banner_stripe`, `game_money`, `cry_money`, `crown_money`) VALUES
  53. (1, 793337, 'Rubens', 'male', 1, 0, 'default_head_2', 0, 17364000, 0, 0, 0, 0, 100000, 100000, 100000),
  54. (2, 4587, 'setTimeout', 'male', 1, 0, 'default_head_4', 0, 17948250, 0, 0, 0, 0, 100000, 100000, 100000);
  55.  
  56. -- --------------------------------------------------------
  57.  
  58. --
  59. -- Estrutura da tabela `emul_users`
  60. --
  61.  
  62. CREATE TABLE `emul_users` (
  63.   `id` int(11) NOT NULL,
  64.   `username` varchar(255) NOT NULL,
  65.   `profileid` int(11) NOT NULL
  66. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  67.  
  68. --
  69. -- Extraindo dados da tabela `emul_users`
  70. --
  71.  
  72. INSERT INTO `emul_users` (`id`, `username`, `profileid`) VALUES
  73. (1, 'rubens', 793337),
  74. (2, 'settimeout', 4587);
  75.  
  76. -- --------------------------------------------------------
  77.  
  78. --
  79. -- Estrutura da tabela `emu_friends`
  80. --
  81.  
  82. CREATE TABLE `emu_friends` (
  83.   `id` int(11) NOT NULL,
  84.   `my_profile_id` int(11) NOT NULL,
  85.   `to_profile_id` int(11) NOT NULL
  86. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  87.  
  88. --
  89. -- Extraindo dados da tabela `emu_friends`
  90. --
  91.  
  92. INSERT INTO `emu_friends` (`id`, `my_profile_id`, `to_profile_id`) VALUES
  93. (1, 793337, 4587),
  94. (2, 4587, 793337);
  95.  
  96. --
  97. -- Indexes for dumped tables
  98. --
  99.  
  100. --
  101. -- Indexes for table `emul_profile`
  102. --
  103. ALTER TABLE `emul_profile`
  104.   ADD PRIMARY KEY (`id`);
  105.  
  106. --
  107. -- Indexes for table `emul_users`
  108. --
  109. ALTER TABLE `emul_users`
  110.   ADD PRIMARY KEY (`id`);
  111.  
  112. --
  113. -- Indexes for table `emu_friends`
  114. --
  115. ALTER TABLE `emu_friends`
  116.   ADD PRIMARY KEY (`id`);
  117.  
  118. --
  119. -- AUTO_INCREMENT for dumped tables
  120. --
  121.  
  122. --
  123. -- AUTO_INCREMENT for table `emul_profile`
  124. --
  125. ALTER TABLE `emul_profile`
  126.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  127. --
  128. -- AUTO_INCREMENT for table `emul_users`
  129. --
  130. ALTER TABLE `emul_users`
  131.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  132. --
  133. -- AUTO_INCREMENT for table `emu_friends`
  134. --
  135. ALTER TABLE `emu_friends`
  136.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  137. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  138. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  139. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement