ws

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

diff --git a/setup/botmail.sql b/setup/botmail.sql
index 1efdd9ba973b537df3bb5b64554a0ddc682d1d23..2789338defddc531df50ea1701b74ce0e1dd3d5c 100644 (file)
--- a/setup/botmail.sql
+++ b/setup/botmail.sql
@@ -1,9 +1,8 @@
 CREATE TABLE botmail (
-       srcwho VARCHAR(20) NOT NULL,
-       dstwho VARCHAR(20) NOT NULL,
-       srcuh VARCHAR(80) NOT NULL,
-       time INT UNSIGNED DEFAULT 'UNIX_TIMESTAMP()',
-       msg TEXT NOT NULL,
-
-       PRIMARY KEY (srcwho,dstwho)
+ srcwho VARCHAR(20) NOT NULL,
+ dstwho VARCHAR(20) NOT NULL,
+ srcuh VARCHAR(80) NOT NULL,
+ time INT UNSIGNED DEFAULT 'UNIX_TIMESTAMP()',
+ msg TEXT NOT NULL,
+ PRIMARY KEY (srcwho,dstwho)
 );

diff --git a/setup/factoids.sql b/setup/factoids.sql
index 9711a945e19754c3632a40c603f738d5a158f149..d5189d0d7a72c5e1342e94d8e1f311d0f1b27ce5 100644 (file)
--- a/setup/factoids.sql
+++ b/setup/factoids.sql
@@ -1,19 +1,14 @@
 CREATE TABLE factoids (
-       factoid_key VARCHAR(64) NOT NULL,
-
-       requested_by VARCHAR(64) NOT NULL DEFAULT 'nobody',
-       requested_time INT NOT NULL DEFAULT '0',
-       requested_count SMALLINT UNSIGNED NOT NULL DEFAULT '0',
-       created_by VARCHAR(64),
-       created_time INT NOT NULL DEFAULT '0',
-
-       modified_by VARCHAR(192),
-       modified_time INT NOT NULL DEFAULT '0',
-
-       locked_by VARCHAR(64),
-       locked_time INT NOT NULL DEFAULT '0',
-
-       factoid_value TEXT NOT NULL,
-
-       PRIMARY KEY (factoid_key)
+ factoid_key VARCHAR(64) NOT NULL,
+ requested_by VARCHAR(64) NOT NULL DEFAULT 'nobody',
+ requested_time INT NOT NULL DEFAULT '0',
+ requested_count SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+ created_by VARCHAR(64),
+ created_time INT NOT NULL DEFAULT '0',
+ modified_by VARCHAR(192),
+ modified_time INT NOT NULL DEFAULT '0',
+ locked_by VARCHAR(64),
+ locked_time INT NOT NULL DEFAULT '0',
+ factoid_value TEXT NOT NULL,
+ PRIMARY KEY (factoid_key)
 );

diff --git a/setup/freshmeat.sql b/setup/freshmeat.sql
index 385b7a743bb9083a8cc323ff68e46ab76b1c4413..4b4f42bed577df317f0156ae4c88f570c0a6885d 100644 (file)
--- a/setup/freshmeat.sql
+++ b/setup/freshmeat.sql
@@ -1,9 +1,8 @@
 CREATE TABLE freshmeat (
-       projectname_short VARCHAR(64) NOT NULL,
-       latest_version VARCHAR(32) DEFAULT 'none' NOT NULL,
-       license VARCHAR(32),
-       url_homepage VARCHAR(128),
-       desc_short VARCHAR(96) NOT NULL,
-
-       PRIMARY KEY (projectname_short,latest_version)
+ projectname_short VARCHAR(64) NOT NULL,
+ latest_version VARCHAR(32) DEFAULT 'none' NOT NULL,
+ license VARCHAR(32),
+ url_homepage VARCHAR(128),
+ desc_short VARCHAR(96) NOT NULL,
+ PRIMARY KEY (projectname_short,latest_version)
 );

