From 643d0840b90384de1ea055e91f5d4c7ec503fe95 Mon Sep 17 00:00:00 2001
From: Vitaly Takmazov
Date: Sat, 24 Feb 2018 08:54:50 +0300
Subject: h2 schema updates

---
 .../com/juick/configuration/DataConfiguration.java | 30 +++++++++++++++++++++-
 1 file changed, 29 insertions(+), 1 deletion(-)

(limited to 'juick-server-jdbc')

diff --git a/juick-server-jdbc/src/main/java/com/juick/configuration/DataConfiguration.java b/juick-server-jdbc/src/main/java/com/juick/configuration/DataConfiguration.java
index f5ed724a..9195d398 100644
--- a/juick-server-jdbc/src/main/java/com/juick/configuration/DataConfiguration.java
+++ b/juick-server-jdbc/src/main/java/com/juick/configuration/DataConfiguration.java
@@ -20,7 +20,10 @@ package com.juick.configuration;
 import com.juick.service.search.SearchService;
 import org.apache.commons.dbcp2.BasicDataSource;
 import org.springframework.beans.factory.annotation.Value;
-import org.springframework.context.annotation.*;
+import org.springframework.context.annotation.Bean;
+import org.springframework.context.annotation.ComponentScan;
+import org.springframework.context.annotation.Configuration;
+import org.springframework.context.annotation.PropertySource;
 import org.springframework.context.support.PropertySourcesPlaceholderConfigurer;
 import org.springframework.jdbc.core.JdbcTemplate;
 import org.springframework.jdbc.datasource.DataSourceTransactionManager;
@@ -117,6 +120,8 @@ public class DataConfiguration implements TransactionManagementConfigurer {
                     "user_id int(10) unsigned NOT NULL," +
                     "jnotify tinyint(1) NOT NULL DEFAULT 1," +
                     "`repliesview` tinyint(1) NOT NULL DEFAULT '0'," +
+                    "`subscr_notify` tinyint(1) NOT NULL DEFAULT '1'," +
+                    "`recommendations` tinyint(1) NOT NULL DEFAULT '1'," +
                     "subscr_active tinyint(1) NOT NULL DEFAULT 1)");
             jdbcTemplate.execute("CREATE TABLE IF NOT EXISTS subscr_users (" +
                     "user_id int(10) unsigned NOT NULL," +
@@ -241,6 +246,29 @@ public class DataConfiguration implements TransactionManagementConfigurer {
                     "  `cnt` smallint(5) unsigned NOT NULL DEFAULT '0'," +
                     "  PRIMARY KEY (`user_id`)" +
                     ")");
+            jdbcTemplate.execute("CREATE TABLE `auth` (" +
+                    "  `user_id` int(10) unsigned NOT NULL," +
+                    "  `protocol` enum('xmpp','email','sms') NOT NULL," +
+                    "  `account` char(64) NOT NULL," +
+                    "  `authcode` char(8) NOT NULL" +
+                    ")");
+            jdbcTemplate.execute("CREATE TABLE `mail` (" +
+                    "  `user_id` int(10) unsigned NOT NULL," +
+                    "  `hash` char(16) NOT NULL," +
+                    "  PRIMARY KEY (`user_id`)" +
+                    ")");
+            jdbcTemplate.execute("CREATE TABLE `usersinfo` (" +
+                    "  `user_id` int(10) unsigned NOT NULL," +
+                    "  `jid` char(32) DEFAULT NULL," +
+                    "  `fullname` char(32) DEFAULT NULL," +
+                    "  `country` char(32) DEFAULT NULL," +
+                    "  `url` char(64) DEFAULT NULL," +
+                    "  `gender` char(32) DEFAULT NULL," +
+                    "  `bday` char(10) DEFAULT NULL," +
+                    "  `descr` varchar(255) DEFAULT NULL," +
+                    "  PRIMARY KEY (`user_id`)" +
+                    ")");
+            jdbcTemplate.update("INSERT INTO users(nick,passw) VALUES (?,?)", "ugnich", "secret");
         }
         return jdbcTemplate;
     }
-- 
cgit v1.2.3