onez.sql

Dedecms5.3泄密版 Dedecms5.3泄密版

DROP TABLE IF EXISTS onez_admin;
CREATE TABLE EXISTS onez_admin (
  id int(11) NOT NULL auto_increment,
  username varchar(20) NOT NULL,
  password varchar(20) NOT NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;
DROP TABLE IF EXISTS onez_freshlist;
CREATE TABLE EXISTS onez_freshlist (
  id int(11) NOT NULL auto_increment,
  username char(40) NOT NULL,
  addtime datetime NOT NULL,
  weburl char(100) NOT NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;
DROP TABLE IF EXISTS onez_members;
CREATE TABLE EXISTS onez_members (
  id int(11) NOT NULL auto_increment,
  username char(40) default NULL,
  password char(32) default NULL,
  locked int(1) NOT NULL default '0',
  infotime datetime NOT NULL,
  grade int(2) default '1',
  email char(80) default NULL,
  webtitle char(80) default NULL,
  weburl char(80) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;
DROP TABLE IF EXISTS onez_urls;
CREATE TABLE EXISTS onez_urls (
  id int(11) NOT NULL auto_increment,
  username char(40) default NULL,
  weburl char(100) default NULL,
  hits bigint(11) NOT NULL default '0',
  locked int(1) NOT NULL default '1',
  PRIMARY KEY  (id)
) TYPE=MyISAM;