%syntax-version=1.0.0
%project=gaia
%uri=http://git.gengmei.cc/backend/gaia

init-run 2015-09-21T15:20:55Z Pengfei.X <pengphy@gmail.com> # init run with sqitch
create_table_shoping_cart 2015-09-22T02:50:36Z Pengfei.X <pengphy@gmail.com> # add table shopping cart
add_installment_refund_in_service 2015-09-24T17:48:28Z Jiabin.Wang <wangjiabin@wanmeizhensuo.com> # add installment refund_anytime compensation_in_advance in api_service
alter_table_add_wiki_in_service 2015-09-24T17:59:07Z Jiabin.Wang <wangjiabin@wanmeizhensuo.com> # add wiki in service
add_uniq_index_for_api_shopcart 2015-09-24T15:45:35Z Pengfei.X <pengphy@gmail.com> # uniq index on person_id, service_id and service_item_key
add_table_api_settlement 2015-09-25T04:03:10Z Pengfei.X <pengphy@gmail.com> # add table api_settlement
create_table_settlementitem 2015-09-25T07:22:11Z Pengfei.X <pengphy@gmail.com> # create table api_settlementitem
add_action_in_table_api_report 2015-09-25T10:41:17Z ZYY <794050504@qq.com> # add action in table report
add_is_online_in_table_api_topicreply 2015-09-25T11:09:42Z ZYY <794050504@qq.com> # add is_online in table api_topicreply
alter_table_add_is_stage_in_service 2015-09-26T18:39:16Z Jiahua.Guo <gjhdgm@gmail.com> # add api_service.is_stage
alter_table_add_stage_app_id_in_order 2015-09-30T18:40:16Z chengliang.w <wanchengliang@wanmeizhensuo.com> # add stage app in order
social_2015_10_16_add_field_reason_count 2015-10-16T06:18:59Z Pengfei.X <pengphy@gmail.com> # add field reason count in table social_feed
api_2015_10_15_create_table_api_smallimage 2015-10-15T10:53:01Z ZYY <794050504@qq.com> # create a table smallimage
api_2015_10_19_add_uniq_for_api_diary 2015-10-19T11:47:32Z Pengfei.X <pengphy@gmail.com> # add uniq constrait for field order_id
alter_table_person 2015-10-20T08:03:22Z kula <kulasama@gmail.com> # alter person table
api_2015_10_30_add_tag_id_for_api_smallimage 2015-10-30T10:03:55Z ZYY <794050504@qq.com> # add tag_id and delete zone_single_id
api_2015_11_02_api_schedule_modify_column_doctor_id 2015-11-02T13:28:04Z Pengfei.X <pengphy@gmail.com> # update doctor_id definition
api_2015_11_12_add_coupon_id_for_settlement 2015-11-11T09:34:49Z Pengfei.X <pengphy@gmail.com> # add_coupon_id_for_settlement
alter_table_api_problem_add_review_status 2015-10-28T11:25:39Z lesliefang <fanglin@wanmeizhensuo.com> # alter table api_problem add field review_status
create_table_api_doctorwhitelist 2015-10-29T09:32:17Z lesliefang <fanglin@wanmeizhensuo.com> # create table api_doctorwhitelist for order refund
alter_table_api_feedback_add_has_more_asks 2015-10-30T03:57:50Z lesliefang <fanglin@wanmeizhensuo.com> # add has_more_asks in table api_feedback
api_2015_11_02_create_table_api_feedbackmessage 2015-11-02T08:22:44Z Pengfei.X <pengphy@gmail.com> # create table feedbackmessage
api_2015_10_30_add_imagetype_for_api_topicimage 2015-10-30T08:46:01Z kula <kulasama@gmail.com> # alter table api_topicimage for imagetype
api_2015_11_02_add_column_for_api_service 2015-11-02T10:11:39Z Pengfei.X <pengphy@gmail.com> # add columns valid_duration, point_deduction_percent
api_2015_11_02_add_column_point_deduction_percent 2015-11-02T11:42:46Z Pengfei.X <pengphy@gmail.com> # add column point_deduction_percent for api_serviceitem
api_2015_11_03_add_cover_for_doctor 2015-11-03T11:19:26Z Pengfei.X <pengphy@gmail.com> # add cover for doctor in api_diary
add_zip_in_userextra 2015-11-04T00:25:27Z Jiabin.Wang <wangjiabin@wanmeizhensuo.com> # add zip in UserExtra
api_2015_11_05_create_table_api_serviceregister 2015-11-05T03:02:13Z ZYY <794050504@qq.com> # create  tables for service register
api_2015_11_05_add_reservation_for_api_service 2015-11-05T03:39:26Z ZYY <794050504@qq.com> # add column reservation for api_service
pay_2015_11_06_create_table_pay_alipaytrefund 2015-11-06T06:24:12Z Pengfei.X <pengphy@gmail.com> # create table pay_alipaytrefund
relation_2015_11_12_alter_table_relation_usertagrelation_add_unique_index 2015-11-11T06:36:57Z Jiabin.Wang <wangjiabin@wanmeizhensuo.com> # alter table relation_user_tagrelation add unique index
api_2015_11_13_alter_table_api_order 2015-11-13T07:21:22Z Pengfei.X <pengphy@gmail.com> # add column cash_back_time
api_2015_11_15_add_tables_for_transaction_locks 2015-11-14T10:38:04Z Pengfei.X <pengphy@gmail.com> # add table CashBackLock, RefundLock, alter Order
api_models_order_2015_11_12_api_order_add_column_duration 2015-11-12T05:51:38Z Jiabin.Wang <wangjiabin@wanmeizhensuo.com> # api models order add column duration
api_2015_11_13_create_table_api_specialseckillservice 2015-11-13T03:57:25Z Pengfei.X <pengphy@gmail.com> # create table api_specialseckillservice
api_2015_11_14_tables_for_activity 2015-11-14T02:56:56Z Pengfei.X <pengphy@gmail.com> # create table api_activity/winlist, alter table api_topic
api_2015_11_17_create_tables_for_order 2015-11-16T16:50:59Z ZYY <794050504@qq.com> # create cashbackorder and refundorder
api_2015_11_17_add_activity_for_slide_smallimage_and_pushtask 2015-11-17T15:23:59Z Pengfei.X <pengphy@gmail.com> # add_activity_for_slide_smallimage_and_pushtask
api_2015_11_16_alter_table_api_doctor_column_business_licence_practice_licence_query_image 2015-11-16T07:28:39Z liuyuan <961289741@qq.com> # add 3 column
api_2015_11_20_create_table_servicemonitor 2015-11-19T16:15:35Z ZYY <794050504@qq.com> # create tables for service monitor
api_2015_11_24_update_settlement_coupon_foreign_key 2015-11-24T07:07:16Z Pengfei.X <pengphy@gmail.com> # settlement.coupon_id should ref couponinfo.id
doctor_2015_11_25_alter_table_doctor_register 2015-11-25T08:37:41Z Pengfei.X <pengphy@gmail.com> # alter table doctor_doctorregister add column editable
api_2015_11_30_add_create_at_for_doctor 2015-11-30T06:57:06Z ZYY <794050504@qq.com> # add_create_at_for_doctor
api_2015_11_30_add_is_settled_for_order 2015-11-30T07:02:25Z ZYY <794050504@qq.com> # add_is_settled_for_order
api_2015_12_02_create_table_campaignimagelink 2015-12-02T08:07:00Z ZCY <zhongchengyang@wanmeizhensuo.com>
api_2015_12_02_create_table_campaignlayout 2015-12-02T08:07:00Z ZCY <zhongchengyang@wanmeizhensuo.com>
alter_table_api_slide_add_title 2015-11-26T06:47:16Z lesliefang <fanglin@wanmeizhensuo.com> # alter table api_slide add title field
api_2015_11_27_api_organization_image_create_table 2015-11-27T09:02:59Z linhuazhu  <linhuazhu@wanmeizhensuo.com > # create table api_organization_image
community_2015_11_27_create_table_community_article 2015-11-27T10:20:38Z luoyingbo <luoyingbo@wanmeizhensuo.com> # create table community_article
api_2015_11_30_creat_table_api_greetingpopup 2015-11-30T09:47:00Z Jiabin.Wang <wangjiabin@wanmeizhensuo.com> # create table api_greetingpopup
create_table_api_preblacklist 2015-12-01T03:01:07Z lesliefang <fanglin@wanmeizhensuo.com> # create table api_preblacklist
doctor_2015_12_02_db_change_for_1.5 2015-12-02T07:56:09Z Pengfei.X <pengphy@gmail.com> # alter table api_reservation/api_doctoraddress, add table api_schedule_tempalte
finance_2015_12_02_create_table_finance 2015-12-02T17:54:23Z zcy <zhongchengyang@wanmeizhensuo.com> # create finance models
api_2015_12_02_add_fields_in_api_feedback 2015-12-02T02:38:56Z lesliefang <fanglin@wanmeizhensuo.com> # add order_reason_category filed in api_feedback
api_2015_12_02_alter_table_doctor_doctorregister 2015-12-02T05:35:39Z liuyuan <961289741@qq.com> # add 1 column
api_2015_12_03_create_table_api_tag_managers 2015-12-03T11:35:02Z liuyuan <961289741@qq.com> # create 1 table
api_2015_12_09_update_api_notification 2015-12-09T08:10:31Z Jiabin.Wang <wangjiabin@wanmeizhensuo.com> # alter table api_notification title and url length
api_2015_12_11_alter_table_feedback 2015-12-11T04:38:38Z lesliefang <fanglin@wanmeizhensuo.com> # alter table feedback change data type
api_2015_12_17_add_refundorder_lastest_apply_refund 2015-12-17T03:47:09Z ChengyangZhong <zhongchengyang@wanmeizhensuo.com> # add refundorder lastest_apply_refund
@release-2015121515 2015-12-19T01:52:31Z Pengfei.X <pengphy@gmail.com> # add tag release-2015121515 for with change api_2015_12_17_add_refundorder_lastest_apply_refund
api_2015_12_10_create_table_api_replyheadline 2015-12-10T07:57:23Z liuyuan <961289741@qq.com> # create table
api_2015_12_09_alter_table_api_doctor_related_doctor_tip 2015-12-09T08:55:43Z liuyuan <961289741@qq.com> # add 2 column
api_2015_12_14_add_refundorder_stale 2015-12-14T10:12:06Z ChengyangZhong <zhongchengyang@wanmeizhensuo.com> # add refundorder stale
api_2015_12_15_add_cashbackorder_stale 2015-12-15T08:07:10Z ChengyangZhong <zhongchengyang@wanmeizhensuo.com> # add cashbackorder stale
api_2015_12_14_add_table_consult_wiki 2015-12-14T03:26:10Z lesliefang <fanglin@wanmeizhensuo.com> # add table consult wiki
api_2015_12_16_alter_table_api_serviceregister 2015-12-16T10:24:36Z lesliefang <fanglin@wanmeizhensuo.com> # alter table api_serviceregister add column audit_time edit_time online_time
api_2015_12_16_add_serviceregisteritem_pre_payment_price_int 2015-12-16T15:41:30Z ZYY <794050504@qq.com> # add serregisteritem pre_payment_price_int
api_2015_12_15_alter_table_serviceitem 2015-12-15T06:45:26Z lesliefang <fanglin@wanmeizhensuo.com> # alter table serviceitem add column topic_cash_back_limit
api_2015_12_16_alter_table_api_service 2015-12-16T04:22:03Z lesliefang <fanglin@wanmeizhensuo.com> # alter table api_service add column tip
api_2015_12_16_create_table_api_recommend_doctor 2015-12-16T07:48:11Z liuyuan <961289741@qq.com> # create table
api_2015_12_15_add_3_column_in_diary 2015-12-15T02:56:15Z Jiabin.Wang <wangjiabin@wanmeizhensuo.com> # add 3 rating in api_diary
api_2015_12_17_alter_table_api_service 2015-12-17T08:05:38Z Pengfei.X <pengphy@gmail.com> # alter table api_service add column recommend_usercase
community_2015_12_13_create_table_community_topic_sticky 2015-12-18T08:05:38Z Pengfei.X <pengphy@gmail.com> # add table community_topic_sticky
api_2015_12_18_api_service_add_ratings 2015-12-18T09:43:10Z Jiabin.Wang <wangjiabin@wanmeizhensuo.com> # add 4 ratings in api_service
api_2015_12_24_alter_table_order 2015-12-24T07:09:11Z ZYY <794050504@qq.com> # change comments longtext
api_2015_12_25_add_column_device_id_for_topic 2015-12-25T03:57:29Z Pengfei.X <pengphy@gmail.com> # add device_id column for table api_problem
@release-201512281600 2015-12-28T08:37:24Z Pengfei.X <pengphy@gmail.com> # add tag for release-201512281600 api_2015_12_25_add_column_device_id_for_topic
api_2015_12_22_update_table_tag 2015-12-22T03:33:08Z fangleslie <lesliefang@localhost> # update table tag add field re_purchase_days
api_2015_12_24_create_table_api_privatemessagepush 2015-12-24T03:02:38Z fangleslie <lesliefang@localhost> # create table api_privatemessagepush
api_2015_12_28_activity_add_relate_doctor 2015-12-28T09:29:11Z Skyler·Hu <huleping@wanmeizhensuo.com> # activity_add_relate_doctor
api_2015_12_29_alter_table_api_person 2015-12-29T03:20:51Z linhuazhu  <linhuazhu@wanmeizhensuo.com > # add column
api_2015_12_30_doctor_add_hospital_agent 2015-12-30T06:58:11Z Skyler·Hu <huleping@wanmeizhensuo.com> # doctor can set hospital agent
api_2015_12_11_alter_table_topicreply 2015-12-24T10:38:29Z luoyingbo <luoyingbo@wanmeizhensuo.com> # alter table api_topicreply
channel_2015_12_31_init_channel 2015-12-31T09:22:32Z ZYY <794050504@qq.com> # sql for model channel init
api_2015_12_29_alter_table_api_itemwiki_column_created_time 2015-12-29T04:24:50Z liuyuan <961289741@qq.com> # add 1 column
message_2016_01_04_add_message_index 2016-01-04T07:56:22Z keyang <keyang@wanmeizhensuo.com> # add -last_reply_time index to ConversationUserStatus
api_2016_01_04_create_table_api_diaryvote 2016-01-04T08:47:30Z luoyingbo <luoyingbo@wanmeizhensuo.com> # create table api_diaryvote
api_2016_1_4_alter_serviceregister 2016-01-03T20:26:39Z ZYY <794050504@qq.com> # charfield to logtext
doctor_2016_01_04_alter_doctorregister 2016-01-04T10:03:20Z ZYY <794050504@qq.com> # add password for doctorregister
api_2016_01_08_alter_table_api_diary 2016-01-08T04:36:19Z luoyingbo <luoyingbo@wanmeizhensuo.com> # alter table api_diary
api_2016_01_09_alter_serviceregister_add_submit_time 2016-01-08T18:18:22Z ZYY <794050504@qq.com> # add submit_time
@release-v5.8-20160115 2016-01-18T02:55:45Z Pengfei.X <pengphy@gmail.com> # add tag for release-v5.8-20160115
add_login_mars_in_userextra 2016-01-26T04:15:55Z ChengyangZhong <zhongchengyang@wanmeizhensuo.com> # add_login_mars_in_userextra
api_2016_01_18_alter_table_api_doctor 2016-01-18T04:05:46Z fangleslie <lesliefang@localhost> # alter table api_doctor add column show_location
api_2016_01_19_add_type_for_smallimage 2016-01-19T04:24:59Z ZYY <794050504@qq.com> # add type for smallimage
api_2016_01_19_create_table_api_servicefilter 2016-01-19T03:19:12Z fangleslie <lesliefang@localhost> # create table api_servicefilter
api_2016_01_21_create_table_gadget 2016-01-21T04:20:21Z ZYY <794050504@qq.com> # create table gadget
add_is_operation_to_service_serviceregister 2016-01-21T06:37:58Z ChengyangZhong <zhongchengyang@wanmeizhensuo.com> # add is_operation to service and serviceregister
channel_2016_01_26_alter_table_versiontochannel 2016-01-26T07:34:42Z ZYY <794050504@qq.com> # add packed
app_2016_02_01_alter_table_doctor 2016-02-01T04:32:10Z fangleslie <lesliefang@localhost> # alter table doctor add field self_run and big
@release-5.9-201602021400 2016-02-15T04:41:16Z Pengfei.X <pengphy@gmail.com> # add tag for release-5.9-201602021400
api_2016_02_21_add_fields_is_vouchsafe 2016-02-21T13:27:03Z gmuser <gmuser@test-gaia> # add is_vouchsafe for api_order and api_service
api_2016_02_15_alter_table_api_order_add_points_deduction_real_payment_coupon_deduction 2016-02-15T04:18:35Z Jiabin.Wang <wangjiabin@wanmeizhensuo.com> # add 3 column in api_order
api_2016_02_15_alter_table_api_settlement_add_real_payment 2016-02-15T06:35:44Z Jiabin.Wang <wangjiabin@wanmeizhensuo.com> # add real_payment in api_settlement
api_2016_02_16_alter_table_api_report 2016-02-16T03:18:28Z Pengfei.X <pengphy@gmail.com> # alter tbale api_report
api_2016-02-23_alter_tabel_diary 2016-02-23T07:35:53Z Skyler·Hu <huleping@wanmeizhensuo.com> # alter table diary add column sticky_post
api_2016_02_18_create_table_api_tagalert 2016-02-18T02:58:58Z fangleslie <lesliefang@localhost> # create table api_tagalert
api_2016_02_17_alter_coupon_for_new_comer_limit 2016-02-17T04:23:41Z ZYY <794050504@qq.com> # add new_comer_limit
api_2016_02_24_alter_table_tagalert 2016-02-24T10:36:32Z fangleslie <lesliefang@fangleslies-MacBook-Pro.local> # alter table tagalert add field create_time
pay_2016_03_04_create_tables_for_pay_settlement 2016-03-04T03:38:07Z ZYY <794050504@qq.com> # create table pay_wechatsettlement and pay_wechatsettlement
@release-5.9.1-201603141632 2016-03-14T08:32:58Z Pengfei.X <pengphy@gmail.com> # add tag for release-5.9.1-201603141632
api_2016_03_16_alter_table_order_add_pay_time 2016-03-16T10:31:38Z Jiabin.Wang <wangjiabin@wanmeizhensuo.com> # add pay_time in api_order
api_2016_03_09_create_table_campaign_coupon_and_share 2016-03-09T06:32:27Z ChengyangZhong <zhongchengyang@wanmeizhensuo.com> # api_2016_03_09_create_table_campaign_coupon_and_share
doctor_2016_03_10_create_tables_for_doctor_operation_content 2016-03-10T02:57:49Z ChengyangZhong <zhongchengyang@wanmeizhensuo.com> # doctor_2016_03_10_create_tables_for_doctor_operation_content
api_2016_03_16_alter_table_api_service 2016-03-16T06:39:26Z Jiabin.Wang <wangjiabin@wanmeizhensuo.com> # column sell_num_limit and total_num null to not null
api_2016_03_16_alter_table_api_diary_add_set_headline_time 2016-03-16T08:03:10Z ChengyangZhong <zhongchengyang@wanmeizhensuo.com> # api_2016_03_16_alter_table_api_diary_add_set_headline_time
doctor_2016_03_16_create_tables_for_mars 2016-03-16T09:26:54Z Skyler·Hu <huleping@wanmeizhensuo.com> # create table for doctor mars
api_2016_03_14_create_table_api_business_channel 2016-03-14T10:56:29Z robertding <robertdingx@gmail.com> # add business_channel
api_2016_03_16_add_table_for_api_points_task 2016-03-16T11:07:29Z linhuazhu  <linhuazhu@wanmeizhensuo.com > # create table api_points_task
api_2016_03_16_add_out_of_stock_alert 2016-03-16T09:36:42Z RobertDing <dingyingcai@gmei.com> # create table remind user of stock
pay_2016_03_14_create_tables_for_doctor_statment 2016-03-14T08:59:38Z ZYY <794050504@qq.com> # create tables for doctor statment
api_2016_03_16_create_table_doctoraccount 2016-03-16T03:19:02Z ZYY <794050504@qq.com> # create table doctoraccount
api_2016_03_23_reservation_add_column 2016-03-23T03:17:02Z Skyler·Hu <huleping@wanmeizhensuo.com> # reservation add column accepted_time
@release-5.9.2-201603281526 2016-03-28T07:28:30Z Pengfei.X <pengphy@gmail.com> # add tag for release-5.9.2
api_2016_03_25_add_table_votepk 2016-03-25T06:55:05Z Jiabin.Wang <wangjiabin@wanmeizhensuo.com> # add table api_votepk
api_2016_03_29_add_fields_for_self_support 2016-03-29T02:36:30Z ZYY <zhangyunyu@gmei.com> # add is_self_support
doctor_2016_03_28_add_doctorActivity_and_ActivityParticipate_table 2016-03-28T04:11:07Z RobertDing <dingyingcai@gmei.com> # create DoctorActivity and ActivityParticipate
api_2016_04_05_alter_is_sink 2016-04-05T09:59:37Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # 美购增加下沉字段
doctor_2016_04_05_add_table_notification 2016-04-05T07:21:55Z Pengfei.X <pengphy@gmail.com> # add table notification for doctor
api_2016_03_30_add_field_for_cashback_topics 2016-03-30T08:19:34Z ZYY <zhangyunyu@gmei.com> # add topic_cash_back
advertise_2016_04_05_create_table_for_advertise 2016-04-05T08:52:24Z lipeng <lipeng@gmei.com> # create table for advertise
api_2016_04_12_alter_table_api_problem 2016-04-12T03:32:42Z linhuazhu  <linhuazhu@wanmeizhensuo.com > # add column is_mixed
channel_2016_04_12_add_released_version_for_channel 2016-04-12T06:52:21Z ZYY <zhangyunyu@gmei.com> # alter table channel_chanel add column
api_2016_04_15_alter_table_api_doctor 2016-04-15T06:55:23Z yangheng <yangheng@gmei.com> # add fields
api_2016_04_15_alter_table_api_hospital 2016-04-15T11:41:07Z yangheng <yangheng@gmail.com> # add fields rate,env_rating,attitude_rating,effect_rating
api_2016_04_21_alter_table_api_preoperationimage 2016-04-21T08:39:40Z linhuazhu  <linhuazhu@wanmeizhensuo.com > # add column is_cover
api_2016_04_21_alter_table_api_topicimage 2016-04-21T08:45:42Z linhuazhu  <linhuazhu@wanmeizhensuo.com > # add column is_cover
api_2016_04_22_alter_table_api_topicvote 2016-04-22T10:41:52Z linhuazhu  <linhuazhu@wanmeizhensuo.com > # add column is_fake
api_2016_04_25_api_diary_add_column_rate_count 2016-04-25T06:29:58Z Pengfei.X <pengphy@gmail.com> # alter table api_diary add column rate_count
@release-5.9.3-20160425 2016-04-25T10:26:44Z Pengfei.X <pengphy@gmail.com> # add tag for release-5.9.3
api_2016_04_25_add_lisences_columns_for_doctor 2016-04-25T11:01:41Z Pengfei.X <pengphy@gmail.com> # add columns `business_licence`, `practise_licence` for api_doctor
@release-5.9.3-201604251933 2016-04-25T11:33:45Z Pengfei.X <pengphy@gmail.com> # add tag for release-5.9.3
register_2016_04_08_create_table_for_api_registerorganization 2016-04-08T07:08:14Z lipeng <lipeng@gmei.com> # create table registerorganization
api_2016_04_12_create_table_for_api_alipayaccount 2016-04-12T10:11:27Z lipeng <lipeng@gmei.com> # create table api_alipayaccount
pay_2016_04_14_create_table_pay_servicesnapshot 2016-04-14T10:39:30Z ZYY <zhangyunyu@gmei.com> # create table for order snapshot
organzitaion_2016_04_29_alter_api_organization_image 2016-04-29T08:02:57Z oldman <lipeng@gmei.com> # alert api_organization_image change hospital_id
pay_2016_05_25_alter_table_pay_servicesnapshot_add_column 2016-05-25T04:15:29Z Jiabin.Wang <wangjiabin@wanmeizhensuo.com> # add business_partener_id
api_2016_04_22_alter_table_api_person 2016-04-21T10:19:11Z kula <kulasama@gmail.com> # add is_mock column on person table
special_2016_04_20_add_is_recommendpool_to_api_special 2016-04-20T09:42:10Z lipeng <lipeng@gmei.com> # add is_is_recommendpool to api_special
problem_2016_04_21_add_share_id_to_api_problem 2016-04-21T03:54:09Z lipeng <lipeng@gmei.com> # add shared_id to api_problem
special_2016_04_21_add_share_id_to_api_special 2016-04-21T10:02:30Z lipeng <lipeng@gmei.com> # add share_id to api_special
api_2016_04_20_alter_table_doctor_add_work_time 2016-04-20T02:51:24Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # add work_time for doctor
api_2016_04_23_create_table_api_update_pop 2016-04-23T02:06:05Z lipeng <lipeng@gmei.com> # create table api_update_pop
api_2016_04_22_create_table_freecustoms 2016-04-22T07:49:30Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # create freecustom tables
api_2016_05_04_create_table_consultscience 2016-05-11T10:11:53Z yangheng <yangheng@gmail.com> # create table api_consult_science
api_2016_05_04_create_table_consulttheme 2016-05-11T10:27:47Z yangheng <yangheng@gmail.com> # create table api_consult_theme
api_2016_05_12_api_service_serviceregister_add_column_user_safe 2016-05-12T04:31:20Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # add user_asfe for service
alter_table_problem_add_send_channel_type 2016-05-13T04:28:56Z luohaifeng <luohaifeng@gmei.com> # 5.13 add column for problem :luohaifeng
api_2016_05_12_create_api_wikiadver 2016-05-12T09:23:46Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # create api_wikiadver
api_2016_05_17_create_table_for_api_zone 2016-05-17T02:22:03Z peng li <lipeng@gmei.com> # add table api_zone,api_overheadtopic,api_tag_related_tag
api_2016_05_13_create_api_docprojecttag 2016-05-13T08:39:15Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # add doctor good at project tag
alter_table_DoctorAccount_add_account_type 2016-05-17T02:19:49Z luoahifeng <luohaifenglight@gmail.com> # add column account_type
api_2016_05_18_alter_table_itemwiki 2016-05-18T11:00:33Z Jiabin.Wang <wangjiabin@wanmeizhensuo.com> # add new itemwiki columns
@release-6.0.0-201605301632 2016-05-30T08:32:39Z Pengfei.X <pengphy@gmail.com> # add tag for release-6.0.0
api_2016_06_01_alter_table_api_votepk_add_column 2016-06-01T03:24:50Z Jiabin.Wang <wangjiabin@wanmeizhensuo.com> # add vote_user
add_anonymous_jpush_binding 2016-06-05T05:57:16Z keyang <keyang@wanmeizhensuo.com> # add anonymous user jpush bindings
api_2016_06_06_create_table_showcity 2016-06-06T10:10:07Z yangheng <yangheng@gmail.com> # create a table api_show_city
api_2016_06_02_create_table_pay_applepay 2016-06-02T11:00:30Z Jiabin.Wang <wangjiabin@wanmeizhensuo.com> # create table about apple pay
alter_table_artic_add_send_channel_type 2016-05-30T11:35:28Z luoahifeng <luohaifenglight@gmail.com> # alter add infied send_channel_type in artic
alter_table_problem_delete_send_channel_type.sql 2016-05-31T04:04:05Z luoahifeng <luohaifenglight@gmail.com> # delete send_channel_type in problem
api_2016_06_03_alter_table_refundorder_cashbackorder 2016-06-03T09:33:26Z Jiabin.Wang <wangjiabin@wanmeizhensuo.com> # add columns
@Sprint-USER-20160530 2016-06-20T03:09:38Z Pengfei.X <pengphy@gmail.com> # add tag for Sprint-USER-20160530
create_table_api_industry_news 2016-06-20T06:32:52Z ChengyangZhong <zhongchengyang@wanmeizhensuo.com> # create table api_industry_news
api_2016_06_20_add_read_in_api_order 2016-06-20T03:24:15Z Jiabin.Wang <wangjiabin@wanmeizhensuo.com> # add read for record status
api_2016_06_20_add_table_api_operate_team 2016-06-20T06:42:30Z peng li <lipeng@gmei.com> # add tables about operate_team
api_2016_06_21_create_table_api_singlerecord 2016-06-21T08:52:06Z luohaifeng <luohaifeng@gmei.com> # create new table api_singlerecord
@Sprint-USER-20160620 2016-07-04T03:50:40Z Pengfei.X <pengphy@gmail.com> # add tag for Sprint-USER-20160620
api_2016_07_05_alter_order_add_phone_crypt 2016-07-05T12:04:08Z ChengyangZhong <zhongchengyang@wanmeizhensuo.com> # api_2016_07_05_alter_order_add_phone_crypt
2016_07_05_add_table_yd_form 2016-07-05T04:00:13Z linhuazhu  <linhuazhu@wanmeizhensuo.com > # add table api_youngdoctorform
2016_07_05_add_table_yd_case 2016-07-05T04:10:57Z linhuazhu  <linhuazhu@wanmeizhensuo.com > # add table api_youngdoctorcase
api_2016_07_05_add_table_api_seckillnotify 2016-07-05T06:54:48Z Jiabin.Wang <wangjiabin@wanmeizhensuo.com> # add table api_seckillnotify
pay_2016_07_05_add_installment_table 2016-07-05T12:12:50Z RobertDing <dingyingcai@gmei.com> # installment table
api_2016_07_04_create_table_api_specialgadget 2016-07-04T10:42:44Z luohaifeng <luohaifeng@gmei.com> # 添加专题模板
api_2016_07_04_alter_table_api_special 2016-07-04T10:52:49Z luohaifeng <luohaifeng@gmei.com> # 添加美券直领，美券直领是否显示，图文详情是否显示，固定模板是否显示
api_2016_07_05_create_table_api_phone_service_record 2016-07-05T07:52:03Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # create table for phone service
2016_07_08_alter_settlement 2016-07-08T08:22:33Z yangchuncheng <yangchuncheng@gmei.com> # settlement installment
api_2016_07_07_alter_table_api_seckillnotify 2016-07-07T08:00:54Z Jiabin.Wang <wangjiabin@wanmeizhensuo.com> # add 3 columns in api_seckillnotify
api_20160711_redo_drop_column_send_channel 2016-07-11T08:48:52Z Pengfei.X <pengphy@gmail.com> # redo alter_table_problem_delete_send_channel_type.sql
campaigngift_2016_06_27_add_campaigngift_table 2016-06-27T07:43:51Z RobertDing <dingyingcai@gmei.com> # create campaigngift table
user_1647_coupon 2016-07-01T08:47:29Z yangchuncheng <yangchuncheng@gmei.com> # user_1647_coupon
api_2016_07_14_add_duration_api_phone_service_record 2016-07-14T03:27:21Z yangheng <yangheng@gmail.com> # add duration in table api_phone_service_record
@Sprint-USER-620-s1-20160704 2016-07-16T15:12:46Z Pengfei.X <pengphy@gmail.com> # add tag for Sprint-USER-620-s1-20160704
2016_07_11_add_error_code 2016-07-11T09:43:15Z yangchuncheng <yangchuncheng@gmei.com> # add error code in pay_wechatrefund
@USER-620-s2-20160711 2016-07-22T07:56:22Z Pengfei.X <pengphy@gmail.com> # add tag for sprint USER-620-s2-20160711
sms_2016_07_22_init_sms_model 2016-07-22T06:01:19Z ZYY <zhangyunyu@gmei.com> # init sms model
api_2016_07_18_create_table_api_agreement 2016-07-18T03:38:00Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # create table agreement
api_2016_07_19_alert_hera_log_add_column_package_new_and_action_new 2016-07-19T07:19:49Z peng li <lipeng@gmei.com> # add column package_new and action_new
api_2016_07_18_alert_table_api_service_add_column_sellcount_changetime 2016-07-18T08:33:10Z peng li <lipeng@gmei.com> # add sellcount_changetime
api_2016_07_21_create_table_agreement_doctor 2016-07-21T03:50:58Z Skyler·Hu <huleping@wanmeizhensuo.com> # create a table agreement_doctor
api_2016_07_15_alter_table_serviceregister 2016-07-14T09:38:29Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # add service_name ordering in serviceregister
api_2016_07_15_create_DoctorBusinessRecord 2016-07-15T09:29:35Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # create table to record doctor change business
@USER-630-s1-20160718 2016-07-29T11:59:07Z Pengfei.X <pengphy@gmail.com> # add tag for sprint USER-630-s1-20160718
api_2016_08_02_create_table_youngdoctorvote 2016-08-02T07:27:39Z hanshuai <hanshuai@gmei.com> # create table api_youngdoctorvote
2016_08_05_add_table_statistic_device_doctor 2016-08-05T07:41:27Z chengliang <wangchengliang@gmei.com> # add table statistic_device_doctor
api_2016_08_02_alter_table_api_freecustom 2016-08-02T02:38:14Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # add is_phone_connect in api_freecustom
2016_08_01_add_table_area 2016-08-01T07:11:56Z xiayu <blacklensama@gmail.com> # create table api_area
api_2016_08_03_add_column_by_hera583 2016-08-03T03:18:45Z peng li <lipeng@gmei.com> # 添加邮箱登录
2016_08_01_alter_person 2016-08-01T08:27:06Z xiayu <blacklensama@gmail.com> # alter person add email and area_id
api_20160802_addtable_api_extendtips_api_advertisemanagement 2016-08-02T10:42:28Z luohaifeng <luohaifeng@gmei.com> # 添加表extendtips与advertisemanagement
doctor_2016_08_04_create_table_doctor_doctorstafflogin 2016-08-04T06:36:36Z ZYY <zhangyunyu@gmei.com> # create_table_doctorstafflogin
qpi_20160803_alter_table_api_wikiadver_add_url_type 2016-08-03T08:54:18Z luohaifeng <luohaifeng@gmei.com> # api_wikiadver增加字段url_type
api_2016_08_12_agreement_doctor_add_unique 2016-08-12T02:57:02Z Skyler·Hu <huleping@wanmeizhensuo.com> # alter table api_agreement_doctor add unique
@USER-630-s2-20160801 2016-08-15T03:29:27Z Pengfei.X <pengphy@gmail.com> # add tag for sprint USER-630-s2
2016_08_11_yinuo 2016-08-11T06:19:15Z yangchuncheng <yangchuncheng@gmei.com> # yinuo insurance
api_2016_08_18_create_table_api_diarycheck 2016-08-18T05:37:09Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # create api_diarycheck
api_2016_08_18_alter_table_api_diary_add_table_api_diaryoperate 2016-08-18T09:26:38Z Jiabin.Wang <wangjiabin@wanmeizhensuo.com> # alter table api_diary and add api_diaryoperate
api_2016_08_23_add_table_draft_drafttag_alter_topicimage 2016-08-23T07:53:04Z Jiabin.Wang <wangjiabin@wanmeizhensuo.com> # add table api_draft api_drafttag alter topicimage
doctor_2016_08_30_change_doctor_default 2016-08-30T09:57:19Z RobertDing <dingyingcai@gmei.com> # change doctor accept_reserve value
api_2016_08_23_add_tables_for_doctor_upload_service 2016-08-23T09:18:55Z peng li <lipeng@gmei.com> # add tables
api_2016_08_23_add_columns_for_serviceregister 2016-08-23T09:36:19Z peng li <lipeng@gmei.com> # add columns

