· 8 years ago · Jul 23, 2018, 05:32 PM
1CREATE TABLE IF NOT EXISTS `groups` (
2 `id` bigint(20) NOT NULL,
3 `chatusername` varchar(32) DEFAULT NULL,
4 PRIMARY KEY (`id`)
5) ENGINE=MyISAM DEFAULT CHARSET=latin1;
6
7CREATE TABLE IF NOT EXISTS `Group id here` (
8 `id` int(40) NOT NULL,
9 `username` varchar(32) DEFAULT NULL,
10 `role` tinyint(4) NOT NULL DEFAULT '0',
11 `messageCounter` int(11) unsigned NOT NULL DEFAULT '0',
12 `free` tinyint(1) DEFAULT NULL,
13 PRIMARY KEY (`id`)
14) ENGINE=MyISAM DEFAULT CHARSET=latin1;