数据库备份文件.sql

功能齐全

# phpMyAdmin SQL Dump
# version 2.5.7
# http://www.phpmyadmin.net
#
# 主机: localhost:3306
# 生成日期: 2005 年 02 月 22 日 22:25
# 服务器版本: 4.0.15
# PHP 版本: 4.3.8
# 
# 数据库 : `user326cxccc`
# 

# --------------------------------------------------------

#
# 表的结构 `friends_conf`
#

CREATE TABLE `friends_conf` (
  `id` int(5) unsigned NOT NULL auto_increment,
  `group` int(3) unsigned NOT NULL default '0',
  `confname` varchar(20) NOT NULL default '',
  `confvalue` varchar(100) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

# --------------------------------------------------------

#
# 表的结构 `friends_setpnt`
#

CREATE TABLE `friends_setpnt` (
  `id` tinyint(3) unsigned NOT NULL auto_increment,
  `group` int(3) NOT NULL default '0',
  `item` varchar(60) NOT NULL default '',
  `act` varchar(30) NOT NULL default '',
  `num` float NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=8 ;

# --------------------------------------------------------

#
# 表的结构 `friends_user`
#

CREATE TABLE `friends_user` (
  `id` int(10) NOT NULL auto_increment,
  `username` varchar(20) NOT NULL default '',
  `pass` varchar(40) NOT NULL default '',
  `email` varchar(40) NOT NULL default '',
  `joindate` date NOT NULL default '0000-00-00',
  `ip` varchar(20) NOT NULL default '',
  `realname` varchar(20) default NULL,
  `sex` tinyint(2) NOT NULL default '0',
  `birth` varchar(15) default NULL,
  `place` tinyint(3) NOT NULL default '0',
  `city` varchar(30) default NULL,
  `address` varchar(80) default NULL,
  `zipcode` varchar(10) default NULL,
  `tel` varchar(15) default NULL,
  `otherinfo` varchar(100) NOT NULL default '',
  `edu` tinyint(3) NOT NULL default '0',
  `job` tinyint(3) NOT NULL default '0',
  `income` tinyint(3) NOT NULL default '0',
  `grade` tinyint(3) NOT NULL default '1',
  `height` tinyint(3) NOT NULL default '0',
  `weight` tinyint(3) NOT NULL default '0',
  `marriage` tinyint(3) NOT NULL default '0',
  `relation` tinyint(3) NOT NULL default '0',
  `skilledlang` varchar(255) NOT NULL default '0',
  `studyinglang` varchar(255) NOT NULL default '0',
  `interest` varchar(255) NOT NULL default '0',
  `drink` tinyint(3) NOT NULL default '0',
  `smoke` tinyint(3) NOT NULL default '0',
  `aboutme` text NOT NULL,
  `update` date NOT NULL default '0000-00-00',
  `uptimes` int(5) NOT NULL default '1',
  `click` int(11) NOT NULL default '0',
  `money` int(11) NOT NULL default '0',
  `active` enum('0','1') NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=29 ;

# --------------------------------------------------------

#
# 表的结构 `friends_words`
#

CREATE TABLE `friends_words` (
  `id` int(5) unsigned NOT NULL auto_increment,
  `writer` varchar(40) NOT NULL default '',
  `from` varchar(60) NOT NULL default '',
  `category` int(3) NOT NULL default '0',
  `title` varchar(100) NOT NULL default '',
  `words` text NOT NULL,
  `date` varchar(10) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=8 ;

# --------------------------------------------------------

#
# 表的结构 `user_album`
#

CREATE TABLE `user_album` (
  `ID` int(7) unsigned NOT NULL auto_increment,
  `username` varchar(50) NOT NULL default '',
  `approved` tinyint(1) NOT NULL default '0',
  `time` varchar(20) NOT NULL default '2000-1-1',
  `path` varchar(40) NOT NULL default 'pic/',
  `fm` tinyint(1) NOT NULL default '0',
  `click` int(10) NOT NULL default '0',
  `name` varchar(60) NOT NULL default '',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=15 ;

# --------------------------------------------------------

#
# 表的结构 `user_charge`
#

CREATE TABLE `user_charge` (
  `username` varchar(20) NOT NULL default '',
  `item` varchar(100) NOT NULL default '',
  `num` float NOT NULL default '0',
  `account` enum('0','1','2') NOT NULL default '0',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  KEY `username` (`username`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# 表的结构 `user_online`
#

CREATE TABLE `user_online` (
  `username` varchar(20) NOT NULL default '',
  `uptime` int(10) NOT NULL default '0'
) TYPE=MyISAM;

# --------------------------------------------------------

#
# 表的结构 `user_pm`
#

CREATE TABLE `user_pm` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `pfrom` varchar(20) NOT NULL default '',
  `pto` varchar(20) NOT NULL default '',
  `title` varchar(60) NOT NULL default '',
  `msg` text NOT NULL,
  `ptime` datetime NOT NULL default '0000-00-00 00:00:00',
  `readed` enum('0','1') NOT NULL default '0',
  `box` enum('1','2') NOT NULL default '1',
  `free` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;