逍遥老鬼继续扯淡

逍遥老鬼最近和魔兽世界一起远征，找我的话请去六区桑德兰服务器，记得阵营是部落的。

推荐使用1024以上分辨率浏览本站，此处广告位招商……

记录一下

10:55 AM 2005-05-31 | 逍遥老鬼 | 日志分类：网络技术

刚才又帮一哥们装了个计数器在我的空间上边，还是mysql的，他的数据结构极乱，弄的我搞不清楚谁是谁了，把导入的数据记录下，以后删除也方便。

# phpMyAdmin SQL Dump
# version 2.5.4
# http://www.phpmyadmin.net
#
# 主机: localhost
# 生成日期: 2004 年 12 月 23 日 15:26
# 服务器版本: 4.0.18
# PHP 版本: 4.3.8
#
# 数据库 : `cq_soft`
#

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

#
# 表的结构 `ad_inc`
#

DROP TABLE IF EXISTS ad_inc;
CREATE TABLE ad_inc (
id bigint(20) unsigned NOT NULL auto_increment,
ad_pos varchar(50) default NULL,
ad_inc_file varchar(30) default NULL,
ad_type char(2) default NULL,
ad_prog text,
ad_use char(2) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM AUTO_INCREMENT=47 ;

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

#
# 表的结构 `ad_main`
#

DROP TABLE IF EXISTS ad_main;
CREATE TABLE ad_main (
id bigint(20) unsigned NOT NULL auto_increment,
ad_title varchar(50) default NULL,
ad_url varchar(100) default NULL,
ad_file varchar(30) default NULL,
ad_size varchar(10) default NULL,
ad_indate datetime default NULL,
ad_outdate datetime default NULL,
ad_type char(2) default NULL,
ad_intro text,
ad_use char(2) default NULL,
ad_color varchar(30) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM AUTO_INCREMENT=94 ;

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

#
# 表的结构 `administrators`
#

DROP TABLE IF EXISTS administrators;
CREATE TABLE administrators (
id bigint(20) unsigned NOT NULL auto_increment,
admin varchar(50) default NULL,
pass varchar(150) default NULL,
pope char(3) default NULL,
used char(1) default NULL,
indate datetime default NULL,
reco varchar(20) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

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

#
# 表的结构 `affiche`
#

DROP TABLE IF EXISTS affiche;
CREATE TABLE affiche (
id bigint(20) unsigned NOT NULL auto_increment,
subject varchar(250) default NULL,
content text,
writer varchar(30) default NULL,
indate datetime default NULL,
used char(1) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM AUTO_INCREMENT=12 ;

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

#
# 表的结构 `chan_info`
#

DROP TABLE IF EXISTS chan_info;
CREATE TABLE chan_info (
id bigint(20) unsigned NOT NULL auto_increment,
chan_name varchar(30) default NULL,
chan_link varchar(200) default NULL,
open_new char(1) default NULL,
indate datetime default NULL,
used char(1) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM AUTO_INCREMENT=16 ;

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

#
# 表的结构 `cnt_adm_user`
#

DROP TABLE IF EXISTS cnt_adm_user;
CREATE TABLE cnt_adm_user (
id bigint(20) unsigned NOT NULL auto_increment,
username varchar(30) default NULL,
password varchar(30) default NULL,
indate datetime default NULL,
used char(1) default NULL,
total_ip bigint(20) unsigned default NULL,
total_view bigint(20) unsigned default NULL,
today_ip bigint(20) unsigned default NULL,
today_view bigint(20) unsigned default NULL,
lastdate datetime default NULL,
website varchar(50) default NULL,
weburl varchar(200) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM AUTO_INCREMENT=14 ;

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

#
# 表的结构 `cnt_admin`
#

DROP TABLE IF EXISTS cnt_admin;
CREATE TABLE cnt_admin (
id bigint(20) unsigned NOT NULL auto_increment,
admin varchar(50) default NULL,
pass varchar(50) default NULL,
indate datetime default NULL,
used char(1) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

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

#
# 表的结构 `forum_admin`
#

DROP TABLE IF EXISTS forum_admin;
CREATE TABLE forum_admin (
id bigint(20) unsigned NOT NULL auto_increment,
admin varchar(30) default NULL,
pass varchar(100) default NULL,
pope char(2) default NULL,
used char(1) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

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

#
# 表的结构 `forum_info`
#

DROP TABLE IF EXISTS forum_info;
CREATE TABLE forum_info (
id bigint(20) unsigned NOT NULL auto_increment,
rootid bigint(20) unsigned default NULL,
ordernum double default NULL,
deep int(10) unsigned default NULL,
subject varchar(250) default NULL,
content text,
indate datetime default NULL,
lastdate datetime default NULL,
annexsize varchar(20) default NULL,
annexfile varchar(30) default NULL,
brow varchar(20) default NULL,
clicked bigint(20) unsigned default NULL,
tip char(1) default NULL,
used char(1) default NULL,
locked char(1) default NULL,
username varchar(30) default NULL,
nickname varchar(30) default NULL,
reco varchar(20) default NULL,
ip_addr varchar(30) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM AUTO_INCREMENT=1651 ;

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

#
# 表的结构 `forum_user`
#

DROP TABLE IF EXISTS forum_user;
CREATE TABLE forum_user (
id bigint(20) unsigned NOT NULL auto_increment,
username varchar(30) default NULL,
password varchar(80) default NULL,
nickname varchar(30) default NULL,
usersex char(1) default NULL,
email varchar(80) default NULL,
qqnum varchar(20) default NULL,
weburl varchar(150) default NULL,
reco varchar(30) default NULL,
face varchar(100) default NULL,
album varchar(254) default NULL,
used char(1) default NULL,
userlevel char(2) default NULL,
indate datetime default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM AUTO_INCREMENT=1177 ;

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

#
# 表的结构 `hot_soft`
#

DROP TABLE IF EXISTS hot_soft;
CREATE TABLE hot_soft (
id bigint(20) unsigned NOT NULL auto_increment,
sf_image varchar(30) default NULL,
sf_name varchar(100) default NULL,
sf_intro text,
sf_link varchar(200) default NULL,
indate datetime default NULL,
used char(1) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM AUTO_INCREMENT=14 ;

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

#
# 表的结构 `index_links`
#

DROP TABLE IF EXISTS index_links;
CREATE TABLE index_links (
id bigint(20) unsigned NOT NULL auto_increment,
website varchar(50) default NULL,
weburl varchar(200) default NULL,
used char(1) default NULL,
indate datetime default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM AUTO_INCREMENT=20 ;

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

#
# 表的结构 `index_logos`
#

DROP TABLE IF EXISTS index_logos;
CREATE TABLE index_logos (
id bigint(20) unsigned NOT NULL auto_increment,
website varchar(50) default NULL,
logofile varchar(30) default NULL,
weburl varchar(200) default NULL,
indate datetime default NULL,
used char(1) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM AUTO_INCREMENT=16 ;

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

#
# 表的结构 `onl_admin`
#

DROP TABLE IF EXISTS onl_admin;
CREATE TABLE onl_admin (
id bigint(3) unsigned NOT NULL auto_increment,
admin varchar(50) default NULL,
pass varchar(50) default NULL,
used char(1) default NULL,
pope char(2) default NULL,
indate datetime default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

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

#
# 表的结构 `onl_user`
#

DROP TABLE IF EXISTS onl_user;
CREATE TABLE onl_user (
id bigint(3) unsigned NOT NULL auto_increment,
username varchar(30) default NULL,
indate datetime default NULL,
used char(1) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

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

#
# 表的结构 `sf_info`
#

DROP TABLE IF EXISTS sf_info;
CREATE TABLE sf_info (
id bigint(20) unsigned NOT NULL auto_increment,
softid varchar(30) default NULL,
softname varchar(80) default NULL,
softsize bigint(20) default NULL,
softtype varchar(20) default NULL,
softrcmd char(3) default NULL,
softintro text,
softdate datetime default NULL,
softhits bigint(20) unsigned default NULL,
softlock char(2) default NULL,
softassoc varchar(50) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM AUTO_INCREMENT=303 ;

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

#
# 表的结构 `sf_path`
#

DROP TABLE IF EXISTS sf_path;
CREATE TABLE sf_path (
downid bigint(20) unsigned default NULL,
softid varchar(30) default NULL,
downinfo varchar(50) default NULL,
downurl varchar(200) default NULL
) TYPE=MyISAM;

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

#
# 表的结构 `sf_server`
#

DROP TABLE IF EXISTS sf_server;
CREATE TABLE sf_server (
server_url varchar(50) default NULL
) TYPE=MyISAM;