incubator-stonehenge-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From shan...@apache.org
Subject svn commit: r767820 - in /incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts: InsertScript.sql Table Creation.sql mssql/ mssql/InsertScript.sql mssql/Table Creation.sql
Date Thu, 23 Apr 2009 06:54:57 GMT
Author: shankar
Date: Thu Apr 23 06:54:57 2009
New Revision: 767820

URL: http://svn.apache.org/viewvc?rev=767820&view=rev
Log:
moving mssql scripts inside mssql folder

Added:
    incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mssql/
    incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mssql/InsertScript.sql
    incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mssql/Table Creation.sql
  (with props)
Removed:
    incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/InsertScript.sql
    incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/Table Creation.sql

Added: incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mssql/InsertScript.sql
URL: http://svn.apache.org/viewvc/incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mssql/InsertScript.sql?rev=767820&view=auto
==============================================================================
--- incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mssql/InsertScript.sql
(added)
+++ incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mssql/InsertScript.sql
Thu Apr 23 06:54:57 2009
@@ -0,0 +1,55 @@
+/*
+ * 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 [StockTraderDB].[dbo].[SERVICE]([SERVICENAME],[URL])
+     VALUES ('JAVA_BS','http://localhost:9763/services/TradeServiceWsas');
+INSERT INTO [StockTraderDB].[dbo].[SERVICE]([SERVICENAME],[URL])
+     VALUES ('JAVA_OPS','http://localhost:9763/services/OrderProcessor');
+INSERT INTO [StockTraderDB].[dbo].[SERVICE]([SERVICENAME],[URL])
+     VALUES ('JAVA_OPSSEC','http://localhost:9763/services/OrderProcessorMsec');
+INSERT INTO [StockTraderDB].[dbo].[SERVICE]([SERVICENAME],[URL])
+     VALUES ('PHP_BS','http://localhost:8080/php_stocktrader/business_service/business_svc.php');
+INSERT INTO [StockTraderDB].[dbo].[SERVICE]([SERVICENAME],[URL])
+     VALUES ('PHP_OPS','http://localhost:8080/php_stocktrader/order_processor/order_processor_svc.php');
+INSERT INTO [StockTraderDB].[dbo].[SERVICE]([SERVICENAME],[URL])
+     VALUES ('PHP_OPSSEC','http://localhost:8080/php_stocktrader/order_processor/order_processor_svc_msec.php');
+INSERT INTO [StockTraderDB].[dbo].[SERVICE]([SERVICENAME],[URL])
+     VALUES ('SPRING_BS','http://localhost:8070/StockTrader/services/TradeService');
+INSERT INTO [StockTraderDB].[dbo].[SERVICE]([SERVICENAME],[URL])
+     VALUES ('SPRING_OPS','http://localhost:8060/StockTrader/services/OrderService');
+INSERT INTO [StockTraderDB].[dbo].[SERVICE]([SERVICENAME],[URL])
+     VALUES ('SPRING_OPSSEC','http://localhost:8060/StockTrader/services/OrderServiceMsec');
+INSERT INTO [StockTraderDB].[dbo].[SERVICE]([SERVICENAME],[URL])
+     VALUES ('RUBY_OPS','http://localhost:3005/OrderService');
+INSERT INTO [StockTraderDB].[dbo].[SERVICE]([SERVICENAME],[URL])
+     VALUES ('RUBY_OPSSEC','http://localhost:3005/OrderServiceMsec');
+INSERT INTO [StockTraderDB].[dbo].[SERVICE]([SERVICENAME],[URL])
+     VALUES ('DOTNET_BS','http://localhost:9000/TradeBusinessService');
+INSERT INTO [StockTraderDB].[dbo].[SERVICE]([SERVICENAME],[URL])
+     VALUES ('DOTNET_OPS','http://localhost:8000/TradeOrderProcessor');
+INSERT INTO [StockTraderDB].[dbo].[SERVICE]([SERVICENAME],[URL])
+     VALUES ('DOTNET_OPSSEC','http://localhost:8000/TradeOrderProcessor/msec');
+INSERT INTO [StockTraderDB].[dbo].[DBCONFIG]([DBNAME],[HOSTNAME],[PORT],[ACTIVE])
+     VALUES ('MSSQL', '127.0.0.1', 1433, 'Y');
+INSERT INTO [StockTraderDB].[dbo].[CLIENTTOBS]([CLIENT],[BS])
+     VALUES ('PHP_CLIENT','PHP_BS');
+INSERT INTO [StockTraderDB].[dbo].[BSTOOPS]([BS],[OPS])
+	 VALUES ('PHP_BS', 'PHP_OPS');
+INSERT INTO [StockTraderDB].[dbo].[BSTOOPS]([BS],[OPS])
+	 VALUES ('JAVA_BS', 'JAVA_OPS');
+
+
+

Added: incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mssql/Table Creation.sql
URL: http://svn.apache.org/viewvc/incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mssql/Table%20Creation.sql?rev=767820&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mssql/Table Creation.sql
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream



Mime
View raw message