mfile.sql

php数据库操作类,access的数据库 欢迎使用

-- phpMyAdmin SQL Dump
-- version 2.8.0.3
-- http://www.phpmyadmin.net
-- 
-- 主机: localhost
-- 生成日期: 2008 年 12 月 29 日 12:28
-- 服务器版本: 5.0.45
-- PHP 版本: 5.2.5
-- 
-- 数据库: `mfile`
-- 

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

-- 
-- 表的结构 `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 ;

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

INSERT INTO `admin` (`id`, `account`, `password`) VALUES (1, 'jixkiss', 'jixkiss');

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

-- 
-- 表的结构 `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 ;

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

INSERT INTO `member` (`UserID`, `UserName`, `PassWord`, `TrueName`, `Email`, `CreateTime`, `LastLoginTime`, `LastLoginIP`, `LoginTimes`, `Role`) VALUES (1, 'admin', 'admin888', '小叶', '[e-mail]', '2008-11-18 00:19:13', '2008-11-17 19:38:35', '127.0.0.1', 15, NULL);

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

-- 
-- 表的结构 `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 ;

-- 
-- 导出表中的数据 `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),