WWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWW Own Ebookkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk

–​Rollback​ ​Update​ ​Channel​ ​logo

update​ ​[dbo].[CoinPaymentChannel]​ ​set​ ​ImageUrl​ ​=​ ​N​'​https://cdn-th.tunwalai.net/files/responsive/ic_coin_payment/ic_payment3_w.png​'​ ​where​ ​id​ ​=​ ​3

update​ ​[dbo].[CoinPaymentChannel]​ ​set​ ​ImageUrl​ ​=​ ​N​'​https://cdn-th.tunwalai.net/files/responsive/ic_coin_payment/ic_payment4_w.png​'​ ​where​ ​id​ ​=​ ​4

update​ ​[dbo].[CoinPaymentChannel]​ ​set​ ​ImageUrl​ ​=​ ​N​'​https://cdn-th.tunwalai.net/files/responsive/ic_coin_payment/ic_payment5_w.png​'​ ​where​ ​id​ ​=​ ​5

update​ ​[dbo].[CoinPaymentChannel]​ ​set​ ​ImageUrl​ ​=​ ​N​'​https://cdn-th.tunwalai.net/files/responsive/ic_coin_payment/ic_payment6_w.png​'​ ​where​ ​id​ ​=​ ​6

update​ ​[dbo].[CoinPaymentChannel]​ ​set​ ​ImageUrl​ ​=​ ​N​'​https://cdn-th.tunwalai.net/files/responsive/ic_coin_payment/ic_payment7_w.png​'​ ​where​ ​id​ ​=​ ​7

update​ ​[dbo].[CoinPaymentChannel]​ ​set​ ​ImageUrl​ ​=​ ​N​'​https://cdn-th.tunwalai.net/files/responsive/ic_coin_payment/ic_payment_shopee_3.png​'​ ​where​ ​id​ ​=​ ​8

update​ ​[dbo].[CoinPaymentChannel]​ ​set​ ​ImageUrl​ ​=​ ​N​'​https://cdn-th.tunwalai.net/files/responsive/ic_coin_payment/ic_payment9_w.png​'​ ​where​ ​id​ ​=​ ​9

update​ ​[dbo].[CoinPaymentChannel]​ ​set​ ​ImageUrl​ ​=​ ​N​'​https://cdn-th.tunwalai.net/files/responsive/ic_coin_payment/ic_payment10_w.png​'​ ​where​ ​id​ ​=​ ​10

update​ ​[dbo].[CoinPaymentChannel]​ ​set​ ​ImageUrl​ ​=​ ​N​'​https://cdn-th.tunwalai.net/files/responsive/ic_coin_payment/ic_payment13_w.png​'​ ​where​ ​id​ ​=​ ​13

update​ ​[dbo].[CoinPaymentChannel]​ ​set​ ​ImageUrl​ ​=​ ​N​'​https://cdn-th.tunwalai.net/files/responsive/ic_coin_payment/ic_payment14_w.png​'​ ​where​ ​id​ ​=​ ​17

update​ ​[dbo].[CoinPaymentChannel]​ ​set​ ​ImageUrl​ ​=​ ​N​'​https://cdn-th.tunwalai.net/files/responsive/ic_coin_payment/ic_truewallet.png​'​ ​where​ ​id​ ​=​ ​20

 

 

–​คำ​ค้​ข​ี​ุ๊​

ALTER​ ​TABLE​ ​[Ebook].[Ebook]

DROP​ ​COLUMN​ ​SearchTags;

 

–​drop​ ​column​ ​imageurl​ ​on​ ​Ebook​ ​PaymentChannel​ ​and​ ​insert​ ​data

ALTER​ ​TABLE​ ​ ​[Ebook].[PaymentChannel]

DROP​ ​COLUMN​ ​ImageUrl;​

 

–​drop​ ​column​ ​start/end​ ​promotion​ ​of​ ​top​ ​up

ALTER​ ​TABLE​ ​ ​[dbo].[CoinPaymentChannelPrice]

DROP​ ​COLUMN​ ​PromotionStartDate,PromotionEndDate​

 

–​delete​ ​new​ ​price​ ​top​ ​up​ ​coin

delete​ ​[dbo].[CoinPaymentChannelPrice]​ ​ ​where​ ​ ​[ProductCode]​ ​=​ ​'​tunwalai-gbprimepay-qr.coin.300.30000​'

 

–​update​ ​top​ ​up​ ​promotion

​update​ ​[dbo].[CoinPaymentChannelPrice]​ ​set​ ​PromotionProductCode​ ​=​ ​N​'​tunwalai-gbprimepay-qr.coin.50.5100​'​,PromotionStartDate​ ​=NULL,PromotionEndDate​ ​=​ ​NULL​ ​where​ ​id​ ​=​ ​1

update​ ​[dbo].[CoinPaymentChannelPrice]​ ​set​ ​PromotionProductCode​ ​=​ ​N​'​tunwalai-gbprimepay-qr.coin.100.10300​'​,PromotionStartDate​ ​=NULL,PromotionEndDate​ ​=​ ​NULL​ ​ ​where​ ​id​ ​=​ ​3

update​ ​[dbo].[CoinPaymentChannelPrice]​ ​set​ ​PromotionProductCode​ ​=​ ​N​'​tunwalai-gbprimepay-qr.coin.200.21000​'​,PromotionStartDate​ ​=NULL,PromotionEndDate​ ​=​ ​NULL​ ​ ​where​ ​id​ ​=​ ​4

update​ ​[dbo].[CoinPaymentChannelPrice]​ ​set​ ​PromotionProductCode​ ​=​ ​N​'​tunwalai-gbprimepay-qr.coin.500.55000​'​,PromotionStartDate​ ​=NULL,PromotionEndDate​ ​=​ ​NULL​ ​,seq​ ​=4​ ​ ​where​ ​id​ ​=​ ​5

update​ ​[dbo].[CoinPaymentChannelPrice]​ ​set​ ​PromotionProductCode​ ​=​ ​N​'​ttunwalai-gbprimepay-qr.coin.1000.115000​'​,PromotionStartDate​ ​=NULL,PromotionEndDate​ ​=​ ​NULL​ ​,seq=5​ ​where​ ​id​ ​=​ ​6

update​ ​[dbo].[CoinPaymentChannelPrice]​ ​set​ ​seq=6​ ​where​ ​id​ ​=​ ​7

 

–​edit​ ​default​ ​profile

ALTER​ ​VIEW​ ​[catalog].[profile]​ ​AS​

SELECT​

member_id​ ​as​ ​id,

ookbee_numeric_id​ ​as​ ​ookbeeNumericId,

member_nickname​ ​as​ ​displayName,

--member_gender​ ​as​ ​gender,

member_about​ ​as​ ​about,

member_allow_comment​ ​as​ ​isAllowComment,

IIF​(​member_image​ ​is​ ​not​ ​null,​ ​'​https://cdn-th.tunwalai.net/files/profile/​'​ ​+​ ​member_image,​ ​'​http://cdn-th.tunwalai.net/files/member/default-new-avatar.png​'​)​ ​ ​as​ ​profileImageUrl,

facebook_url​ ​as​ ​facebookId,

twitter_url​ ​as​ ​twitterId,

instagram_url​ ​as​ ​instagramId,

line_url​ ​as​ ​lineId,

email_contact​ ​as​ ​emailContact,

CONVERT​(​varchar,​ ​TODATETIMEOFFSET​(​member_login_datetime,​ ​0),​ ​127)​ ​as​ ​eTag,

member_support_message_default​ ​AS​ ​supportMessageDefault

FROM​

[catalog].[profile_full]