-- phpMyAdmin SQL Dump
-- version 3.1.4
-- http://www.phpmyadmin.net
--
-- 主机: 127.0.0.1
-- 生成日期: 2009 年 05 月 02 日 00:59
-- 服务器版本: 5.0.41
-- PHP 版本: 5.2.8

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- 数据库: `freecomm`
--

-- --------------------------------------------------------

--
-- 表的结构 `fcm_allow_connect`
--

CREATE TABLE IF NOT EXISTS `fcm_allow_connect` (
  `AllowSubSvrIP` varchar(255) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `fcm_allow_connect`
--


-- --------------------------------------------------------

--
-- 表的结构 `fcm_black_user`
--

CREATE TABLE IF NOT EXISTS `fcm_black_user` (
  `UserID` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `fcm_black_user`
--


-- --------------------------------------------------------

--
-- 表的结构 `fcm_book_group`
--

CREATE TABLE IF NOT EXISTS `fcm_book_group` (
  `UserID` int(11) default NULL,
  `GroupID` int(11) default NULL,
  `GroupName` tinytext
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `fcm_book_group`
--


-- --------------------------------------------------------

--
-- 表的结构 `fcm_bulletin`
--

CREATE TABLE IF NOT EXISTS `fcm_bulletin` (
  `BulletinID` int(11) default NULL,
  `BulletinType` int(11) default NULL,
  `BulletinMsg` mediumtext,
  `BulletinURL` mediumtext
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `fcm_bulletin`
--

-- --------------------------------------------------------

--
-- 表的结构 `fcm_b2b_bulletin`
--

CREATE TABLE IF NOT EXISTS `fcm_b2b_bulletin` (
  `ID` int(11) default NULL,
  `Type` int(11) default NULL,
  `BeginTime` datetime default NULL,
  `EndTime` datetime default NULL,
  `ActiveTime` datetime default NULL,
  `Duration` int(11) default NULL,
  `ConsumeMoney` int(11) default NULL,
  `UserID` int(11) default NULL,
  `Price` int(11) default NULL,
  `Title` varchar(255) default NULL,
  `Message` varchar(255) default NULL,
  `Url` varchar(255) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `fcm_b2b_bulletin`
--

-- --------------------------------------------------------

--
-- 表的结构 `fcm_chatroom`
--

CREATE TABLE IF NOT EXISTS `fcm_chatroom` (
  `ChatRoomID` int(11) default NULL,
  `ChatRoomName` varchar(255) default NULL,
  `PlatformID` int(11) default NULL,
  `ChatRoomPwd` varchar(255) default NULL,
  `ChatRoomBulletin` varchar(255) default NULL,
  `ChatRoomType` int(11) default NULL,
  `OwnerID` int(11) default NULL,
  `OwnerPwd` varchar(255) default NULL,
  `TicketPrice` int(11) default NULL,
  `StoreServer` varchar(255) default NULL,
  `AD` mediumtext
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `fcm_chatroom`
--


-- --------------------------------------------------------

--
-- 表的结构 `fcm_chatroom_admin`
--

CREATE TABLE IF NOT EXISTS `fcm_chatroom_admin` (
  `ChatRoomID` int(11) default NULL,
  `ChatRoomAdminID` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `fcm_chatroom_admin`
--


-- --------------------------------------------------------

--
-- 表的结构 `fcm_chatroom_consume`
--

CREATE TABLE IF NOT EXISTS `fcm_chatroom_consume` (
  `UserID` int(11) default NULL,
  `ChatRoomID` int(11) default NULL,
  `ConsumeMoney` int(11) default NULL,
  `GoodCount` int(11) default NULL,
  `BuyTime` datetime default NULL,
  `GoodType` int(11) default NULL,
  `BuyType` tinyint(3) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `fcm_chatroom_consume`
--


-- --------------------------------------------------------

--
-- 表的结构 `fcm_chatroom_doc`
--

CREATE TABLE IF NOT EXISTS `fcm_chatroom_doc` (
  `FileID` int(11) default NULL,
  `ChatRoomID` int(11) default NULL,
  `FileName` tinytext,
  `FileSize` int(11) default NULL,
  `FileMemo` varchar(255) default NULL,
  `FileServer` varchar(255) default NULL,
  `CreateDT` datetime default NULL,
  `OwnerID` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `fcm_chatroom_doc`
--


-- --------------------------------------------------------

--
-- 表的结构 `fcm_chatroom_platform`
--

CREATE TABLE IF NOT EXISTS `fcm_chatroom_platform` (
  `PlatformID` int(11) default NULL,
  `PlatformName` varchar(255) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `fcm_chatroom_platform`
--


-- --------------------------------------------------------

--
-- 表的结构 `fcm_cluster`
--

CREATE TABLE IF NOT EXISTS `fcm_cluster` (
  `ClusterID` int(11) NOT NULL,
  `ClusterName` varchar(250) NOT NULL,
  `ClusterBulletin` varchar(255) NOT NULL,
  `ClusterMemo` varchar(255) NOT NULL,
  `ClusterType` int(11) NOT NULL,
  `PlatformID` int(11) NOT NULL,
  `OwnerID` int(11) NOT NULL,
  `CreateDate` datetime NOT NULL,
  `IsVerify` tinyint(1) NOT NULL,
  `StoreServer` varchar(255) default NULL,
  `LeavewordDay` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='群数据表定义';

--
-- 导出表中的数据 `fcm_cluster`
--

-- --------------------------------------------------------

--
-- 表的结构 `fcm_cluster_leaveword`
--

CREATE TABLE IF NOT EXISTS `fcm_cluster_leaveword` (
  `ClusterID` int(11) NOT NULL,
  `FromID` int(11) NOT NULL,
  `ToID` int(11) NOT NULL,
  `MsgDate` datetime default NULL,
  `Message` mediumtext  
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='群留言数据表定义';

--
-- 导出表中的数据 `fcm_cluster_leaveword`
--

-- --------------------------------------------------------

--
-- 表的结构 `fcm_cluster_admin`
--

CREATE TABLE IF NOT EXISTS `fcm_cluster_admin` (
  `ClusterID` int(11) NOT NULL,
  `AdminID` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `fcm_cluster_admin`
--


-- --------------------------------------------------------

--
-- 表的结构 `fcm_cluster_doc`
--

CREATE TABLE IF NOT EXISTS `fcm_cluster_doc` (
  `FileID` int(11) default NULL,
  `ClusterID` int(11) default NULL,
  `FileName` tinytext,
  `FileSize` int(11) default NULL,
  `FileMemo` varchar(255) default NULL,
  `FileServer` varchar(255) default NULL,
  `CreateDT` datetime default NULL,
  `OwnerID` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `fcm_cluster_doc`
--


-- --------------------------------------------------------

--
-- 表的结构 `fcm_cluster_platform`
--

CREATE TABLE IF NOT EXISTS `fcm_cluster_platform` (
  `PlatformID` int(11) default NULL,
  `PlatformName` varchar(255) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `fcm_cluster_platform`
--


-- --------------------------------------------------------

--
-- 表的结构 `fcm_cluster_user`
--

CREATE TABLE IF NOT EXISTS `fcm_cluster_user` (
  `ClusterID` int(11) NOT NULL,
  `UserID` int(11) NOT NULL,
  `NickName` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `fcm_cluster_user`
--


-- --------------------------------------------------------

--
-- 表的结构 `fcm_counseling`
--

CREATE TABLE IF NOT EXISTS `fcm_counseling` (
  `UserID` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `fcm_counseling`
--


-- --------------------------------------------------------

--
-- 表的结构 `fcm_enterprise`
--

CREATE TABLE IF NOT EXISTS `fcm_enterprise` (
  `BranchID` int(11) default NULL,
  `BranchName` tinytext,
  `PBranchID` int(11) default NULL,
  `AdminID` int(11) default NULL,
  `MessageServer` tinytext,
  `StoreServer` tinytext,
  `LastModify` datetime default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `fcm_enterprise`
--


-- --------------------------------------------------------

--
-- 表的结构 `fcm_leaveword`
--

CREATE TABLE IF NOT EXISTS `fcm_leaveword` (
  `FromID` int(11) default NULL,
  `ToID` int(11) default NULL,
  `MsgType` int(11) default NULL,
  `Message` mediumtext,
  `MsgDate` datetime default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `fcm_leaveword`
--


-- --------------------------------------------------------

--
-- 表的结构 `fcm_sip_user`
--

CREATE TABLE IF NOT EXISTS `fcm_sip_user` (
  `UserID` int(11) default NULL,
  `SIPUserID` tinytext,
  `SIPUserPwd` varchar(64) default NULL,
  `SIPSvrIP` varchar(255) default NULL,
  `Money` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `fcm_sip_user`
--


-- --------------------------------------------------------

--
-- 表的结构 `fcm_sms_info`
--

CREATE TABLE IF NOT EXISTS `fcm_sms_info` (
  `UserID` int(11) default NULL,
  `PhoneNumbers` mediumtext,
  `SmsContent` mediumtext,
  `SendTime` datetime default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `fcm_sms_info`
--


-- --------------------------------------------------------

--
-- 表的结构 `fcm_telephone_book`
--

CREATE TABLE IF NOT EXISTS `fcm_telephone_book` (
  `UserID` int(11) default NULL,
  `GroupID` int(11) default NULL,
  `ContactName` varchar(255) default NULL,
  `SipID` varchar(255) default NULL,
  `Mobile` varchar(255) default NULL,
  `FixPhone` varchar(255) default NULL,
  `Sex` tinyint(3) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `fcm_telephone_book`
--


-- --------------------------------------------------------

--
-- 表的结构 `fcm_user_branch`
--

CREATE TABLE IF NOT EXISTS `fcm_user_branch` (
  `UserID` int(11) default NULL,
  `BranchID` int(11) default NULL,
  `Weight` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `fcm_user_branch`
--


-- --------------------------------------------------------

--
-- 表的结构 `fcm_user_face`
--

CREATE TABLE IF NOT EXISTS `fcm_user_face` (
  `UserID` int(11) default NULL,
  `FaceName` tinytext,
  `FileServer` varchar(255) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `fcm_user_face`
--


-- --------------------------------------------------------

--
-- 表的结构 `fcm_user_friend`
--

CREATE TABLE IF NOT EXISTS `fcm_user_friend` (
  `OwnerID` int(11) default NULL,
  `FriendID` int(11) default NULL,
  `GroupID` int(11) default NULL,
  `Name` varchar(255) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `fcm_user_friend`
--


-- --------------------------------------------------------

--
-- 表的结构 `fcm_user_group`
--

CREATE TABLE IF NOT EXISTS `fcm_user_group` (
  `OwnerID` int(11) default NULL,
  `GroupID` int(11) default NULL,
  `GroupName` varchar(255) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `fcm_user_group`
--


-- --------------------------------------------------------

--
-- 表的结构 `fcm_user_card`
--

CREATE TABLE IF NOT EXISTS `fcm_user_card` (
  `UserID` int(11) NOT NULL,
  `UserName` varchar(255) default NULL,
  `Company` varchar(255) default NULL,
  `Department` varchar(255) default NULL,
  `Title` varchar(255) default NULL,
  `Sex` tinyint(3) NOT NULL,
  `Mobile` varchar(255) default NULL,
  `Phone` varchar(255) default NULL,
  `EMail` varchar(255) default NULL,
  `Fax` varchar(255) default NULL,
  `Addr` varchar(255) default NULL,
  `Brief` varchar(255) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `fcm_user_card`
--


-- --------------------------------------------------------

--
-- 表的结构 `fcm_user_info`
--

CREATE TABLE IF NOT EXISTS `fcm_user_info` (
  `UserID` int(11) NOT NULL,
  `UserName` varchar(255) default NULL,
  `UserPwd` varchar(255) default NULL,
  `UserNickname` varchar(255) default NULL,
  `BloodType` tinyint(3) unsigned default NULL,
  `ConStellation` tinyint(3) unsigned default NULL,
  `Career` tinyint(3) unsigned default NULL,
  `ShengXiao` tinyint(3) unsigned default NULL,
  `FinishSchool` varchar(255) default NULL,
  `HomePage` varchar(255) default NULL,
  `Brief` varchar(255) default NULL,
  `EMail` varchar(255) default NULL,
  `Address` varchar(255) default NULL,
  `PostalCode` varchar(255) default NULL,
  `FixedPhone` varchar(255) default NULL,
  `Mobile` varchar(255) default NULL,
  `Birthday` datetime default NULL,
  `Age` tinyint(3) unsigned default NULL,
  `Sex` tinyint(3) NOT NULL,
  `Country` varchar(255) default NULL,
  `Province` varchar(255) default NULL,
  `City` varchar(255) default NULL,
  `ImgIdx` tinyint(3) unsigned default NULL,
  `HasMoney` int(11) default NULL,
  `PwdProtect` tinyint(3) NOT NULL,
  `ProtectText` varchar(255) default NULL,
  `RegTime` datetime default NULL,
  `Member` tinyint(3) unsigned default NULL,
  `OnlineTime` int(11) default NULL,
  `Signature` varchar(64) default NULL,
  `CardStyle` int(11) default NULL,
  `ThirdAccount` varchar(240) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `fcm_user_info`
--

 
-- ------------------------------------------------------

--
-- 表的结构 `fcm_user_deny`
--

CREATE TABLE IF NOT EXISTS `fcm_user_deny` (
  `UserID` int(11) NOT NULL,
  `PeerID` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `fcm_user_deny`
--

-- --------------------------------------------------------

--
-- 表的结构 `fcm_user_disable`
--

CREATE TABLE IF NOT EXISTS `fcm_user_disable` (
  `UserID` int(11) NOT NULL,
  `PeerID` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `fcm_user_disable`
--

-- --------------------------------------------------------

--
-- 表的结构 `fcm_user_cache`
--

CREATE TABLE IF NOT EXISTS `fcm_user_cache` (
  `UserID` int(11) NOT NULL,
  `GroupCache` int(11) default '1',
  `FriendCache` int(11) default '1',
  `ClusterCache` int(11) default '1',
  `DenyCache` int(11) default '1',
  `DisableCache` int(11) default '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `fcm_user_cache`
--

-- --------------------------------------------------------

--
-- Table structure for table `fcm_user_deny`
--

DROP TABLE IF EXISTS `fcm_user_deny`;
CREATE TABLE `fcm_user_deny` (
  `UserID` int(11) NOT NULL,
  `PeerID` int(11) DEFAULT NULL,
  KEY `UserID` (`UserID`),
  UNIQUE KEY `Key` (`UserID`,`PeerID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `fcm_user_disable`
--

DROP TABLE IF EXISTS `fcm_user_disable`;
CREATE TABLE `fcm_user_disable` (
  `UserID` int(11) NOT NULL,
  `PeerID` int(11) DEFAULT NULL,
  KEY `UserID` (`UserID`),
  UNIQUE KEY `Key` (`UserID`,`PeerID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


-- --------------------------------------------------------

--
-- 表的结构 `fcm_user_login`
--

CREATE TABLE IF NOT EXISTS `fcm_user_login` (
  `UserID` int(11) NOT NULL,
  `NatIP` varchar(255) default NULL,
  `InnerIP` varchar(255) default NULL,
  `LastTime` datetime default NULL,
  `Signature` tinyint(3) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `fcm_user_login`
--

-- --------------------------------------------------------

--
-- 表的结构 `fcm_user_server`
--

CREATE TABLE IF NOT EXISTS `fcm_user_server` (
	`UserID` int(11) NOT NULL,
  `Type` varchar(255) default NULL,
  `Server` varchar(255) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `fcm_user_server`
--


-- --------------------------------------------------------

--
-- 表的结构 `fcm_peer_system`
--

CREATE TABLE IF NOT EXISTS `fcm_peer_system` (
	`Name` varchar(150) default NULL,
  `Server` varchar(150) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `fcm_peer_system`
--


-- --------------------------------------------------------

--
-- 表的结构 `fcm_peer_friends`
--

CREATE TABLE IF NOT EXISTS `fcm_peer_friends` (
  `Server` varchar(255) default NULL,
  `OwnerID` int(11) default NULL,
  `GroupID` int(11) default NULL,
  `FriendID` int(11) default NULL,
  `FriendName` varchar(255) default NULL,
  `MemoName` varchar(255) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `fcm_peer_friends`
--


-- --------------------------------------------------------

--
-- 表的结构 `fcm_peer_platform`
--

CREATE TABLE IF NOT EXISTS `fcm_peer_platform` (
  `Server` varchar(255) default NULL,
  `PlatformID` int(11) default NULL,
  `PlatformName` varchar(255) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `fcm_peer_platform`
--

-- --------------------------------------------------------

--
-- 表的结构 `fcm_web_url`
--

CREATE TABLE IF NOT EXISTS `fcm_web_url` (
  `Category` int(11) default NULL,
  `LiveRoomID` int(11) default NULL,
  `LiveName` varchar(255) default NULL,
  `LiveURL` tinytext,
  `LiveMemo` tinytext,
  `OwnerID` int(11) default NULL,
  `PublicDT` datetime default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `fcm_web_url`
--


-- --------------------------------------------------------

--
-- Stand-in structure for view `vfcm_branch`
--
CREATE TABLE IF NOT EXISTS `vfcm_branch` (
`BranchID` int(11)
,`UserID` int(11)
,`Weight` int(11)
,`UserName` varchar(255)
,`UserNickName` varchar(255)
,`ImgIdx` tinyint(3) unsigned
,`Member` tinyint(3) unsigned
,`Sex` tinyint(3)
,`OnlineTime` int(11)
,`Signature` varchar(255)
,`CardStyle` int(11)
);
-- --------------------------------------------------------

--
-- Stand-in structure for view `vfcm_chatroom_admin`
--
CREATE TABLE IF NOT EXISTS `vfcm_chatroom_admin` (
`PlatformID` int(11)
,`ChatRoomID` int(11)
,`ChatRoomAdminID` int(11)
);
-- --------------------------------------------------------

--
-- Stand-in structure for view `vfcm_chatroom_consume`
--
CREATE TABLE IF NOT EXISTS `vfcm_chatroom_consume` (
`UserID` int(11)
,`UserName` varchar(255)
,`ChatRoomID` int(11)
,`ConsumeMoney` int(11)
,`GoodType` int(11)
,`GoodCount` int(11)
,`BuyType` tinyint(3)
,`BuyTime` datetime
);
-- --------------------------------------------------------

--
-- Stand-in structure for view `vfcm_chatroom_doc`
--
CREATE TABLE IF NOT EXISTS `vfcm_chatroom_doc` (
`PlatformID` int(11)
,`FileID` int(11)
,`ChatRoomID` int(11)
,`FileName` tinytext
,`FileSize` int(11)
,`FileMemo` varchar(255)
,`FileServer` varchar(255)
,`CreateDT` datetime
,`OwnerID` int(11)
);
-- --------------------------------------------------------

--
-- Stand-in structure for view `vfcm_cluster`
--
CREATE TABLE IF NOT EXISTS `vfcm_cluster` (
`UserID` int(11)
,`ClusterID` int(11)
,`ClusterName` varchar(250)
,`ClusterBulletin` varchar(255)
,`ClusterMemo` varchar(255)
,`ClusterType` int(11)
,`PlatformID` int(11)
,`OwnerID` int(11)
,`CreateDate` datetime
,`IsVerify` tinyint(1)
,`StoreServer` varchar(255)
,`LeavewordDay`int(11)
);
-- --------------------------------------------------------

--
-- Stand-in structure for view `vfcm_cluster_admin`
--
CREATE TABLE IF NOT EXISTS `vfcm_cluster_admin` (
`PlatformID` int(11)
,`ClusterID` int(11)
,`AdminID` int(11)
,`UserID` int(11)
,`UserName` varchar(255)
,`UserPwd` varchar(255)
,`UserNickname` varchar(255)
,`BloodType` tinyint(3) unsigned
,`ConStellation` tinyint(3) unsigned
,`Career` tinyint(3) unsigned
,`ShengXiao` tinyint(3) unsigned
,`FinishSchool` varchar(255)
,`HomePage` varchar(255)
,`Brief` varchar(255)
,`EMail` varchar(255)
,`Address` varchar(255)
,`PostalCode` varchar(255)
,`FixedPhone` varchar(255)
,`Mobile` varchar(255)
,`Birthday` datetime
,`Age` tinyint(3) unsigned
,`Sex` tinyint(3)
,`Country` varchar(255)
,`Province` varchar(255)
,`City` varchar(255)
,`ImgIdx` tinyint(3) unsigned
,`HasMoney` int(11)
,`PwdProtect` tinyint(3)
,`ProtectText` varchar(255)
,`RegTime` datetime
,`Member` tinyint(3) unsigned
,`OnlineTime` int(11)
,`Signature` varchar(64)
);
-- --------------------------------------------------------

--
-- Stand-in structure for view `vfcm_cluster_doc`
--
CREATE TABLE IF NOT EXISTS `vfcm_cluster_doc` (
`PlatformID` int(11)
,`FileID` int(11)
,`ClusterID` int(11)
,`FileName` tinytext
,`FileSize` int(11)
,`FileMemo` varchar(255)
,`FileServer` varchar(255)
,`CreateDT` datetime
,`OwnerID` int(11)
);
-- --------------------------------------------------------

--
-- Stand-in structure for view `vfcm_cluster_user`
--
CREATE TABLE IF NOT EXISTS `vfcm_cluster_user` (
`ClusterID` int(11)
,`NickName` varchar(255)
,`UserID` int(11)
,`UserName` varchar(255)
,`UserPwd` varchar(255)
,`UserNickname` varchar(255)
,`BloodType` tinyint(3) unsigned
,`ConStellation` tinyint(3) unsigned
,`Career` tinyint(3) unsigned
,`ShengXiao` tinyint(3) unsigned
,`FinishSchool` varchar(255)
,`HomePage` varchar(255)
,`Brief` varchar(255)
,`EMail` varchar(255)
,`Address` varchar(255)
,`PostalCode` varchar(255)
,`FixedPhone` varchar(255)
,`Mobile` varchar(255)
,`Birthday` datetime
,`Age` tinyint(3) unsigned
,`Sex` tinyint(3)
,`Country` varchar(255)
,`Province` varchar(255)
,`City` varchar(255)
,`ImgIdx` tinyint(3) unsigned
,`HasMoney` int(11)
,`PwdProtect` tinyint(3)
,`ProtectText` varchar(255)
,`RegTime` datetime
,`Member` tinyint(3) unsigned
,`OnlineTime` int(11)
,`Signature` varchar(64)
);
-- --------------------------------------------------------

--
-- Stand-in structure for view `vfcm_user_friend`
--
CREATE TABLE IF NOT EXISTS `vfcm_user_friend` (
`OwnerID` int(11)
,`GroupID` int(11)
,`FriendID` int(11)
,`UserName` varchar(255)
,`UserNickname` varchar(255)
,`ImgIdx` tinyint(3) unsigned
,`Member` tinyint(3) unsigned
,`Sex` tinyint(3)
,`Name` varchar(64)
,`OnlineTime` int(11)
,`Signature` varchar(255)
,`CardStyle` int(11)
);
-- --------------------------------------------------------

--
-- Stand-in structure for view `vfcm_sms_info`
--
CREATE TABLE IF NOT EXISTS `vfcm_sms_info` (
`UserID` int(11)
,`UserName` varchar(255)
,`UserNickname` varchar(255)
,`PhoneNumbers` mediumtext
,`SmsContent` mediumtext
,`SendTime` datetime
);
-- --------------------------------------------------------

--
-- Structure for view `vfcm_branch`
--
DROP TABLE IF EXISTS `vfcm_branch`;

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vfcm_branch` AS select `fcm_user_branch`.`BranchID` AS `BranchID`,`fcm_user_branch`.`UserID` AS `UserID`,`fcm_user_branch`.`Weight` AS `Weight`,`fcm_user_info`.`UserName` AS `UserName`,`fcm_user_info`.`UserNickname` AS `UserNickname`,`fcm_user_info`.`ImgIdx` AS `ImgIdx`,`fcm_user_info`.`Member` AS `Member`,`fcm_user_info`.`Sex` AS `Sex`,`fcm_user_info`.`OnlineTime` AS `OnlineTime`,`fcm_user_info`.`Signature` AS `Signature`,`fcm_user_info`.`CardStyle` AS `CardStyle` from (`fcm_user_info` join `fcm_user_branch` on((`fcm_user_info`.`UserID` = `fcm_user_branch`.`UserID`)));

-- --------------------------------------------------------

--
-- Structure for view `vfcm_chatroom_admin`
--
DROP TABLE IF EXISTS `vfcm_chatroom_admin`;

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vfcm_chatroom_admin` AS select `fcm_chatroom`.`PlatformID` AS `PlatformID`,`fcm_chatroom`.`ChatRoomID` AS `ChatRoomID`,`fcm_chatroom_admin`.`ChatRoomAdminID` AS `ChatRoomAdminID` from ((`fcm_chatroom_platform` join `fcm_chatroom` on((`fcm_chatroom_platform`.`PlatformID` = `fcm_chatroom`.`PlatformID`))) join `fcm_chatroom_admin` on((`fcm_chatroom`.`ChatRoomID` = `fcm_chatroom_admin`.`ChatRoomID`)));

-- --------------------------------------------------------

--
-- Structure for view `vfcm_chatroom_consume`
--
DROP TABLE IF EXISTS `vfcm_chatroom_consume`;

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vfcm_chatroom_consume` AS select `fcm_chatroom_consume`.`UserID` AS `UserID`,`fcm_user_info`.`UserName` AS `UserName`,`fcm_chatroom_consume`.`ChatRoomID` AS `ChatRoomID`,`fcm_chatroom_consume`.`ConsumeMoney` AS `ConsumeMoney`,`fcm_chatroom_consume`.`GoodType` AS `GoodType`,`fcm_chatroom_consume`.`GoodCount` AS `GoodCount`,`fcm_chatroom_consume`.`BuyType` AS `BuyType`,`fcm_chatroom_consume`.`BuyTime` AS `BuyTime` from (`fcm_chatroom_consume` join `fcm_user_info`);

-- --------------------------------------------------------

--
-- Structure for view `vfcm_chatroom_doc`
--
DROP TABLE IF EXISTS `vfcm_chatroom_doc`;

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vfcm_chatroom_doc` AS select `fcm_chatroom_platform`.`PlatformID` AS `PlatformID`,`fcm_chatroom_doc`.`FileID` AS `FileID`,`fcm_chatroom_doc`.`ChatRoomID` AS `ChatRoomID`,`fcm_chatroom_doc`.`FileName` AS `FileName`,`fcm_chatroom_doc`.`FileSize` AS `FileSize`,`fcm_chatroom_doc`.`FileMemo` AS `FileMemo`,`fcm_chatroom_doc`.`FileServer` AS `FileServer`,`fcm_chatroom_doc`.`CreateDT` AS `CreateDT`,`fcm_chatroom_doc`.`OwnerID` AS `OwnerID` from ((`fcm_chatroom_platform` join `fcm_chatroom` on((`fcm_chatroom_platform`.`PlatformID` = `fcm_chatroom`.`PlatformID`))) join `fcm_chatroom_doc` on((`fcm_chatroom`.`ChatRoomID` = `fcm_chatroom_doc`.`ChatRoomID`)));

-- --------------------------------------------------------

--
-- Structure for view `vfcm_cluster`
--
DROP TABLE IF EXISTS `vfcm_cluster`;

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vfcm_cluster` AS select `fcm_cluster_user`.`UserID` AS `UserID`,`fcm_cluster`.`ClusterID` AS `ClusterID`,`fcm_cluster`.`ClusterName` AS `ClusterName`,`fcm_cluster`.`ClusterBulletin` AS `ClusterBulletin`,`fcm_cluster`.`ClusterMemo` AS `ClusterMemo`,`fcm_cluster`.`ClusterType` AS `ClusterType`,`fcm_cluster`.`PlatformID` AS `PlatformID`,`fcm_cluster`.`OwnerID` AS `OwnerID`,`fcm_cluster`.`CreateDate` AS `CreateDate`,`fcm_cluster`.`IsVerify` AS `IsVerify`,`fcm_cluster`.`StoreServer` AS `StoreServer`,
`fcm_cluster`.`LeavewordDay` AS `LeavewordDay` from (`fcm_cluster` join `fcm_cluster_user` on((`fcm_cluster`.`ClusterID` = `fcm_cluster_user`.`ClusterID`)));

-- --------------------------------------------------------

--
-- Structure for view `vfcm_cluster_admin`
--
DROP TABLE IF EXISTS `vfcm_cluster_admin`;

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vfcm_cluster_admin` AS select `fcm_cluster`.`PlatformID` AS `PlatformID`,`fcm_cluster_admin`.`ClusterID` AS `ClusterID`,`fcm_cluster_admin`.`AdminID` AS `AdminID`,`fcm_user_info`.`UserID` AS `UserID`,`fcm_user_info`.`UserName` AS `UserName`,`fcm_user_info`.`UserPwd` AS `UserPwd`,`fcm_user_info`.`UserNickname` AS `UserNickname`,`fcm_user_info`.`BloodType` AS `BloodType`,`fcm_user_info`.`ConStellation` AS `ConStellation`,`fcm_user_info`.`Career` AS `Career`,`fcm_user_info`.`ShengXiao` AS `ShengXiao`,`fcm_user_info`.`FinishSchool` AS `FinishSchool`,`fcm_user_info`.`HomePage` AS `HomePage`,`fcm_user_info`.`Brief` AS `Brief`,`fcm_user_info`.`EMail` AS `EMail`,`fcm_user_info`.`Address` AS `Address`,`fcm_user_info`.`PostalCode` AS `PostalCode`,`fcm_user_info`.`FixedPhone` AS `FixedPhone`,`fcm_user_info`.`Mobile` AS `Mobile`,`fcm_user_info`.`Birthday` AS `Birthday`,`fcm_user_info`.`Age` AS `Age`,`fcm_user_info`.`Sex` AS `Sex`,`fcm_user_info`.`Country` AS `Country`,`fcm_user_info`.`Province` AS `Province`,`fcm_user_info`.`City` AS `City`,`fcm_user_info`.`ImgIdx` AS `ImgIdx`,`fcm_user_info`.`HasMoney` AS `HasMoney`,`fcm_user_info`.`PwdProtect` AS `PwdProtect`,`fcm_user_info`.`ProtectText` AS `ProtectText`,`fcm_user_info`.`RegTime` AS `RegTime`,`fcm_user_info`.`Member` AS `Member`,`fcm_user_info`.`OnlineTime` AS `OnlineTime`,`fcm_user_info`.`Signature` AS `Signature` from ((`fcm_cluster_admin` join `fcm_user_info` on((`fcm_cluster_admin`.`AdminID` = `fcm_user_info`.`UserID`))) join `fcm_cluster` on((`fcm_cluster_admin`.`ClusterID` = `fcm_cluster`.`ClusterID`)));

-- --------------------------------------------------------

--
-- Structure for view `vfcm_cluster_doc`
--
DROP TABLE IF EXISTS `vfcm_cluster_doc`;

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vfcm_cluster_doc` AS select `fcm_cluster`.`PlatformID` AS `PlatformID`,`fcm_cluster_doc`.`FileID` AS `FileID`,`fcm_cluster_doc`.`ClusterID` AS `ClusterID`,`fcm_cluster_doc`.`FileName` AS `FileName`,`fcm_cluster_doc`.`FileSize` AS `FileSize`,`fcm_cluster_doc`.`FileMemo` AS `FileMemo`,`fcm_cluster_doc`.`FileServer` AS `FileServer`,`fcm_cluster_doc`.`CreateDT` AS `CreateDT`,`fcm_cluster_doc`.`OwnerID` AS `OwnerID` from (`fcm_cluster` join `fcm_cluster_doc` on((`fcm_cluster`.`ClusterID` = `fcm_cluster_doc`.`ClusterID`)));

-- --------------------------------------------------------

--
-- Structure for view `vfcm_cluster_user`
--
DROP TABLE IF EXISTS `vfcm_cluster_user`;

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vfcm_cluster_user` AS select `fcm_cluster_user`.`ClusterID` AS `ClusterID`,`fcm_cluster_user`.`NickName` AS `NickName`,`fcm_user_info`.`UserID` AS `UserID`,`fcm_user_info`.`UserName` AS `UserName`,`fcm_user_info`.`UserPwd` AS `UserPwd`,`fcm_user_info`.`UserNickname` AS `UserNickname`,`fcm_user_info`.`BloodType` AS `BloodType`,`fcm_user_info`.`ConStellation` AS `ConStellation`,`fcm_user_info`.`Career` AS `Career`,`fcm_user_info`.`ShengXiao` AS `ShengXiao`,`fcm_user_info`.`FinishSchool` AS `FinishSchool`,`fcm_user_info`.`HomePage` AS `HomePage`,`fcm_user_info`.`Brief` AS `Brief`,`fcm_user_info`.`EMail` AS `EMail`,`fcm_user_info`.`Address` AS `Address`,`fcm_user_info`.`PostalCode` AS `PostalCode`,`fcm_user_info`.`FixedPhone` AS `FixedPhone`,`fcm_user_info`.`Mobile` AS `Mobile`,`fcm_user_info`.`Birthday` AS `Birthday`,`fcm_user_info`.`Age` AS `Age`,`fcm_user_info`.`Sex` AS `Sex`,`fcm_user_info`.`Country` AS `Country`,`fcm_user_info`.`Province` AS `Province`,`fcm_user_info`.`City` AS `City`,`fcm_user_info`.`ImgIdx` AS `ImgIdx`,`fcm_user_info`.`HasMoney` AS `HasMoney`,`fcm_user_info`.`PwdProtect` AS `PwdProtect`,`fcm_user_info`.`ProtectText` AS `ProtectText`,`fcm_user_info`.`RegTime` AS `RegTime`,`fcm_user_info`.`Member` AS `Member`,`fcm_user_info`.`OnlineTime` AS `OnlineTime`,`fcm_user_info`.`Signature` AS `Signature` from (`fcm_cluster_user` join `fcm_user_info` on((`fcm_cluster_user`.`UserID` = `fcm_user_info`.`UserID`)));

-- --------------------------------------------------------

--
-- Structure for view `vfcm_user_friend`
--
DROP TABLE IF EXISTS `vfcm_user_friend`;

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vfcm_user_friend` AS select `fcm_user_friend`.`OwnerID` AS `OwnerID`,`fcm_user_friend`.`GroupID` AS `GroupID`,`fcm_user_friend`.`FriendID` AS `FriendID`,`fcm_user_info`.`UserName` AS `UserName`,`fcm_user_info`.`UserNickname` AS `UserNickname`,`fcm_user_info`.`ImgIdx` AS `ImgIdx`,`fcm_user_info`.`Member` AS `Member`,`fcm_user_info`.`Sex` AS `Sex`,`fcm_user_friend`.`Name` AS `Name`,`fcm_user_info`.`OnlineTime` AS `OnlineTime`,`fcm_user_info`.`Signature` AS `Signature`,`fcm_user_info`.`CardStyle` AS `CardStyle` from (`fcm_user_friend` join `fcm_user_info` on((`fcm_user_friend`.`FriendID` = `fcm_user_info`.`UserID`)));

-- --------------------------------------------------------

--
-- Structure for view `vfcm_sms_info`
--
DROP TABLE IF EXISTS `vfcm_sms_info`;

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vfcm_sms_info` AS select `fcm_user_info`.`UserID` AS `UserID`,`fcm_user_info`.`UserName` AS `UserName`,`fcm_user_info`.`UserNickname` AS `UserNickname`,`fcm_sms_info`.`PhoneNumbers` AS `PhoneNumbers`,`fcm_sms_info`.`SmsContent` AS `SmsContent`,`fcm_sms_info`.`SendTime` AS `SendTime` from (`fcm_sms_info` join `fcm_user_info`);
