add: mysql support

2 files changed, 60 insertions, 53 deletions

diff --git a/scripts/mysql.schema b/scripts/mysql.schema
index 3ca7492..a7deb93 100644
--- a/scripts/mysql.schema
+++ b/scripts/mysql.schema
@@ -19,6 +19,13 @@
 -- --------------------------------------------------------------------------- --
 
 -- --------------------------------------------------------------------------- --
+-- Create base
+--
+CREATE DATABASE isidabot DEFAULT CHARACTER SET 'utf8';
+USE isidabot;
+
+
+-- --------------------------------------------------------------------------- --
 -- Base of ages
 --
 CREATE TABLE age (
@@ -33,9 +40,9 @@ CREATE TABLE age (
 	no_case_nick text
 );
 
-CREATE INDEX age_rj ON age (room(255),jid(255));
+CREATE INDEX age_rj ON age (room(64),jid(64));
 
-CREATE INDEX age_rnj ON age (room(255),nick(255),jid(255));
+CREATE INDEX age_rnj ON age (room(64),nick(255),jid(64));
 
 CREATE TABLE jid (
 	login text,
@@ -58,8 +65,8 @@ CREATE TABLE talkers (
 	frases integer
 );
 
-CREATE INDEX talkers_rj ON talkers (room(255),jid(255));
-CREATE INDEX talkers_rjn ON talkers (room(255),jid(255),nick(255));
+CREATE INDEX talkers_rj ON talkers (room(64),jid(64));
+CREATE INDEX talkers_rjn ON talkers (room(64),jid(64),nick(255));
 
 -- --------------------------------------------------------------------------- --
 -- Base for `WTF` commands
@@ -75,9 +82,9 @@ CREATE TABLE wtf (
 	lim integer
 );
 
-CREATE INDEX wtf_r ON wtf (room(255));
-CREATE INDEX wtf_rj ON wtf (room(255),jid(255));
-CREATE INDEX wtf_rw ON wtf (room(255),wtfword(255));
+CREATE INDEX wtf_r ON wtf (room(64));
+CREATE INDEX wtf_rj ON wtf (room(64),jid(64));
+CREATE INDEX wtf_rw ON wtf (room(64),wtfword(255));
 
 -- --------------------------------------------------------------------------- --
 -- Answers base for random flood
@@ -89,7 +96,7 @@ CREATE TABLE answer (
 
 -- INSERT INTO answer VALUES(1,';-)');
 -- INSERT INTO answer VALUES(2,'Hi!');
-CREATE INDEX answer_id ON answer (ind(255));
+CREATE INDEX answer_id ON answer (ind);
 
 -- --------------------------------------------------------------------------- --
 -- Base for `SayTo` plugin
@@ -101,7 +108,7 @@ CREATE TABLE sayto (
 	message text
 );
 
-CREATE INDEX sayto_rj ON sayto (room(255),jid(255));
+CREATE INDEX sayto_rj ON sayto (room(64),jid(64));
 
 -- --------------------------------------------------------------------------- --
 -- User distances for `Dist` plugin
@@ -131,8 +138,8 @@ CREATE TABLE karma (
 	karma int
 );
 
-CREATE INDEX karma_krj ON karma (room(255),jid(255));
-CREATE INDEX karma_crjk ON karma (room(255),jid(255),karma(255));
+CREATE INDEX karma_krj ON karma (room(64),jid(64));
+CREATE INDEX karma_crjk ON karma (room(64),jid(64),karma);
 
 CREATE TABLE karma_commiters (
 	room text,
@@ -141,7 +148,7 @@ CREATE TABLE karma_commiters (
 	last int
 );
 
-CREATE INDEX karma_commiters_rjk ON karma_commiters (room(255),jid(255),karmajid(255));
+CREATE INDEX karma_commiters_rjk ON karma_commiters (room(64),jid(64),karmajid(64));
 
 CREATE TABLE karma_limits (
 	room text,
@@ -149,7 +156,7 @@ CREATE TABLE karma_limits (
 	log text
 );
 
-CREATE INDEX karma_limits_lrj ON karma_limits (room(255),jid(255));
+CREATE INDEX karma_limits_lrj ON karma_limits (room(64),jid(64));
 
 -- --------------------------------------------------------------------------- --
 -- Action list base
@@ -164,7 +171,7 @@ CREATE TABLE acl (
 	level int default 9
 );
 
-CREATE INDEX acl_jid ON acl (jid(255),action(255),type(255));
+CREATE INDEX acl_jid ON acl (jid(64),action(255),type(255));
 
 -- --------------------------------------------------------------------------- --
 -- Base for `GisMeteo` plugin
@@ -205,7 +212,7 @@ CREATE TABLE def_ru_mobile (
 	date text
 );
 
-CREATE INDEX def_ru_mobile_ph ON def_ru_mobile (def(255),defbegin(255),defend(255));
+CREATE INDEX def_ru_mobile_ph ON def_ru_mobile (def,defbegin,defend);
 
 -- --------------------------------------------------------------------------- --
 -- WZ Weather base
@@ -226,7 +233,7 @@ CREATE TABLE muc_lock (
 	jid text
 );
 
-CREATE INDEX muc_lock_rj ON muc_lock (room(255),jid(255));
+CREATE INDEX muc_lock_rj ON muc_lock (room(64),jid(64));
 
 -- --------------------------------------------------------------------------- --
 -- Versions base
@@ -240,9 +247,9 @@ CREATE TABLE versions (
 	time integer
 );
 
-CREATE INDEX versions_rj ON versions (room(255),jid(255));
+CREATE INDEX versions_rj ON versions (room(64),jid(64));
 CREATE INDEX versions_cvo ON versions (client(255),version(255),os(255));
-CREATE INDEX versions_rjcvo ON versions (room(255),jid(255),client(255),version(255),os(255));
+CREATE INDEX versions_rjcvo ON versions (room(64),jid(64),client(255),version(255),os(255));
 
 -- --------------------------------------------------------------------------- --
 -- Issues base
@@ -262,8 +269,8 @@ CREATE TABLE issues (
 	accept_date integer
 );
 
-CREATE INDEX issues_r ON issues (room(255),id(255));
-CREATE INDEX issues_d ON issues (room(255),date(255));
+CREATE INDEX issues_r ON issues (room(64),id);
+CREATE INDEX issues_d ON issues (room(64),date);
 
 -- --------------------------------------------------------------------------- --
 -- Cron base
@@ -273,60 +280,60 @@ CREATE TABLE cron (
 	jid text,
 	nick text,
 	time integer,
-	repeat text,
+	`repeat` text,
 	command text,
 	level integer
 );
 
-CREATE INDEX cron_r ON cron (room(255));
-CREATE INDEX cron_rt ON cron (room(255),time(255));
-CREATE INDEX cron_rtr ON cron (room(255),time(255),repeat(255));
+CREATE INDEX cron_r ON cron (room(64));
+CREATE INDEX cron_rt ON cron (room(64),time);
+CREATE INDEX cron_rtr ON cron (room(64),time,`repeat`(255));
 
 -- --------------------------------------------------------------------------- --
 -- Conference config
 --
 CREATE TABLE config_conf (
 	room text,
-	option text,
+	`option` text,
 	value text
 );
 
-CREATE INDEX config_conf_r ON config_conf (room(255));
-CREATE INDEX config_conf_ro ON config_conf (room(255),option(255));
+CREATE INDEX config_conf_r ON config_conf (room(64));
+CREATE INDEX config_conf_ro ON config_conf (room(64),`option`(255));
 
 -- --------------------------------------------------------------------------- --
 -- Owner config
 --
 CREATE TABLE config_owner (
-	option varchar(255) unique,
+	`option` varchar(255) unique,
 	value text
 );
 
-CREATE INDEX config_owner_o ON config_owner (option(255));
+CREATE INDEX config_owner_o ON config_owner (`option`(255));
 
 -- --------------------------------------------------------------------------- --
 -- Top command
 --
 CREATE TABLE top (
 	room varchar(255) unique,
-	count integer,
+	`count` integer,
 	time integer
 );
 
-CREATE INDEX top_r ON top (room(255));
-CREATE INDEX top_rc ON top (room(255),count(255));
+CREATE INDEX top_r ON top (room(64));
+CREATE INDEX top_rc ON top (room(64),count);
 
 -- --------------------------------------------------------------------------- --
 -- Aliases
 --
 CREATE TABLE alias (
 	room text,
-	match text,
+	`match` text,
 	cmd text
 );
 
-CREATE INDEX alias_r ON alias (room(255));
-CREATE INDEX alias_rm ON alias (room(255),match(255));
+CREATE INDEX alias_r ON alias (room(64));
+CREATE INDEX alias_rm ON alias (room(64),`match`(255));
 
 -- --------------------------------------------------------------------------- --
 -- Blacklist for rooms
@@ -343,8 +350,8 @@ CREATE TABLE commonoff (
 	cmd text
 );
 
-CREATE INDEX commonoff_r ON commonoff (room(255));
-CREATE INDEX commonoff_rm ON commonoff (room(255),cmd(255));
+CREATE INDEX commonoff_r ON commonoff (room(64));
+CREATE INDEX commonoff_rm ON commonoff (room(64),cmd(255));
 
 -- --------------------------------------------------------------------------- --
 -- Rooms list
@@ -359,15 +366,15 @@ CREATE TABLE conference (
 --
 CREATE TABLE feed (
 	url text,
-	update varchar(255),
+	`update` varchar(255),
 	type text,
 	time integer,
 	room text,
-	hash text array[10]
+	hash text
 );
 
-CREATE INDEX feed_r ON feed (room(255));
-CREATE INDEX feed_rt ON feed (room(255),time(255));
+CREATE INDEX feed_r ON feed (room(64));
+CREATE INDEX feed_rt ON feed (room(64),time);
 
 -- --------------------------------------------------------------------------- --
 -- Hiden rooms
@@ -392,7 +399,7 @@ CREATE TABLE bot_owner (
 	jid varchar(255) unique
 );
 
-CREATE INDEX bot_owner_j ON bot_owner (jid(255));
+CREATE INDEX bot_owner_j ON bot_owner (jid(64));
 
 -- --------------------------------------------------------------------------- --
 -- Logs in rooms
@@ -401,7 +408,7 @@ CREATE TABLE log_rooms (
 	room varchar(255) unique
 );
 
-CREATE INDEX log_rooms_r ON log_rooms (room(255));
+CREATE INDEX log_rooms_r ON log_rooms (room(64));
 
 -- --------------------------------------------------------------------------- --
 -- Spy for activity
@@ -414,8 +421,8 @@ CREATE TABLE spy (
 	pattern text
 );
 
-CREATE INDEX spy_r ON spy (room(255));
-CREATE INDEX spy_rt ON spy (room(255),time(255));
+CREATE INDEX spy_r ON spy (room(64));
+CREATE INDEX spy_rt ON spy (room(64),time);
 
 -- --------------------------------------------------------------------------- --
 -- Temporary ban
@@ -426,8 +433,8 @@ CREATE TABLE tmp_ban (
 	time integer
 );
 
-CREATE INDEX tmp_ban_r ON tmp_ban (room(255));
-CREATE INDEX tmp_ban_rt ON tmp_ban (room(255),time(255));
+CREATE INDEX tmp_ban_r ON tmp_ban (room(64));
+CREATE INDEX tmp_ban_rt ON tmp_ban (room(64),time);
 
 -- --------------------------------------------------------------------------- --
 -- Say to owner
@@ -453,7 +460,7 @@ CREATE TABLE first_join (
 	time integer
 );
 
-CREATE INDEX join_rj ON first_join (room(255),jid(255));
+CREATE INDEX join_rj ON first_join (room(64),jid(64));
 
 -- --------------------------------------------------------------------------- --
 -- URL Storage
@@ -466,10 +473,10 @@ CREATE TABLE url (
 	url text,
 	title text);
 
-CREATE INDEX url_r ON url (room(255));
-CREATE INDEX url_rj ON url (room(255),jid(255));
-CREATE INDEX url_rjn ON url (room(255),jid(255),nick(255));
-CREATE INDEX url_rt ON url (room(255),time(255));
+CREATE INDEX url_r ON url (room(64));
+CREATE INDEX url_rj ON url (room(64),jid(64));
+CREATE INDEX url_rjn ON url (room(64),jid(64),nick(255));
+CREATE INDEX url_rt ON url (room(64),time);
 
 -- --------------------------------------------------------------------------- --
 -- THE END
diff --git a/scripts/sqlite3.schema b/scripts/sqlite3.schema
index f4c7b6f..6858b4b 100644
--- a/scripts/sqlite3.schema
+++ b/scripts/sqlite3.schema
@@ -363,7 +363,7 @@ CREATE TABLE feed (
 	type text,
 	time integer,
 	room text,
-	hash text array[10]
+	hash text
 );
 
 CREATE INDEX feed_r ON feed (room);