install_duoxun.sql

程序安装简便容易

DROP TABLE IF EXISTS duoxun_settings;
CREATE TABLE duoxun_settings (
  name varchar(32) NOT NULL default '',
  value text NOT NULL,
  PRIMARY KEY  (name)
) TYPE=MyISAM;

INSERT INTO duoxun_settings(name,value) VALUES('name','多讯网');
INSERT INTO duoxun_settings(name,value) VALUES('url','http://www.duoxun.com');
INSERT INTO duoxun_settings(name,value) VALUES('ceomail','[e-mail]');
INSERT INTO duoxun_settings(name,value) VALUES('news','新闻公告');
INSERT INTO duoxun_settings(name,value) VALUES('news_num','9');
INSERT INTO duoxun_settings(name,value) VALUES('index_num','7');
INSERT INTO duoxun_settings(name,value) VALUES('list_num','25');
INSERT INTO duoxun_settings(name,value) VALUES('postmax','50000');
INSERT INTO duoxun_settings(name,value) VALUES('comment_num','35');
INSERT INTO duoxun_settings(name,value) VALUES('newslength','50');
INSERT INTO duoxun_settings(name,value) VALUES('subjectlength','38');
INSERT INTO duoxun_settings(name,value) VALUES('listrightlength','30');
INSERT INTO duoxun_settings(name,value) VALUES('listright_num','7');
INSERT INTO duoxun_settings(name,value) VALUES('toppiclength','26');
INSERT INTO duoxun_settings(name,value) VALUES('allowupload','0');
INSERT INTO duoxun_settings(name,value) VALUES('uploadmaxsize','2048000');
INSERT INTO duoxun_settings(name,value) VALUES('uploadfiletype','gif jpg rar txt zip swf jqf');
INSERT INTO duoxun_settings(name,value) VALUES('upload','upload');
INSERT INTO duoxun_settings(name,value) VALUES('attachnum','4');
INSERT INTO duoxun_settings(name,value) VALUES('indexlink','1');
INSERT INTO duoxun_settings(name,value) VALUES('bbs_login','0');
INSERT INTO duoxun_settings(name,value) VALUES('indexbbs','0');
INSERT INTO duoxun_settings(name,value) VALUES('whichbbs','');
INSERT INTO duoxun_settings(name,value) VALUES('bbsdir','bbs');
INSERT INTO duoxun_settings(name,value) VALUES('templateid','1');
INSERT INTO duoxun_settings(name,value) VALUES('ifhtml','0');
INSERT INTO duoxun_settings(name,value) VALUES('obstart','1');
INSERT INTO duoxun_settings(name,value) VALUES('hash','');
INSERT INTO duoxun_settings(name,value) VALUES('logo','logo.gif');
INSERT INTO duoxun_settings(name,value) VALUES('banner','banner.gif');
INSERT INTO duoxun_settings(name,value) VALUES('seotitle','');
INSERT INTO duoxun_settings(name,value) VALUES('keywords','多讯,多讯网,duoxun,http://www.duoxun.com,');
INSERT INTO duoxun_settings(name,value) VALUES('description','http://www.duoxun.com  - 多讯网');
INSERT INTO duoxun_settings(name,value) VALUES('rg_allowreg','1');
INSERT INTO duoxun_settings(name,value) VALUES('rg_regminname','3');
INSERT INTO duoxun_settings(name,value) VALUES('rg_regmaxname','12');
INSERT INTO duoxun_settings(name,value) VALUES('rg_rglower','0');
INSERT INTO duoxun_settings(name,value) VALUES('rg_fbname','duoxun,duoxun.com,多讯,多讯网,admin');

DROP TABLE IF EXISTS duoxun_members;
CREATE TABLE duoxun_members (
  uid mediumint(8) unsigned NOT NULL auto_increment,
  username varchar(15) NOT NULL default '',
  password varchar(40) NOT NULL default '',
  email varchar(60) NOT NULL default '',
  groupid tinyint(3) NOT NULL default '0',
  gender tinyint(1) NOT NULL default '3',
  bday date NOT NULL default '0000-00-00',
  qq varchar(12) NOT NULL default '',
  site varchar(75) NOT NULL default '',
  introduce text NOT NULL default '',
  regdate int(10) unsigned NOT NULL default '0',
  regip varchar(15) NOT NULL default '',
  lastip varchar(15) NOT NULL default '',
  p_num tinyint(3) unsigned NOT NULL default '0',
  c_num tinyint(3) unsigned NOT NULL default '0',
  lastlogin int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (uid),
  UNIQUE username (username)
) TYPE=MyISAM;

DROP TABLE IF EXISTS duoxun_links;
CREATE TABLE duoxun_links (
  sid smallint(6) unsigned NOT NULL auto_increment,
  displayorder tinyint(3) NOT NULL default '0',
  name char(100) NOT NULL default '',
  url char(100) NOT NULL default '',
  descrip char(200) NOT NULL default 'http://www.duoxun.com  多讯网',
  logo char(100) NOT NULL default '',
  PRIMARY KEY  (sid)
) TYPE=MyISAM;

