Author: chintana Date: Tue Dec 8 09:36:59 2009 New Revision: 888301 URL: http://svn.apache.org/viewvc?rev=888301&view=rev Log: Fixing the missing sec column.
Modified: incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mysql/InsertScript.sql Modified: incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mysql/InsertScript.sql URL: http://svn.apache.org/viewvc/incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mysql/InsertScript.sql?rev=888301&r1=888300&r2=888301&view=diff ============================================================================== --- incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mysql/InsertScript.sql (original) +++ incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mysql/InsertScript.sql Tue Dec 8 09:36:59 2009 @@ -14,29 +14,29 @@ * See the License for the specific language governing permissions and * limitations under the License. */ -INSERT INTO service(servicename,url) +INSERT INTO service(servicename,url,sec) VALUES ('WSAS_BS','http://localhost:9763/services/TradeServiceWsas', 'N'); -INSERT INTO service(servicename,url) +INSERT INTO service(servicename,url,sec) VALUES ('WSAS_OPS','http://localhost:9763/services/OrderProcessor', 'N'); -INSERT INTO service(servicename,url) +INSERT INTO service(servicename,url,sec) VALUES ('WSAS_OPSSEC','http://localhost:9763/services/OrderProcessorMsec', 'Y'); -INSERT INTO service(servicename,url) +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) +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) +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) +INSERT INTO service(servicename,url,sec) VALUES ('METRO_BS','http://localhost:8090/business_service/TradeServiceWsas', 'N'); -INSERT INTO service(servicename,url) +INSERT INTO service(servicename,url,sec) VALUES ('METRO_OPS','http://localhost:8090/order_processor/OrderProcessor', 'N'); -INSERT INTO service(servicename,url) +INSERT INTO service(servicename,url,sec) VALUES ('METRO_OPSSEC','http://localhost:8090/order_processor/OrderProcessorSec', 'Y'); -INSERT INTO service(servicename,url) +INSERT INTO service(servicename,url,sec) VALUES ('DOTNET_BS','http://localhost:9000/TradeBusinessService', 'N'); -INSERT INTO service(servicename,url) +INSERT INTO service(servicename,url,sec) VALUES ('DOTNET_OPS','http://localhost:8000/TradeOrderProcessor', 'N'); -INSERT INTO service(servicename,url) +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');