diff --git a/setup/news.sql b/setup/news.sql
index 26351df3afb99fee90ad60f5088f3d43f536a25c..ebfb0e2f06dff67f549c5c9d2763bd32c83a14d9 100644 (file)
--- a/setup/news.sql
+++ b/setup/news.sql
@@ -1,8 +1,7 @@
 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)
+ 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/setup/rootwarn.sql b/setup/rootwarn.sql
index bab4ec2f519630485ff0ff470dd0893c34ebd0a2..afcee2c59afe343dc37f19a17fc57892724504f2 100644 (file)
--- a/setup/rootwarn.sql
+++ b/setup/rootwarn.sql
@@ -1,9 +1,8 @@
 CREATE TABLE rootwarn (
-       nick VARCHAR(20) NOT NULL,
-       attempt SMALLINT UNSIGNED,
-       time INT NOT NULL,
-       host VARCHAR(80) NOT NULL,
-       channel VARCHAR(20) NOT NULL,
-
-       PRIMARY KEY (nick)
+ nick VARCHAR(20) NOT NULL,
+ attempt SMALLINT UNSIGNED,
+ time INT NOT NULL,
+ host VARCHAR(80) NOT NULL,
+ channel VARCHAR(20) NOT NULL,
+ PRIMARY KEY (nick)
 );

diff --git a/setup/seen.sql b/setup/seen.sql
index 9221c2b3515397a9203a4dd68a398d12c55b1d58..d920f79bc5230843719147a5e59ab7b381c567e9 100644 (file)
--- a/setup/seen.sql
+++ b/setup/seen.sql
@@ -1,9 +1,8 @@
 CREATE TABLE seen (
-       nick VARCHAR(20) NOT NULL,
-       time INT NOT NULL,
-       channel VARCHAR(20) NOT NULL,
-       host VARCHAR(80) NOT NULL,
-       message TINYTEXT NOT NULL,
-
-       PRIMARY KEY (nick,channel)
+ nick VARCHAR(20) NOT NULL,
+ time INT NOT NULL,
+ channel VARCHAR(20) NOT NULL,
+ host VARCHAR(80) NOT NULL,
+ message TINYTEXT NOT NULL,
+ PRIMARY KEY (nick,channel)
 );

diff --git a/setup/stats.sql b/setup/stats.sql
index 4a585b1501200a67479efb6e1581e7097ef2c798..97f773c96682d52cd24440c18c5f83cf2dda82b7 100644 (file)
--- a/setup/stats.sql
+++ b/setup/stats.sql
@@ -1,10 +1,8 @@
 CREATE TABLE stats (
-       nick VARCHAR(20) NOT NULL,
-       type VARCHAR(8) NOT NULL,
-       channel VARCHAR(16) NOT NULL DEFAULT "PRIVATE",
-
-       time INT UNSIGNED DEFAULT 'UNIX_TIMESTAMP()',
-       counter SMALLINT UNSIGNED DEFAULT '0',
-
-       PRIMARY KEY (nick,type,channel)
+ nick VARCHAR(20) NOT NULL,
+ type VARCHAR(8) NOT NULL,
+ channel VARCHAR(16) NOT NULL DEFAULT "PRIVATE",
+ time INT UNSIGNED DEFAULT 'UNIX_TIMESTAMP()',
+ counter SMALLINT UNSIGNED DEFAULT '0',
+ PRIMARY KEY (nick,type,channel)
 );

diff --git a/setup/uptime.sql b/setup/uptime.sql
index abfb35a38aee15213addcce5831a78e5e0e4d483..373902ad7d2aec7b4b5d866edf9a670103c58684 100644 (file)
--- a/setup/uptime.sql
+++ b/setup/uptime.sql
@@ -1,8 +1,6 @@
 CREATE TABLE uptime (
-       uptime  INT UNSIGNED DEFAULT '0',       # start.
-       endtime INT UNSIGNED DEFAULT '0',       # end.
-
-       string  VARCHAR(128) NOT NULL,
-
-       PRIMARY KEY (uptime)
+ uptime INT UNSIGNED DEFAULT '0', # start.
+ endtime INT UNSIGNED DEFAULT '0', # end.
+ string VARCHAR(128) NOT NULL,
+ PRIMARY KEY (uptime)
 );