
-- 
-- Ľṹ `##__message`
-- 

DROP TABLE IF EXISTS `##__message`;
CREATE TABLE `##__message` (
  `id` int(11) NOT NULL auto_increment,
  `fromid` int(11) NOT NULL default '0',
  `toid` int(11) NOT NULL default '0',
  `read` int(11) NOT NULL default '0',
  `del` tinyint(4) NOT NULL default '0',
  `store` tinyint(4) NOT NULL default '0',
  `time` int(11) NOT NULL default '0',
  `subject` varchar(100) NOT NULL default '',
  `body` text NOT NULL,
  `system` tinyint(4) NOT NULL default '0',
  `ip` varchar(24) NOT NULL default '',
  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 default '',
  `password` varchar(40) NOT NULL default '',
  `safekey` varchar(10) NOT NULL default '',
  `email` varchar(60) NOT NULL default '',
  `regtime` int(11) NOT NULL default '0',
  `regip` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`uid`),
  UNIQUE KEY `username` (`username`)
) 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 default '',
  `name` varchar(40) NOT NULL default '',
  `privkey` text NOT NULL,
  `loginban` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`uid`)
) ENGINE=MyISAM ;
