⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 lybbs_mysql_upgrade_7.1to7.2.sql

📁 一个学习型的论坛适合于初学者的参考和学习
💻 SQL
字号:
🔍 
# Set names, if mysql version is 4.1.x

#SET NAMES gbk;

# Warnning: This script is only for LyBBS ver 7.1.MySQL to 7.2 upgrade.
update lybbs_author set isonline='0' where isonline!='0';
ALTER TABLE lybbs_author CHANGE viewmode blogid INT(10) DEFAULT 0 NOT NULL;
ALTER TABLE lybbs_author CHANGE isonline isonline TINYINT(1) DEFAULT 0 NOT NULL;
ALTER TABLE lybbs_posts CHANGE title title VARCHAR(100)  NOT NULL;
update lybbs_author set username='guest1' where username='Guest';
INSERT INTO lybbs_author (id, usergroupid, username, password, msgpopup, myinfo, mess, advpost, hidden, onlineview, threadages, blogid, email, showemail, lostquestion, lostanswer, sex, education, marry, work, birthday, astro, usersx, homepage, qq, icq, country, province, city, timedifference, introdution, signature, notshowsignature, imagename, imageurl, imagewidth, imageheight, lastactivetime, logintime, activetime, registertime, isonline, mark, nposts, ndelete, nreply, money, experience, charm, visittimes, newmembertitle, newsocialpart, status, allowprivate, styleid, ipfrom, usermode, grade, freshtime, warmindex, lastposttime, lastloginip) VALUES (0, 0, 'Guest', '123456', '1', '0', '', '0', '0', '1', 0, 0, 'guest@guest.com', '0', '', '', 'sect', 'secret', 'secret', 'secret', '1900-01-01', 'secret', 'secret', 'http://', '', '', '', '', '', 0, '', '', '0', 'noavatar.gif', '', 0, 0, now(), now(), now(), now(), 0, 0, 0, 0, 0,0,0,0,0, '','', '0', '0',0, '127.0.0.1', 1,0,0,0,0,'127.0.0.1');
DROP TABLE lybbs_postvalidate;
DROP TABLE lybbs_postdelete;

CREATE TABLE lybbs_postlist (
  id int(10) NOT NULL default 0,
  forumid smallint(4) NOT NULL default 0,
  authorid int(10) NOT NULL default 0,
  author varchar(40) NOT NULL default '',
  title varchar(80) NOT NULL default '',
  postat int(10) NOT NULL default 0,
  titleicon varchar(20) NOT NULL default '',
  accessaryimg tinyint(1) NOT NULL default 0,
  accessaryext varchar(6) NOT NULL default '',
  accessarypath varchar(60) NOT NULL default '',
  clicktimes int(6) NOT NULL default 0,
  replynum int(8) NOT NULL default 0,
  votenum int(8) NOT NULL default 0,
  locktop tinyint(1) NOT NULL default 0,
  locktopid smallint(4) NOT NULL default 0,
  lockreply tinyint(1) NOT NULL default 0,
  lockvote tinyint(1) NOT NULL default 0,
  vote tinyint(1) NOT NULL default 0,
  elite tinyint(1) NOT NULL default 0,
  invisible tinyint(1) NOT NULL default 0,
  color varchar(7) NOT NULL default '',
  boldcode tinyint(1) NOT NULL default 0,
  lastauthorid int(10) NOT NULL default 0,
  lastauthor varchar(40) NOT NULL default '',
  lastpostat int(10) NOT NULL default 0,
  lastpostclue varchar(80) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY forumid (forumid), 
  KEY authorid (authorid),
  KEY locktop (locktop),
  KEY elite (elite),
  KEY lastpostat (lastpostat)
) TYPE=MyISAM;

CREATE TABLE lybbs_posttopic (
  id int(10) NOT NULL default 0,
  forumid smallint(4) NOT NULL default 0,
  authorid int(10) NOT NULL default 0,
  author varchar(40) NOT NULL default '',
  title varchar(80) NOT NULL default '',
  content text NOT NULL,
  postat int(10) NOT NULL default 0,
  postattime datetime NOT NULL default '1900-01-01 00:00:00',
  postip varchar(64) NOT NULL default '',
  titleicon varchar(20) NOT NULL default '',
  accessary tinyint(1) NOT NULL default 0,
  clicktimes int(6) NOT NULL default 0,
  replynum int(8) NOT NULL default 0,
  votenum int(8) NOT NULL default 0,
  locktop tinyint(1) NOT NULL default 0,
  locktopid smallint(4) NOT NULL default 0,
  lockreply tinyint(1) NOT NULL default 0,
  lockvote tinyint(1) NOT NULL default 0,
  vote tinyint(1) NOT NULL default 0,
  votecondition tinyint(2) NOT NULL default 0,
  elite tinyint(1) NOT NULL default 0,
  invisible tinyint(1) NOT NULL default 0,
  showsign tinyint(1) NOT NULL default 0,
  color varchar(7) NOT NULL default '',
  boldcode tinyint(1) NOT NULL default 0,
  viewmode tinyint(1) NOT NULL default 0,
  viewnumber int(10) NOT NULL default 0,
  lasteditauthorid int(10) NOT NULL default 0,
  lasteditauthor varchar(40) NOT NULL default '',
  lasteditat int(10) NOT NULL default 0,
  lasteditip varchar(64) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY forumid (forumid),
  KEY authorid (authorid),
  KEY postat (postat)
) TYPE=MyISAM;

