From 8ec823be4fc587abb7282a06a12f9df9c37810d2 Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?louiz=E2=80=99?= <louiz@louiz.org>
Date: Fri, 12 Aug 2016 16:39:19 +0200
Subject: Save received and sent messages into the database

---
 database/database.xml | 15 ++++++++++++---
 1 file changed, 12 insertions(+), 3 deletions(-)

(limited to 'database')

diff --git a/database/database.xml b/database/database.xml
index f102db0..fc67caf 100644
--- a/database/database.xml
+++ b/database/database.xml
@@ -39,8 +39,17 @@
         </index>
     </object>
 
-    <object name="LogLine">
-        <field name="date" type="date" />
-        <field name="body" type="string" length="4096"/>
+    <object name="MucLogLine">
+        <field name="uuid" type="string" length="36" />
+        <!-- The bare JID of the user for which we stored the line. It's
+        the JID associated with the Bridge -->
+        <field name="owner" type="string" length="4096" />
+        <!-- The room IID -->
+        <field name="ircChanName" type="string" length="4096" />
+        <field name="ircServerName" type="string" length="4096" />
+
+        <field name="date" type="datetime" />
+        <field name="body" type="string" length="65536"/>
+        <field name="nick" type="string" length="4096" />
     </object>
 </database>
-- 
cgit v1.2.3


From 6776b827d243ec0e018eac8233c5df402030640e Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?louiz=E2=80=99?= <louiz@louiz.org>
Date: Mon, 22 Aug 2016 00:38:44 +0200
Subject: Add a global configure ad-hoc command, with max history length

---
 database/database.xml | 10 ++++++++++
 1 file changed, 10 insertions(+)

(limited to 'database')

diff --git a/database/database.xml b/database/database.xml
index fc67caf..277d03f 100644
--- a/database/database.xml
+++ b/database/database.xml
@@ -2,6 +2,12 @@
 <!DOCTYPE database SYSTEM "litesql.dtd">
 
 <database name="BibouDB" namespace="db">
+    <object name="GlobalOptions">
+        <field name="owner" type="string" length="3071"/>
+
+        <field name="maxHistoryLength" type="integer"/>
+    </object>
+
     <object name="IrcServerOptions">
         <field name="owner" type="string" length="3071"/>
         <field name="server" type="string" length="3071"/>
@@ -18,6 +24,8 @@
         <field name="encodingOut" type="string" default="ISO-8859-1"/>
         <field name="encodingIn"  type="string" default="ISO-8859-1"/>
 
+        <field name="maxHistoryLength" type="integer"/>
+
         <index unique="true">
             <indexfield name="owner"/>
             <indexfield name="server"/>
@@ -32,6 +40,8 @@
         <field name="encodingOut" type="string"/>
         <field name="encodingIn"  type="string"/>
 
+        <field name="maxHistoryLength" type="integer"/>
+
         <index unique="true">
             <indexfield name="owner"/>
             <indexfield name="server"/>
-- 
cgit v1.2.3


From 19240d79688d58f23e67732521b80c6a94fbd4e6 Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?louiz=E2=80=99?= <louiz@louiz.org>
Date: Mon, 22 Aug 2016 00:44:52 +0200
Subject: Default max_history_length is 20, not 0

---
 database/database.xml | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

(limited to 'database')

diff --git a/database/database.xml b/database/database.xml
index 277d03f..7a9d656 100644
--- a/database/database.xml
+++ b/database/database.xml
@@ -5,7 +5,7 @@
     <object name="GlobalOptions">
         <field name="owner" type="string" length="3071"/>
 
-        <field name="maxHistoryLength" type="integer"/>
+        <field name="maxHistoryLength" type="integer" default="20"/>
     </object>
 
     <object name="IrcServerOptions">
@@ -24,7 +24,7 @@
         <field name="encodingOut" type="string" default="ISO-8859-1"/>
         <field name="encodingIn"  type="string" default="ISO-8859-1"/>
 
-        <field name="maxHistoryLength" type="integer"/>
+        <field name="maxHistoryLength" type="integer" default="20"/>
 
         <index unique="true">
             <indexfield name="owner"/>
@@ -40,7 +40,7 @@
         <field name="encodingOut" type="string"/>
         <field name="encodingIn"  type="string"/>
 
-        <field name="maxHistoryLength" type="integer"/>
+        <field name="maxHistoryLength" type="integer" default="20"/>
 
         <index unique="true">
             <indexfield name="owner"/>
-- 
cgit v1.2.3


From cfebca4d7c46959fc490cb9c72363d4ac3ee0c7a Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?louiz=E2=80=99?= <louiz@louiz.org>
Date: Tue, 23 Aug 2016 00:11:51 +0200
Subject: Only save the logs if recordHistory global config option is true

---
 database/database.xml | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'database')

diff --git a/database/database.xml b/database/database.xml
index 7a9d656..490bc5a 100644
--- a/database/database.xml
+++ b/database/database.xml
@@ -6,6 +6,7 @@
         <field name="owner" type="string" length="3071"/>
 
         <field name="maxHistoryLength" type="integer" default="20"/>
+        <field name="recordHistory" type="boolean" default="true"/>
     </object>
 
     <object name="IrcServerOptions">
@@ -25,7 +26,6 @@
         <field name="encodingIn"  type="string" default="ISO-8859-1"/>
 
         <field name="maxHistoryLength" type="integer" default="20"/>
-
         <index unique="true">
             <indexfield name="owner"/>
             <indexfield name="server"/>
-- 
cgit v1.2.3


From 91285d144d9ff8692a812840985cf2501e6b71c5 Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?louiz=E2=80=99?= <louiz@louiz.org>
Date: Mon, 22 Aug 2016 15:12:03 +0200
Subject: Index the owner for the global conf table

---
 database/database.xml | 3 +++
 1 file changed, 3 insertions(+)

(limited to 'database')

diff --git a/database/database.xml b/database/database.xml
index 490bc5a..af15ad5 100644
--- a/database/database.xml
+++ b/database/database.xml
@@ -7,6 +7,9 @@
 
         <field name="maxHistoryLength" type="integer" default="20"/>
         <field name="recordHistory" type="boolean" default="true"/>
+        <index unique="true">
+            <indexfield name="owner"/>
+        </index>
     </object>
 
     <object name="IrcServerOptions">
-- 
cgit v1.2.3