Skip to content

Instantly share code, notes, and snippets.

@ego008

ego008/gist:4285280

Created Dec 14, 2012
Embed
What would you like to do?
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 ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment