From: timriker <timriker@c11ca15a-4712-0410-83d8-924469b57eb5>
Date: Sat, 15 Mar 2008 22:46:25 +0000 (+0000)
Subject: sql comments
X-Git-Url: https://git.donarmstrong.com/?p=infobot.git;a=commitdiff_plain;h=bf0983b9203af3fdbcc436c6d299464758146e9a

sql comments

git-svn-id: https://svn.code.sf.net/p/infobot/code/trunk@1640 c11ca15a-4712-0410-83d8-924469b57eb5
---

diff --git a/setup/sqlite2/connections.sql b/setup/sqlite2/connections.sql
index d1256c1..fa70517 100644
--- a/setup/sqlite2/connections.sql
+++ b/setup/sqlite2/connections.sql
@@ -3,7 +3,7 @@ CREATE TABLE connections (
  port INT NOT NULL DEFAULT '6667',
  nick VARCHAR(20) NOT NULL,
  nickservpass VARCHAR(8) NOT NULL,
- ircname VARCHAR (20) NOT NULL DEFAULT 'infobot experimental bot',
+ ircname VARCHAR (20) NOT NULL DEFAULT 'infobot - perl irc bot',
  timeadded INT UNSIGNED DEFAULT 'UNIX_TIMESTAMP()',
  PRIMARY KEY (server,port,nick)
 );
diff --git a/setup/sqlite2/news.sql b/setup/sqlite2/news.sql
index 274e656..199e468 100644
--- a/setup/sqlite2/news.sql
+++ b/setup/sqlite2/news.sql
@@ -2,6 +2,7 @@ CREATE TABLE news (
  channel VARCHAR(30) NOT NULL,
  id INT UNSIGNED DEFAULT '0',
  key VARCHAR(16) NOT NULL,
- value TEXT NOT NULL, # limit to ~450 or so.
+ value TEXT NOT NULL,
  PRIMARY KEY (channel,id,key)
 );
+-- limit value to ~450 or so.
diff --git a/setup/sqlite2/uptime.sql b/setup/sqlite2/uptime.sql
index 373902a..7721072 100644
--- a/setup/sqlite2/uptime.sql
+++ b/setup/sqlite2/uptime.sql
@@ -1,6 +1,9 @@
 CREATE TABLE uptime (
- uptime INT UNSIGNED DEFAULT '0', # start.
- endtime INT UNSIGNED DEFAULT '0', # end.
+ uptime INT UNSIGNED DEFAULT '0',
+ endtime INT UNSIGNED DEFAULT '0',
  string VARCHAR(128) NOT NULL,
  PRIMARY KEY (uptime)
 );
+
+-- uptime is start time
+-- endtime is endtime :)