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 d1256c17c258a0c2007026f7c920a7bf84f6868a..fa705177bff11605d928aaa675cf25f6d3a21a98 100644 (file)
--- 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 274e656499ffe4d02915e5c9a46526c5f34c784b..199e468108266fe94e17aa1707a52405b1ba904e 100644 (file)
--- 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 373902ad7d2aec7b4b5d866edf9a670103c58684..7721072572edc98a301d1b39ad504027ec6f1143 100644 (file)
--- 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 :)