links.sql

晕了

# phpMyAdmin MySQL-Dump
# http://127.0.0.1/my/
#
# 主机: localhost 数据库 : mygjp
# --------------------------------------------------------  
#
# 数据表的结构 'links_users'
#

CREATE TABLE links_users (
   id int(11) DEFAULT '0' NOT NULL auto_increment,
   name varchar(20) NOT NULL,
   password varchar(20) NOT NULL,
   email varchar(63) NOT NULL,
   sitename varchar(14) NOT NULL,
   siteurl varchar(63) DEFAULT 'http://' NOT NULL,
   sitetype int(11) DEFAULT '0' NOT NULL,
   sitesubtype int(11) DEFAULT '1' NOT NULL,
   siteintro varchar(63) NOT NULL,
   account int(11) DEFAULT '0' NOT NULL,
   bgcolor varchar(6) NOT NULL,
   exchgtype int(11) DEFAULT '0' NOT NULL,
   referid varchar(20),
   question varchar(63) NOT NULL,
   answer varchar(63) NOT NULL,
   realname varchar(10),
   sex int(11),
   birthday date,
   signupday date DEFAULT '0000-00-00' NOT NULL,
   status int(11) DEFAULT '0' NOT NULL,
   counter int(11) DEFAULT '0' NOT NULL,
   style int(11) DEFAULT '1' NOT NULL,
   textcolor varchar(6) DEFAULT '000000' NOT NULL,
   lbordercolor varchar(6) DEFAULT '6699ff' NOT NULL,
   dbordercolor varchar(6) DEFAULT 'ffffff' NOT NULL,
   account_in int(11) DEFAULT '0' NOT NULL,
   account_out int(11) DEFAULT '0' NOT NULL,
   cpd int(11) DEFAULT '0' NOT NULL,
   activetime datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
   PRIMARY KEY (id),
   KEY id (id)
);

#
# 数据表的结构 'links_hits'
#

CREATE TABLE links_hits (
   ip varchar(15) NOT NULL,
   fromid int(11) DEFAULT '0' NOT NULL,
   toid int(11) DEFAULT '0' NOT NULL,
   time datetime DEFAULT '0000-00-00 00:00:00' NOT NULL
);