INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('faxage_url','https://www.faxage.com/httpsfax.php','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('fishbowl_url','http://moes.fbmta.com/members/subscribe.aspx','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('fishbowl_site_guid','452EEB8B-3FF1-48ED-8116-97EB1C3848C7','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('fishbowl_list_id','36507222073','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('fpn_loyalty_url','http://www.SynergyWebService.com/SynergyWebX.asmx','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('geocode_farm_url','https://www.geocode.farm/v3/json/forward','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('google_geocode_url','https://maps.googleapis.com/maps/api/geocode/json?sensor=false','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('heartland_archer_url','https://api.test.chockstone.com/archer/v1/','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('heartland_katana_url','https://api.test.chockstone.com/katana/v1/domains/%%domain%%/chains/global/','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('heartland_api_key','hrhq3coqbkuv','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('heartland_archer_user_password','splickit:12345','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('heartland_archer_create_account_user_password','splickit:12345','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('mandrill_url','https://mandrillapp.com/api/1.0/messages/send.json','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('phaxio_key','fc99560b1a5f00366b84b4d74f3ad5820a610b1a','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('phaxio_secret','f1bfe6c2ac026235e6ca13b38756c3e4ac58e7ea','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('phaxio_url','https://api.phaxio.com/v1/send','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('sfax_url','https://api.sfaxme.com/api/','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('sfax_api_key','664936B47CF044588D2859654E7D6009','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('shorepoints_url','https://dev.api.jerseymikes.com:8181/v1/loyalty/','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('splickit_fax_dir','/usr/local/splickit/httpd/htdocs/prod/app2/orderfiles/faxfiles/','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('vio_url','https://api-staging.value.io/v1/','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('levelup_url','https://sandbox.thelevelup.com/v15/orders','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('levelup_merchant_token','1139-251d600c31a73e949c7842ed9c049b4c419162f3f827e37024b222ade08f6d','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('brink_api_url_settings','https://api.brinkpos.net/Settings.svc','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('brink_api_url','https://api.brinkpos.net/Ordering.svc','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('brink_test_location_token','lF0MNIdSokC4RHHEkqvUNg==','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('brink_access_token','ssYesckeWU+3jzRwuW1IyQ==','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('twilio_account_sid','AC2ccdc203cfaf99b028b797ad6d178af1','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('twilio_account_auth_token','6a9fcd69f49eba9b6a5f434a40bfcd55','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('twilio_from_number','+17205451006','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('twimlets_server','http://twimlets.com/echo?Twiml=','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('vivonet_api_version','v1.1','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('vivonet_service_url','https://vvnapi-quarantine.qa.vivonet.com','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('xoikos_service_url','http://www.subshop.com/OnlineOrderingTEST/order.asmx','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('punch_service_url','https://intg.punchh.com','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('punch_client_secret','57ecf12b950de187c5f7daac9eae24b265335426c284bf6cc89e2a33904aaa2d','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('punch_client_id','f11354c3b84f9cefbac57322eba129eeb37607abb2a3e5739a22e414acc5923d','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('elpolloloco_api_url','https://www.myepl.net/no_auth','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('vio_admin_username_password','splikit:05bfd758-5e1a-4ceb-bb39-f64b60d99d30','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('vio_write_username_password','splikit:ac3b99e4-0d0c-4369-a70d-f44d56a874fc','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('vio_read_username_password','splikit:c74ee220-aa7c-4f26-be77-384225be78c4','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('vio_vault_username_password','splikit:50F3304A-B665-11E2-805C-14109FE16435','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('default_test_value','default','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('mailchimp_url','https://%%data_center%%.api.mailchimp.com/3.0/','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('mailchimp_mail_list','2ab75af229','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('mailchimp_api_key','f490dc1239e64237c1bcc31b0a0d2f56-us1','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('emagine_service_url','http://pos.emaginepos.com','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('facebook_url','https://graph.facebook.com/v2.11/me','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('memcached_server','none','default');
-- INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('memcached_server','memcached-container','unit_test');
-- INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('memcached_server','memcached-container','unit_test_ide');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('task_retail_api_key','d2706013-633e-409f-ac59-92000dd33d38','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('doordash_service_url','https://api.doordash.com/drive/v1/','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('doordash_api_key','6e70eefc4fbada08c09bfaa394839f1a4cfde2bc','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('gsm_api_key','AIzaSyBmICR3LTLavxWSjMy4dAnyzGqaLBfgsWw','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('sts_url','https://smarttransactions.net/gateway_no_lrc.php','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('vantive_url','https://w1.mercurycert.net/PaymentsAPI/PrePaid/','default');
-- INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('givex_url','https://dev-dataconnect.givex.com:50104','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('default_environment_file','loaded','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('loaded_environment','unit_test_ide','unit_test_ide');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('loaded_environment','unit_test','unit_test');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('loaded_environment','laptop','laptop');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('loaded_environment','default','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('loaded_environment','development','development');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('comprise_message_buffer_in_seconds','10','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('comprise_status_message_buffer_in_seconds','300','default');

INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('thanx_url','https://api.thanxsandbox.com','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('thanx_url','https://api.thanx.com','production');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('thanx_legacy_url','https://loyalty.thanxsandbox.com','default');
INSERT INTO Configuration_By_Environment_Variables (`name`,`value`,`environment`) VALUES ('thanx_legacy_url','https://loyalty.thanx.com','production');

INSERT INTO Third_Party_Providers (id,third_party_provider_type_id,name,description) VALUES (3003,3000,'Thanx','Thanx Loyalty');
INSERT INTO Third_Party_Provider_Parameters (third_party_provider_id,name,default_context,required) VALUES (3003,'client_id','skin',1),(3003,'secret','skin',1),(3003,'merchant_key','skin',1),(3003,'redirect_url','skin',1);


INSERT INTO Third_Party_Provider_Types (`id`,`type`,`description`) VALUES (6000,'Email_Marketing','Email Marketing Service');
INSERT INTO Third_Party_Providers VALUE (6001,6000,'Mailchimp','Mail Chimp', NOW(),now(),'N');
INSERT INTO Third_Party_Provider_Parameters (`third_party_provider_id`,`name`,`description`)
                VALUES (6001,'mailchimp_mail_list',''),
                (6001,'mailchimp_api_key',''),
                (6001,'active_flag','');


