补充dw表，by 张春光

#Stage&Prod
mysql> USE dw;
DATABASE changed
mysql> ALTER TABLE `broker_dailystatistic` ADD `salenum_other` INT( 6 ) NOT NULL AFTER `broker_activity` ,
    -> ADD `rentnum_other` INT( 6 ) NOT NULL AFTER `salenum_other` , ADD `shopid` INT( 13 ) NOT NULL ,
    -> ADD `areaid` INT( 13 ) NOT NULL ,
    -> ADD `companyid` INT( 13 ) NOT NULL ,
    -> ADD `broker_shop_verify` INT( 6 ) NOT NULL ,
    -> ADD `member_id_card_state` INT( 6 ) NOT NULL;
Query OK, 71400 rows affected (0.50 sec)
Records: 71400  Duplicates: 0  Warnings: 0

#QA
mysql> source /DATA/backup/mysql/1.2.8/1.2.8-zcg.sql;       
DATABASE changed
Query OK, 0 rows affected (0.07 sec)
 
#Stage
mysql> source /DATA/bak/sql/1.2.8/1.2.8-zcg.sql;
DATABASE changed
Query OK, 0 rows affected (0.04 sec)
 
#Prod
mysql> source /DATA/backup/sql/1.2.8/1.2.8-zcg.sql;
DATABASE changed
Query OK, 0 rows affected (0.14 sec)
 
#QA
mysql> source /DATA/backup/mysql/1.2.8/1.2.8--derong--xml-alter.sql
DATABASE changed
Query OK, 0 rows affected (0.03 sec)
Records: 0  Duplicates: 0  Warnings: 0
 
Query OK, 12 rows affected (0.03 sec)
Records: 12  Duplicates: 0  Warnings: 0
 
Query OK, 12 rows affected (0.04 sec)
Records: 12  Duplicates: 0  Warnings: 0
 
#Stage
mysql> source /DATA/bak/sql/1.2.8/1.2.8--derong--xml.sql;
DATABASE changed
Query OK, 0 rows affected (0.05 sec)
 
Query OK, 0 rows affected (0.01 sec)
 
mysql> source /DATA/bak/sql/1.2.8/1.2.8--derong--xml-alter.sql;
DATABASE changed
Query OK, 0 rows affected (0.04 sec)
Records: 0  Duplicates: 0  Warnings: 0
 
Query OK, 0 rows affected (0.00 sec)
Records: 0  Duplicates: 0  Warnings: 0
 
Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0
 
#Prod
mysql> source /DATA/backup/sql/1.2.8/1.2.8--derong--xml.sql;
DATABASE changed
Query OK, 0 rows affected (0.15 sec)
 
Query OK, 0 rows affected (0.05 sec)
 
mysql> source /DATA/backup/sql/1.2.8/1.2.8--derong--xml-alter.sql;
DATABASE changed
Query OK, 0 rows affected (0.11 sec)
Records: 0  Duplicates: 0  Warnings: 0
 
Query OK, 0 rows affected (0.08 sec)
Records: 0  Duplicates: 0  Warnings: 0
 
Query OK, 0 rows affected (0.06 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql>  USE yoohouse_alpha;
DATABASE changed
mysql> ALTER TABLE `house_estate` CHANGE `estate_newhouse_price` `estate_newhouse_price` VARCHAR( 50 ) NULL DEFAULT NULL COMMENT '新房价格';
Query OK, 17244 rows affected (1.19 sec)
Records: 17244  Duplicates: 0  Warnings: 0

 ## ORDER BY 張春光
 #QA
 mysql> USE yoohouse_alpha;
 DATABASE changed
 mysql> ALTER TABLE `house_estate` CHANGE `estate_newhouse_price` `estate_newhouse_price` VARCHAR( 50 ) NULL DEFAULT NULL COMMENT '新房价格';
 Query OK, 17196 rows affected (1.24 sec)
 Records: 17196  Duplicates: 0  Warnings: 0
#stage
mysql> USE yoohouse_alpha;
DATABASE changed
mysql> ALTER TABLE `house_estate` CHANGE `estate_newhouse_price` `estate_newhouse_price` VARCHAR( 50 ) NULL DEFAULT NULL COMMENT '新房价格';
Query OK, 17232 rows affected (1.12 sec)
Records: 17232  Duplicates: 0  Warnings: 0