api_2016_09_01_add_columns_for_service 2016-09-01T10:40:42Z peng li <lipeng@gmei.com> # serviceitem 和serviceregisterItem表添加is_delete以及两个表的关联
api_2016_09_07_alert_serviceregister_addcolumn_doctor_can_see 2016-09-07T03:21:05Z peng li <lipeng@gmei.com> # can doctor see this serviceregister
@USER-630-s4-20160822 2016-09-08T08:18:44Z Pengfei.X <pengphy@gmail.com> # add tag for sprint USER-630-s4
create_table_api_gmhome_sideskidcategory 2016-09-14T03:58:27Z Chengyang Zhong <zhongchengyang@gmei.com> # create table api_gmhome_sideskidcategory
api_2016_09_14_add_table_wechatmaterial 2016-09-14T07:56:16Z linhuazhu  <linhuazhu@wanmeizhensuo.com > # add table wechat material
api_2016_09_12_create_table_pgcclassfiy_add_column_for_problem 2016-09-12T08:41:34Z luohaifeng <luohaifeng@gmei.com> # 添加pgcclassfiy修改表problem
api_2016_09_17_alter_table_slider 2016-09-17T02:54:46Z xiayu <blacklensama@gmail.com> # alter api_slider is_show_info
2016_9_19_alter_api_slide_picture 2016-09-19T02:10:33Z xiayu <blacklensama@gmail.com> # alter slide table feed picture
2016_09_23_alter_table_statistic_device_add_column_idfv 2016-09-23T03:42:11Z chengliang <wangchengliang@gmei.com> # alter table statistic_device add column idfv
2016_09_23_alter_table_statistic_device_doctor_add_column_idfv 2016-09-23T06:43:17Z chengliang <wangchengliang@gmei.com> # alter table statistic_device_doctor add column idfv
@USER-640-s1-20160908 2016-09-24T06:48:13Z Pengfei.X <pengphy@gmail.com> # add tag for sprint USER-640-s1
api_2016_09_12_create_table_optimizewiki 2016-09-12T06:28:30Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # create table and alter column for optimize wiki
2016_09_28_alter_table_statistic_device_add_index_idfv 2016-09-28T10:21:56Z chengliang <wangchengliang@gmei.com> # alter table statistic_device add index index_idfv
2016_09_28_alter_table_statistic_device_doctor_add_index_idfv 2016-09-28T10:25:05Z chengliang <wangchengliang@gmei.com> # alter table statistic_device_doctor add index index_idfv
pay_2016_08_23_add_installment 2016-09-23T10:35:15Z ZYY <zhangyunyu@gmei.com> # add installment for order statement ship
2016_10_14_create_settlement_extra 2016-10-14T05:46:27Z yangchuncheng <yangchuncheng@gmei.com> # add 3 params
api_20160920_create_table_shortmessagesend 2016-09-20T11:29:43Z luohaifeng <luohaifeng@gmei.com> # shortmessagesend
@release-20161017 2016-10-17T11:54:13Z Pengfei.X <pengphy@gmail.com> # add tag for release-20161017
api_2016_10_11_add_recommanduserproject 2016-10-11T11:12:22Z luohaifeng <luohaifeng@gmei.com> # add table recommanduseratentions
alter_table_api_diary_vote_is_fake 2016-10-11T08:13:39Z xiayu <blacklensama@gmail.com> # alter_table_api_diary_vote_is_fake
api_2016_10_14_add_columns_for_richtext 2016-10-14T02:18:46Z peng li <lipeng@gmei.com> # add richtext for problem and activity

