paperen / paperenblog Goto Github PK

ALTER TABLE category ADD pidlevel VARCHAR( 50 ) NOT NULL DEFAULT '0-' COMMENT '层级树' AFTER pid;
ALTER TABLE category ADD UNIQUE (
category
);
ALTER TABLE category ADD isdefault TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0' COMMENT '是否是默认类别';
INSERT INTO simblog2.category (id, category, pid, pidlevel, ispublic, userid, isdefault) VALUES (NULL, '默认类别', '0', '0-', '1', '0', '1');

ALTER TABLE config ADD name VARCHAR( 10 ) NOT NULL COMMENT '名称' AFTER key

ALTER TABLE post ADD istrash TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0' COMMENT '是否垃圾',
ADD INDEX ( istrash )

ALTER TABLE user ADD token VARCHAR( 32 ) NULL AFTER role

ALTER TABLE user ADD data TEXT NULL