structure.sql

一个很好的同学录,PHP+TXT,没有数据库的网友的最好选择

#
# 表的结构 `member`
#

CREATE TABLE `mc_member` (
  `id` varchar(12) binary NOT NULL default '',
  `pass` varchar(16) NOT NULL default '',
  `name` varchar(8) binary default NULL,
  `sex` int(1) default '0',
  `Email` varchar(50) default NULL,
  `birthday` date default NULL,
  `unit` varchar(50) default NULL,
  `address` varchar(50) default NULL,
  `postcode` int(6) unsigned zerofill default NULL,
  `phone` varchar(15) default NULL,
  `QQ` int(10) unsigned default NULL,
  `mobile` varchar(15) default NULL,
  `brief` text,
  `power` int(1) NOT NULL default '0',
  `jointime` datetime default NULL,
  `lastlogin` datetime default NULL,
  `lastIP` varchar(15) default NULL,
  `logintimes` int(4) default '0',
  UNIQUE KEY `id` (`id`)
) TYPE=MyISAM;


#
# 表的结构 `pix`
#

CREATE TABLE `mc_pix` (
  `ID` int(3) NOT NULL auto_increment,
  `filename` int(6) NOT NULL default '0',
  `owner` varchar(12) NOT NULL default '',
  `oldname` varchar(20) NOT NULL default '',
  `size` int(6) NOT NULL default '0',
  `type` int(1) NOT NULL default '0',
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `height` int(4) NOT NULL default '0',
  `width` int(4) NOT NULL default '0',
  `brief` text,
  `clicks` int(3) NOT NULL default '0',
  UNIQUE KEY `ID` (`ID`),
  UNIQUE KEY `filename` (`filename`)
) TYPE=MyISAM;

#
# 表的结构 `word`
#

CREATE TABLE `mc_word` (
  `id` int(4) NOT NULL auto_increment,
  `author` varchar(12) NOT NULL default '',
  `content` text NOT NULL,
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  UNIQUE KEY `id` (`id`)
) TYPE=MyISAM;