member_backup.sql

php开发实例完全剖析

/* 
SQLyog v3.71
Host - localhost : Database - member
**************************************************************
Server version 4.1.7-nt
*/

create database if not exists `member`;

use `member`;

/*
Table structure for member
*/

drop table if exists `member`;
CREATE TABLE `member` (
  `id` varchar(20) NOT NULL default '',
  `name` varchar(10) NOT NULL default '',
  `password` varchar(50) NOT NULL default '',
  `sex` varchar(4) NOT NULL default '',
  `email` varchar(50) NOT NULL default '',
  `oicq` varchar(20) default NULL,
  `homepage` varchar(50) default NULL,
  `city` varchar(14) default NULL,
  `address` varchar(80) default NULL,
  `zip` varchar(10) default NULL,
  `tel` varchar(14) default NULL,
  `edu` varchar(10) default NULL,
  `introduction` varchar(250) default NULL,
  `interest` varchar(100) default NULL,
  `birthday` date NOT NULL default '0000-00-00',
  `photo` longblob,
  `regtime` datetime NOT NULL default '0000-00-00 00:00:00',
  `regip` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*
Table data for member.member
*/

INSERT INTO `member` VALUES 
('abc','张名','e10adc3949ba59abbe56e057f20f883e','女','[e-mail]','4561232','www.zhangming.com','北京','海淀','100888','','大学','very Good!','All','1980-10-28','','2005-01-09 22:19:38','127.0.0.1'),
('admin','管理员','e10adc3949ba59abbe56e057f20f883e','男','[e-mail]','','','','','','','','','','1978-01-01','','2005-01-10 14:42:37','127.0.0.1'),
('def','klk','e10adc3949ba59abbe56e057f20f883e','男','w@t.m','','','','','','','','','','1983-09-09','','2005-01-09 22:22:08','127.0.0.1'),
('似的','jkl','e10adc3949ba59abbe56e057f20f883e','男','jkl@t.m','','','','','','','','','','1934-01-01','','2005-01-09 22:55:25','127.0.0.1'),
('fw','fw','e10adc3949ba59abbe56e057f20f883e','男','s@s.s','1563251','北京','','','','','','No','','1964-01-01','','2005-01-09 23:19:49','127.0.0.1'),
('jjj','照例','e10adc3949ba59abbe56e057f20f883e','男','zh@z.h','','','','','','','','','','1967-07-03','','2005-01-09 22:26:15','127.0.0.1'),
('local','网名','e10adc3949ba59abbe56e057f20f883e','男','[e-mail]','','','','','','','','','','1980-01-01','','2005-01-08 11:53:13','127.0.0.1'),
('qqq','klk','e10adc3949ba59abbe56e057f20f883e','男','w@t.m','','','','','','','','','','1983-09-09','','2005-01-09 22:25:00','127.0.0.1'),
('S','S','e10adc3949ba59abbe56e057f20f883e','男','s@s.s','','','','','','','','','','1964-01-01','BROWSE.GIF','2005-01-09 23:16:47','127.0.0.1'),
('sdf','jkl','e10adc3949ba59abbe56e057f20f883e','男','jkl@t.m','','','','','','','','','','1934-01-01','','2005-01-09 22:53:35','127.0.0.1'),
('skl','jkl','e10adc3949ba59abbe56e057f20f883e','男','jkl@t.m','','','','','','','','','','1934-01-01','','2005-01-09 22:51:54','127.0.0.1');