LAmMY1x8

1Group = {}
2db = dbConnect("sqlite", ":/grupos.db")
3--idRank = id_group+name_rank
4---Creacion de la tabla de grupos
5dbExec(db, "CREATE TABLE IF NOT EXISTS groups (id integer PRIMARY KEY AUTOINCREMENT, "..
6	"name TEXT not null, leaderAcc TEXT not null, message TEXT, chatcolor TEXT, date TEXT)")
7
8---Creacion de la tabla de rangos de grupos
9dbExec(db, "CREATE TABLE IF NOT EXISTS groupRanks (id text PRIMARY KEY, id_group integer not null, "..
10	"name TEXT not null, kick integer default 0, adv integer default 0, changerank integer default 0,"..
11	"createrank integer default 0, inv integer default 0, changemsg integer default 0,"..
12	"colorchat integer default 0, changeNameTeam integer default 0,"..
13	"FOREIGN KEY(`id_group`) REFERENCES `groups`(`id`))")
14
15---Creacion de la tabla de miembros
16dbExec(db,"CREATE TABLE IF NOT EXISTS groupMembers (id integer PRIMARY KEY AUTOINCREMENT,"..
17	"id_group integer not null, account TEXT not null,date TEXT, advs integer default 0,"..
18	"last_activity text, rank_id text,"..
19	"FOREIGN KEY(`id_group`) REFERENCES `groups`(`id`),"..
20	"FOREIGN KEY(`rank_id`) REFERENCES `groupRanks`(`id`))")
21	
22---Creacion de la tabla de invitaciones
23dbExec(db,"CREATE TABLE IF NOT EXISTS invit (id integer PRIMARY KEY AUTOINCREMENT,"..
24	"id_group integer not null, account_inv TEXT not null,"..
25	"FOREIGN KEY(`id_group`) REFERENCES `groups`(`id`))")
26
27	
28Group.getConexion = function ()
29	return db
30end