From aa79d4dedbc95b5ea3dd3e27fd44b57a8448f7f2 Mon Sep 17 00:00:00 2001
From: dms <dms@c11ca15a-4712-0410-83d8-924469b57eb5>
Date: Fri, 22 Nov 2002 13:11:32 +0000
Subject: [PATCH] - new tables. not used as yet.

git-svn-id: https://svn.code.sf.net/p/infobot/code/trunk@692 c11ca15a-4712-0410-83d8-924469b57eb5
---
 blootbot/setup/news.sql   | 8 ++++++++
 blootbot/setup/uptime.sql | 8 ++++++++
 2 files changed, 16 insertions(+)
 create mode 100644 blootbot/setup/news.sql
 create mode 100644 blootbot/setup/uptime.sql

diff --git a/blootbot/setup/news.sql b/blootbot/setup/news.sql
new file mode 100644
index 0000000..26351df
--- /dev/null
+++ b/blootbot/setup/news.sql
@@ -0,0 +1,8 @@
+CREATE TABLE news (
+	channel VARCHAR(16) NOT NULL,
+	id	INT UNSIGNED DEFAULT '0',
+	key	VARCHAR(16) NOT NULL,
+	value	TEXT NOT NULL,	# limit to ~450 or so.
+
+	PRIMARY KEY (channel,id,key)
+);
diff --git a/blootbot/setup/uptime.sql b/blootbot/setup/uptime.sql
new file mode 100644
index 0000000..abfb35a
--- /dev/null
+++ b/blootbot/setup/uptime.sql
@@ -0,0 +1,8 @@
+CREATE TABLE uptime (
+	uptime	INT UNSIGNED DEFAULT '0',	# start.
+	endtime	INT UNSIGNED DEFAULT '0',	# end.
+
+	string	VARCHAR(128) NOT NULL,
+
+	PRIMARY KEY (uptime)
+);
-- 
2.39.5