From 0ad3a54150b43a00de6d7b8208f38943def20204 Mon Sep 17 00:00:00 2001
From: daita <maxence@pontapreta.net>
Date: Sat, 3 Dec 2016 01:23:41 -0100
Subject: #75 - implement database queue

---
 appinfo/database-disabled.xml | 40 ----------------------------------------
 appinfo/database.xml          | 29 +++++++++++++++++++++++++++++
 2 files changed, 29 insertions(+), 40 deletions(-)
 delete mode 100644 appinfo/database-disabled.xml
 create mode 100644 appinfo/database.xml

(limited to 'appinfo')

diff --git a/appinfo/database-disabled.xml b/appinfo/database-disabled.xml
deleted file mode 100644
index 36f8c07..0000000
--- a/appinfo/database-disabled.xml
+++ /dev/null
@@ -1,40 +0,0 @@
-<?xml version="1.0" encoding="ISO-8859-1" ?>
-<database>
-	<name>*dbname*</name>
-	<create>true</create>
-	<overwrite>false</overwrite>
-	<charset>utf8</charset>
-
-	<table>
-		<name>*dbprefix*nextant_index</name>
-		<declaration>
-			<field>
-				<name>fileid</name>
-				<type>integer</type>
-				<default>0</default>
-				<notnull>true</notnull>
-				<length>4</length>
-			</field>
-			<field>
-				<name>clef</name>
-				<type>text</type>
-				<notnull>true</notnull>
-				<length>64</length>
-			</field>
-			<field>
-				<name>creation</name>
-				<type>timestamp</type>
-				<default></default>
-				<notnull>false</notnull>
-			</field>
-			<index>
-				<name>nextant_clef</name>
-				<unique>true</unique>
-				<field>
-					<name>fileid</name>
-					<name>clef</name>
-				</field>
-			</index>
-		</declaration>
-	</table>
-</database>
\ No newline at end of file
diff --git a/appinfo/database.xml b/appinfo/database.xml
new file mode 100644
index 0000000..0adbc94
--- /dev/null
+++ b/appinfo/database.xml
@@ -0,0 +1,29 @@
+<?xml version="1.0" encoding="ISO-8859-1" ?>
+<database>
+	<name>*dbname*</name>
+	<create>true</create>
+	<overwrite>false</overwrite>
+	<charset>utf8</charset>
+
+	<table>
+		<name>*dbprefix*nextant_live_queue</name>
+		<declaration>
+			<field>
+				<name>id</name>
+				<type>integer</type>
+				<notnull>true</notnull>
+				<autoincrement>true</autoincrement>
+				<unsigned>true</unsigned>
+				<primary>true</primary>
+				<length>8</length>
+			</field>
+			<field>
+				<name>item</name>
+				<type>text</type>
+				<notnull>true</notnull>
+				<length>512</length>
+			</field>
+		</declaration>
+	</table>
+
+</database>
\ No newline at end of file
-- 
cgit v1.2.3