-- 
-- Ľṹ `##__message`
-- 
DROP TABLE IF EXISTS `##__message`;
CREATE TABLE `##__message` (
  `id` int(11) NOT NULL auto_increment,
  `fromid` int(11) NOT NULL,
  `toid` int(11) NOT NULL,
  `read` int(11) NOT NULL,
  `del` tinyint(4) NOT NULL,
  `store` tinyint(4) NOT NULL,
  `time` int(11) NOT NULL,
  `subject` varchar(100) NOT NULL,
  `body` text NOT NULL,
  `system` tinyint(4) NOT NULL,
  `ip` varchar(24) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM ;

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

-- 
-- Ľṹ `##__passport`
-- 
DROP TABLE IF EXISTS `##__passport`;
CREATE TABLE `##__passport` (
  `uid` int(11) NOT NULL auto_increment,
  `username` varchar(20) NOT NULL,
  `password` varchar(40) NOT NULL,
  `safekey` varchar(10) NOT NULL,
  `email` varchar(60) NOT NULL,
  `regtime` int(11) NOT NULL,
  `regip` varchar(20) NOT NULL,
  PRIMARY KEY  (`uid`)
) ENGINE=MyISAM;

-- 
-- Ľṹ `##__passport_admin`
-- 

DROP TABLE IF EXISTS `##__passport_admin`;
CREATE TABLE `##__passport_admin` (
  `uid` int(11) NOT NULL auto_increment,
  `userid` varchar(20) NOT NULL,
  `name` varchar(40) NOT NULL,
  `privkey` text NOT NULL,
  `loginban` tinyint(1) NOT NULL,
  PRIMARY KEY  (`uid`)
) ENGINE=MyISAM ;

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