diff options
| author |  Vitaly Takmazov | 2018-06-22 07:38:30 +0000 |
|---|---|---|
| committer | Vitaly Takmazov | 2018-06-22 07:38:30 +0000 |
| commit | e0d62557ee17033026695390fc9157b48c3485a3 (patch) | |
| tree | 0b150432b2f097ad938089194debc5aefe36b881 | |
| parent | c9834a79f4eb7fc4739bb6d588cbfdf591ae9d82 (diff) | |
update vk schema
| -rw-r--r-- | juick-server/src/main/resources/juick.sql | 8 |
1 files changed, 4 insertions, 4 deletions
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 |