INSERT INTO duoxun_links (sid,displayorder,name,url,descrip,logo ) VALUES('','0','多讯网','http://www.duoxun.com','http://www.duoxun.com  多讯网','./images/duoxun/logo.gif');

DROP TABLE IF EXISTS duoxun_templates;
CREATE TABLE duoxun_templates (
  templateid smallint(6) unsigned NOT NULL auto_increment,
  name char(30) NOT NULL default '',
  charset varchar(30) NOT NULL default '',
  tplpath char(50) NOT NULL default '',
  imgpath char(50) NOT NULL default '',
  PRIMARY KEY  (templateid)
) TYPE=MyISAM;

INSERT INTO duoxun_templates VALUES (1,'duoxun','gb2312','template/duoxun','images/duoxun');

DROP TABLE IF EXISTS duoxun_sort;
CREATE TABLE duoxun_sort (
  sid smallint(6) unsigned NOT NULL auto_increment,
  name char(50) NOT NULL default '',
  vieworder tinyint(3) NOT NULL default '0',
  ifcheck tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (sid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS duoxun_upload;
CREATE TABLE duoxun_upload (
  upid mediumint(8) unsigned NOT NULL auto_increment,
  uid mediumint(8) unsigned NOT NULL default '0',
  aid mediumint(8) unsigned NOT NULL default '0',
  name char(80) NOT NULL default '',
  type char(30) NOT NULL default '',
  size int(10) unsigned NOT NULL default '0',
  uploadurl char(80) NOT NULL default '0',
  uploadtime int(10) NOT NULL default '0',
  PRIMARY KEY  (upid),
  KEY  (uid),
  KEY  (type)
) TYPE=MyISAM;

DROP TABLE IF EXISTS duoxun_wordfb;
CREATE TABLE duoxun_wordfb (
  id smallint(6) unsigned NOT NULL auto_increment,
  word varchar(100) NOT NULL default '',
  wordreplace varchar(100) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

DROP TABLE IF EXISTS duoxun_subject;
CREATE TABLE duoxun_subject (
  aid mediumint(8) unsigned NOT NULL auto_increment,
  sid smallint(6) NOT NULL default '0',
  title_color char(15) NOT NULL default '',
  title_extra char(15) NOT NULL default '',
  author char(15) NOT NULL default '',
  authorid mediumint(8) unsigned NOT NULL default '0',
  itfrom varchar(30) NOT NULL default '',
  subject char(100) NOT NULL default '',
  hits int(10) unsigned NOT NULL default '0',
  cnum int(10) unsigned NOT NULL default '0',
  topped smallint(6) NOT NULL default '0',
  ifshow tinyint(1) NOT NULL default '1',
  postdate int(10) unsigned NOT NULL default '0',
  userip varchar(15) NOT NULL default '',
  ipfrom varchar(80) NOT NULL default '',
  ifcommect tinyint(1) NOT NULL default '1',
  commect_check tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (aid),
  KEY authorid  (authorid),
  KEY topped  (topped)
) TYPE=MyISAM;

DROP TABLE IF EXISTS duoxun_content;
CREATE TABLE duoxun_content (
  aid mediumint(8) unsigned NOT NULL default '0',
  pid mediumint(8) NOT NULL default '1',
  content mediumtext NOT NULL default ''
) TYPE=MyISAM;

DROP TABLE IF EXISTS duoxun_comment;
CREATE TABLE duoxun_comment (
  cid int(10) unsigned NOT NULL auto_increment,
  sid smallint(6) unsigned NOT NULL default '0',
  aid mediumint(8) unsigned NOT NULL default '0',
  author varchar(15) NOT NULL default '',
  postdate int(10) unsigned NOT NULL default '0',
  ifshow tinyint(1) NOT NULL default '1',
  userip varchar(15) NOT NULL default '',
  ipfrom varchar(30) NOT NULL default '',
  content mediumtext NOT NULL default '',
  PRIMARY KEY  (cid),
  KEY sid (sid),
  KEY aid (aid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS duoxun_news;
CREATE TABLE duoxun_news (
  aid smallint(6) unsigned NOT NULL auto_increment,
  postdate int(10) unsigned NOT NULL default '0',
  topped smallint(6) NOT NULL default '0',
  author varchar(15) NOT NULL default '',
  itfrom varchar(30) NOT NULL default '',
  title_color char(15) NOT NULL default '',
  title_extra char(15) NOT NULL default '',
  subject varchar(100) NOT NULL default '',
  content mediumtext NOT NULL default '',
  hits int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (aid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS duoxun_toppic;
CREATE TABLE duoxun_toppic (
  tpid smallint(6) unsigned NOT NULL auto_increment,
  displayorder tinyint(3) NOT NULL default '0',
  title varchar(100) NOT NULL default '',
  picurl char(100) NOT NULL default '',
  linkurl char(100) NOT NULL default '',
  PRIMARY KEY  (tpid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS duoxun_bbs;
CREATE TABLE duoxun_bbs (
  bid smallint(5) unsigned NOT NULL auto_increment,
  showorder tinyint(3) NOT NULL default '0',
  bname char(50) NOT NULL default '',
  bcode text NOT NULL,
  bmore varchar(255) NOT NULL default '',
  PRIMARY KEY (bid)
) TYPE=MyISAM;