· 9 years ago · Jan 26, 2017, 06:34 PM
1db.query(""
2 + "CREATE TABLE IF NOT EXISTS `guild`"
3 + " (`owneruid` varchar(50) NOT NULL,"
4 + " `owner` varchar(50) NOT NULL,"
5 + " `name` varchar(15) NOT NULL PRIMARY KEY,"
6 + " `tag` varchar(6) NOT NULL,"
7 + " `membersuid` varchar(50),"
8 + " `created` varchar(24) NOT NULL,"
9 + " `home` varchar(150)),"
10 + " FOREIGN KEY(membersuid) REFERENCES members(memberuid);"
11 );
12 db.query(""
13 + "CREATE TABLE IF NOT EXISTS `members`"
14 + " (`memberuid` varchar(50) PRIMARY KEY,"
15 + " `member` varchar(150),"
16 + " `level` TINYINT);"
17 );