File size: 616B
CREATE TABLE `COMMUNITIES` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`USER_ID` int(11) NOT NULL,
`TIME` int(11) NOT NULL,
`NAME` varchar(200) NOT NULL,
`MESSAGE` varchar(10000) NOT NULL,
`PRIVATE` int(11) DEFAULT '0',
`ID_CATEGORY` int(11) DEFAULT '0',
`RATING` double(10,2) DEFAULT '0.00',
`AVATAR` int(11) DEFAULT '0',
`SCREENSAVER` int(11) DEFAULT '0',
`MOTTO` varchar(500) DEFAULT NULL,
`RULES` varchar(1000) DEFAULT NULL,
`INTERESTS` varchar(500) DEFAULT NULL,
`URL` varchar(120) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1;