[Stdair-svn] SF.net SVN: stdair:[358] trunk/stdair/db/admin

[<den...@us...>]

Revision: 358
          http://stdair.svn.sourceforge.net/stdair/?rev=358&view=rev
Author:   denis_arnaud
Date:     2010-11-02 17:39:46 +0000 (Tue, 02 Nov 2010)

Log Message:
-----------
[DB] Fixed a few SQL scripts for the DSim database.

Modified Paths:
--------------
    trunk/stdair/db/admin/clean_all_tables.sh
    trunk/stdair/db/admin/count_all_tables.sh
    trunk/stdair/db/admin/create_dsim_db.sh
    trunk/stdair/db/admin/create_dsim_tables.sql
    trunk/stdair/db/admin/dump_dsim_db_structure.sh
    trunk/stdair/db/admin/load_dsim_data.sh

Property Changed:
----------------
    trunk/stdair/db/admin/


Property changes on: trunk/stdair/db/admin
___________________________________________________________________
Added: svn:ignore
   + sim_dsim.sql



Modified: trunk/stdair/db/admin/clean_all_tables.sh
===================================================================
--- trunk/stdair/db/admin/clean_all_tables.sh	2010-11-02 16:03:06 UTC (rev 357)
+++ trunk/stdair/db/admin/clean_all_tables.sh	2010-11-02 17:39:46 UTC (rev 358)
@@ -34,7 +34,7 @@
 DB_PASSWD="${DB_USER}"
 
 # Database Name
-DB_NAME="dsim"
+DB_NAME="sim_dsim"
 
 # Count the number of elements of a given database table
 function countElements() {

Modified: trunk/stdair/db/admin/count_all_tables.sh
===================================================================
--- trunk/stdair/db/admin/count_all_tables.sh	2010-11-02 16:03:06 UTC (rev 357)
+++ trunk/stdair/db/admin/count_all_tables.sh	2010-11-02 17:39:46 UTC (rev 358)
@@ -34,7 +34,7 @@
 DB_PASSWD="${DB_USER}"
 
 # Database Name
-DB_NAME="dsim"
+DB_NAME="sim_dsim"
 
 # Count the number of elements of a given database table
 function countElements() {

Modified: trunk/stdair/db/admin/create_dsim_db.sh
===================================================================
--- trunk/stdair/db/admin/create_dsim_db.sh	2010-11-02 16:03:06 UTC (rev 357)
+++ trunk/stdair/db/admin/create_dsim_db.sh	2010-11-02 17:39:46 UTC (rev 358)
@@ -7,7 +7,7 @@
 #
 
 # Database Name
-DB_NAME="dsim"
+DB_NAME="sim_dsim"
 
 # Database server (host)
 DB_HOST="localhost"

Modified: trunk/stdair/db/admin/create_dsim_tables.sql
===================================================================
--- trunk/stdair/db/admin/create_dsim_tables.sql	2010-11-02 16:03:06 UTC (rev 357)
+++ trunk/stdair/db/admin/create_dsim_tables.sql	2010-11-02 17:39:46 UTC (rev 358)
@@ -1,6 +1,6 @@
 -- MySQL dump 10.11
 --
--- Host: localhost    Database: dsim
+-- Host: localhost    Database: sim_dsim
 -- ------------------------------------------------------
 -- Server version	5.0.67
 

Modified: trunk/stdair/db/admin/dump_dsim_db_structure.sh
===================================================================
--- trunk/stdair/db/admin/dump_dsim_db_structure.sh	2010-11-02 16:03:06 UTC (rev 357)
+++ trunk/stdair/db/admin/dump_dsim_db_structure.sh	2010-11-02 17:39:46 UTC (rev 358)
@@ -38,13 +38,13 @@
 DB_PASSWD="$2"
 
 # Database Name
-DB_NAME="geo_geonames"
+DB_NAME="sim_dsim"
 
 # Export Tool
 EXPORTER=mysqldump
 
 # Dump file
-DUMP_FILE="geo_geonames.sql"
+DUMP_FILE="sim_dsim.sql"
 
 #
 ${EXPORTER} -u ${DB_USER} --password=${DB_PASSWD} -P ${DB_PORT} -h ${DB_HOST} \

Modified: trunk/stdair/db/admin/load_dsim_data.sh
===================================================================
--- trunk/stdair/db/admin/load_dsim_data.sh	2010-11-02 16:03:06 UTC (rev 357)
+++ trunk/stdair/db/admin/load_dsim_data.sh	2010-11-02 17:39:46 UTC (rev 358)
@@ -34,7 +34,7 @@
 DB_PASSWD="dsim"
 
 # Database Name
-DB_NAME="dsim"
+DB_NAME="sim_dsim"
 
 # Create the tables
 SQL_FILE="create_dsim_tables.sql"


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.