From e0d62557ee17033026695390fc9157b48c3485a3 Mon Sep 17 00:00:00 2001
From: Vitaly Takmazov
Date: Fri, 22 Jun 2018 07:38:30 +0000
Subject: update vk schema

---
 juick-server/src/main/resources/juick.sql | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

(limited to 'juick-server/src/main/resources/juick.sql')

diff --git a/juick-server/src/main/resources/juick.sql b/juick-server/src/main/resources/juick.sql
index ce34385f..a6fb76cd 100644
--- a/juick-server/src/main/resources/juick.sql
+++ b/juick-server/src/main/resources/juick.sql
@@ -894,11 +894,11 @@ DROP TABLE IF EXISTS `vk`;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `vk` (
   `user_id` int(10) unsigned DEFAULT NULL,
-  `vk_id` bigint(20) NOT NULL,
+  `vk_id` bigint(20) unsigned DEFAULT NULL,
   `loginhash` char(36) DEFAULT NULL,
-  `access_token` char(128) NOT NULL,
+  `access_token` char(128) DEFAULT NULL,
   `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
-  `vk_name` char(64) NOT NULL,
+  `vk_name` char(64) DEFAULT NULL,
   `vk_link` char(64) NOT NULL,
   `crosspost` tinyint(3) unsigned NOT NULL DEFAULT '1',
   KEY `user_id` (`user_id`)
@@ -944,4 +944,4 @@ CREATE TABLE `wl_users` (
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2018-06-13  9:49:48
+-- Dump completed on 2018-06-22  7:38:17
-- 
cgit v1.2.3

