API tools faq
paste
Advertisement
Guest User

Achievements Table

a guest
Oct 6th, 2012
67
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 8.94 KB | None | 0 0
raw download clone embed print report
  1. -- phpMyAdmin SQL Dump
  2. -- version 3.5.2
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: localhost
  6. -- Generation Time: Oct 07, 2012 at 06:28 AM
  7. -- Server version: 5.5.25a
  8. -- PHP Version: 5.4.4
  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 utf8 */;
  18.  
  19. --
  20. -- Database: `vert2`
  21. --
  22.  
  23. -- --------------------------------------------------------
  24.  
  25. --
  26. -- Table structure for table `achievements`
  27. --
  28.  
  29. CREATE TABLE IF NOT EXISTS `achievements` (
  30.   `player` varchar(32) NOT NULL,
  31.   `achievement` varchar(255) NOT NULL,
  32.   `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  33.   KEY `player` (`player`)
  34. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  35.  
  36. --
  37. -- Dumping data for table `achievements`
  38. --
  39.  
  40. INSERT INTO `achievements` (`player`, `achievement`, `timestamp`) VALUES
  41. ('apoisonedgift', 'exp01', '2012-09-18 14:34:26'),
  42. ('apoisonedgift', 'mobkill04', '2012-09-18 14:34:56'),
  43. ('apoisonedgift', 'login01', '2012-09-18 16:12:57'),
  44. ('apoisonedgift', 'armswing01', '2012-09-18 16:34:27'),
  45. ('apoisonedgift', 'destroy01', '2012-09-18 16:59:00'),
  46. ('apoisonedgift', 'fish01', '2012-09-18 17:05:00'),
  47. ('apoisonedgift', 'walk01', '2012-09-18 17:07:30'),
  48. ('apoisonedgift', 'fish02', '2012-09-18 17:39:35'),
  49. ('BUTSLASHER', 'chat01', '2012-09-19 06:34:03'),
  50. ('Darkrecruiter', 'chat01', '2012-09-19 06:42:05'),
  51. ('BUTSLASHER', 'armswing01', '2012-09-19 06:54:05'),
  52. ('Darkrecruiter', 'armswing01', '2012-09-19 06:58:27'),
  53. ('BUTSLASHER', 'login01', '2012-09-19 07:00:32'),
  54. ('BUTSLASHER', 'fish01', '2012-09-19 07:00:32'),
  55. ('BUTSLASHER', 'kills01', '2012-09-19 07:00:32'),
  56. ('BUTSLASHER', 'mobkill04', '2012-09-19 07:00:32'),
  57. ('BUTSLASHER', 'fish02', '2012-09-19 07:00:32'),
  58. ('Darkrecruiter', 'walk01', '2012-09-19 07:33:07'),
  59. ('BUTSLASHER', 'walk01', '2012-09-19 07:33:39'),
  60. ('BUTSLASHER', 'mobkill02', '2012-09-19 07:51:47'),
  61. ('BUTSLASHER', 'mobkill03', '2012-09-19 07:51:47'),
  62. ('Looni115mirani', 'chat01', '2012-09-19 08:01:48'),
  63. ('BUTSLASHER', 'die01', '2012-09-19 08:15:48'),
  64. ('Looni115mirani', 'exp01', '2012-09-19 08:22:20'),
  65. ('apoisonedgift', 'chat01', '2012-09-19 08:23:19'),
  66. ('BUTSLASHER', 'walk02', '2012-09-19 08:42:12'),
  67. ('werewolfx28', 'chat01', '2012-09-19 08:44:42'),
  68. ('Looni115mirani', 'walk01', '2012-09-19 08:54:21'),
  69. ('werewolfx28', 'exp01', '2012-09-19 08:54:21'),
  70. ('apoisonedgift', 'walk02', '2012-09-19 08:56:22'),
  71. ('Looni115mirani', 'armswing01', '2012-09-19 09:11:26'),
  72. ('werewolfx28', 'walk01', '2012-09-19 09:13:31'),
  73. ('werewolfx28', 'armswing01', '2012-09-19 09:20:02'),
  74. ('BUTSLASHER', 'mobkill01', '2012-09-19 09:35:32'),
  75. ('werewolfx28', 'walk02', '2012-09-19 09:38:32'),
  76. ('apoisonedgift', 'create01', '2012-09-19 09:49:32'),
  77. ('apoisonedgift', 'kills01', '2012-09-19 10:26:32'),
  78. ('Looni115mirani', 'fish01', '2012-09-19 10:49:32'),
  79. ('Looni115mirani', 'fish02', '2012-09-19 10:49:32'),
  80. ('Looni115mirani', 'walk02', '2012-09-19 11:03:32'),
  81. ('BUTSLASHER', 'fish03', '2012-09-19 11:05:32'),
  82. ('BUTSLASHER', 'create01', '2012-09-19 11:25:02'),
  83. ('BUTSLASHER', 'walk03', '2012-09-19 11:27:32'),
  84. ('apoisonedgift', 'walk03', '2012-09-19 11:59:03'),
  85. ('apoisonedgift', 'mobkill08', '2012-09-19 12:10:04'),
  86. ('apoisonedgift', 'damage02', '2012-09-19 12:21:36'),
  87. ('BUTSLASHER', 'mobkill08', '2012-09-19 12:26:38'),
  88. ('apoisonedgift', 'mobkill07', '2012-09-19 12:32:39'),
  89. ('apoisonedgift', 'fish03', '2012-09-19 12:34:09'),
  90. ('Darkrecruiter', 'login01', '2012-09-20 06:27:15'),
  91. ('Darkrecruiter', 'exp01', '2012-09-20 06:52:15'),
  92. ('Darkrecruiter', 'walk02', '2012-09-20 07:28:15'),
  93. ('Darkrecruiter', 'fish01', '2012-09-20 07:41:45'),
  94. ('Darkrecruiter', 'fish02', '2012-09-20 07:43:45'),
  95. ('Notex', 'exp03', '2012-09-20 08:28:45'),
  96. ('Notex', 'exp02', '2012-09-20 08:28:45'),
  97. ('nipping', 'chat01', '2012-09-20 09:12:49'),
  98. ('Slaterbug', 'chat01', '2012-09-20 09:13:49'),
  99. ('Notex', 'damage02', '2012-09-21 06:35:39'),
  100. ('nipping', 'walk01', '2012-09-21 07:15:12'),
  101. ('werewolfx28', 'walk03', '2012-09-21 07:25:45'),
  102. ('nipping', 'armswing01', '2012-09-21 07:26:45'),
  103. ('Slaterbug', 'walk01', '2012-09-21 07:39:18'),
  104. ('Darkrecruiter', 'destroy01', '2012-09-21 07:41:24'),
  105. ('Notex', 'walk02', '2012-09-21 07:41:54'),
  106. ('werewolfx28', 'kills01', '2012-09-21 07:39:54'),
  107. ('werewolfx28', 'mobkill05', '2012-09-21 07:39:54'),
  108. ('Darkrecruiter', 'walk03', '2012-09-21 07:50:02'),
  109. ('werewolfx28', 'die01', '2012-09-21 07:49:32'),
  110. ('Slaterbug', 'armswing01', '2012-09-21 07:51:32'),
  111. ('nipping', 'walk02', '2012-09-21 07:52:04'),
  112. ('Looni115mirani', 'walk03', '2012-09-21 07:57:04'),
  113. ('Slaterbug', 'walk02', '2012-09-21 07:58:34'),
  114. ('werewolfx28', 'mobkill10', '2012-09-21 08:17:11'),
  115. ('nipping', 'destroy01', '2012-09-21 08:29:11'),
  116. ('Slaterbug', 'destroy01', '2012-09-21 08:44:47'),
  117. ('nipping', 'walk03', '2012-09-21 09:58:51'),
  118. ('Slaterbug', 'create01', '2012-09-21 11:01:23'),
  119. ('nipping', 'create01', '2012-09-21 11:12:25'),
  120. ('Slaterbug', 'walk03', '2012-09-21 11:15:25'),
  121. ('Looni115mirani', 'create01', '2012-09-21 11:18:25'),
  122. ('nipping', 'login01', '2012-09-21 13:21:55'),
  123. ('Looni115mirani', 'destroy01', '2012-09-21 13:54:55'),
  124. ('nipping', 'die01', '2012-09-21 14:11:25'),
  125. ('werewolfx28', 'destroy01', '2012-09-21 23:31:46'),
  126. ('werewolfx28', 'exp02', '2012-09-21 23:38:46'),
  127. ('nipping', 'destroy02', '2012-09-22 04:55:29'),
  128. ('nipping', 'mobkill01', '2012-09-22 08:38:31'),
  129. ('nipping', 'kills01', '2012-09-22 08:39:31'),
  130. ('nipping', 'exp01', '2012-09-22 10:06:02'),
  131. ('nipping', 'mobkill03', '2012-09-22 10:06:32'),
  132. ('nipping', 'mobkill04', '2012-09-22 10:49:02'),
  133. ('nipping', 'mobkill02', '2012-09-22 13:49:21'),
  134. ('nipping', 'fish01', '2012-09-22 13:55:51'),
  135. ('nipping', 'fish02', '2012-09-22 13:58:21'),
  136. ('nipping', 'fish03', '2012-09-22 13:59:51'),
  137. ('nipping', 'destroy03', '2012-09-22 14:23:51'),
  138. ('smax25', 'chat01', '2012-09-22 15:09:21'),
  139. ('smax25', 'armswing01', '2012-09-22 15:26:21'),
  140. ('Looni115mirani', 'exp02', '2012-09-23 03:54:10'),
  141. ('smax25', 'destroy01', '2012-09-23 04:09:10'),
  142. ('Looni115mirani', 'kills01', '2012-09-23 04:49:40'),
  143. ('smax25', 'walk01', '2012-09-23 05:01:40'),
  144. ('nipping', 'damage02', '2012-09-23 05:41:10'),
  145. ('nipping', 'create02', '2012-09-23 05:50:10'),
  146. ('nipping', 'mobkill05', '2012-09-23 06:16:12'),
  147. ('Looni115mirani', 'login01', '2012-09-23 07:28:12'),
  148. ('Notex', 'login01', '2012-09-23 07:55:12'),
  149. ('nipping', 'exp02', '2012-09-23 08:02:42'),
  150. ('Notex', 'mobkill04', '2012-09-23 08:42:42'),
  151. ('Notex', 'mobkill01', '2012-09-23 08:52:42'),
  152. ('nipping', 'kills02', '2012-09-23 11:38:12'),
  153. ('Notex', 'mobkill02', '2012-09-24 05:00:48'),
  154. ('nipping', 'exp03', '2012-09-24 05:03:48'),
  155. ('Looni115mirani', 'fish03', '2012-09-24 06:29:48'),
  156. ('nipping', 'create03', '2012-09-24 11:49:28'),
  157. ('astractx', 'chat01', '2012-09-24 14:20:04'),
  158. ('astractx', 'armswing01', '2012-09-24 14:36:34'),
  159. ('Notex', 'destroy02', '2012-09-25 03:40:24'),
  160. ('Darkrecruiter', 'exp02', '2012-09-25 06:36:55'),
  161. ('Darkrecruiter', 'kills01', '2012-09-25 06:46:55'),
  162. ('Pkr3', 'chat01', '2012-09-29 00:15:26'),
  163. ('apoisonedgift', 'die01', '2012-09-30 11:34:09'),
  164. ('werewolfx28', 'login01', '2012-10-03 09:22:10'),
  165. ('werewolfx28', 'walk01', '2012-10-04 03:00:22'),
  166. ('werewolfx28', 'armswing01', '2012-10-04 03:00:22'),
  167. ('werewolfx28', 'kills01', '2012-10-04 03:00:22'),
  168. ('werewolfx28', 'destroy01', '2012-10-04 03:00:22'),
  169. ('werewolfx28', 'login01', '2012-10-04 03:00:22'),
  170. ('werewolfx28', 'die01', '2012-10-04 03:00:22'),
  171. ('werewolfx28', 'mobkill10', '2012-10-04 03:00:22'),
  172. ('werewolfx28', 'mobkill05', '2012-10-04 03:00:22'),
  173. ('werewolfx28', 'chat01', '2012-10-04 03:00:22'),
  174. ('werewolfx28', 'walk02', '2012-10-04 03:00:22'),
  175. ('werewolfx28', 'exp01', '2012-10-04 03:00:22'),
  176. ('werewolfx28', 'walk03', '2012-10-04 03:00:22'),
  177. ('Notex', 'kills01', '2012-10-05 09:26:54'),
  178. ('Notex', 'mobkill06', '2012-10-05 09:26:54'),
  179. ('Notex', 'mobkill05', '2012-10-05 09:26:54'),
  180. ('Notex', 'destroy01', '2012-10-05 09:26:54'),
  181. ('Notex', 'mobkill10', '2012-10-05 09:26:54'),
  182. ('Notex', 'chat01', '2012-10-05 09:26:54'),
  183. ('Notex', 'armswing01', '2012-10-05 09:26:54'),
  184. ('Notex', 'kills02', '2012-10-05 09:26:54'),
  185. ('Notex', 'walk01', '2012-10-05 09:26:54'),
  186. ('Notex', 'exp01', '2012-10-05 09:27:54'),
  187. ('Notex', 'create01', '2012-10-05 09:26:54'),
  188. ('Notex', 'walk03', '2012-10-05 09:26:54'),
  189. ('seth_sh', 'chat01', '2012-10-06 05:16:21'),
  190. ('seth_sh', 'armswing01', '2012-10-06 05:22:23'),
  191. ('seth_sh', 'walk01', '2012-10-06 05:39:55'),
  192. ('seth_sh', 'walk02', '2012-10-06 06:06:23'),
  193. ('Notex', 'create02', '2012-10-06 06:15:23'),
  194. ('Notex', 'kills03', '2012-10-06 06:35:26'),
  195. ('Notex', 'kills04', '2012-10-06 06:35:26'),
  196. ('LONG_HAIRED_GIT', 'chat01', '2012-10-06 22:49:58');
  197.  
  198. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  199. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  200. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!