CREATE TABLE IF NOT EXISTS `cot_social_friendslist` (
	`id` int(11) NOT NULL auto_increment,
	`userid` int(11) default NULL,
	`friendid` int(11) default NULL,
	`date` int(11) NOT NULL default '0',
	`status` int(11) NOT NULL default '0',
	PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS `cot_social_userwall` (
	`id` int(11) NOT NULL auto_increment,
	`onuser` int(11) default NULL,
	`fromuser` int(11) default NULL,
	`parent` int(11) NOT NULL default '0',
	`date` int(11) NOT NULL default '0',
	`message` text collate utf8_unicode_ci NOT NULL,
	PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;