SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- database: `UniMateWebAuthentication`
--

CREATE DATABASE IF NOT EXISTS `UniMateWebAuthentication`;

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

--
-- table structure `OperatorInfo`
--

CREATE TABLE IF NOT EXISTS `OperatorInfo` (
  `OperatorId` varchar(20) NOT NULL PRIMARY KEY,
  `Password` varchar(40) default NULL,
  `Remark` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- item `OperatorInfo`
--

INSERT INTO `OperatorInfo` (`OperatorID`, `Password`, `Remark`) VALUES
('administrator', '7c4a8d09ca3762af61e59520943dc26494f8941b', 'super operator');

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

--
-- table structure `UniMateToken_UserInfo`
--

CREATE TABLE IF NOT EXISTS `UniMateToken_UserInfo` (
  `RecordID` varchar(20) NOT NULL PRIMARY KEY,
  `Credential` char(32) NOT NULL,
  `Active` int(11) default '0',
  `UniMateID` varchar(20) default NULL,
  `UserID` varchar(10) default NULL,
  `UserInfo` text,
  `TokenType` tinyint(4) NOT NULL default '1',
  `rand` int(12) unsigned default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
