X-Git-Url: http://git.pk910.de/?p=NeonServV5.git;a=blobdiff_plain;f=database.sql;h=d3781181034f7a3bc4f115b9ec8fc7626309ab4a;hp=45cb784168f73ee4bb9beac0e927da41b13b5d9b;hb=HEAD;hpb=3e82313bfb3eaf4f2b59dfc165372e3174be838b diff --git a/database.sql b/database.sql index 45cb784..d378118 100644 --- a/database.sql +++ b/database.sql @@ -33,9 +33,12 @@ CREATE TABLE IF NOT EXISTS `bots` ( `ident` varchar(12) NOT NULL, `realname` varchar(255) NOT NULL, `automodes` varchar(20) NOT NULL, + `oper_user` varchar(50) DEFAULT NULL, + `oper_pass` varchar(50) DEFAULT NULL, `botclass` int(10) NOT NULL, `textbot` tinyint(1) NOT NULL, `queue` tinyint(1) NOT NULL, + `secret` tinyint(1) NOT NULL, `defaulttrigger` varchar(10) NOT NULL, `max_channels` int(5) NOT NULL, `register_priority` int(2) NOT NULL, @@ -320,6 +323,7 @@ CREATE TABLE IF NOT EXISTS `users` ( `user_god` tinyint(1) NOT NULL, `user_lang` varchar(6) NOT NULL, `user_reply_privmsg` tinyint(1) NOT NULL, + `user_block_invites` tinyint(1) NOT NULL, `user_registered` INT(20) NOT NULL, `user_lastcheck` INT(20) NOT NULL, PRIMARY KEY (`user_id`),