not used yet

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

diff --git a/setup/connections.sql b/setup/connections.sql
new file mode 100644 (file)
index 0000000..d513d28
--- /dev/null
+++ b/setup/connections.sql
@@ -0,0 +1,12 @@
+CREATE TABLE connections (
+ server VARCHAR(30) NOT NULL,
+ port INT NOT NULL DEFAULT '6667',
+ nick VARCHAR(20) NOT NULL,
+ nickservpass VARCHAR(8) NOT NULL,
+ ircname VARCHAR (20) NOT NULL DEFAULT 'blootbot experimental bot',
+ timeadded INT UNSIGNED DEFAULT 'UNIX_TIMESTAMP()',
+ PRIMARY KEY (server,port,nick)
+);
+INSERT INTO connections (server, port, nick, nickservpass, ircname) VALUES ('localhost','6667','abot','0password', 'abot blootbot');
+INSERT INTO connections (server, port, nick, nickservpass, ircname) VALUES ('localhost','6667','bbot','0password', 'bbot blootbot');
+INSERT INTO connections (server, port, nick, nickservpass, ircname) VALUES ('localhost','6667','cbot','0password', 'cbot blootbot');