Update dump

Signed-off-by: Roeland Jago Douma <roeland@famdouma.nl>

1 files changed, 22 insertions, 123 deletions

diff --git a/mysql.dmp b/mysql.dmp
index b6eea52..d1230d5 100755
--- a/mysql.dmp
+++ b/mysql.dmp
@@ -3,12 +3,10 @@
 -- https://www.phpmyadmin.net/
 --
 -- Host: 172.17.0.2
--- Generation Time: Nov 18, 2016 at 01:23 PM
+-- Generation Time: Nov 21, 2016 at 12:48 PM
 -- Server version: 10.1.19-MariaDB-1~jessie
 -- PHP Version: 7.0.13
 
--- TODO: FIX BIGINT AND ALL
-
 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
 SET time_zone = "+00:00";
 
@@ -21,24 +19,8 @@ SET time_zone = "+00:00";
 --
 -- Database: `lookup`
 --
-
--- --------------------------------------------------------
-
---
--- Table structure for table `apitraffic`
---
-
-CREATE TABLE `apitraffic` (
-  `ip` bigint(20) NOT NULL,
-  `count` int(11) NOT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-
---
--- Dumping data for table `apitraffic`
---
-
-INSERT INTO `apitraffic` (`ip`, `count`) VALUES
-(2130706433, 16);
+CREATE DATABASE IF NOT EXISTS `lookup` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+USE `lookup`;
 
 -- --------------------------------------------------------
 
@@ -46,45 +28,18 @@ INSERT INTO `apitraffic` (`ip`, `count`) VALUES
 -- Table structure for table `store`
 --
 
-CREATE TABLE `store` (
-  `id` int(11) NOT NULL,
+DROP TABLE IF EXISTS `store`;
+CREATE TABLE IF NOT EXISTS `store` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
   `userId` int(11) NOT NULL,
-  `k` varchar(255) NOT NULL,
-  `v` varchar(255) NOT NULL,
-  `valid` tinyint(1) NOT NULL DEFAULT '0'
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-
---
--- Dumping data for table `store`
---
-
-INSERT INTO `store` (`id`, `userId`, `k`, `v`, `valid`) VALUES
-(11, 10, 'name', 'admin', 0),
-(12, 10, 'email', 'a@b.nl', 0);
-
--- --------------------------------------------------------
-
---
--- Table structure for table `user`
---
-
-CREATE TABLE `user` (
-  `userid` bigint(20) NOT NULL,
-  `authkey` varchar(255) NOT NULL DEFAULT '',
-  `federationid` varchar(255) NOT NULL DEFAULT '',
-  `name` varchar(255) NOT NULL DEFAULT '',
-  `email` varchar(255) NOT NULL DEFAULT '',
-  `emailstatus` int(11) NOT NULL DEFAULT '0',
-  `organisation` varchar(255) NOT NULL DEFAULT '',
-  `country` varchar(255) NOT NULL DEFAULT '',
-  `city` varchar(255) NOT NULL DEFAULT '',
-  `picture` text NOT NULL,
-  `vcard` text NOT NULL,
-  `created` int(11) NOT NULL DEFAULT '0',
-  `changed` int(11) NOT NULL DEFAULT '0',
-  `localchange` int(11) NOT NULL DEFAULT '0',
-  `karma` int(11) NOT NULL DEFAULT '0'
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+  `k` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `v` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `valid` tinyint(1) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`id`),
+  KEY `key` (`k`(191)),
+  KEY `value` (`v`(191)),
+  KEY `userId` (`userId`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 
 -- --------------------------------------------------------
 
@@ -92,71 +47,15 @@ CREATE TABLE `user` (
 -- Table structure for table `users`
 --
 
-CREATE TABLE `users` (
-  `id` int(10) UNSIGNED NOT NULL,
-  `federationId` varchar(255) NOT NULL,
-  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-
---
--- Dumping data for table `users`
---
+DROP TABLE IF EXISTS `users`;
+CREATE TABLE IF NOT EXISTS `users` (
+  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
+  `federationId` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+  PRIMARY KEY (`id`),
+  KEY `federationId` (`federationId`(191))
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 
-INSERT INTO `users` (`id`, `federationId`, `timestamp`) VALUES
-(10, 'admin@127.0.0.1:1234', '2016-11-18 13:18:44');
-
---
--- Indexes for dumped tables
---
-
---
--- Indexes for table `apitraffic`
---
-ALTER TABLE `apitraffic`
-  ADD PRIMARY KEY (`ip`);
-
---
--- Indexes for table `store`
---
-ALTER TABLE `store`
-  ADD PRIMARY KEY (`id`),
-  ADD KEY `key` (`k`),
-  ADD KEY `value` (`v`),
-  ADD KEY `userId` (`userId`);
-
---
--- Indexes for table `user`
---
-ALTER TABLE `user`
-  ADD PRIMARY KEY (`userid`),
-  ADD KEY `userid` (`userid`,`karma`),
-  ADD KEY `authkey` (`authkey`),
-  ADD KEY `email` (`email`,`karma`),
-  ADD KEY `email2` (`email`,`authkey`),
-  ADD KEY `karma` (`localchange`,`changed`);
-ALTER TABLE `user` ADD FULLTEXT KEY `FullText` (`name`,`email`,`organisation`,`country`,`city`);
-
---
--- Indexes for table `users`
---
-ALTER TABLE `users`
-  ADD PRIMARY KEY (`id`),
-  ADD KEY `federationId` (`federationId`);
-
---
--- AUTO_INCREMENT for dumped tables
---
-
---
--- AUTO_INCREMENT for table `store`
---
-ALTER TABLE `store`
-  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
---
--- AUTO_INCREMENT for table `users`
---
-ALTER TABLE `users`
-  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;