From e8ed50b39e814427a4e680aa37aa94801437f4d7 Mon Sep 17 00:00:00 2001 From: timriker Date: Mon, 5 Apr 2004 02:31:44 +0000 Subject: [PATCH] ws git-svn-id: https://svn.code.sf.net/p/infobot/code/trunk/blootbot@935 c11ca15a-4712-0410-83d8-924469b57eb5 --- setup/botmail.sql | 13 ++++++------- setup/factoids.sql | 29 ++++++++++++----------------- setup/freshmeat.sql | 13 ++++++------- setup/news.sql | 11 +++++------ setup/rootwarn.sql | 13 ++++++------- setup/seen.sql | 13 ++++++------- setup/stats.sql | 14 ++++++-------- setup/uptime.sql | 10 ++++------ 8 files changed, 51 insertions(+), 65 deletions(-) diff --git a/setup/botmail.sql b/setup/botmail.sql index 1efdd9b..2789338 100644 --- 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 9711a94..d5189d0 100644 --- 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 385b7a7..4b4f42b 100644 --- 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 26351df..ebfb0e2 100644 --- 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 bab4ec2..afcee2c 100644 --- 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 9221c2b..d920f79 100644 --- 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 4a585b1..97f773c 100644 --- 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 abfb35a..373902a 100644 --- 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) ); -- 2.39.5