gistfile1.sql

INSERT INTO yunbbs_settings VALUES('site_des', '');
INSERT INTO yunbbs_settings VALUES('spam_words', '');
INSERT INTO yunbbs_settings VALUES('qq_scope', 'get_user_info');
INSERT INTO yunbbs_settings VALUES('qq_appid', '');
INSERT INTO yunbbs_settings VALUES('qq_appkey', '');

ALTER TABLE  `yunbbs_articles` ADD  `favorites` INT( 10 ) UNSIGNED NOT NULL DEFAULT  '0' AFTER  `closecomment` ;
ALTER TABLE  `yunbbs_articles` ADD  `visible` TINYINT( 1 ) NOT NULL DEFAULT  '1' AFTER  `favorites` ;
ALTER TABLE  `yunbbs_categories` ADD  `about` TEXT NOT NULL DEFAULT  '' AFTER  `articles` ;

CREATE TABLE yunbbs_favorites (
  id mediumint(8) unsigned NOT NULL auto_increment,
  uid mediumint(8) unsigned NOT NULL default '0',
  articles mediumint(8) unsigned NOT NULL default '0',
  content mediumtext NOT NULL default '',
  PRIMARY KEY (id),
  KEY uid (uid)
) ENGINE=MyISAM ;


CREATE TABLE yunbbs_qqweibo (
  id mediumint(8) unsigned NOT NULL auto_increment,
  uid mediumint(8) unsigned NOT NULL default '0',
  name varchar(20) NOT NULL default '',
  openid char(32) NOT NULL,
  PRIMARY KEY (id),
  KEY uid (uid),
  KEY openid (openid)
) ENGINE=MyISAM ;