forked from zhaobod1/QDadvertorial
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathupdate20170115.sql
1 lines (1 loc) · 1012 Bytes
/
update20170115.sql
1
ALTER TABLE `advertorial`.`media_info` ADD COLUMN `dlprice3` int(11) AFTER `price`, ADD COLUMN `dlprice2` int(11) AFTER `dlprice3`, CHANGE COLUMN `dlprice` `dlprice1` int(11) DEFAULT '0' AFTER `dlprice2`, CHANGE COLUMN `scprice` `scprice` int(11) DEFAULT '0' AFTER `dlprice1`, CHANGE COLUMN `content` `content` text DEFAULT NULL AFTER `scprice`, CHANGE COLUMN `neirong` `neirong` text CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL AFTER `content`, CHANGE COLUMN `data` `data` varchar(255) DEFAULT '' AFTER `neirong`, CHANGE COLUMN `flag` `flag` int(11) DEFAULT '0' AFTER `data`, CHANGE COLUMN `tj` `tj` varchar(255) DEFAULT '../images/stars.gif' AFTER `flag`, CHANGE COLUMN `hyprice` `hyprice` int(11) NOT NULL DEFAULT '0' AFTER `tj`, CHANGE COLUMN `zjdlprice` `zjdlprice` int(11) NOT NULL DEFAULT '0' AFTER `hyprice`, CHANGE COLUMN `gjdlprice` `gjdlprice` int(11) NOT NULL DEFAULT '0' AFTER `zjdlprice`, CHANGE COLUMN `rkjibie` `rkjibie` varchar(255) NOT NULL DEFAULT '没有入口' AFTER `gjdlprice`;