/*
 * Licensed to the Apache Software Foundation (ASF) under one or more
 * contributor license agreements.  See the NOTICE file distributed with
 * this work for additional information regarding copyright ownership.
 * The ASF licenses this file to You under the Apache License, Version 2.0
 * (the "License"); you may not use this file except in compliance with
 * the License.  You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
INSERT INTO service(servicename,url,sec)
     VALUES ('WSAS_BS','http://localhost:9763/services/TradeServiceWsas', 'N');
INSERT INTO service(servicename,url,sec)
     VALUES ('WSAS_OPS','http://localhost:9763/services/OrderProcessor', 'N');
INSERT INTO service(servicename,url,sec)
     VALUES ('WSAS_OPSSEC','http://localhost:9763/services/OrderProcessorMsec', 'Y');
INSERT INTO service(servicename,url,sec)
     VALUES ('PHP_BS','http://localhost:8080/php_stocktrader/business_service/business_svc.php', 'N');
INSERT INTO service(servicename,url,sec)
     VALUES ('PHP_OPS','http://localhost:8080/php_stocktrader/order_processor/order_processor_svc.php', 'N');
INSERT INTO service(servicename,url,sec)
     VALUES ('PHP_OPSSEC','http://localhost:8080/php_stocktrader/order_processor/order_processor_svc_msec.php', 'Y');
INSERT INTO service(servicename,url,sec)
     VALUES ('METRO_BS','http://localhost:8090/business_service/TradeServiceWsas', 'N');
INSERT INTO service(servicename,url,sec)
     VALUES ('METRO_OPS','http://localhost:8090/order_processor/OrderProcessor', 'N');
INSERT INTO service(servicename,url,sec)
     VALUES ('METRO_OPSSEC','http://localhost:8090/order_processor/OrderProcessorSec', 'Y');
INSERT INTO service(servicename,url,sec)
     VALUES ('DOTNET_BS','http://localhost:9000/TradeBusinessService', 'N');
INSERT INTO service(servicename,url,sec)
     VALUES ('DOTNET_OPS','http://localhost:8000/TradeOrderProcessor', 'N');
INSERT INTO service(servicename,url,sec)
     VALUES ('DOTNET_OPSSEC','http://localhost:8000/TradeOrderProcessor/sec', 'Y');
INSERT INTO dbconfig(dbname,hostname,port,active)
     VALUES ('MSSQL', '127.0.0.1', 1433, 'Y');
INSERT INTO clienttobs(client,bs)
     VALUES ('PHP_CLIENT','PHP_BS');
INSERT INTO clienttobs(client,bs)
     VALUES ('DOTNET_CLIENT','DOTNET_BS');
INSERT INTO clienttobs(client,bs)
     VALUES ('METRO_CLIENT','METRO_BS');
INSERT INTO bstoops(bs,ops)
	 VALUES ('PHP_BS', 'PHP_OPS');
INSERT INTO bstoops(bs,ops)
	 VALUES ('WSAS_BS', 'WSAS_OPS');
INSERT INTO bstoops(bs,ops)
	 VALUES ('DOTNET_BS', 'DOTNET_OPS');
INSERT INTO bstoops(bs,ops)
	 VALUES ('METRO_BS', 'METRO_OPS');




INSERT INTO account(creationdate, openbalance, logoutcount, balance, lastlogin, logincount, profile_userid)
	VALUES ('2008-01-01 00:00:00', 10000, 1, 10000, '2008-01-01 00:00:00', 1, 'uid:0');

INSERT INTO quote (low,open1,volume,price,high,companyname,symbol,change1)
     VALUES (100, 100, 1000, 100, 100, 'S0 Incorp', 's:0', 0);
INSERT INTO quote (low,open1,volume,price,high,companyname,symbol,change1)
     VALUES (100, 100, 1000, 100, 100, 'S1 Incorp', 's:1', 0);
INSERT INTO quote (low,open1,volume,price,high,companyname,symbol,change1)
     VALUES (100, 100, 1000, 100, 100, 'S2 Incorp', 's:2', 0);
INSERT INTO quote (low,open1,volume,price,high,companyname,symbol,change1)
     VALUES (100, 100, 1000, 100, 100, 'S3 Incorp', 's:3', 0);
INSERT INTO quote (low,open1,volume,price,high,companyname,symbol,change1)
     VALUES (100, 100, 1000, 100, 100, 'S4 Incorp', 's:4', 0);
INSERT INTO quote (low,open1,volume,price,high,companyname,symbol,change1)
     VALUES (100, 100, 1000, 100, 100, 'S5 Incorp', 's:5', 0);
INSERT INTO quote (low,open1,volume,price,high,companyname,symbol,change1)
     VALUES (100, 100, 1000, 100, 100, 'S6 Incorp', 's:6', 0);
INSERT INTO quote (low,open1,volume,price,high,companyname,symbol,change1)
     VALUES (100, 100, 1000, 100, 100, 'S7 Incorp', 's:7', 0);
INSERT INTO quote (low,open1,volume,price,high,companyname,symbol,change1)
     VALUES (100, 100, 1000, 100, 100, 'S8 Incorp', 's:8', 0);
INSERT INTO quote (low,open1,volume,price,high,companyname,symbol,change1)
     VALUES (100, 100, 1000, 100, 100, 'S9 Incorp', 's:9', 0);





