From 62ba7cb1a7023e97cef418eeec6e5c610e244b91 Mon Sep 17 00:00:00 2001
From: Pinapelz <yukais@pinapelz.com>
Date: Mon, 8 Sep 2025 17:05:59 -0700
Subject: add independents to captcha pool

---
 .gitignore                                   |  1 +
 VtuberCaptchaUpdater/src/main/java/Main.java |  6 +++---
 databank_setup.sql                           |  7 -------
 schema.sql                                   | 15 +++++++++++++++
 4 files changed, 19 insertions(+), 10 deletions(-)
 delete mode 100644 databank_setup.sql
 create mode 100644 schema.sql

diff --git a/.gitignore b/.gitignore
index dee83c9..e5a648a 100644
--- a/.gitignore
+++ b/.gitignore
@@ -198,3 +198,4 @@ build/
 ### Mac OS ###
 .DS_Store
 .env*.local
+secrets.json
diff --git a/VtuberCaptchaUpdater/src/main/java/Main.java b/VtuberCaptchaUpdater/src/main/java/Main.java
index 3cb93a8..5e9ca4d 100644
--- a/VtuberCaptchaUpdater/src/main/java/Main.java
+++ b/VtuberCaptchaUpdater/src/main/java/Main.java
@@ -18,10 +18,10 @@ public class Main
     private static Map<String, String> organizations = Map.of(
             "Hololive", "Hololive",
             "Nijisanji", "Nijisanji",
-            "VShojo", "VShojo",
             "idol Corp", "Idol Corp",
-            "EIEN Project", "Eien Project",
-            "Phase Connect", "Phase Connect"
+            "Phase Connect", "Phase Connect",
+            "VSpo", "VSPO!",
+            "Independents", "Independents"
     );
 
     public static HashMap<String, String> readSettings() throws IOException {
diff --git a/databank_setup.sql b/databank_setup.sql
deleted file mode 100644
index f6b9482..0000000
--- a/databank_setup.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-CREATE TABLE vtuber_data
-(
-    id text PRIMARY KEY,
-    name text,
-    organization text,
-    photo text
-);
diff --git a/schema.sql b/schema.sql
new file mode 100644
index 0000000..04f46d6
--- /dev/null
+++ b/schema.sql
@@ -0,0 +1,15 @@
+CREATE TABLE vtuber_data
+(
+    id serial PRIMARY KEY,
+    name text,
+    affiliation text,
+    image_url text
+);
+
+
+CREATE TABLE sessions
+(
+    session_id varchar(255) PRIMARY KEY,
+    answer varchar(255),
+    created_at timestamp,
+);
-- 
cgit v1.2.3