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