-- phpMyAdmin SQL Dump-- version 2.8.0.3-- http://www.phpmyadmin.net-- -- 主機: localhost-- 生成日期: 2008 年 12 月 29 日 12:28-- 服務(wù)器版本: 5.0.45-- PHP 版本: 5.2.5-- -- 數(shù)據(jù)庫: `mfile`-- -- ---------------------------------------------------------- -- 表的結(jié)構(gòu) `admin`-- CREATE TABLE IF NOT EXISTS `admin` (  `id` int(11) NOT NULL auto_increment,  `account` varchar(20) collate utf8_unicode_ci NOT NULL,  `password` varchar(30) collate utf8_unicode_ci NOT NULL,  PRIMARY KEY  (`id`)) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;-- -- 導(dǎo)出表中的數(shù)據(jù) `admin`-- INSERT INTO `admin` (`id`, `account`, `password`) VALUES (1, 'jixkiss', 'jixkiss');-- ---------------------------------------------------------- -- 表的結(jié)構(gòu) `member`-- CREATE TABLE IF NOT EXISTS `member` (  `UserID` bigint(20) NOT NULL auto_increment,  `UserName` varchar(50) NOT NULL,  `PassWord` varchar(50) NOT NULL,  `TrueName` varchar(50) NOT NULL,  `Email` varchar(50) NOT NULL,  `CreateTime` timestamp NOT NULL default CURRENT_TIMESTAMP,  `LastLoginTime` datetime default NULL,  `LastLoginIP` varchar(20) default NULL,  `LoginTimes` int(11) NOT NULL default '0',  `Role` varchar(250) default NULL,  PRIMARY KEY  (`UserID`)) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gbk AUTO_INCREMENT=2 ;-- -- 導(dǎo)出表中的數(shù)據(jù) `member`-- INSERT INTO `member` (`UserID`, `UserName`, `PassWord`, `TrueName`, `Email`, `CreateTime`, `LastLoginTime`, `LastLoginIP`, `LoginTimes`, `Role`) VALUES (1, 'admin', 'admin888', '小葉', 'ydyhkjy@163.com', '2008-11-18 00:19:13', '2008-11-17 19:38:35', '127.0.0.1', 15, NULL);-- ---------------------------------------------------------- -- 表的結(jié)構(gòu) `message`-- CREATE TABLE IF NOT EXISTS `message` (  `MsgID` bigint(20) NOT NULL auto_increment,  `Title` varchar(50) NOT NULL,  `Content` text NOT NULL,  `CreateTime` timestamp NULL default CURRENT_TIMESTAMP,  `UserID` varchar(50) NOT NULL,  `IsEnabled` int(11) NOT NULL default '0',  PRIMARY KEY  (`MsgID`)) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=gbk AUTO_INCREMENT=29 ;-- -- 導(dǎo)出表中的數(shù)據(jù) `message`-- INSERT INTO `message` (`MsgID`, `Title`, `Content`, `CreateTime`, `UserID`, `IsEnabled`) VALUES (1, 'asdfadsf', 'asdfasdf', '2008-11-18 03:36:53', 'admin', 0),(2, 'asdf', 'asdf', '2008-11-18 03:38:44', 'admin', 0),(3, 'fdas', 'dasf', '2008-11-18 03:39:19', 'admin', 0),(4, 'fdsafasdf', 'asdfadfweasdfwefadsf', '2008-11-18 03:39:33', 'admin', 0),(5, 'dasffsda', 'dasffasd', '2008-11-18 03:40:13', 'admin', 0),(6, 'dasfasdfsadf', 'dasffsfasdfs', '2008-11-18 03:40:38', 'admin', 0),(7, 'sadfdasfdasfadsf', 'dasfasfddasfasdf', '2008-11-18 03:41:33', 'admin', 0),(8, 'asdf', 'asdef', '2008-11-18 03:47:28', 'admin', 0),(9, 'adsf', 'asdasf', '2008-11-18 03:57:09', 'admin', 0),(10, 'adsf', 'asdasf', '2008-11-18 03:59:00', 'admin', 0),(11, 'sdaf', 'adsf', '2008-11-18 03:59:07', 'admin', 0),(12, 'dasf', 'dasf', '2008-11-18 04:02:24', 'admin', 0),(13, 'dasf', 'dasf', '2008-11-18 04:10:14', 'admin', 0),(14, 'asdf', 'adsf', '2008-11-18 04:12:37', 'admin', 0),(15, 'asdf', 'asdf', '2008-11-18 04:19:01', 'admin', 0),(16, 'adsf', 'dasf', '2008-11-18 04:21:23', 'admin', 0),(17, 'adsf', 'dasf', '2008-11-18 04:23:23', 'admin', 0),(18, 'adsf', 'dasf', '2008-11-18 04:23:57', 'admin', 0),(19, 'adsf', 'dasf', '2008-11-18 04:24:08', 'admin', 0),(20, 'adsf', 'dasf', '2008-11-18 04:24:44', 'admin', 0),(21, 'adsf', 'dasf', '2008-11-18 04:31:55', 'admin', 0),(22, 'asdf', 'asdf', '2008-11-18 04:39:08', 'admin', 0),(23, '阿斯蒂芬', '阿斯蒂芬', '2008-11-18 04:50:42', 'admin', 0),(24, '測試', '測試', '2008-12-19 15:00:20', 'Admin', 0),(25, '測試', '測試', '2008-12-19 15:03:20', 'Admin', 0),(26, '測試', '測試', '2008-12-19 15:03:26', 'Admin', 0),(27, '測試', '測試', '2008-12-19 15:03:29', 'Admin', 0),