api_2016_10_24_alter_table_api_special 2016-10-24T02:35:48Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # alter api_special service_zone
api_2016_10_25_is_doctor_see_for_api_order 2016-10-25T09:17:22Z yangheng <yangheng@gmail.com> # add is_doctor_see
api_2016_10_25_create_table_seckill_button_servicereg_alter_seckillservice 2016-10-25T07:47:55Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # create seckillbutton seckill servicereg alter seckill service
api_2016_10_25_add_get_ponits_can_refund 2016-10-25T09:38:55Z ZYY <zhangyunyu@gmei.com> # add can_refund get_points to table order
pay_2016_10_25_add_special_to_service_snapshot 2016-10-25T09:45:17Z ZYY <zhangyunyu@gmei.com> # add special ro service snapshot

api_2016_10_18_add_packageserviceremark 2016-10-18T08:53:19Z ZYY <zhangyunyu@gmei.com> # add packageserviceremark
api_2016_10_12_create_table_api_tickets 2016-10-12T03:08:30Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # create table api_tickets alter table api_singlerecord
maidan_2016_10_18_maidan_init 2016-10-18T03:17:08Z ZYY <zhangyunyu@gmei.com> # add maidan order maidan statement
@release-20161108 2016-11-09T03:53:04Z Chengyang Zhong <zhongchengyang@gmei.com> # add tag for release-20161108
phonerecord_2016_11_15_add_for_vendor 2016-11-15T03:40:45Z Chengyang Zhong <zhongchengyang@gmei.com> # phonerecord_2016_11_15_add_for_vendor
doctor_2016_11_8_doctor_quick_replay_init 2016-11-08T04:31:21Z zhangxiaolin <zhangxiaolin@gmei.com> # add quickreplay table
api_2016_11_15_create_table_for_api_smart_rank 2016-11-15T12:46:09Z yangheng <yangheng@gmail.com> # create a table api_smart_rank
2016_11_19_create_hospital_list 2016-11-19T09:01:28Z xiayu <blacklensama@gmail.com> # create a table convert renmai hospital list

create_table_diary_score 2016-11-09T02:37:58Z xiayu <blacklensama@gmail.com> # create a table record diary score
api_2016_11_14_create_table_api_speciallayout 2016-11-14T10:00:51Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # create api_speciallayout
create_table_topic_video 2016-11-16T10:33:10Z xiayu <blacklensama@gmail.com> # create a table topic video
api_20161117_update_api_zone 2016-11-17T08:21:37Z Pengfei.X <pengphy@gmail.com> # add more columns for api_zone
2016_11_18_alter_draft_table_video 2016-11-18T07:17:50Z xiayu <blacklensama@gmail.com> # alter_draft_table_video
api_2016_11_16_api_service_add_column_yinuo_type_zhongan_type 2016-11-16T09:59:28Z peng li <lipeng@gmei.com> # add yinuo_type zhongan_type
api_2016_11_22_create_table_locklist_servicelock 2016-11-22T03:24:22Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # create servicelock and locklist
api_2016_11_23_add_table_api_specialactiveservice 2016-11-23T06:20:47Z peng li <lipeng@gmei.com> # table api_specialactiveservice
api_2016_11_25_add_doctor_seckill_apply_to_service_snapshot 2016-11-25T05:34:15Z ZYY <zhangyunyu@gmei.com> # alter table pay_servcesnapshot add doctor_seckill apply

api_2016_12_03_add_index_on_doctor_apply 2016-12-03T09:08:00Z peng li <lipeng@gmei.com> # add index
api_2016_12_05_add_column_desc 2016-12-05T04:21:29Z peng li <lipeng@gmei.com> # add html_ziduan
api_2016_12_05_add_index_end_time_for_api_special 2016-12-05T09:46:41Z Chengyang Zhong <zhongchengyang@gmei.com> # api_2016_12_05_add_index_end_time_for_api_special
api_2016_12_1_create_table_for_fenxiao 2016-12-01T03:19:48Z louchaoqi <louchaoqi@gmei.com> # add fenxiao table

api_2016_12_09_alter_table_diary_service_topic_favor 2016-12-08T16:01:14Z Pengfei Xue <pengfei@PengfeideMacBook-Air.local> # add is_deleted created_time for servicefavor topicfavor diaryfavor
api_2016_12_01_create_table_region_table_special_show_services 2016-12-01T10:58:44Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # create table region special show services
api_2016_12_06_add_table_service_recommand 2016-12-06T02:39:26Z peng li <lipeng@gmei.com> # add table api_servicerecommand
api_2016_12_9_alter_table_api_period_hospital_add_is_online 2016-12-09T05:21:30Z ZYY <zhangyunyu@gmei.com> # alter_table_api_period_hospital_add_is_online
create_index_api_diary_vote 2016-12-14T10:18:23Z xiayu <blacklensama@gmail.com> # create_index_api_diary_vote
channel_2016_12_20_add_unique_for_channel_and_version 2016-12-20T04:20:51Z Chengyang Zhong <zhongchengyang@gmei.com> # channel_2016_12_20_add_unique_for_channel_and_version
api_2016_12_09_create_table_qqcouponrecord 2016-12-12T08:27:53Z Jiabin.Wang <wangjiabin@wanmeizhensuo.com> # create table api_qqcouponrecord
api_2016_11_30_alter_slide_zhibouser 2016-11-30T08:28:34Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # alter slide_zhibouser
create_live_table 2016-12-19T02:49:27Z xiayu <blacklensama@gmail.com> # create_live_table
zhibo_2016_12_20_create_table_api_zhiboconfig 2016-12-20T10:46:06Z wangshengguang <wangshengguang@gmei.com> # create a table api_zhiboconfig
api_2016_12_20_alter_table_api_advertisemanagement 2016-12-20T10:55:49Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # 广告位管理增加字段
api_2017_01_11_add_column_is_lock_for_serviceregister 2017-01-11T03:49:52Z peng li <lipeng@gmei.com> # add is_lock for serviceregister
api_2017_01_05_alter_table_api_doctor_add_index_for_phone_ext 2017-01-05T12:45:39Z yangheng <yangheng@gmail.com> # add index for phone_ext
api_2017_01_13_alter_table_api_phone_call_record 2017-01-13T03:37:20Z yangheng <yangheng@gmail.com> # create table api_phone_call_record
gmhome_2017_01_03_alter_table_api_slide 2017-01-03T10:02:54Z wangshengguang <wangshengguang@gmei.com> # ALTER TABLE `api_slide` ADD `slide_type`
diary_2017_01_04_alter_table_api_slide 2017-01-04T02:49:07Z wangshengguang <wangshengguang@gmei.com> # ALTER TABLE api_slide ADD COLUMN `can_video_cover`
api_2016_12_22_alter_service_add_insurance 2016-12-22T06:06:47Z ZYY <zhangyunyu@gmei.com> # 添加保险ID
api_2017_01_10_add_notify_status 2017-01-10T07:33:23Z Jiabin.Wang <wangjiabin@wanmeizhensuo.com> # add notify status

api_2017_01_16_alter_additional_weight_for_api_diaryrank 2017-01-16T09:59:01Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # alter table api_diaryrank add column additional_weight
create_table_api_topicrankingscore 2017-01-13T12:07:21Z keyang <keyang@gmei.com> # model TopicRankingScore
api_2017_02_07_create_ordercost 2017-02-07T02:27:23Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # 增加订单成本价表

alter_image_table_cover_image 2017-01-06T11:46:01Z xiayu <blacklensama@gmail.com> # alter_image_table_cover_image
pay_20170124_record_business_partner 2017-01-24T07:57:19Z Jiahua Ni <nijiahua@gmei.com> # record_business_partnet

api_2017_02_06_create_seokeyword 2017-02-06T07:19:13Z Jiabin.Wang <wangjiabin@wanmeizhensuo.com> # create SeoKeyword and KeywordRelation
api_2016_12_12_sku_161212 2016-12-12T10:41:10Z Jiahua Ni <nijiahua@gmei.com> # update_sku
api_2017_02_09_create_table_seo_digest 2017-02-09T11:48:38Z Jiabin.Wang <wangjiabin@wanmeizhensuo.com> # create table api_seodigest

2017_02_09_alter_stream_replay_danmu 2017-02-09T06:22:06Z xiayu <blacklensama@gmail.com> # alter api_live_stream replay danmu
api_2017_02_07_alter_table_api_live_white_list 2017-02-07T02:41:37Z Gengmei <gengmei@Plus-Mac-Pro.local> # alter table api_live_white_list add column is_online
api_2017_02_07_alter_table_api_zhiboconfig 2017-02-07T07:14:32Z Gengmei <gengmei@Plus-Mac-Pro.local> # alter table api_zhiboconfig add column is_shouyejingxuan is_shouyezhibo is_zhiboliebiao
api_2017_02_13_alter_table_api_slide 2017-02-13T09:49:12Z ZhouYang <ZhouYang@Esses-MBP.local> # alter talbe api_slide and column zhiboconfig_id
api_2017_02_09_add_more_info_for_coupon 2017-02-10T09:52:52Z Jiahua Ni <nijiahua@gmei.com> # api_2017_02_09_add_more_info_for_coupon
channel_2016_02_08_create_table_channel_verdor 2017-02-08T07:05:56Z Chengyang Zhong <zhongchengyang@gmei.com> # channel_2016_02_08_create_table_channel_verdor
themis_2017_02_17_create_team_teamuser 2017-02-17T05:48:41Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # 增加组权限表

api_2017_02_28_alter_table_pushtast_zhibouser 2017-02-28T02:40:29Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # 推送跳转到直播
maidan_2017_02_28_alter_maidansnapshot_business_partner 2017-02-28T06:33:30Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # 买单订单快照增加售出商务

pay_2017_03_01_create_statementaccount 2017-03-01T08:58:15Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # 新增对账单账户
api_2017_03_01_create_doctorgroups 2017-03-01T06:20:53Z ZhouYang <ZhouYang@Esses-MBP.local> # create table api_doctorgroup api_doctor_related_doctorgroup api_user_related_doctorgroup
doctor_2017_03_01_service_regiter_add_is_draft 2017-03-02T03:10:02Z Skyler·Hu <huleping@wanmeizhensuo.com> # service_register add is_draft
api_2017_02_27_alter_table_api_slide 2017-02-27T06:14:06Z ZhouYang <ZhouYang@Esses-MBP.local> # alter table api_slide add column not_show_title
api_2017_02_28_create_api_tag_relation_ad 2017-02-28T02:54:34Z ZhouYang <ZhouYang@Esses-MBP.local> # create table api_tag_relation_ad
api_2017_02_22_alter_table_api_seocategory_add_columns 2017-02-22T10:33:21Z Jiabin.Wang <wangjiabin@wanmeizhensuo.com> # add columns in api_seocategory
alter_2017_02_21_topic_vote_topic_author_id 2017-02-21T11:12:31Z xiayu <blacklensama@gmail.com> # alter topic_vote topic author id
api_2017_03_13_alter_table_slide_show_as_diary 2017-03-13T03:54:37Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # 日记本banner以日记本形式展示
doctor_2017_02_14_doctor_register 2017-02-14T10:45:47Z Skyler·Hu <huleping@wanmeizhensuo.com> # add and alter table for regist doctor
api_2017_03_07_create_table_friendlysite_innerhyperlink 2017-03-07T09:36:19Z Jiabin.Wang <wangjiabin@wanmeizhensuo.com> # create table api_friendlysite and api_innerhyperlink
api_2017_03_23_alter_table_api_greetingpopup 2017-03-23T04:35:15Z Ming.xu <xumingming@gmail.com> # 首屏广告优化中新增rank排序字段
api_2017_03_22_add_privatemessage_user_list 2017-03-22T08:39:13Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # 增加批量给用户发送私信
answer_2017_03_14_create_table_answer 2017-03-14T12:04:08Z xiayu <blacklensama@gmail.com> # create a table answer
api_2017_03_14_create_table_user_homepage 2017-03-14T06:33:16Z Ming.xu <xumingming@gmail.com> # 用户设置首页新老版本
api_2017_03_10_add_rank_for_api_searchkeyword 2017-03-10T07:10:13Z ZhouYang <ZhouYang@Esses-MBP.local> # alter table api_searchkeyworkd add column rank
api_2017_03_14_create_api_skupricelog 2017-03-14T03:59:15Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # 创建sku历史记录表
2017_03_10_add_num_in_serviceregisteritem 2017-03-10T10:32:03Z zhangxiaolin <zhangxiaolin@gmei.com> # add add_num for serviceregisteritem
face_2017_03_17_create_table_analyze 2017-03-28T02:45:17Z gushitong <gushitong@kylin.local> # BEGIN;
talos_2017_03_27_alter_api_live_msg 2017-03-27T09:04:39Z Ming.xu <xumingming@gmail.com> # add is_vest_send field on table api_live_msg
talos_2017_03_28_alter_table_api_live_stream 2017-03-28T03:43:42Z Ming.xu <xumingming@gmail.com> # 新增美购香港
2017_03_14_doctor_coupon 2017-03-14T03:53:30Z RobertDing <dingyingcai@gmei.com> # 医生美券model变更
2017-04-10_add_shequ_device_and_integralwall 2017-04-10T12:25:03Z Pengfei.X <pengphy@gmail.com> # add shequ device and integralwall
2017_04_12_add_index_in_seodogest 2017-04-12T03:29:17Z Ming.xu <xumingming@gmail.com> # add index in seodigest
api_2017_03_30_alter_api_pushtask 2017-03-30T07:33:00Z ZhouYang <ZhouYang@Esses-MBP.local> # alter table api_pushtask for precise push
api_2017_04_05_add_markuser 2017-04-05T07:59:01Z Skyler·Hu <huleping@wanmeizhensuo.com> # doctor want add mark user
api_2017_04_11_create_table_userinnerinfo 2017-04-11T08:52:59Z ZhouYang <ZhouYang@Esses-MBP.local> # create table userinnerinfo
2017-04-14_add_act_type 2017-04-14T12:16:36Z Pengfei.X <pengphy@gmail.com> # add column for api_activity
api_20170329_alter_table_serviceregister 2017-03-29T07:27:14Z ZhouYang <ZhouYang@Esses-MBP.local> # meigou revision for table serviceregister
api_20170329_alter_table_service 2017-03-29T07:48:55Z ZhouYang <ZhouYang@Esses-MBP.local> # meigou revision for table service
api_2017_03_29_add_table_servicecomment 2017-03-29T07:45:21Z Jiabin.Wang <wangjiabin@wanmeizhensuo.com> # add api_servicecommentoption and api_servicecomment
api_2017_04_13_fix_seckill_notify 2017-04-13T11:24:41Z Jiahua Ni <nijiahua@gmei.com> # api_2017_04_13_fix_seckill_notify
api_2017_04_13_add_table_doctor_intelligence 2017-04-13T06:44:36Z Ming.xu <xumingming@gmail.com> # add table doctor intelligence
api_2017_04_18_alter_table_docotr_intelligence_add_index 2017-04-18T11:54:15Z Ming.xu <xumingming@gmail.com> # add index
2017-04-24_add_is_online_for_api_city 2017-04-24T10:34:27Z Pengfei.X <pengphy@gmail.com> # add column is_online for api_city
doris_2017_03_28_create_doris_servicestat 2017-03-28T10:48:39Z yangchuncheng <yangchuncheng@gmei.com> # 策略service统计
api_2017_04_12_alter_table_api_speciaextra_column_show_position 2017-04-12T03:31:14Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # 美购外显增加展示类型
api_2017_04_21_create_ranklist 2017-04-21T06:41:15Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # 创建排行榜
api_2017_04_21_alter_table_api_greetingpopup_add_is_sustain 2017-04-21T11:23:11Z Ming.xu <xumingming@gmail.com> # add is_sustain
doctor_2017_05_04_add_msg_mute_noti 2017-05-04T03:16:54Z Skyler·Hu <huleping@wanmeizhensuo.com> # doctor's settings add msg mute notification
api_2017_5_5_create_table_api_user_question_answer 2017-05-05T11:55:21Z Ming.xu <xumingming@gmail.com> # add table api_user_question_answer
doctor_2017_05_03_register_record 2017-05-03T03:57:40Z Skyler·Hu <huleping@wanmeizhensuo.com> # doctor register record add change_fields
doctor_2017_05_03_add_account_record 2017-05-03T10:27:49Z Skyler·Hu <huleping@wanmeizhensuo.com> # doctor add doctor_account record
doctor_2017_05_05_change_register_person 2017-05-05T08:04:41Z Skyler·Hu <huleping@wanmeizhensuo.com> # doctorregister change FK person_id to unique
api_2017_05_09_add_doctoragreement 2017-05-09T03:58:25Z ZhouYang <ZhouYang@Esses-MBP.local> # add table api_doctoragreement

