diff options
| -rw-r--r-- | .gitignore | 1 | ||||
| -rw-r--r-- | VtuberCaptchaUpdater/src/main/java/Main.java | 6 | ||||
| -rw-r--r-- | databank_setup.sql | 7 | ||||
| -rw-r--r-- | schema.sql | 15 |
4 files changed, 19 insertions, 10 deletions
@@ -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, +); |