lybbs_mysql_upgrade_6.5to7.0.sql

常见的bbs源代码

# Set names, if mysql version is 4.1.x

#SET NAMES gbk;

# Warnning: This script is only for LyBBS ver 6.5.MySQL to 7.0 upgrade.
ALTER TABLE lybbs_author CHANGE ipfrom ipfrom VARCHAR(64) NOT NULL;
ALTER TABLE lybbs_author CHANGE lastloginip lastloginip VARCHAR(64) NOT NULL;
ALTER TABLE lybbs_posts CHANGE ipfrom ipfrom VARCHAR(64) NOT NULL;
ALTER TABLE lybbs_postvalidate CHANGE ipfrom ipfrom VARCHAR(64) NOT NULL;
ALTER TABLE lybbs_postdelete CHANGE ipfrom ipfrom VARCHAR(64) NOT NULL;
ALTER TABLE lybbs_log CHANGE logip logip VARCHAR(64) NOT NULL;
ALTER TABLE lybbs_uploadinfo ADD blogpostid INT(10) NOT NULL default 0 AFTER postsid;
ALTER TABLE lybbs_uploadinfo ADD INDEX ix_uploadinfo_blogpostid (blogpostid);
ALTER TABLE lybbs_uploadinfo ADD forumid SMALLINT(4) DEFAULT 0 NOT NULL;
ALTER TABLE lybbs_uploadinfo ADD parentid INT(10) DEFAULT 0 NOT NULL;
ALTER TABLE lybbs_uploadinfo ADD title VARCHAR(255) NOT NULL;
update lybbs_uploadinfo a,lybbs_posts b set a.forumid=b.db,a.parentid=b.parentid,a.title=b.title where a.postsid=b.id and a.postsid>0;

CREATE TABLE lyblog_album (
  id int(10) NOT NULL default '0',
  blogid int(10) NOT NULL default '0',
  userid int(10) NOT NULL default '0',
  username varchar(40) NOT NULL default '',
  dirid int(10) NOT NULL default '0',
  filename varchar(80) NOT NULL default '',
  filerealname varchar(100) NOT NULL default '',
  fileext varchar(40) NOT NULL default '',
  filesize int(10) NOT NULL default '0',
  filezoompath varchar(200) NOT NULL default '',
  filepath varchar(200) NOT NULL default '',
  uploadat bigint(14) NOT NULL default '0',
  orderby int(10) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY blogid (blogid),
  KEY userid (userid),
  KEY dirid (dirid)
) TYPE=MyISAM;

CREATE TABLE lyblog_album_dir (
  id int(10) NOT NULL default '0',
  parentid int(10) NOT NULL default '0',
  userid int(10) NOT NULL default '0',
  username varchar(40) NOT NULL default '',
  dirname varchar(100) NOT NULL default '',
  dirdescription varchar(255) NOT NULL default '',
  dirtype tinyint(1) NOT NULL default '0',
  dirpass varchar(60) NOT NULL default '',
  dirimg varchar(200) NOT NULL default '',
  dircount int(10) NOT NULL default '0',
  createat bigint(14) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY userid (userid)
) TYPE=MyISAM;

CREATE TABLE lyblog_blog (
  id int(10) NOT NULL default '0',
  userid int(10) NOT NULL default '0',
  domain varchar(40) NOT NULL default '',
  title varchar(80) NOT NULL default '',
  description varchar(250) NOT NULL default '',
  bgpic varchar(100) NOT NULL default '',
  commentenabled tinyint(1) NOT NULL default '0',
  msgenabled tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY userid (userid),
  KEY ix_blog_domain (domain)
) TYPE=MyISAM;

CREATE TABLE lyblog_catalog (
  id int(10) NOT NULL default '0',
  userid int(10) NOT NULL default '0',
  blogid int(10) NOT NULL default '0',
  title varchar(100) NOT NULL default '',
  PRIMARY KEY  (id,blogid),
  KEY ix_catalog_blogid (blogid),
  KEY ix_catalog_userid (userid)
) TYPE=MyISAM;

CREATE TABLE lyblog_comment (
  id int(10) NOT NULL default '0',
  userid int(10) NOT NULL default '0',
  username varchar(40) NOT NULL default '',
  bloguserid int(10) NOT NULL default '0',
  postid int(10) NOT NULL default '0',
  title varchar(200) NOT NULL default '',
  content text NOT NULL,
  postat bigint(14) NOT NULL default '0',
  postip varchar(64) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY postid (postid),
  KEY ix_comment_bloguserid (bloguserid)
) TYPE=MyISAM;

CREATE TABLE lyblog_favorite (
  id int(10) NOT NULL default '0',
  ownerid int(10) NOT NULL default '0',
  userid int(10) NOT NULL default '0',
  username varchar(40) NOT NULL default '',
  url varchar(200) NOT NULL default '',
  title varchar(200) NOT NULL default '',
  content varchar(255) NOT NULL default '',
  postat bigint(14) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY ownerid (ownerid)
) TYPE=MyISAM;

CREATE TABLE lyblog_link (
  id smallint(5) NOT NULL default '0',
  userid int(10) NOT NULL default '0',
  name varchar(80) NOT NULL default '',
  link varchar(150) NOT NULL default '',
  description varchar(200) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY ix_link_userid (userid)
) TYPE=MyISAM;

CREATE TABLE lyblog_posts (
  id int(10) NOT NULL default '0',
  userid int(10) NOT NULL default '0',
  username varchar(40) NOT NULL default '',
  blogid int(10) NOT NULL default '0',
  catalogid int(10) NOT NULL default '0',
  catalogname varchar(100) NOT NULL default '',
  title varchar(200) NOT NULL default '',
  summary text NOT NULL,
  content text NOT NULL,
  postat bigint(14) NOT NULL default '0',
  postip varchar(64) NOT NULL default '',
  commentnum smallint(5) NOT NULL default '0',
  clicknum int(10) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY userid (userid),
  KEY blogid (blogid),
  KEY catalogid (catalogid)
) TYPE=MyISAM;

update lybbs_publicstyle set membergone=15;