api_2017_05_15_add_full_desc_in_zhiboconfig 2017-05-15T02:57:40Z ZhouYang <ZhouYang@Esses-MBP.local> # add column full_desc in table api_zhiboconfig
answer_2017_05_15_alter_is_spam 2017-05-15T03:15:25Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # 是否为垃圾问答
api_2017_05_16_add_aq_of_zone 2017-05-16T03:03:27Z ZhouYang <ZhouYang@Esses-MBP.local> # add api_overheadanswer and api_overheadquestion table
answer_2017_05_17_alter_question_answer_table_topic_id 2017-05-17T10:53:56Z xiayu <blacklensama@gmail.com> # alter_question_answer_table_topic_id
api_2017_05_15_alter_serviceitemprice_total_num 2017-05-15T10:22:22Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # skuprice增加总数量
talos_2017_05_23_live_stream_add_index 2017-05-23T03:05:51Z xiayu <blacklensama@gmail.com> # live表添加索引
api_2017_05_31_alter_doctorseckillapply 2017-05-31T07:24:26Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # 医生活动提报增加活动类型库存上线
2017_05_27_shopcart 2017-05-27T02:17:29Z RobertDing <dingyingcai@gmei.com> # shopcart add serviceitem and number
api_alter_table_userextra_add_columu_rights_level 2017-05-17T09:44:14Z Ming.xu <xumingming@gmail.com> # add column user_rights_level
2017_05_31_answer_top 2017-05-31T09:02:45Z RobertDing <dingyingcai@gmei.com> # add answer_top
social_2017_05_31_add_virtual_fan 2017-05-31T02:18:00Z ZhouYang <ZhouYang@Esses-MBP.local> # add column is_virtual_fan in table social_userfollow
api_2017_05_31_alter_service_comment_service_item_id 2017-05-31T03:45:30Z xiayu <blacklensama@gmail.com> # alter service_comment_service_item_id

api_2017_05_24_add_column_api_order 2017-05-24T07:07:12Z ZhouYang <ZhouYang@Esses-MBP.local> # add is_ordertoservice in api_order
api_2017_06_05_add_adorder_id 2017-06-05T03:54:38Z peng li <lipeng@gmei.com> # add adorder_id to zhiboyugao and doufukuai

api_2017_06_08_alter_question_addcolumn_city 2017-06-08T09:38:42Z Gengmei <gengmei1@GandeMacBook-Pro.local> # api_2017_06_08_alter_question_addcolumn_city
api_2017_06_12_create_table_api_skulock 2017-06-12T06:38:11Z ZhouYang <ZhouYang@Esses-MBP.local> # create table api_skulock
2017_06_16_alter_table_userextra_add_column_is_push_checkin 2017-06-16T03:48:18Z Ming.xu <xumingming@gmail.com> # add column is_push_checkin on userextra

talos_2017_06_07_create_my_reply_table 2017-06-07T10:07:32Z xiayu <blacklensama@gmail.com> # talos_2017_06_07_create_my_reply_table
api_2017_06_14_create_watermark 2017-06-14T03:01:12Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # 创建促销标签表
api_2017_06_15_alter_talble_searchkeywork_type 2017-06-15T06:41:32Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # 搜索关键字增加类型
api_2017_06_21_alter_seckillnotify_service_item_id 2017-06-21T10:27:19Z Jiahua Ni <nijiahua@gmei.com> # seckillnotify add service_item_id
api_2017_06_30_api_searchkeyword_drop_index_keyword 2017-06-30T03:37:17Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # 删除搜索词unique
api_2017_06_29_alter_service_table_service_type 2017-06-29T07:14:29Z xiayu <blacklensama@gmail.com> # alter_service_type

api_2017_06_28_create_table_api_categorygadget 2017-06-28T07:55:58Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # 新建品类模块表
api_2017_06_28_multitopic 2017-06-28T02:57:17Z ZhouYang <ZhouYang@Esses-MBP.local> # add multitopic tables
api_2017_07_02_order_record_invite_code 2017-07-02T10:21:13Z Jiahua Ni <nijiahua@gmei.com> # order_record_invite_code
2017_06_29_api_columntab_create_table 2017-06-29T06:45:25Z JesseYan <jiayiyan2017@163.com> # 2017_06_29_api_columntab_create_table
api_2017_07_04_add_cost_price 2017-07-04T09:42:40Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # 增加自营成本
2017_07_03_add_pos_machine 2017-07-03T12:00:37Z RobertDing <dingyingcai@gmei.com> # pos机相关
api_2017_07_14_add_unique 2017-07-14T03:24:33Z ZhouYang <ZhouYang@Esses-MBP.local> # add unqiue of api_multitopicreview
api_2017_07_06_add_budan 2017-07-06T07:31:56Z zhangxiaolin <zhangxiaolin@gmei.com> # 添加补单,补单记录,补单结算单三张表
api_2017_07_12_create_rankboard 2017-07-12T07:24:28Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # 新增客户端榜单

2017_07_13_add_coupon_distribution 2017-07-14T02:36:14Z RobertDing <dingyingcai@gmei.com> # 美券分发
2017_07_18_add_hospital_info 2017-07-18T03:15:06Z RobertDing <dingyingcai@gmei.com> # 医院增加字段
api_2017_07_20_create_table_api_shortvideo_black_list 2017-07-20T10:22:50Z 邹明哲 <zoumz@sarabis-MacBook-Pro.local> # 新建直播黑名单

user_2017-07-28_add_index 2017-07-28T10:15:51Z Pengfei.X <pengphy@gmail.com> # masrs_login_add_index
2017_07_13_alter_table_smart_rank_add_column 2017-07-13T10:47:05Z Ming.xu <xumingming@gmail.com> # alter smartrank
2017_08_03_api_multitopic 2017-08-03T07:02:36Z gushitong <gushitong@kylin.local> # drop multitopic question foreign key
2017_07_27_create_api_article 2017-07-25T08:31:40Z JesseYan <jiayiyan2017@163.com> # 创建文章关联表
api_2017_07_26_alter_table_api_slide 2017-07-26T05:56:23Z 邹明哲 <zoumz@sarabis-MacBook-Pro.local> # 新增详情页字段
api_2017_07_28_alter_api_optimizewiki 2017-07-28T09:48:16Z 邹明哲 <zoumz@sarabis-MacBook-Pro.local> # 百科详情展现图片
api_2017_08_01_create_table_api_special_button_city_tag 2017-08-01T10:48:53Z 邹明哲 <zoumz@sarabis-MacBook-Pro.local> # 新建城市tag关联表
doctor_2017_07_26_add_doctor_is_merchant 2017-07-26T08:19:57Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # 医生是否为商户
2017_07_31_installment_hospital 2017-07-31T07:32:08Z RobertDing <dingyingcai@gmei.com> # 可分期医院设置
2018_8_8_alter_table_answer_reply_add_is_read 2017-08-09T04:33:23Z Ming.xu <xumingming@gmail.com> # add is read to answerreply

2017_08_16_change_doctor_account_length 2017-08-16T09:29:01Z RobertDing <dingyingcai@gmei.com> # 修改doctor account_name 长度
api_2017_08_14_add_servicevideo 2017-08-14T03:00:48Z ZhouYang <ZhouYang@Esses-MBP.local> # add service video
api_2017_07_31_add_hospita_info 2017-07-31T07:31:13Z ZhouYang <ZhouYang@Esses-MBP.local> # add table api_hospitalinfo and api_hospitallicenes
2017_08_21_alter_api_slide 2017-08-21T03:00:27Z gushitong <gushitong@kylin.local> # drop foreign_key question answer on api_slide.
hera_2017_08_15_create_sendmailtasklog 2017-08-15T07:40:25Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # 创建导出操作记录表

user_2017-07-26_add_current_city_id 2017-07-26T08:54:06Z Pengfei.X <pengphy@gmail.com> # add current city id for user
message_2017-07-26_add_refer 2017-07-26T09:30:24Z Pengfei.X <pengphy@gmail.com> # add refer from api_conversationuserstatus
api_2017_08_01_add_is_star_in_api_conversation 2017-08-01T06:14:45Z peng li <lipeng@gmei.com> # 在私信表中添加字段是否是星标

api_2017_09_01_alter_sideskidcategory_modify_ordering 2017-09-01T06:47:38Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # api_gmhome_sideskidcategory ordering 可为null
api_2017_08_25_alter_api_pushtask 2017-08-25T08:48:10Z 邹明哲 <zoumz@sarabis-MacBook-Pro.local> # 新增详情页字段
hera_viewmodel_for_diary 2017-09-04T03:49:32Z Chengyang Zhong <zhongchengyang@gmei.com> # hera_viewmodel_for_diary
2017_09_06_add_doctor_business_group 2017-09-06T11:30:25Z RobertDing <dingyingcai@gmei.com> # 医生添加商务组

doctor_2017_09_05_add_bulletinread 2017-09-05T06:03:20Z ZhouYang <ZhouYang@Esses-MBP.local> # add table doctor_bulletinread
api_2017_09_18_create_userauthentication 2017-09-18T10:57:04Z Gengmei <gengmei1@R-deMacBook-Pro.local> # create user authentication by phone
api_2017_09_13_create_api_couponchannel 2017-09-13T05:18:27Z 邹明哲 <zoumz@sarabis-MacBook-Pro.local> # 新建渠道领券表
api_2017_09_22_record_info_for_create_order 2017-09-22T11:05:44Z Jiahua Ni <nijiahua@gmei.com> # record_info_for_create_order
create_table_statistic_baidu_promotion 2017-09-28T07:08:14Z wangmeng <wangmeng@gmail.com> # create statistic_baidu_promotion

api_2017_10_12_alter_GreetingPopup_addfield 2017-10-12T11:42:47Z wangmeng <wangmeng@gmail.com> # add field popup_user_type

api_2017_08_30_create_table_api_specialtag 2017-08-30T06:47:21Z 邹明哲 <zoumz@sarabis-MacBook-Pro.local> # 专题和tag关联表
2017_09_18_add_special_service_dbmw 2017-09-18T03:02:46Z RobertDing <dingyingcai@gmei.com> # 专场美购同步表

2017_09_29_add_maidan_out_trade_no 2017-09-29T10:58:22Z zhangxiaolin <zhangxiaolin@gmei.com> # add_maidan_out_trade_no
api_2017_10_09_alter_api_slide 2017-10-09T09:28:04Z 邹明哲 <zoumz@sarabis-MacBook-Pro.local> # 添加位置字段
api_2017_10_10_alter_api_problem 2017-10-10T07:23:49Z 邹明哲 <zoumz@sarabis-MacBook-Pro.local> # 所长发帖添加是否推荐
api_2017_10_10_alter_api_special 2017-10-10T08:22:35Z 邹明哲 <zoumz@sarabis-MacBook-Pro.local> # 专题列表增加是否广告
2017_09_30_doctor_punishment 2017-09-30T09:35:29Z RobertDing <dingyingcai@gmei.com> # 商户罚单

alter_api_2017_10_17_api_gadget 2017-10-17T04:27:23Z 邹明哲 <zoumz@sarabis-MacBook-Pro.local> # 添加是否在新版本中展示
hippo_20171021_merchant 2017-10-21T15:26:02Z Chengyang Zhong <zhongchengyang@gmei.com> # hippo_20171021_merchant

2017_09_28_add_budansettlement_field 2017-09-28T04:15:10Z zhangxiaolin <zhangxiaolin@gmei.com> # add alread_payment, balance field
2017_09_27_add_statement_refused_record 2017-09-27T08:47:04Z zhangxiaolin <zhangxiaolin@gmei.com> # add_statement_refused_record
api_2017_10_11_add_tables_doctor_finance_province_city 2017-10-11T03:17:37Z peng li <lipeng@gmei.com> # 医生的财务生吃表
statistic_2017_10_25_create_statistic_google_promotion 2017-10-25T04:32:43Z wangmeng <wangmeng@gmei.com> # create statistic google promotion

2017_09_28_add_payment_order 2017-09-28T10:29:25Z zhangxiaolin <zhangxiaolin@gmei.com> # 添加美购支付描述

2017_10_26_user_report_doctor 2017-10-26T09:08:37Z RobertDing <dingyingcai@gmei.com> # 用户举报
alter_2017_10_25_api_punishment 2017-10-25T10:48:16Z 邹明哲 <zoumz@sarabis-MacBook-Pro.local> # 罚单增加处罚方式调权指数

2017_11_01_init_statementall 2017-11-01T02:40:22Z zhangxiaolin <zhangxiaolin@gmei.com> # init statementall, account, operation, feedeductionall
hippo_20171103_billtable 2017-11-03T03:35:59Z ZhouYang <ZhouYang@Esses-MBP.local> # add bill tables

2017_11_02_add_device_binding 2017-11-02T04:00:19Z Gaia Test <test@gmei.com> # 添加用户设备绑定关系表
2017_11_08_add_lasker 2017-11-08T10:52:27Z Gaia Test <test@gmei.com> # 金刀奖
api_2017_11_17_record_doctor_coupon_info 2017-11-17T11:10:45Z Jiahua Ni <nijiahua@gmei.com> # api_2017_11_17_record_doctor_coupon_info
api_2017_11_22_update_record_doctor_coupon_info 2017-11-22T09:25:48Z Jiahua Ni <nijiahua@gmei.com> # api_2017_11_22_update_record_doctor_coupon_info

2017_11_16_add_search_words 2017-11-17T02:45:52Z Ming.xu <xumingming@gmail.com> # search words recommend
2017_11_10_add_img_in_coupondistribute 2017-11-10T10:27:50Z add img <chenfeifei@chenfeifeideMacBook-Pro.local> # add img
2017_11_14_add_pushcoupon 2017-11-14T03:07:12Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # 增加没权推送表

2017_11_08_create_searchkeyword_city_region 2017-11-08T04:25:47Z 邹明哲 <zoumz@sarabis-MacBook-Pro.local> # 热门搜索词关联大区城市
2017_11_29_add_words_length 2017-11-29T10:54:54Z Ming.xu <xumingming@gmail.com> # add words lenght
2017_11_29_change_words_type 2017-11-29T11:36:00Z Ming.xu <xumingming@gmail.com> # change words type to longtext
# 2017_12_04_api_message_add_column 2017-12-04T11:36:31Z xufukun <xufukun@igengmei.com> # 私信消息表添加body字段, just for recording::

hippo_2017_11_15_add_qdvertise_Table 2017-11-15T01:22:56Z peng li <lipeng@gmei.com> # 医生页面浏览和私信服务费服务明细
hippo_20171120_add_doctormessage 2017-11-20T02:48:36Z ZhouYang <ZhouYang@Esses-MBP.local> # add hippo_doctormessage

api_2017_12_07_alter_point 2017-12-07T11:15:54Z Pengfei.X <pengphy@gmail.com> # alter point reason

2017_12_04_pv_punishment 2017-12-04T02:54:57Z RobertDing <dingyingcai@gmei.com> # pv罚单

2017_12_04_alter_api_coupon 2017-12-04T06:56:00Z zoumingzhe <zoumingzhe@gmei.com> # 美券增加费用承担部门和生效人
2017_12_05_create_api_rankboardbatch 2017-12-05T11:45:45Z zoumingzhe <zoumingzhe@gmei.com> # 聚合榜单以及映射表
2017_12_06_alter_api_serviceregister 2017-12-06T09:07:32Z zoumingzhe <zoumingzhe@gmei.com> # 增加美购待包装描述
2017_12_02_point_mall 2017-12-02T07:45:52Z RobertDing <dingyingcai@gmei.com> # 美分商城

api_2017_12_07_alter_api_slide_column 2017-12-07T12:07:22Z wangmeng <wangmeng@gmei.com> # add columns
api_2017_12_07_alter_api_specialexterior_column 2017-12-07T12:15:31Z wangmeng <wangmeng@gmei.com> # add columns
api_2017_12_07_alter_api_greetingpopup_column 2017-12-07T12:19:38Z wangmeng <wangmeng@gmei.com> # add columns

api_2017_12_15_alter_notification_length 2017-12-15T08:17:32Z Pengfei.X <pengphy@gmail.com> # alter notification length

2017_12_18_alter_greetingpopup 2017-12-18T03:43:51Z zoumingzhe <zoumingzhe@gmei.com> # 增加大区城市

statistic_2017_12_22_create_table_statistic_promotion_channel 2017-12-22T08:47:36Z wangmeng <wangmeng@gmei.com> # create statistic_promotion_channel

hippo_2017_12_11_add_doctor_hospital_extra 2017-12-11T08:35:33Z peng li <lipeng@gmei.com> # 添加医生医院属性

