X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=blobdiff_plain;f=src%2Fcore%2FSQL%2FPostgreSQL%2F19%2Fsetup_100_user_setting.sql;fp=src%2Fcore%2FSQL%2FPostgreSQL%2F19%2Fsetup_100_user_setting.sql;h=bf6d85d2b950678eed834fe97f7de5111ea0d007;hp=0000000000000000000000000000000000000000;hb=7d30b18136eecbdf2089e5d5877c7e41c6f4bcb6;hpb=3a5df5589e3cbefcaad966ba23643d58d4ec9768

diff --git a/src/core/SQL/PostgreSQL/19/setup_100_user_setting.sql b/src/core/SQL/PostgreSQL/19/setup_100_user_setting.sql
new file mode 100644
index 00000000..bf6d85d2
--- /dev/null
+++ b/src/core/SQL/PostgreSQL/19/setup_100_user_setting.sql
@@ -0,0 +1,6 @@
+CREATE TABLE user_setting (
+    userid integer NOT NULL REFERENCES quasseluser (userid) ON DELETE CASCADE,
+    settingname TEXT NOT NULL,
+    settingvalue bytea,
+    PRIMARY KEY (userid, settingname)
+)