From 421c960df501b40e836a783400ab00dc60c3fdae Mon Sep 17 00:00:00 2001
From: Florent Le Coz <louiz@louiz.org>
Date: Thu, 24 Dec 2015 21:39:53 +0100
Subject: Add a ChannelOptions table in the DB

And a way to retrieve its values, defaulting on the ServerOptions for unset
values.
---
 database/database.xml | 18 ++++++++++++++++++
 1 file changed, 18 insertions(+)

(limited to 'database')

diff --git a/database/database.xml b/database/database.xml
index 1750b61..0688984 100644
--- a/database/database.xml
+++ b/database/database.xml
@@ -14,9 +14,27 @@
         <field name="realname" type="string" length="1024" default=""/>
         <field name="verifyCert" type="boolean" default="true"/>
 
+        <field name="encodingOut" type="string" default="utf-8"/>
+        <field name="encodingIn"  type="string" default="utf-8"/>
+
+        <index unique="true">
+            <indexfield name="owner"/>
+            <indexfield name="server"/>
+        </index>
+    </object>
+
+    <object name="IrcChannelOptions">
+        <field name="owner" type="string" length="3071"/>
+        <field name="server" type="string" length="3071"/>
+        <field name="channel" type="string" length="1024"/>
+
+        <field name="encodingOut" type="string"/>
+        <field name="encodingIn"  type="string"/>
+
         <index unique="true">
             <indexfield name="owner"/>
             <indexfield name="server"/>
+            <indexfield name="channel"/>
         </index>
     </object>
 
-- 
cgit v1.2.3