statistic_2017_12_25_add_platform_promotion_channel 2017-12-25T11:09:23Z wangmeng <wangmeng@gmei.com> # add platform_type of promotion channel
api_20171221_use_two_coupon 2017-12-21T07:02:10Z Jiahua Ni <nijiahua@gmei.com> # api_20171221_use_two_coupon
2017_12_15_create_api_homepageoperate 2017-12-15T11:03:20Z zoumingzhe <zoumingzhe@gmei.com> # 首页运营位统一
lasker_2017_12_21_create_table_awardresult 2017-12-21T10:54:26Z yuhao <liaoyuhao@igengmei.com> # create a table lasker_awardresult

hippo_2017_12_14_add_rechangbill 2017-12-14T07:15:48Z ZhouYang <ZhouYang@Esses-MBP.local> # add ad rechange bill
api_2017_12_27_add_budan_luru_table 2017-12-27T01:14:45Z peng li <lipeng@gmei.com> # 添加补单录入表

pay_20180102_add_total_discount 2018-01-02T02:15:18Z ZhouYang <ZhouYang@Esses-MBP.local> # add column total_discount in pay_statement

api_2017_12_29_kabalance 2017-12-29T04:24:43Z chenwei <chenwei@igengme.com> # create kabalance table to mysql
statistic_2018_01_15_add_income_value 2018-01-15T18:24:43Z kula <zhengwei@igengme.com> # 增加收入指数

2018_01_02_alter_api_slide_add_new_slide_img 2018-01-02T07:14:55Z zoumingzhe <zoumingzhe@gmei.com> # 轮播图增加新版本图片字段
api_2018_01_05_add_municipality.sql 2018-01-09T08:59:40Z xufukun <xufukun@igengmei.com> # api_province表添加is_municipality字段
2018_01_12_advertisemanagement_type 2018-01-12T09:38:33Z RobertDing <dingyingcai@gmei.com> # 广告位运营类型
hippo_20180118_merchant_nonsync 2018-01-18T06:33:30Z Chengyang Zhong <zhongchengyang@gmei.com> # hippo_20180118_merchant_nonsync
hippo_2018_01_10_add_userbrowsing 2018-01-11T02:07:12Z peng li <lipeng@gmei.com> # add table hippo_userbrowsing
hippo_20170110_add_hospital_info 2018-01-10T03:15:26Z ZhouYang <ZhouYang@Esses-MBP.local> # add hospital info tables
hippo_2018_01_19_add_uniq_key_on_userbrowsing 2018-01-19T09:59:16Z peng li <lipeng@gmei.com> # description for this schema change

api_20180130_create_table_api_ordercategory 2018-01-30T10:03:58Z Chengyang Zhong <zhongchengyang@gmei.com> # api_20180130_create_table_api_ordercategory

2018_01_18_alter_api_pushtask_qa 2018-01-18T07:49:09Z zoumingzhe <zoumingzhe@gmei.com> # 消息推送增加问答类型
api_2018_1_16_create_table_photostorage 2018-01-16T11:43:35Z chenwei <chenwei@igengme.com> # create a table photostorage
hippo_20180124_ad_deduct 2018-01-24T03:05:32Z ZhouYang <ZhouYang@Esses-MBP.local> # add ad_whitelist and pv_over_norm


2018_01_26_alter_api_searchkeyword_add_jump_type 2018-01-26T06:27:36Z zoumingzhe <zoumingzhe@gmei.com> # 热门搜索词增加跳转类型和特殊样式
wiki_20180129_create_wiki_models 2018-01-29T02:56:30Z 陈菲菲 <chenfeifei@chenfeifeideMacBook-Pro.local> # 新百科建表
api_20180202_shopcart 2018-02-02T07:38:45Z Jiahua Ni <nijiahua@gmei.com> # api_20180202_shopcart
statistic_2018_02_12_create_statistic_service_smart_rank_v2 2018-02-12T17:38:45Z kula <zhengwei@igengmei.com> # statistic_service_smart_rank_v2

statistic_2018_02_27_alter_staticstic_service_smart_rank_v2 2018-02-27T18:48:45Z kula <zhengwei@igengmei.com> # alter statistic_service_smart_rank_v2
statistic_2018_03_06_alter_staticstic_service_smart_rank_v2 2018-03-06T18:52:45Z kula <zhengwei@igengmei.com> # alter statistic_service_smart_rank_v2
2018_02_22_alter_api_special 2018-02-22T03:51:34Z zoumingzhe <zoumingzhe@gmei.com> # 增加专场秒杀类型字段
2018_02_22_create_api_specialresource 2018-02-22T10:44:33Z zoumingzhe <zoumingzhe@gmei.com> # 秒杀资源位
api_20180227_settlement_add_cancel_reason 2018-02-27T11:47:55Z Jiahua Ni <nijiahua@gmei.com> # api_20180227_settlement_add_cancel_reason
api_20180313_tag_resembles 2018-03-13T04:07:58Z Chengyang Zhong <zhongchengyang@gmei.com> # api_20180313_tag_resembles
statistic_2018_03_23_create_statistic_service_smart_rank_v3 2018-03-23T12:38:45Z kula <zhengwei@igengmei.com> # statistic_service_smart_rank_v3
api_2018_2_22_create_diaryspreadfit 2018-02-22T07:07:23Z chenwei <chenwei@igengme.com> # 新增首页日记本按地域设置分
2018-04-02_alter_specialseckillbutton_add_fixed_price 2018-04-02T11:35:59Z zoumingzhe <zoumingzhe@gmei.com> # 增加固定价格
api_20180402_wordrel 2018-04-02T07:52:30Z Chengyang Zhong <zhongchengyang@gmei.com> # api_20180402_wordrel
polymer_2018_03_30_polymer 2018-03-30T10:03:32Z RobertDing <dingyingcai@gmei.com> # 内容聚合
hippo_2018_04_16_add_doctor_resource_rank 2018-04-16T10:47:43Z yangjiaronga <weichengfei@igengmei.com> # add table doctor_service_rank and doctor_diary_rank
api_2018_04_13_add_two_column_fields 2018-04-13T04:14:35Z chenwei <chenwei@igengme.com> # create slide_banner_img color fields
area_2018_04_26 2018-04-27T12:33:00Z RobertDing <dingyingcai@gmei.com> # 城市配置
hippo_2018_04_17_add_doctor_business_data 2018-04-23T03:12:55Z peng li <lipeng@gmei.com> # doctor_business_data

api_2018_05_05_create_table_indexfeed 2018-05-05T04:15:12Z chenwei <chenwei@igengme.com> # create table indexfeed
hippo_2018_05_07_alter_table_hospitalextra_add_notice 2018-05-07T04:30:23Z yangjiaronga <weichengfei@igengmei.com> # hippo_2018_05_07_alter_table_hospitalextra_add_notice
hippo_2018_05_16_add_business_data 2018-05-16T01:46:32Z peng li <lipeng@gmei.com> # description for this schema change

api_2018_04_18_add_rank_position 2018-04-18T02:12:52Z chenwei <chenwei@igengme.com> # add rankposition field
2018_05_23_cashback 2018-05-23T03:34:05Z Gaia Test <test@gmei.com> # cashback app models initialize
2018_05_23_polymer_tab_recommend 2018-05-24T05:38:29Z RobertDing <dingyingcai@gmei.com> # polymer tab recommend
api_2018_05_15_create_table_college 2018-05-15T06:45:11Z chenwei <chenwei@igengme.com> # 添加大学表

hippo_2018_05_14_alter_table_hospitalextra_add_scale 2018-05-14T03:17:01Z yangjiaronga <weichengfei@igengmei.com> # hippo_2018_05_14_alter_table_hospitalextra_add_scale

api_20180428_specialitem_add_position 2018-04-27T10:15:34Z Chengyang Zhong <zhongchengyang@gmei.com> # api_20180428_specialitem_add_position

2018_06_22_create_weikuan_hospitalpay 2018-06-22T03:46:51Z zoumingzhe <zoumingzhe@gmei.com> # 尾款支付单表
hippo_2018_05_31_merchant_info 2018-05-31T08:45:36Z esse <zhouyang@igengmei.com> # add merchant info tables
api_2018_06_08_add_cloumn_xiaochengxu_img 2018-06-08T02:33:14Z chenwei <chenwei@igengme.com> # special表增加xiaochengxu_img字段

filterword_2018_06_25_upgrade_filterword 2018-06-25T07:30:19Z XuJunPeng <xujunpeng@igengmei.com> # 评论等ugc的敏感词库升级

2018_07_05_create_index_function 2018-07-05T06:55:47Z zoumingzhe <zoumingzhe@gmei.com> # 首页改版增加功能区表以及已有表格增加部分字段
2018_07_04_doctor_rank_factor 2018-07-04T07:48:16Z Gaia Test <test@gmei.com> # 医生排序因子
api_2018_07_06_bd_transfer 2018-07-06T11:09:35Z chenwei <chenwei@igengme.com> # 商务转诊相关表
api_2018_07_24_alter_userextra_auth_type 2018-07-24T08:57:48Z ZhangYingjie <zhangyingjie@igengmei.com> # alter api_userextra auth_type
api_2018_07_26_alert_content_length 2018-07-26T11:03:57Z chenwei <chenwei@igengme.com> # 修改沟通记录表content长度

pay_20180726_momo_log_db 2018-07-26T09:29:03Z Jiahua Ni <nijiahua@gmei.com> # pay_20180726_momo_log_db

2018_07_18_create_api_nearby_city 2018-07-18T06:59:18Z zoumingzhe <zoumingzhe@gmei.com> # 创建邻近城市表
2018_07_26_create_api_nearby_city_to_es 2018-07-26T10:20:57Z zoumingzhe <zoumingzhe@gmei.com> # es使用的邻近城市表

polymer_2018_07_20_create_polymer_toptitle 2018-07-20T08:43:40Z Mac <mac@MacdeMacBook-Pro.local> # create_table_polymer_toptitle #内容聚合页新加置顶信息表

api_2018_07_12_add_related_fields 2018-07-12T09:41:52Z chenwei <chenwei@igengme.com> # 内容聚合推荐增加相应字段
api_2018_07_13_greetingpopup_add_image_ipx 2018-07-13T06:16:15Z wangkai <wangkai@igengmei.com> # alter table greetingpop add image_ipx

polymer_2018_07_30_addattrbute 2018-07-30T03:08:00Z Mac <mac@MacdeMacBook-Pro.local> # 内容聚合页增加问题默认分类、问题分类字段
2018_08_06_alter_table_polymer_external_display 2018-08-06T10:04:11Z ZhangYingjie <zhangyingjie@igengmei.com> # table polymer add column external_display

add_tongdun2018_07_30_device_user 2018-07-31T10:00:28Z Mac <mac@MacdeMacBook-Pro.local> # 同盾合作相关字段
20170802-add-polymer_extra_info 2018-08-02T04:10:19Z JackieZhang <zlujackie@gmail.com> # 添加聚合页统计信息（目前仅仅针对讨论聚合页）
2018_07_30_create_api_tab_operation 2018-07-30T09:48:29Z zoumingzhe <zoumingzhe@gmei.com> # 新增首页tab运营池
create_table_pushtaskpolymer_2018_08_07 2018-08-07T12:09:15Z Mac <mac@MacdeMacBook-Pro.local> # 推送优化修改
2017_08_14_add_column_tongdun_exist_device 2018-08-14T06:02:11Z JackieZhang <zlujackie@gmail.com> # 设备表添加同盾是否请求字段
2017_08_14_add_column_device_idfa 2018-08-15T07:34:17Z JackieZhang <zlujackie@gmail.com> # 添加同盾注册设备信息表
2017_08_16_delete_device_tongdun_info 2018-08-16T02:47:42Z JackieZhang <zlujackie@gmail.com> # 设备表中删除同盾的相关信息
2018_08_16_alter_table_api_cityscale 2018-08-16T07:44:18Z ZhangYingjie <zhangyingjie@igengmei.com> # 内容占比增加特大城市比例
2018_08_16_create_table_api_cityscale_nearby_city 2018-08-16T07:44:55Z ZhangYingjie <zhangyingjie@igengmei.com> # create table api_cityscale_nearby_city
api_2018_08_08_add_cloumn_with_special 2018-08-08T07:00:31Z chenwei <chenwei@igengme.com> # 增加拼团相关字段及其表
20180822_alter_polymer_polymercontent 2018-08-22T09:04:37Z zoumingzhe <zoumingzhe@gmei.com> # content类型字段加长
api_2018_08_10_alter_table_polymer_add_rank 2018-08-10T07:58:24Z ZhangYingjie <zhangyingjie@igengmei.com> # 聚合页增加默认排序字段
api_2018_08_14_add_new_banner_size_colume 2018-08-14T09:14:28Z XuJunPeng <xujunpeng@igengmei.com> # banner尺寸整理
2018_08_16-add-varietyvote-tables 2018-08-23T09:18:35Z JackieZhang <zlujackie@gmail.com> # 综艺投票节目
create_table_pushtask_qa_have_alert 2018-08-27T10:17:44Z Mac <mac@MacdeMacBook-Pro.local> # hera回答是否有推送内容
api_2018_09_05_add_lipstick_table 2018-09-05T06:36:12Z chenwei <chenwei@igengme.com> # 增加口红活动相关表
2018_09_04_create_new_wiki_tag 2018-09-04T06:41:58Z zoumingzhe <zoumingzhe@gmei.com> # 新百科关联标签
polymer_2018_09_04_polymer_add_column 2018-09-04T10:42:02Z wangkai <wangkai@igengmei.com> # introduction and bg_image for polymer
api_2018_08_28_function_entry_add_payment_colume 2018-08-28T02:51:39Z XuJunPeng <xujunpeng@igengmei.com> # 功能入口配置增加支付类型字段
2018_10_10_alter_api_privatemessagepush 2018-10-10T06:21:14Z zoumingzhe <zoumingzhe@gmei.com> # 增加url跳转链接
2018_09_15_create_table_channel_gift_statistics 2018-09-21T05:45:11Z yangjiaronga <weichengfei@igengmei.com> # 2018_09_21_alter_groupbuy_special_add_column
api_2018_09_18_add_skuexaminelist_and_skuexamine_list 2018-09-18T02:43:45Z chenwei <chenwei@igengme.com> # sku改价待审核相关表
doctor_2018_09_18_message_mechanism_chain 2018-09-18T08:50:40Z peng li <lipeng@gmei.com> # mechanism_chain
2018_10_11_create_table_channel_gift_statistics 2018-10-11T09:16:39Z yangjiaronga <weichengfei@igengmei.com> # 增加优惠券发放的统计表
api_2018_10_11_add_more_reason_colum 2018-10-11T08:04:32Z chenwei <chenwei@igengme.com> # sku改价待审核相关表
2018_10_27_alter_api_variety_idol 2018-10-25T02:42:15Z zoumingzhe <zoumingzhe@gmei.com> # 支持口红王子最后一期总结活动
polymer_2018_09_28_create_table_deliver_polymer 2018-09-25T10:25:50Z XuJunPeng <xujunpeng@igengmei.com> # 新增投稿小组表
api_2018_10_08_alter_table_api_settlement 2018-10-08T07:07:19Z ZhangYingjie <zhangyingjie@igengmei.com> # api_settlement add column auto_create_diary
hippo_2018_10_12_hospital_index_revised 2018-10-12T03:49:14Z peng li <lipeng@gmei.com> # hospital_revised
api_2018_10_25_add_special_colum 2018-10-25T11:49:31Z chenwei <chenwei@igengme.com> # 增加专题关联
2018_10_27_alter_table_awards_add_column_laureate_type 2018-10-26T07:31:01Z yangjiaronga <weichengfei@igengmei.com> # 名医大赏奖项添加作用人员类型
2018_10_26_alter_table_lasker_participant_add_column 2018-10-26T10:07:03Z ZhangYingjie <zhangyingjie@igengmei.com> # lasker_participant add column votes_num
2018_11_19_create_model_user 2018-11-19T03:20:21Z zoumingzhe <zoumingzhe@gmei.com> # 创建用户类型池 商家设备池
create_table_sign_activity 2018-11-20T12:02:02Z Mac <mac@MacdeMacBook-Pro.local> # 7730连续签到需求
2018_11_30_firendlysite_add_coloumn_city 2018-11-30T02:52:08Z JackieZhang <zlujackie@gmail.com> # 友情链接添加城市
api_2018_10_31_add_soyoungserviceitem_table 2018-10-31T08:43:22Z chenwei <chenwei@igengme.com> # 增加新氧数据信息及其关联表
modify_soyoung_service_item_table 2018-12-20T07:30:29Z chenwei <chenwei@igengmei.com> # 修改新氧表结构
api_2018_12_17_add_some_fileds_bdtransfer_model_for_call_center 2018-12-17T05:34:50Z yangjiaronga <weichengfei@igengmei.com> # add some fileds in bdtransfer model for call center
api_create_table_sign_status 2018-12-20T10:17:00Z Mac <mac@MacdeMacBook-Pro.local> # 签到活动优化相关表
api_2018_12_27_create_table_singlerecord_log 2018-12-27T14:07:29Z yangjiaronga <weichengfei@igengmei.com> # create table single record log
2019_01_02_create_table_api_dbtransfer_daychangelog 2019-01-02T09:47:32Z kula <zhengwei@igengmei.com> # 创建转正状态变更表
mimas_2018_12_25_diary_add_cloumn_is_import 2018-12-25T03:59:44Z chenwei <chenwei@igengmei.com> # 增加日记本是否导入字段
2019_01_04_create_table_api_bdtransfer_thread_income 2019-01-04T06:24:47Z kula <zhengwei@igengmei.com> # 派单收入明细表
al_wiki_cityvisit_topten_d 2019-01-07T08:50:57Z duanyingrong  <duanyingrong@igengmei.com> # 增加百科点击埋点数据表
2019_01_10_al_wiki_cityvisit_topten_d_add_column 2019-01-10T06:34:56Z ZhangYingjie <zhangyingjie@igengmei.com> # al_wiki_cityvisit_topten_d add column
2019_01_14_add_unique_index_in_sign_table 2019-01-14T03:04:03Z Mac <mac@MacdeMacBook-Pro-8.local> # 签到表添加联合唯一索引
2018_12_28_alter_api_special_add_promotion_image 2018-12-28T12:13:01Z zoumingzhe <zoumingzhe@gmei.com> # 专题表增加大促图片
api_2019_01_03_add_sign_icon 2019-01-03T02:53:10Z Mac <mac@MacdeMacBook-Pro-8.local> # 签到优化添加icon
2019_01_02_create_table_new_wiki_relation_wordrel 2019-01-02T03:36:13Z ZhangYingjie <zhangyingjie@igengmei.com> # 新百科关联同义近义词，词根
gaia_2019_01_11_add_table_about_new_spring 2019-01-11T10:45:05Z chenwei <chenwei@igengmei.com> # 增加新春活动相关表
2019_02_12_alter_channel_version_add_column 2019-02-12T13:02:16Z zoumingzhe <zoumingzhe@gmei.com> # 安卓版本表增加是否确认字段
create_table_bdtransfer_web_kefu 2019-02-19T08:06:09Z Yangjiaronga <weichengfei@igengmei.com> # create table bdtransfer_web_kefu
2019_02_14_change_add_sign 2019-02-12T06:49:18Z Mac <mac@MacdeMacBook-Pro-8.local> # 签到兑换修改
gaia_2019_02_14_add_spider_third_platform_table 2019-02-14T10:14:54Z chenwei <chenwei@igengmei.com> # 增加爬虫比价表
20190227_alter_configuration_tables_add_column 2019-02-27T03:13:35Z zoumingzhe <zoumingzhe@gmei.com> # 主要配置内容增加类别字段
gaia_2019_02_19_add_related_fields 2019-02-19T10:39:23Z chenwei <chenwei@igengmei.com> # 增加商户连锁账号运营关联

