XERpWUCf

1-- --------------------------------------------------------
2
3--
4-- Estructura de tabla para la tabla `groups_details`
5--
6
7CREATE TABLE IF NOT EXISTS `groups_details` (
8  `id` int(10) NOT NULL AUTO_INCREMENT,
9  `name` varchar(45) COLLATE latin1_general_ci NOT NULL,
10  `description` varchar(200) COLLATE latin1_general_ci NOT NULL,
11  `ownerid` int(10) NOT NULL,
12  `roomid` int(10) NOT NULL,
13  `created` varchar(50) COLLATE latin1_general_ci NOT NULL,
14  `badge` text COLLATE latin1_general_ci NOT NULL,
15  `type` int(1) NOT NULL DEFAULT '0',
16  `recommended` int(1) NOT NULL DEFAULT '0',
17  `views` int(15) NOT NULL,
18  `pane` smallint(1) NOT NULL DEFAULT '0',
19  `topics` smallint(1) NOT NULL DEFAULT '0',
20  PRIMARY KEY (`id`,`name`)
21) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
22
23-- --------------------------------------------------------
24
25--
26-- Estructura de tabla para la tabla `groups_memberships`
27--
28
29CREATE TABLE IF NOT EXISTS `groups_memberships` (
30  `userid` int(10) NOT NULL,
31  `groupid` int(10) NOT NULL,
32  `member_rank` enum('3','2','1') COLLATE latin1_general_ci NOT NULL DEFAULT '3',
33  `is_current` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '0',
34  `is_pending` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '0'
35) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
36
37-- --------------------------------------------------------