Hi,
in the past there where some users who wanted to use my Helga plugin, but didn’t have an MySQL database. Now I did massive changes to my database tables so it should be compatible to any database that openfire supports.
I need *.sql-Files which create the tables for each supported database software. But, I have no way to test it, and I only know MySQL.
Maybe someone can translate the following SQL and help with testing. Should be really straightforward
-- Helga DB version 2 / MySQL CREATE TABLE helgaEvent (
event_id CHAR(15) NOT NULL,
owner TEXT NOT NULL,
creation CHAR(15) NOT NULL,
execution CHAR(15) NOT NULL,
type TINYINT NOT NULL DEFAULT 0,
PRIMARY KEY(event_id)
); CREATE TABLE helgaMessage (
event_id CHAR(15) NOT NULL,
tojid TEXT NOT NULL,
msg TEXT NOT NULL,
PRIMARY KEY(event_id)
); CREATE TABLE helgaUser (
id INT UNSIGNED AUTO_INCREMENT,
jid TEXT NOT NULL,
sub TINYINT NOT NULL DEFAULT 1,
public TINYINT NOT NULL DEFAULT 0,
source TEXT DEFAULT NULL,
PRIMARY KEY(id),
INDEX jid_idx(jid(10))
); CREATE TABLE helgaGroup (
id INT UNSIGNED AUTO_INCREMENT,
type TINYINT NOT NULL DEFAULT 0,
jid TEXT NOT NULL,
group_id CHAR(15) NOT NULL,
PRIMARY KEY (id),
INDEX idx(type,jid(10),group_id)
); -- insert database version
INSERT INTO jiveVersion (name, version) VALUES ('helga', 2);