create_table_api_budan_ref_order 2019-03-11T02:57:10Z Yangjiaronga <weichengfei@igengmei.com> # create table api_budan_ref_order
2019-3-6_create_table_slide_display 2019-03-06T07:03:01Z 张永 <zhangyong@igengmei.com> # 轮播图展示地址
create_table_platform_user 2019-03-09T10:36:21Z Mac <mac@MacdeMacBook-Pro-8.local> # 注册登录第三方表
hippo_20190124_update_doctorregister 2019-01-24T02:12:16Z esse <zhouyang@igengmei.com> # add is_merchant and merchant_id in doctorregister

hippo_2019_03_18_add_table_merchant_related_info 2019-03-18T11:22:36Z peng li <lipeng@gmei.com> # description for this schema change
2019_03_20_modify_api_problem 2019-03-20T07:27:59Z Yangchenglin <yangchenglin@igengmei.com> # ADD COLUMN apply_phone
gaia_new_special_add_fields 2019-03-05T07:40:34Z chenwei <chenwei@igengmei.com> # 新专题增加字段
2019_03_14_alter_table_bdtransfer_single_record 2019-03-14T09:16:32Z Yangjiaronga <weichengfei@igengmei.com> # alter table bdtransfer_single_record add column and change column
20180327_create_service_home_tables 2019-03-27T06:49:50Z zoumingzhe <zoumingzhe@gmei.com> # 美购首页改版
wiki_add_table_video_library 2019-03-25T10:31:27Z ZhangYingjie <zhangyingjie@igengmei.com> # wiki add table api_video_library

api_20190401_bd_transfer 2019-04-01T03:29:44Z esse <zhouyang@igengmei.com> # add bdtransfer apply tables
2019_04_09_add_speciallayout_unique 2019-04-09T12:38:31Z chenwei <chenwei@igengmei.com> # 增加楼层唯一约束
user_ground_push 2019-04-08T09:12:58Z wangkai <wangkai@igengmei.com> # 添加用户推广的n张表
update_charset 2019-04-11T02:44:28Z wangkai <wangkai@igengmei.com> # update table charset to utf8mb64
update_nickname_to_mb64 2019-04-12T01:42:10Z wangkai <wangkai@igengmei.com> # 修改nickname字段为mb64
2019_04_08_add_category_tables 2019-04-08T04:12:55Z chenwei <chenwei@igengmei.com> # 增加品类聚合相关表
gaia_2019_04_08_add_homepage_icon_table 2019-04-08T03:29:58Z XuJunPeng <xujunpeng@igengmei.com> # 增加首页icon配置表,首页节日特殊展示表
2019_04_17_add_category_polymer_name 2019-04-17T07:46:09Z chenwei <chenwei@igengmei.com> # 增加name字段
2019_04_22_special_related_tag 2019-04-22T03:40:47Z chenwei <chenwei@igengmei.com> # 专题关联tag
api_hospital_add_new_columns 2019-04-25T07:44:00Z zhanghang <zhanghang@zhanghangdeMacBook-Pro.local> # 新增是否删除字段
2019_04_24_add_new_banner 2019-04-24T09:19:25Z chenwei <chenwei@igengmei.com> # 轮播图增加新尺寸
api_2019_04_29_add_triggr_for_user_change 2019-04-29T07:39:19Z xiaowei <xiaowei@igengmei.com> # add trigger when user info changed
2019_04_25_discount_coupon 2019-04-25T03:43:55Z chenwei <chenwei@igengmei.com> # 新增折扣券
al_tractate_city_hotkeyword 2019-04-29T05:16:01Z Lxrent <lxrent@lxrentdeMacBook-Pro.local> # 新增帖子热门搜索词表
hippo_2019_05_05_service_add_merchant_id 2019-05-05T06:42:45Z peng li <lipeng@gmei.com> # service_merchant_id
api_2019_04_28_add_homepage_feeds_and_new_tab 2019-04-28T03:53:05Z XuJunPeng <xujunpeng@igengmei.com> # 增加首页feed,新tab表
2019_4_29_create_table_icon 2019-04-29T10:01:30Z 张永 <zhangyong@igengmei.com> # user center icon
add_user_update_time 2019-05-23T03:10:46Z wangkai <wangkai@igengmei.com> # 用户表添加update_time
create_table_sign_v2 2019-05-23T02:14:00Z Mac <mac@MacdeMacBook-Pro-8.local> # 签到新版相关表
wiki_2019_05_27_api_video_library_add_column 2019-05-27T03:35:03Z ZhangYingjie <zhangyingjie@igengmei.com> # api_video_library add column
2019_06_04_add_beautyphoto_table 2019-06-04T07:56:21Z chenwei <chenwei@igengmei.com> # 新增美图关联表
2019_6_3_create_table_api_face_one_image 2019-06-04T09:41:42Z 张永 <zhangyong@igengmei.com> # create table api_face_one_image
add_is_delete_for_api_budan_ref_order 2019-06-06T07:02:36Z zhanghang <zhanghang@zhanghangdeMacBook-Pro.local> # 增加是否删除字段
yd_create 2019-05-18T09:47:37Z wangkai <wangkai@igengmei.com> # 青年医生
hippo_20190618_add_ad_check_time 2019-06-18T02:09:10Z esse <zhouyang@igengmei.com> # add ad_check_start_time and ad_check_end_time
api_2019_06_10_feedoperatev2_add_column 2019-06-05T08:07:36Z XuJunPeng <xujunpeng@igengmei.com> # feeds流插入表增加字段
2019_06_03_add_servicerelatedoperation_table 2019-06-03T02:59:06Z chenwei <chenwei@igengmei.com> # 新增美购首页运营位关联配置
2019_6_18_add_al_search_rank_table 2019-06-18T03:09:18Z zhanghang <zhanghang@zhanghangdeMacBook-Pro.local> # 增加热门搜索词表
2019-06-19-scan-face-facial 2019-06-19T07:21:08Z JackieZhang <zlujackie@gmail.com> # 扫脸v2.0 脸部特征
api_2019_06_20_create_table_for_scan_face 2019-06-20T08:46:36Z ZhangYingjie <zhangyingjie@igengmei.com> # create table api_face_one_image_v2
mychangeplan 2019-06-21T07:49:16Z gaomingming <apple@AppledeMacBook-Pro.local> # 修改alert列编码
2019_06_12_add_some_fields_about_bdtransfer 2019-06-12T09:36:14Z chenwei <chenwei@igengmei.com> # 新增转诊补单字段
2019_06_26_update_express_no_type 2019-06-26T10:35:39Z Mac <mac@MacdeMacBook-Pro-8.local> # 批量上传运单号更改数据类型

2019_06_24_add_indextab_classify 2019-06-24T09:36:49Z Mac <mac@MacdeMacBook-Pro-8.local> # 首页新增IBeautyTab
2019_6_18_person_search_hot_words 2019-06-18T07:34:32Z zhanghang <zhanghang@zhanghangdeMacBook-Pro.local> # 增加人工专有配置搜索词
device_category_add 2019-06-25T07:35:25Z wangkai <wangkai@igengmei.com> # 添加设备品类表定义
2019-6-19_create_aglie_models 2019-06-19T11:00:51Z 张永 <zhangyong@igengmei.com> # 新帖子体系表
mypushtask 2019-07-02T06:53:03Z gaomingming <apple@AppledeMacBook-Pro.local> # Creates a an application user.
hippo_20190627_add_userbrowsing_count 2019-06-27T08:22:46Z esse <zhouyang@igengmei.com> # add table hippo_merchantdailyconv
2019_07_10_add_user_push_click 2019-07-10T07:40:23Z wangkai <wangkai@igengmei.com> # postoperative_care
assist_prize 2019-07-05T03:15:39Z wangkai <wangkai@igengmei.com> # add table for assist
fix_assist_prize 2019-07-06T06:53:26Z wangkai <wangkai@igengmei.com> # fix assist prize
2019_07_12_add_cloumn_order_has_service_comment 2019-07-12T03:34:49Z chenwei <chenwei@igengmei.com> # 增加订单是否有评价
2019_07_01_add_cloumn_doctor_coupon_use_type 2019-07-01T09:25:05Z chenwei <chenwei@igengmei.com> # 增加医生美券使用类型
2019_07_08_add_doctor_extra_cloumn 2019-07-08T08:36:40Z peng li <lipeng@gmei.com> # 2019_07_08_add_doctor_extra_cloumn
api_2019_07_16_facialcombi_add_column_celebrity 2019-07-16T03:45:50Z XuJunPeng <xujunpeng@igengmei.com> # 增加明星字段
add_seq_on_category 2019-07-17T03:27:36Z wangkai <wangkai@igengmei.com> # 品类基础表添加序号字段
appcolumn 2019-07-08T04:57:53Z gaomingming <apple@AppledeMacBook-Pro.local> # Creates a an application user.
2019_07_04_api_agile_tag_add_column 2019-07-04T08:05:05Z ZhangYingjie <zhangyingjie@igengmei.com> # api_agile_tag add column
2019_07_07_add_table_user_old_new 2019-07-07T02:36:18Z peng li <lipeng@gmei.com> # add table new old
pushuser 2019-07-24T12:41:00Z wangkai <wangkai@igengmei.com> # add is_all
2019_07_16_add_doctor_fields 2019-07-16T12:06:45Z chenwei <chenwei@igengmei.com> # 增加医院医生更新时间
2019_07_19_create_table_agile_tag_hera_recommend 2019-07-19T08:24:28Z ZhangYingjie <zhangyingjie@igengmei.com> # create table api_agile_tag_hera_recommend
api_20190723_dev_projects_length 2019-07-23T10:57:15Z esse <zhouyang@igengmei.com> # change api_budan dev_projects length
api_20190807_add_smartrank_time 2019-08-07T12:04:00Z esse <zhouyang@igengmei.com> # add update_time of api_smartrank
2019_08_08_add_smart_rank_factor 2019-08-08T03:36:22Z chenwei <chenwei@igengmei.com> # 增加美购smart_rank因子
hippo_2019_08_06_alter_table_merchant_add_merchant_columns 2019-08-06T04:06:33Z songzhenqi <songzhenqi@igengmei.com> # 商户表增加字段
api_2019_07_29_add_face_type_image_url 2019-07-29T10:48:18Z XuJunPeng <xujunpeng@igengmei.com> # 增加脸型对应的动漫图
2019-07-31-polymer 2019-07-31T11:00:52Z JackieZhang <zlujackie@gmail.com> # 聚合页改版调整
api_2019_08_02_add_change_face_table 2019-08-02T03:18:29Z XuJunPeng <xujunpeng@igengmei.com> # 增加变量相关表结构
alter_table_sign_add_detail 2019-08-02T11:21:13Z Mac <mac@MacdeMacBook-Pro-8.local> # 添加签到奖品详情页
api_2019_08_14_alter_table_api_budanluru_add_column_type 2019-08-14T01:37:59Z songzhenqi <songzhenqi@igengmei.com> # 补单录增加类型字段
alert_table_icon_add_column_old_image 2019-08-19T02:34:40Z 张永 <zhangyong@igengmei.com> # icon添加老版本图片
api_2019_08_18_add_facial_feature_family_table 2019-08-19T03:26:59Z XuJunPeng <xujunpeng@igengmei.com> # 增加五官分类信息表
gm_ai_20190822_puzzle_image 2019-08-22T02:04:41Z xiaowei <xiaowei@igengmei.com> # add puzzle_image table for gm_ai:face_app
2019_08_15_api_topic_aggregation 2019-08-15T07:11:33Z xueqianqian <xueqianqian@igengmei.com> # 增加搜索导航页话题聚合配置
api_2019_08_16_alter_table_api_pushtask2_add_column_push_image 2019-08-16T07:57:56Z songzhenqi <songzhenqi@igengmei.com> # 推送图片
2019_08_21_update_api_searchkeyword 2019-08-21T07:41:13Z xueqianqian <xueqianqian@igengmei.com> # 增加表字段
2019-08-21-add_skin_result_model 2019-08-21T09:39:17Z wanghao <haoweiking@gmail.com> # 添加测肤结果model
2019_08_31_add_is_back_field 2019-08-31T13:40:13Z chenwei <chenwei@igengmei.com> # 增加回抛字段标示
2019_09_01_add_pooled_field 2019-09-01T08:02:56Z chenwei <chenwei@igengmei.com> # 增加入池时间
hippo_2019_09_03_alter_table_billapplyrecord_add_column_remark 2019-09-03T06:56:42Z songzhenqi <songzhenqi@igengmei.com> # 发票申请表增加备注
hippo_2019_08_23_add_table_userlist 2019-08-23T08:06:18Z songzhenqi <songzhenqi@igengmei.com> # 增加用户列表
hippo_2019_08_30_alter_table_merchant_add_column_is_freeze 2019-08-30T09:08:08Z songzhenqi <songzhenqi@igengmei.com> # 商户表增加冻结状态字段
hippo_2019_08_30_create_table_merchantfreezerecord 2019-08-30T09:14:35Z songzhenqi <songzhenqi@igengmei.com> # 新建用户冻结操作日志表
2019_08_29_create_table_pushreadlog 2019-08-29T06:22:29Z 张永 <zhangyong@igengmei.com> # 消息相关表
2019_08_23_add_table_ip_device 2019-08-23T12:57:35Z apple <apple@apple.local> # ip and device black name list
2019_09_03_modify_device_ip_black_name_field 2019-09-03T11:07:00Z apple <apple@apple.local> # modify_device_ip_black_name_field
api_2019_08_13_add_nanshenshouge_table 2019-08-13T09:01:19Z XuJunPeng <xujunpeng@igengmei.com> # 增加男神收割机活动相关表
2019_08_30_create_api_speciallbutton_doctor_rangetype 2019-08-30T07:13:04Z apple <apple@apple.local> # create_api_speciallbutton_doctor_rangetype
2019_09_05_add_api_bdtransfer_communicationrecord_img 2019-09-05T06:12:42Z xueqianqian <xueqianqian@igengmei.com> # 增加表沟通记录图片
doctor_2019_09_06_create_table_bullteinextra 2019-09-06T06:26:36Z songzhenqi <songzhenqi@igengmei.com> # 增加医生公告展示范围记录表
api_2019_09_09_alter_table_api_budanluru_modify_amount_float 2019-09-09T06:47:44Z songzhenqi <songzhenqi@igengmei.com> # 修改amount字段属性
2019_08_30_add_protect_phone 2019-08-30T03:29:20Z chenwei <chenwei@igengmei.com> # 增加用户回拨表
hippo_2019_09_10_alter_table_userlist_add_unique_index 2019-09-10T06:42:38Z songzhenqi <songzhenqi@igengmei.com> # 用户列表增加联合唯一索引
hippo_2019_09_10_alter_table_merchantaccount_add_column_update_time 2019-09-10T09:22:48Z songzhenqi <songzhenqi@igengmei.com> # 商户结算信息表增加资料审核通过更新时间
2019-09-11-add_colunm_in_order_phone_service_record 2019-09-11T11:03:59Z wanghao <haoweiking@gmail.com> # 添加辅助字段
2019_09_11_update_api_budan 2019-09-11T07:01:37Z xueqianqian <xueqianqian@igengmei.com> # 增加表api_budan字段
2019_09_11_update_api_bdtransfermonth 2019-09-11T07:25:48Z xueqianqian <xueqianqian@igengmei.com> # 增加表api_bdtransfermonth字段
2019_09_11_add_api_bdtransfermonthlywithdrawaltobudan 2019-09-11T07:29:21Z xueqianqian <xueqianqian@igengmei.com> # 创建表api_bdtransfermonthlywithdrawaltobudan
2019_09_12_update_revocation_time 2019-09-12T06:18:29Z xueqianqian <xueqianqian@igengmei.com> # 修改表api_budan字段默认值
2019_08_30_add_aggregate_id_in_api_searchkeyword 2019-08-29T07:18:53Z xueqianqian <xueqianqian@igengmei.com> # 在api_searchkeyword增加字段
2019_09_10_add_scan_skin_table 2019-09-10T03:28:11Z XuJunPeng <xujunpeng@igengmei.com> # 增加测肤配置表
hippo_2019_09_17_alter_table_userlist_add_index 2019-09-17T02:50:42Z songzhenqi <songzhenqi@igengmei.com> # 用户列表增加索引
hippo_20190909_quich_reply 2019-09-09T06:08:38Z esse <zhouyang@igengmei.com> # add hippo_quickreplygroup and hippo_quickreplycontent
2019_09_18_doctor_add_is_show_field 2019-09-18T11:13:54Z apple <apple@apple.local> # doctor add is_show field


