select * from aw_sms_provider

update aw_sms_provider set sms_password='123456' where sms_provider_id in (7,8) and sms_provider_name like 'Value Leaf%'

update aw_sms_provider set sms_provider_url='http://203.129.203.254/sms/user/urlsms.php?response=Y&' where sms_provider_id in (7,8) and sms_provider_name like 'Value Leaf%'
update aw_sms_provider set user_id_label='username', password_label='pass' where sms_provider_id in (7,8) and sms_provider_name like 'Value Leaf%'
update aw_sms_provider set message_label='message', mobile_list_label='dest_mobileno' where sms_provider_id in (7,8) and sms_provider_name like 'Value Leaf%'
update aw_sms_provider set optional_label='senderid', optional_value='AgWatchV' where sms_provider_id in (7,8) and sms_provider_name like 'Value Leaf%'


http://203.129.203.254/sms/user/urlsms.php?username=valueleaf&pass=value&senderid=VALULEAF&message=Testt&dest_mobileno=919225240725,919225240726&response=Y
http://203.129.203.254/sms/user/urlsms.php?username=deepak&pass=123456&senderid=AGWATCH&message=Bhaskar_test&dest_mobileno=919350169502,919910084639&response=Y

7	VL	Value Leaf GSM	http://202.71.152.238/desk2web/SendSMS.aspx?isFlash=False&CDMAHeader=919811340636&	UserName	password	Message	MobileNo	SenderID	deepak	123456	AgriwatchV	Y

http://202.71.152.238/desk2web/SendSMS.aspx?isFlash=False&CDMAHeader=919811340636&UserName=deepak&password=123456&Message=this is a test&MobileNo=919350169502,919910084639&SenderID=AgriwatchV

8	VL-R	Value Leaf CDMA	http://202.71.152.238/desk2web/SendSMS.aspx?isFlash=False&SenderID=Agwatch8&	UserName	password	Message	MobileNo	CDMAHeader	deepak	123456	919891655340	Y

select * from aw_operators where operator_id like '%raj%'
select * from aw_operators where department like '%adm%'
insert into aw_operators values('rajender', 'rajender2', 'Rajender Dobriyal', 'ADMIN', 'rajender@agriwatch.com', NULL, 'Manager (Admin)', 'Y', 0)
insert into aw_operator_roles select 'rajender', role_id from aw_operator_roles where operator_id='bhaskar'

select * from aw_operator_roles where operator_id='rajender' order by 2
delete from aw_operator_roles where operator_id='rajender' and role_id in ('USER', 'MAGAZINE', 'COMMWEEKLY', 'TICKEROPER')

select * from aw_roles where role_label like 'manage%'

