xyzshop/document/ugc.txt

mb_special 表修改

ALTER TABLE pandashop.lrlz_mb_special ADD category_id INT DEFAULT 0 NULL;
ALTER TABLE pandashop.lrlz_mb_special ADD comments INT DEFAULT 0 NULL;
ALTER TABLE pandashop.lrlz_mb_special ADD clicks INT DEFAULT 0 NULL;
ALTER TABLE pandashop.lrlz_mb_special ADD likes INT DEFAULT 0 NULL;
ALTER TABLE pandashop.lrlz_mb_special ADD state INT DEFAULT 0 NULL;
ALTER TABLE pandashop.lrlz_mb_special ADD origin_data TEXT DEFAULT NULL  NULL;
ALTER TABLE pandashop.lrlz_mb_special ADD share_image VARCHAR(200) DEFAULT '' NULL;
ALTER TABLE pandashop.lrlz_mb_special ADD share_title VARCHAR(200) DEFAULT '' NULL;
ALTER TABLE pandashop.lrlz_mb_special ADD addtime INT(11) DEFAULT 0 NULL;
ALTER TABLE pandashop.lrlz_mb_special ADD member_id INT DEFAULT 0 NULL;
ALTER TABLE pandashop.lrlz_mb_special ADD from_user TINYINT(1) DEFAULT 0 NULL;
ALTER TABLE pandashop.lrlz_mb_special
  MODIFY COLUMN special_desc VARCHAR(20) NOT NULL COMMENT '专题描述' AFTER from_user;