TxDfQavD

1
2-- ----------------------------
3-- Table structure for `group_memberships`
4-- ----------------------------
5DROP TABLE IF EXISTS `group_memberships`;
6CREATE TABLE `group_memberships` (
7  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
8  `group_id` int(11) unsigned NOT NULL,
9  `user_id` int(11) unsigned NOT NULL,
10  `rank` enum('0','1','2') NOT NULL DEFAULT '0',
11  PRIMARY KEY (`id`),
12  KEY `groupid` (`group_id`),
13  KEY `userid` (`user_id`)
14) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;
15
16-- ----------------------------
17-- Records of group_memberships
18-- ----------------------------
19INSERT INTO `group_memberships` VALUES ('1', '1', '299423', '2');
20
21-- ----------------------------
22-- Table structure for `groups`
23-- ----------------------------
24DROP TABLE IF EXISTS `groups`;
25CREATE TABLE `groups` (
26  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
27  `name` varchar(50) NOT NULL,
28  `desc` varchar(255) NOT NULL,
29  `badge` varchar(50) NOT NULL,
30  `owner_id` int(11) unsigned NOT NULL,
31  `created` varchar(50) NOT NULL,
32  `room_id` int(10) unsigned NOT NULL DEFAULT '0',
33  `state` enum('0','1','2') NOT NULL DEFAULT '0',
34  `colour1` int(11) NOT NULL DEFAULT '242424',
35  `colour2` int(11) NOT NULL DEFAULT '242424',
36  PRIMARY KEY (`id`),
37  KEY `id` (`id`)
38) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
39
40-- ----------------------------
41-- Records of groups
42-- ----------------------------
43INSERT INTO `groups` VALUES ('1', 'Plus|', 'Welcome to HabPlus|||', 'b05114t3311481268cbd06b4ad1e7815b61f0e47cb28', '299423', '123', '1801663', '0', '242424', '242424');