api_2019_09_17_alter_api_skin_age_add_columns 2019-09-17T10:12:38Z ZhangYingjie <zhangyingjie@igengmei.com> # api_skin_age add columns
2019_08_29_add_market_table 2019-08-29T11:25:29Z chenwei <chenwei@igengmei.com> # 增加营销人群表
2019_09_16_add_heidong_scan_table 2019-09-16T10:36:04Z XuJunPeng <xujunpeng@igengmei.com> # 增加黑洞扫脸配置表
2019_09_19_alter_heidong_scan_table 2019-09-19T12:02:27Z XuJunPeng <xujunpeng@igengmei.com> # 更改字段类型
2019_09_25_add_special_polymer_id 2019-09-25T08:02:12Z chenwei <chenwei@igengmei.com> # 增加秒杀聚合页id
hippo_20190916_add_budanbill 2019-09-16T06:14:04Z esse <zhouyang@igengmei.com> # add transfer budan bill
2019-09-25-create_business_kpi_data_and_city_relation_table 2019-09-25T03:05:47Z wanghao <haoweiking@gmail.com> # 创建商务kpi和城市关系表
alter_table_hippo_billapplyrecord_modify_column_amount_float 2019-10-14T10:21:20Z songzhenqi <songzhenqi@igengmei.com> # 修改医生发票申请记录amount字段属性


2019-09-05-add_colunm_protectphone 2019-09-05T08:03:25Z wanghao <haoweiking@gmail.com> # 用户手机号隐私保护添加字段
2019_09_10_add_column_in_service 2019-09-10T08:59:06Z peng li <lipeng@gmei.com> # 2019_09_10_add_column_in_service
2019_10_09_sign_table 2019-10-09T06:08:19Z Mac <mac@MacdeMacBook-Pro-8.local> # 签到改版相关表

2019_10_08_add_column_is_online 2019-10-08T02:56:43Z chenwei <chenwei@igengmei.com> # 秒杀聚合增加上下线字段
2019_10_10_add_column_is_share 2019-10-10T10:14:49Z chenwei <chenwei@igengmei.com> # 增加分享字段
2019_10_15_add_column_left_stock 2019-10-15T09:03:02Z chenwei <chenwei@igengmei.com> # 增加剩余库存数
2019_10_12_sign_add_xcx_push 2019-10-12T03:23:45Z Mac <mac@MacdeMacBook-Pro-8.local> # 小程序推送新增字段
2019_10_14_sign_add_fields 2019-10-14T08:12:53Z Mac <mac@MacdeMacBook-Pro-8.local> # 签到后续开发补充字段
hippo_and_api_2019_10_16_alter_table_billapplyrecord_budanluru_modify_column 2019-10-16T03:10:09Z songzhenqi <songzhenqi@igengmei.com> # 补单录入和发票申请金额字段属性修改

specialexterior_special_id_can_be_null 2019-10-16T13:55:08Z wangkai <wangkai@igengmei.com> # 专题id可为空
yiyuanpintuan 2019-10-16T08:41:39Z gaomingming <apple@AppledeMacBook-Pro.local> # 一元拼团修改表结构
api_2019_09_20_alter_table_api_serviceitem_add_city_id 2019-09-19T13:24:06Z songzhenqi <songzhenqi@igengmei.com> # 美购sku增加city属性
api_2019_09_21_alter_table_api_serviceregisteritem_add_city_id 2019-09-20T01:47:29Z songzhenqi <songzhenqi@igengmei.com> # 注册美购sku增加city属性
api_2019_09_21_create_table_store_classification 2019-09-20T03:51:19Z songzhenqi <songzhenqi@igengmei.com> # 新建店铺分类表
api_2019_09_21_create_table_storeclassificationrelevance 2019-09-20T05:15:31Z songzhenqi <songzhenqi@igengmei.com> # 店铺分类、美购关联表
hippo_2019_09_21_alter_table_mastermerchant_add_column_is_store_classification 2019-09-20T06:57:15Z songzhenqi <songzhenqi@igengmei.com> # 主连锁商户增加旗舰店关联字段
2019-10-09-add_new_column_with_service_about_more_buy 2019-10-09T09:11:23Z wanghao <haoweiking@gmail.com> # 新增多买相关字段在sku系列数据中
groupbuy_change 2019-09-26T06:51:07Z gaomingming <apple@AppledeMacBook-Pro.local> # 修改数据库表结构
ctx_form_id 2019-09-27T11:20:48Z gaomingming <apple@AppledeMacBook-Pro.local> # 增减小程序表单form_id
add_formid 2019-10-10T07:39:18Z gaomingming <apple@AppledeMacBook-Pro.local> # settment增加form_id一列
notice_wechat 2019-10-10T11:15:43Z gaomingming <apple@AppledeMacBook-Pro.local> # groupbuy_team增加通知标记位.
2019-10-09-freecuritment 2019-10-09T11:05:00Z JackieZhang <zlujackie@gmail.com> # 免费招募
2019_10_14_create_api_freerecruitment_table 2019-10-14T08:33:06Z xueqianqian <xueqianqian@igengmei.com> # 创建免费招募相关表
2019_10_22_slide_add_column 2019-10-22T02:10:22Z 张永 <zhangyong@igengmei.com> # 轮播图添加字段
record_union_open_relation 2019-10-24T08:26:53Z wangkai <wangkai@igengmei.com> # 记录union_id open_id
unionid_can_be_null 2019-10-28T07:43:00Z wangkai <wangkai@igengmei.com> # unionid default null
api_2019_10_25_modify_bdtransfer_add_column_age 2019-10-25T02:04:20Z songzhenqi <songzhenqi@igengmei.com> # 商务转诊增加年龄字段
2019_10_28_add_stock 2019-10-28T03:59:17Z chenwei <chenwei@igengmei.com> # 增加库存映射
2019_10_21_add_column_commission_rate_and_pre_payment_price 2019-10-21T07:26:06Z chenwei <chenwei@igengmei.com> # 增加抽佣比例和预付款比例
2019_10_28_add_user_scan_record 2019-10-28T10:03:03Z XuJunPeng <xujunpeng@igengmei.com> # 保存用户扫脸或者测肤结果
api_2019_10_29_api_skin_result_add_index 2019-10-29T02:13:25Z ZhangYingjie <zhangyingjie@igengmei.com> # alter table api_skin_result add index
api_2019_10_29_skin_add_conf_table 2019-10-29T02:14:07Z ZhangYingjie <zhangyingjie@igengmei.com> # skin add conf table
2019_10_30_add_sign_prize 2019-10-30T02:24:41Z Mac <mac@MacdeMacBook-Pro-8.local> # 添加签到奖品
2019_11_05_add_auditattroptions 2019-11-05T02:57:45Z xueqianqian <xueqianqian@igengmei.com> # 增加审核项目多属性模板具体属性项名字表
statistic_2019_11_13_statistic_service_smart_rank_v4 2019-11-13T11:54:11Z zhaowei <zhaowei@igengmei.com> # add statistic_service_smart_rank_v4
2019-11-07-famous_doctors 2019-11-07T03:32:01Z JackieZhang <zlujackie@gmail.com> # 名医大赏
2019_11_14_api_smart_rank_update 2019-11-14T06:08:59Z zhaowei <zhaowei@igengmei.com> # update api_smart_rank and api_smart_rank_factor
2019_10_29_create_table_search_activity 2019-10-28T11:58:16Z 张永 <zhangyong@igengmei.com> # 综合搜索活动配置
2019_10_30_add_index_keywords 2019-10-30T07:22:53Z 张永 <zhangyong@igengmei.com> # 搜索活动搜索词增加索引
2019_11_06_add_bar 2019-11-06T02:29:11Z Mac <mac@MacdeMacBook-Pro-8.local> # 美购底增加bar
2019_11_12_api_orderuserinfo 2019-11-12T10:39:56Z xueqianqian <xueqianqian@igengmei.com> # 增加订单关联用户信息表api_orderuserinfo
api_2019_11_08_alter_table_api_bdtransfer_and_api_bdtransfer_singlerecord_add_column 2019-11-08T11:01:47Z songzhenqi <songzhenqi@igengmei.com> # 转诊线索和派单记录表增加字段
2019_11_21_add_api_business_city_relation 2019-11-21T07:44:34Z xueqianqian <xueqianqian@igengmei.com> # 增加商务城市关系表字段
# AI需求
2019_11_07_add_column_to_facial_feature 2019-11-07T06:49:52Z XuJunPeng <xujunpeng@igengmei.com> # 五官信息表增加字段
2019_11_13_add_seriousness 2019-11-13T06:52:40Z Yangchenglin <yangchenglin@igengmei.com> # 显著问题分析文案
2019_11_13_add_api_ai_target 2019-11-13T08:29:02Z Yangchenglin <yangchenglin@igengmei.com> # AI指标
2019_11_25_add_client_cache 2019-11-25T07:39:25Z Yangchenglin <yangchenglin@igengmei.com> # add_client_cache
2019_11_28_modify_field_type 2019-11-28T08:24:05Z xueqianqian <xueqianqian@igengmei.com> # 修改表api_business_city_relation字段类型
2019_11_19_add_seckillpolymerbutton 2019-11-19T08:24:07Z xueqianqian <xueqianqian@igengmei.com> # 增加按钮区设置表
2019-12-05-add_index_in_api_sign_user_task 2019-12-05T03:37:16Z wanghao <haoweiking@gmail.com> # 用户完成记录添加所以
2019_11_18_add_table_pay_merchantpayorder 2019-11-18T02:51:34Z chenwei <chenwei@igengmei.com> # 增加商户支付表
2019_11_18_alert_uniqueOrderNo 2019-11-20T03:59:29Z chenwei <chenwei@igengmei.com> # 可以为空
hippo_2019_12_03_alter_table_hippo_billapplyrecord 2019-12-03T07:22:37Z songzhenqi <songzhenqi@igengmei.com> # 发票申请记录表增加字段：is_online
hippo_2019_12_04_alter_table_hippo_billtoadrechange 2019-12-04T02:58:46Z songzhenqi <songzhenqi@igengmei.com> # 修改hippo_billtoadrechange表adrechange_id字段属性
hippo_2019_12_04_alter_table_hippo_billapplyrecord 2019-12-04T09:34:40Z songzhenqi <songzhenqi@igengmei.com> # 修改发票申请记录金额精度
2019-12-11-add-newtag-3.0 2019-12-11T06:55:01Z JackieZhang <zlujackie@gmail.com> # 添加新标签3.0
hera_2019_12_18_zhengxing_update_desc 2019-12-18T05:16:26Z Marge N. O’Vera <marge@example.com> # alert api_userinnerinfo table wx_email
# 7.20
2019-12-04-add_polymer_table_about_tag 2019-12-04T11:31:18Z wanghao <haoweiking@gmail.com> # 新增聚合页标签关联表
launch_2019_12_10_create_table 2019-12-10T03:25:47Z ZhangYingjie <zhangyingjie@igengmei.com> # launch app create table
2019_11_28_add_face_diagnose 2019-11-28T06:55:30Z Yangchenglin <yangchenglin@igengmei.com> # 2019_11_28_add_face_diagnose
2019_11_27_add_api_searchkeyword_operationrecord 2019-11-27T08:50:15Z xueqianqian <xueqianqian@igengmei.com> # 增加默认搜索词配置操作记录表
2019-12-31_add_like_promotioninfo_table 2019-12-31T02:41:38Z 钟尚武 <zhongshangwu@zhongshangwudeMacBook-Pro.local> # 迁移like channels 渠道表
budan_payment 2020-01-03T06:26:26Z mac <mac@macdeMacBook-Pro-7.local> # used for zhaochangda
20_change_payment 2020-01-03T09:22:47Z mac <mac@macdeMacBook-Pro-7.local> # used for zhaochangda
2019_12_26_add_api_shortcut_screen_label 2019-12-26T08:35:53Z xueqianqian <xueqianqian@igengmei.com> # 增加快捷筛选标签配置表
api_2019_12_31_alter_api_service_add_is_delete 2019-12-31T11:31:00Z songzhenqi <songzhenqi@igengmei.com> # 美购表增加是否删除字段
20200108_alter_api_service_add_delete_time 2020-01-08T11:01:31Z songzhenqi <songzhenqi@igengmei.com> # 美购表添加删除时间字段
2020-1-2_add_column_tag_type 2019-12-31T08:16:19Z 张永 <zhangyong@igengmei.com> # 标签3.0增加类型
2020-1-6_add_old_tag_category 2020-01-03T06:30:03Z 张永 <zhangyong@igengmei.com> # 老标签大类
2020-1-07_change_tag_category_column_name 2020-01-07T12:47:14Z 张永 <zhangyong@igengmei.com> # 修改字段名
2020-1-07_change_tag_category_column_tag_category_id 2020-01-07T12:54:58Z 张永 <zhangyong@igengmei.com> # tag_category_id
user_callback_list_peotect_phone 2020-01-15T09:00:43Z 唐香港 <tangxianggang@igengmei.com> # 添加hera项目转诊目录下用户回拨列表所用表结构
2020-01-08-group 2020-01-08T02:44:06Z JackieZhang <zlujackie@gmail.com> # 添加小组
launch_2020_01_09_create_table 2020-01-09T09:04:49Z ZhangYingjie <zhangyingjie@igengmei.com> # launch app create table
2019-01-06-add_sku_desc 2020-01-06T02:43:34Z wanghao <haoweiking@gmail.com> # 增加sku描述
bdtransfer_2020_01_09_assist_create 2020-01-09T03:03:10Z Marge N. O’Vera <marge@example.com> # bdtransfer_2020_01_09_assist_create
bdtransfer_2020_01_19_alter_api_bdtransfer_assist 2020-01-16T08:50:19Z Marge N. O’Vera <marge@example.com> # bdtransfer_2020_01_19_alter_api_bdtransfer_assist
bdtransfer_2019_01_21_update_api_bdtransfer_date 2020-01-21T03:58:57Z Marge N. O’Vera <marge@example.com> # nsfer_2019_01_21_update_api_bdtransfer_date
2020_02_07_hospital_map_add 2020-02-06T23:15:12Z apple <apple@apple.local> # 医院id和自增id映射
2020_02_08_doctor_card_generate 2020-02-08T09:03:53Z apple <apple@apple.local> # 医生卡片生成
2020-02-07-add_home_page_clolumn_version 2020-02-07T06:49:24Z GengmeiMac <gengmeimac@xielinzhen.local> # 2020-02-07_add_home_page_clolumn_version
2020-02-11_slide_gadget_festival_homepage_icon_add_column_version 2020-02-11T12:40:04Z GengmeiMac <gengmeimac@xielinzhen.local> # slide_gadget_festival_homepage_icon_add_column_version
create_table_for_toprank_2020_02_18 2020-02-18T06:57:33Z hexy <hexy@hexydeMacBook-Pro.local> # create a table for toprank
2020_02_04_update_api_special 2020-02-04T03:44:03Z xueqianqian <xueqianqian@igengmei.com> # 增加表api_special字段
2020-02-07-alter_table_AwardResult 2020-02-07T09:02:35Z kouyalong <kouyalong@kouyalongdeMacBook-Pro.local> # alter table AwardResult
create_table_FunctionFeedback 2020-02-05T05:07:52Z kouyalong <kouyalong@kouyalongdeMacBook-Pro.local> # create a table function_feedback
2020-02-06-alter_table_FunctionFeedback 2020-02-06T02:26:14Z kouyalong <kouyalong@kouyalongdeMacBook-Pro.local> # alter table function_feedback
2020_02_05_create_launch_serviceconfigurerelevant 2020-02-05T07:55:31Z xueqianqian <xueqianqian@igengmei.com> # 创建美购配置相关表
2020_02_20_add_word_and_synonymgroup 2020-02-20T07:15:34Z hukaixuan <hukaixuan@igengmei.com> # 添加word、synonymgroup相关表
2020-2-25-pushuser-add-index 2020-02-24T07:49:42Z 张永 <zhangyong@igengmei.com> # pushuser 表增加索引
2020-02-14_alter_api_punishment 2020-02-14T09:52:56Z songzhenqi <songzhenqi@igengmei.com> # 商家干预处罚变增加range、target_ids字段
2020_02_27_alert_api_greetingpopup 2020-02-27T02:06:10Z GengmeiMac <gengmeimac@localhost> # 2020_02_27_alert_api_greetingpopup
2020_2_17_add_column_tag_v3 2020-02-17T02:23:07Z 张永 <zhangyong@igengmei.com> # 标签增加在医生后台展示状态
2020_2_19_tag_wiki_relate 2020-02-19T03:22:49Z 张永 <zhangyong@igengmei.com> # 新标签百科关联
# 20200304_alter_tabl_api_order_add_index_status 2020-03-05T07:35:55Z kouyalong <kouyalong@igengmei.com> # add api_order index status
2020_03_09_add_api_scan_record_index 2020-03-09T07:12:23Z Yangchenglin <yangchenglin@igengmei.com> # 添加created_time_with_updated_time联合索引
2020_03_06_create_table_merchant_level_record 2020-03-06T08:06:14Z songzhenqi <songzhenqi@igengmei.com> # 创建商户评级记录表，修改商户表相关字段名字

# old and new tag change
api_2020_03_02_create_table_tab_operate_relation_tag_v3 2020-03-02T02:33:16Z ZhangYingjie <zhangyingjie@igengmei.com> # create table tab_operate relation tag_v3
category_2020_03_02_create_table_category_relation_tag_v3 2020-03-02T02:33:57Z ZhangYingjie <zhangyingjie@igengmei.com> # create table category relation tag_v3
group_2020_03_02_create_table_group_relation_tag_v3 2020-03-02T02:34:38Z ZhangYingjie <zhangyingjie@igengmei.com> # create table group relation tag_v3
polymer_2020_03_02_create_table_polymer_relation_tag_v3 2020-03-02T02:34:44Z ZhangYingjie <zhangyingjie@igengmei.com> # create table polymer relation tag_v3
wiki_2020_03_02_create_table_wiki_relation_tag_v3 2020-03-02T04:07:24Z ZhangYingjie <zhangyingjie@igengmei.com> # create table wiki relation tag_v3
2020-03-02_add_tag_relevant_table 2020-03-02T03:18:48Z xueqianqian <xueqianqian@igengmei.com> # 增加新标签相关表

20200302_add_app_config 2020-03-02T04:15:33Z kouyalong <kouyalong@igengmei.com> # add table app_config
20200303_alter_table_feedoperatev2 2020-03-03T03:46:35Z kouyalong <kouyalong@igengmei.com> # add column relevance_tag and plastic_template
20200309_add_feedback_question_answer 2020-03-09T11:31:04Z kouyalong <kouyalong@igengmei.com> # add feedback question answer
20200311_add_index_table_feedoperate_v2 2020-03-11T02:13:50Z kouyalong <kouyalong@igengmei.com> # alter table FeedOperateV2 add index
2020_03_04_add_api_plastic_template 2020-03-04T07:37:36Z Yangchenglin <yangchenglin@igengmei.com> # 模拟整形模板
2020_03_04_add_xiaolian_shouquangu 2020-03-04T09:08:30Z Yangchenglin <yangchenglin@igengmei.com> # 整形模板新增参数
2020_03_06_alert_api_plastic_template 2020-03-06T07:29:57Z Yangchenglin <yangchenglin@igengmei.com> # 整形模板参数表去掉null限制
2020_03_19_add_face_style_desc 2020-03-19T06:00:32Z Yangchenglin <yangchenglin@igengmei.com> # api_skin_result添加face_style_desc
2020_03_25_add_image_url 2020-03-25T03:19:16Z Yangchenglin <yangchenglin@igengmei.com> # ai记录增加扫脸图片
20200410-tag-map-tag 2020-04-10T02:34:21Z 张永 <zhangyong@igengmei.com> # 标签关联
2020_03_26_add_api_plastic_appeal_card 2020-03-26T08:42:54Z Yangchenglin <yangchenglin@igengmei.com> # 模拟整形诉求卡片
2020_04_01_add_api_plastic_tab_type 2020-04-01T03:37:32Z Yangchenglin <yangchenglin@igengmei.com> # 模拟整形feed tab
launch_2020_03_24_add_table 2020-03-24T11:47:13Z ZhangYingjie <zhangyingjie@igengmei.com> # questionnaire create table relation tagv3 and interest questions

bdtransfer_2020_04_08_add_auto_assign 2020-04-08T12:12:18Z System Administrator <root@wushengyudeMacBook-Pro.local> # 添加自动转诊自动分配表
bdtransfer_2020_04_17_add_auto_assign 2020-04-17T07:03:44Z wangxiaojun <wangxiaojun@igengmei.com> # bdtransfer_2020_04_17_add_auto_assign
2020_04_21_upgrade_indic 2020-04-21T09:28:43Z apple <apple@apple-2.local> # 验证升单质量指标基本信息和平均值
bdtransfer_2020_04_22_drop_create_hera_transfer_rate 2020-04-22T03:02:43Z wangxiaojun <wangxiaojun@igengmei.com> # 删除旧hera_transfer_rate创建新表
bdtransfer_2020_04_23_alter_api_bdtransfer 2020-04-23T09:21:58Z wangxiaojun <wangxiaojun@igengmei.com> # 添加新带老字段
2020_04_21_commodity_category 2020-04-21T08:12:04Z Yangchenglin <yangchenglin@igengmei.com> # 商品类目信息
2020_04_21_commodity_category_register_id 2020-04-21T10:20:40Z Yangchenglin <yangchenglin@igengmei.com> # 补充register_id字段
2020_04_21_commodity_category_father_id 2020-04-22T03:51:38Z Yangchenglin <yangchenglin@igengmei.com> # 补充father_id字段
20200420_alter_table_order_extra 2020-04-20T07:49:06Z kouyalong <kouyalong@igengmei.com> # 20200420_alter_table_order_extra
api_2020_04_17_alter_table_userextra_add_column 2020-04-17T02:01:57Z ZhangYingjie <zhangyingjie@igengmei.com> # api_userextra add column blood_type
2020-04-16-726_group_topic 2020-04-16T02:44:26Z JackieZhang <zlujackie@gmail.com> # 小组话题
mark_2020_04_15_init_create_table 2020-04-15T06:11:12Z ZhangYingjie <zhangyingjie@igengmei.com> # mark init create table
mark_2020_04_26_create_mark_push_table 2020-04-26T06:35:49Z GengmeiMac <gengmeimac@xielinzhen.local> # 创建打卡push相关表
20200415-ios-user-device 2020-04-15T06:52:59Z 张永 <zhangyong@igengmei.com> # 苹果用户关联设备
20200428_add_promotion_coupon 2020-04-28T14:02:55Z kouyalong <kouyalong@igengmei.com> # 20200428_add_promotion_coupon
20020_04_17_visual_related_field 2020-04-17T07:52:47Z xueqianqian <xueqianqian@igengmei.com> # 增加自定义专题相关字段
2020_04_22_add_promotion_id 2020-04-22T09:39:51Z xueqianqian <xueqianqian@igengmei.com> # 表api_slide增加字段
kyc4-opt 2020-05-08T09:17:57Z JackieZhang <zhanglu@igengmei.com> # kyc4.0 优化
user_extra_add_good_looking 2020-05-12T10:44:29Z JackieZhang <zhanglu@igengmei.com> # 用户增加高颜值属性
2020_04_13_alert_table_api_sign_assist_user 2020-04-13T08:46:38Z GengmeiMac <gengmeimac@xielinzhen.local> # 好友助力增加任务类型
api_2020_04_30_alter_table_sign_blind_relate_prize 2020-04-30T08:10:36Z GengmeiMac <gengmeimac@xielinzhen.local> # 盲盒兑换的奖品表增加美券id
20200512-modity_pay_alipayrefund_order_no_length 2020-05-12T10:28:42Z wanghao <haoweiking@gmail.com> # modity pay_alipayrefund order_no cloumn length
gm_ai_2020_05_07_create_kyc_table 2020-05-07T03:44:45Z System Administrator <root@wushengyudeMacBook-Pro.local> # ai频道页kyc
api_2020_05_12_alter_table_api_slide 2020-05-12T09:04:49Z GengmeiMac <gengmeimac@xielinzhen.local> # 轮播图表增加权重字段
2020_05_19_add_table_category_map 2020-05-19T11:02:24Z songzhenqi <songzhenqi@igengmei.com> # 医生后台和hera品类映射关系
2020_05_19_custom_ad_buy 2020-05-19T02:20:13Z apple <apple@apple-2.local> # 自定义广告购买
2020_05_20_add_custom_ad_id 2020-05-20T13:01:42Z apple <apple@apple-2.local> # 添加custom_ad_id列
doctor_2020_05_19_modify_service_add_offline_reason 2020-05-19T02:43:19Z wangxiaojun <wangxiaojun@igengmei.com> # doctor_2020_05_19_modify_service_add_offline_reason
api_2020_05_08_create_table_skin_type 2020-05-08T02:09:29Z GM <gm@Locus-4.local> # 创建旷视测肤表
api_2020_05_19_create_table_skin_face_result 2020-05-19T07:48:40Z ‘wang’ <1350821504@qq.com> # 创建存储旷视测肤结果model
20200601_alter_table_api_update_pop_add_index 2020-06-01T03:15:52Z kouyalong <kouyalong@igengmei.com> # 20200601_alter_table_api_update_pop_add_index
group_topic_add_is_show_index 2020-05-27T09:59:05Z JackieZhang <zhanglu@igengmei.com> # 小组话题添加是否展示在首页字段
group_2020_05_22_alter_group_topic 2020-05-22T06:16:26Z GengmeiMac <gengmeimac@xielinzhen.local> # 修改小组话题相关表
variety_show_2020_05_22_create_young_related_table 2020-05-22T06:29:04Z GengmeiMac <gengmeimac@xielinzhen.local> # 创建少年之名活动相关表
variety_show_2020_06_01_create_idol_tag 2020-06-01T11:15:44Z GengmeiMac <gengmeimac@xielinzhen.local> # 新增打榜选手标签表
2020-05-28-mark-activity-add-column 2020-05-28T08:33:06Z 张永 <zhangyong@igengmei.com> # 打卡活动
20200601-add_column_api_topic_aggregation 2020-06-01T07:05:22Z wanghao <haoweiking@gmail.com> # add column api_topic_aggregation
bdtransfer_2020_05_28_add_bdtransfer_visit_record 2020-05-28T12:08:35Z wangxiaojun <wangxiaojun@igengmei.com> # 添加转诊回访相关表
2020_06_05_create_user_seal_log_table 2020-06-05T09:30:06Z ywj <ywj@123.com> # create user seal log table
alter_bdtransfer_visit_2020_06_08 2020-06-08T08:29:53Z wangxiaojun <wangxiaojun@igengmei.com> # 更改回访表字段
alter_userlist_commodity_category_relation_2020_06_12 2020-06-12T06:37:43Z wangxiaojun <wangxiaojun@igengmei.com> # 修复数据表增加索引
2020_06_16_recreate_user_seal_log_table 2020-06-16T09:30:06Z ywj <ywj@123.com> # recreate user seal log table
api_2020_06_10_create_push_gift_record_table 2020-06-10T08:33:00Z GengmeiMac <gengmeimac@MacBook-Pro.local> # 创建push授权礼包领取记录表
20200622_del_simple_action_log_foreign_key 2020-06-22T12:07:16Z wanghao <haoweiking@gmail.com> # del_simple_action_log_foreign_key
2020-06-12-modify_api_tag_3_0 2020-06-12T03:13:15Z wanghao <haoweiking@gmail.com> # 修改新标签表
2020-07-03-sign-add-index 2020-07-03T10:42:58Z 张永 <zhangyong@igengmei.com> # 签到记录表添加索引
2020_07_09_api_order_add_index 2020-07-09T08:01:46Z System Administrator <root@MikedeMacBook-Pro.local> # api_order添加索引
group_2020_06_24_alter_group_topic 2020-06-24T11:41:29Z GengmeiMac <gengmeimac@MacBook-Pro.local> # 修改小组、话题
ai_qa 2020-06-29T07:52:30Z JackieZhang <zhanglu@igengmei.com> # AI问答
2020_07_07_ai_qa_add_column 2020-07-07T03:49:28Z ZhangYingjie <zhangyingjie@igengmei.com> # ap_qa add column
clue_strategy 2020-07-02T09:15:14Z gm <gm@gmdeMacBook-Air.local> # clue strategy tables
clue_strategy_alter_doctor_smart_rank 2020-07-15T07:08:34Z gm <gm@gmdeMacBook-Air.local> # modify doctor smart rank table
2020-07-14-api_questionnaire_theme_and_question_relations 2020-07-14T07:53:54Z 张永 <zhangyong@igengmei.com> # kyc主题问题添加field
2020-07-23_alter_table_service_name_change_log 2020-07-23T10:22:26Z zhongshangwu <zhongshangwu@MacBook-Pro.local> # 增加美购名字修改记录表
2020-07-24_modify_service_name_change_log 2020-07-24T09:49:33Z wangxiaojun <wangxiaojun@igengmei.com> # 修改美购相关名称日志表
2020-07-24_modify_service_name_change_log_drop_column 2020-07-24T11:12:05Z wangxiaojun <wangxiaojun@igengmei.com> # 美购相关名称修改记录表删除部分列
add_sku_sale_nums 2020-07-27T02:00:16Z gm <gm@gmdeMacBook-Air.local> # add sku sale num
feed_operate_add_version_limit 2020-07-21T10:44:15Z JackieZhang <zhanglu@igengmei.com> # feeds流插入添加版本限制
2020_07_14_ai_qa_recommend_add_column 2020-07-14T09:19:49Z ZhangYingjie <zhangyingjie@igengmei.com> # api_ai_qa_recommend add column
create_table_ai_qa_consult_info 2020-07-14T09:21:07Z ZhangYingjie <zhangyingjie@igengmei.com> # create table for ai_qa consult info
2020-07-24_add_table_bwc_orderverifynotice 2020-07-24T10:19:25Z wangxiaojun <wangxiaojun@igengmei.com> # 霸王餐未验证订单添加推送记录表
2020-07-27_modify_table_api_bwc_orderverifynotice 2020-07-27T08:46:03Z wangxiaojun <wangxiaojun@igengmei.com> # 修改推送记录表列类型
2020_07_31_add_table_freemessage 2020-07-31T09:50:30Z songzhenqi <songzhenqi@igengmei.com> # 新增不计费私信记录表
2020-07-16_create_hot_table 2020-07-16T07:29:56Z wangxiaojun <wangxiaojun@igengmei.com> # 热门榜相关表
2019-06-05-add_special_pool 2020-06-05T08:09:12Z wanghao <haoweiking@gmail.com> # 专题池配置
2020_07_23_alter_table_add_device_type 2020-07-23T03:56:25Z songzhenqi <songzhenqi@igengmei.com> # 资源定向位相关表增加device_type字段
add_sku_sale_nums_new 2020-08-11T07:41:33Z gm <gm@gmdeMacBook-Air.local> # modify sku sale num
add_sku_sale_nums_new_modify 2020-08-11T08:55:57Z gm <gm@gmdeMacBook-Air.local> # modify sku sale num

20200713__add_plastics_3_0 2020-07-13T06:35:26Z kouyalong <kouyalong@igengmei.com> # 20200713_add_plastics_3_0
20200721_alter_plastics_3_0 2020-07-21T10:35:08Z kouyalong <kouyalong@igengmei.com> # 20200721_alter_plastics_3_0
2020_07_21_create_plastic_4.0 2020-07-18T07:03:54Z GengmeiMac <gengmeimac@MacBook-Pro.local> # 模拟整形4.0相关表
20200722_creare_plastics_3_0 2020-07-22T03:44:45Z kouyalong <kouyalong@igengmei.com> # 20200722_create_plastics_3_0
2020-07-28-gold-add-fields 2020-07-28T02:33:47Z 张永 <zhangyong@igengmei.com> # 美学点位添加字段
2020_08_03_user_plastic_history_add_user_device 2020-08-03T09:30:46Z Yangchenglin <yangchenglin@igengmei.com> # 增加用户设备信息
20200810_create_table_api_tag_city 2020-08-10T02:44:19Z 张永 <zhangyong@igengmei.com> # 城市表现映射
2020-08-12_create_table_api_couponmerchantrestrict 2020-08-12T02:36:20Z xuguoliang <xuguoliang@igengmei.com> # create create_table_api_couponmerchantrestrict
20200811_api_greetingpopup_add_deep_link 2020-08-11T03:14:41Z 张永 <zhangyong@igengmei.com> # 首页弹窗配置添加deep_link
api_2020_08_07_add_skin_result_tag 2020-08-07T08:54:31Z GengmeiMac <gengmeimac@MacBook-Pro.local> # 增加测肤结果标签表
20200828_ai_scan_skin_video 2020-08-28T02:47:42Z JackieZhang <zlujackie@gmail.com> # AI测肤质-增加精选视频
api_2020_08_28_alert_skintype 2020-08-28T02:53:55Z GengmeiMac <gengmeimac@MacBook-Pro.local> # 修改测肤配置表
2020_08_19_api_ai_qa_answer_add_column 2020-08-19T10:54:37Z ZhangYingjie <zhangyingjie@igengmei.com> # api_ai_qa_answer add column
index_function_icon_add_version_limit 2020-08-31T10:44:15Z JackieZhang <zhanglu@igengmei.com> # 功能入口增加最大最小版本限制
gaia_2020_08_24_api_tag_add_clomun 2020-08-24T06:54:31Z edz <edz@wangruihuan> # api tag添加是否可移动列表以及是否展示列表
2020_08_22_add_column_category_polymer_operate_id 2020-08-22T02:31:05Z xuguoliang <xuguoliang@igengmei.com> # 给category_polymer添加一级运营分类id
api_2020_09_02_create_table_api_skin_result_extra 2020-09-02T10:49:40Z GengmeiMac <gengmeimac@MacBook-Pro.local> # 增加测肤额外信息表
20200907_search_add_recommend_words 2020-09-07T06:35:16Z kouyalong <kouyalong@igengmei.com> # 20200907_search_add_recommend_words
2020_09_15_create_add_famous_doctor_field 2020-09-15T04:15:13Z jinqiyun <jinqiyun@igengmei.com> # add version and create two tables
2020_09_16_service_add_upgrade 2020-09-16T09:30:26Z wangxiaojun <wangxiaojun@igengmei.com> # 美购添加是否升级标志
2020_09_16_add_messge_source 2020-09-16T08:15:16Z System Administrator <root@bogon> # message表添加source字段
api_2020_09_14_alter_api_face_one_image_v2 2020-09-14T08:03:19Z GengmeiMac <gengmeimac@MacBook-Pro.local> # 扫脸新的记录表增加字段
api_2020_09_17_alter_api_scan_skin_video 2020-09-17T09:19:33Z GengmeiMac <gengmeimac@MacBook-Pro.local> # 扫脸视频表增加字段
gaia_2020_09_18_api_tag_add_multiple_column 2020-09-18T10:47:43Z edz <edz@wangruihuan> # api_tag表添加二级下的三级是否可以多选
2020_09_16_service_add_upgrade 2020-09-16T09:30:26Z wangxiaojun <wangxiaojun@igengmei.com> # 美购添加是否升级标志
20200921_api_greetingpopup 2020-09-21T03:27:39Z 张永 <zhangyong@igengmei.com> # 首页弹窗调整
api_2020_10_27_create_table_api_distribute_record 2020-10-27T09:57:05Z System Administrator <root@edzdeMacBook-Pro.local> # 创建分销记录表
api_2020_09_23_update_bdtransfer 2020-09-23T13:16:42Z System Administrator <root@bogon> # 修改派单记录
api_2020_09_24_alter_budan 2020-09-24T08:29:20Z songzhenqi <songzhenqi@igengmei.com> # 补单表增加派单id字段
2020_10_26_create_table_hippo_merchant_contract 2020-10-26T08:02:15Z xuwentao <xuwentao@igengmei.com> # create a table hippo_merchant_contract