CREATE TABLE lybbs_postreply (
  id int(10) NOT NULL default 0,
  forumid smallint(4) NOT NULL default 0,
  topicid int(10) NOT NULL default 0,
  authorid int(10) NOT NULL default 0,
  author varchar(40) NOT NULL default '',
  title varchar(90) NOT NULL default '',
  content text NOT NULL,
  postat int(10) NOT NULL default 0,
  postattime datetime NOT NULL default '1900-01-01 00:00:00',
  postip varchar(64) NOT NULL default '',
  titleicon varchar(20) NOT NULL default '',
  accessary tinyint(1) NOT NULL default 0,
  invisible tinyint(1) NOT NULL default 0,
  showsign tinyint(1) NOT NULL default 0,
  viewmode tinyint(1) NOT NULL default 0,
  viewnumber int(10) NOT NULL default 0,
  lasteditauthorid int(10) NOT NULL default 0,
  lasteditauthor varchar(40) NOT NULL default '',
  lasteditat int(10) NOT NULL default 0,
  lasteditip varchar(64) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY forumid (forumid),
  KEY topicid (topicid),
  KEY authorid (authorid),
  KEY postat (postat)
) TYPE=MyISAM;

CREATE TABLE lybbs_postvalidate (
  id int(10) NOT NULL default 0,
  forumid smallint(4) NOT NULL default 0,
  topicid int(10) NOT NULL default 0,
  authorid int(10) NOT NULL default 0,
  author varchar(40) NOT NULL default '',
  title varchar(80) NOT NULL default '',
  content text NOT NULL,
  postat int(10) NOT NULL default 0,
  postip varchar(64) NOT NULL default '',
  titleicon varchar(20) NOT NULL default '',
  accessary tinyint(1) NOT NULL default 0,
  accessaryimg tinyint(1) NOT NULL default 0,
  accessaryext varchar(6) NOT NULL default '',
  accessarypath varchar(60) NOT NULL default '',
  clicktimes int(6) NOT NULL default 0,
  replynum int(8) NOT NULL default 0,
  votenum int(8) NOT NULL default 0,
  locktop tinyint(1) NOT NULL default 0,
  locktopid smallint(4) NOT NULL default 0,
  lockreply tinyint(1) NOT NULL default 0,
  lockvote tinyint(1) NOT NULL default 0,
  vote tinyint(1) NOT NULL default 0,
  votecondition tinyint(2) NOT NULL default 0,
  elite tinyint(1) NOT NULL default 0,
  invisible tinyint(1) NOT NULL default 0,
  showsign tinyint(1) NOT NULL default 0,
  color varchar(7) NOT NULL default '',
  boldcode tinyint(1) NOT NULL default 0,
  viewmode tinyint(1) NOT NULL default 0,
  viewnumber int(10) NOT NULL default 0,
  lasteditauthorid int(10) NOT NULL default 0,
  lasteditauthor varchar(40) NOT NULL default '',
  lasteditat int(10) NOT NULL default 0,
  lasteditip varchar(64) NOT NULL default '',
  lastauthorid int(10) NOT NULL default 0,
  lastauthor varchar(40) NOT NULL default '',
  lastpostat int(10) NOT NULL default 0,
  lastpostclue varchar(80) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY forumid (forumid),
  KEY topicid (topicid),
  KEY authorid (authorid),
  KEY postat (postat)
) TYPE=MyISAM;

CREATE TABLE lybbs_postrecycle (
  id int(10) NOT NULL default 0,
  forumid smallint(4) NOT NULL default 0,
  topicid int(10) NOT NULL default 0,
  authorid int(10) NOT NULL default 0,
  author varchar(40) NOT NULL default '',
  title varchar(80) NOT NULL default '',
  content text NOT NULL,
  postat int(10) NOT NULL default 0,
  postip varchar(64) NOT NULL default '',
  titleicon varchar(20) NOT NULL default '',
  accessary tinyint(1) NOT NULL default 0,
  accessaryimg tinyint(1) NOT NULL default 0,
  accessaryext varchar(6) NOT NULL default '',
  accessarypath varchar(60) NOT NULL default '',
  clicktimes int(6) NOT NULL default 0,
  replynum int(8) NOT NULL default 0,
  votenum int(8) NOT NULL default 0,
  locktop tinyint(1) NOT NULL default 0,
  locktopid smallint(4) NOT NULL default 0,
  lockreply tinyint(1) NOT NULL default 0,
  lockvote tinyint(1) NOT NULL default 0,
  vote tinyint(1) NOT NULL default 0,
  votecondition tinyint(2) NOT NULL default 0,
  elite tinyint(1) NOT NULL default 0,
  invisible tinyint(1) NOT NULL default 0,
  showsign tinyint(1) NOT NULL default 0,
  color varchar(7) NOT NULL default '',
  boldcode tinyint(1) NOT NULL default 0,
  viewmode tinyint(1) NOT NULL default 0,
  viewnumber int(10) NOT NULL default 0,
  lasteditauthorid int(10) NOT NULL default 0,
  lasteditauthor varchar(40) NOT NULL default '',
  lasteditat int(10) NOT NULL default 0,
  lasteditip varchar(64) NOT NULL default '',
  lastauthorid int(10) NOT NULL default 0,
  lastauthor varchar(40) NOT NULL default '',
  lastpostat int(10) NOT NULL default 0,
  lastpostclue varchar(80) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY forumid (forumid),
  KEY topicid (topicid),
  KEY authorid (authorid),
  KEY postat (postat)
) TYPE=MyISAM;

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -