DB.lua

Group = {}
db = dbConnect("sqlite", ":/grupos.db")
--idRank = id_group+name_rank
---Creacion de la tabla de grupos
dbExec(db, "CREATE TABLE IF NOT EXISTS groups (id integer PRIMARY KEY AUTOINCREMENT, "..
    "name TEXT not null, leaderAcc TEXT not null, message TEXT, chatcolor TEXT, date TEXT)")

---Creacion de la tabla de rangos de grupos
dbExec(db, "CREATE TABLE IF NOT EXISTS groupRanks (id text PRIMARY KEY, id_group integer not null, "..
    "name TEXT not null, kick integer default 0, adv integer default 0, changerank integer default 0,"..
    "createrank integer default 0, inv integer default 0, changemsg integer default 0,"..
    "colorchat integer default 0, changeNameTeam integer default 0,"..
    "FOREIGN KEY(`id_group`) REFERENCES `groups`(`id`))")

---Creacion de la tabla de miembros
dbExec(db,"CREATE TABLE IF NOT EXISTS groupMembers (id integer PRIMARY KEY AUTOINCREMENT,"..
    "id_group integer not null, account TEXT not null,date TEXT, advs integer default 0,"..
    "last_activity text, rank_id text,"..
    "FOREIGN KEY(`id_group`) REFERENCES `groups`(`id`),"..
    "FOREIGN KEY(`rank_id`) REFERENCES `groupRanks`(`id`))")

---Creacion de la tabla de invitaciones
dbExec(db,"CREATE TABLE IF NOT EXISTS invit (id integer PRIMARY KEY AUTOINCREMENT,"..
    "id_group integer not null, account_inv TEXT not null,"..
    "FOREIGN KEY(`id_group`) REFERENCES `groups`(`id`))")


Group.getDB = function ()
    return db
end