diff options
| author | Sean Dague | 2009-04-22 19:23:38 +0000 |
|---|---|---|
| committer | Sean Dague | 2009-04-22 19:23:38 +0000 |
| commit | e0160e56409720045b09b250fd40424fea4fd42a (patch) | |
| tree | d7e8e728d51850454943ec649894597aae8a1fa8 /OpenSim/Data/MySQL/Tests | |
| parent | add cleardb to estate tests (diff) | |
| download | opensim-SC_OLD-e0160e56409720045b09b250fd40424fea4fd42a.zip opensim-SC_OLD-e0160e56409720045b09b250fd40424fea4fd42a.tar.gz opensim-SC_OLD-e0160e56409720045b09b250fd40424fea4fd42a.tar.bz2 opensim-SC_OLD-e0160e56409720045b09b250fd40424fea4fd42a.tar.xz | |
add if exists to the drop table
Diffstat (limited to 'OpenSim/Data/MySQL/Tests')
| -rw-r--r-- | OpenSim/Data/MySQL/Tests/MySQLEstateTest.cs | 30 | ||||
| -rw-r--r-- | OpenSim/Data/MySQL/Tests/MySQLRegionTest.cs | 30 |
2 files changed, 30 insertions, 30 deletions
diff --git a/OpenSim/Data/MySQL/Tests/MySQLEstateTest.cs b/OpenSim/Data/MySQL/Tests/MySQLEstateTest.cs index 8659aa2..148d910 100644 --- a/OpenSim/Data/MySQL/Tests/MySQLEstateTest.cs +++ b/OpenSim/Data/MySQL/Tests/MySQLEstateTest.cs | |||
| @@ -83,21 +83,21 @@ namespace OpenSim.Data.MySQL.Tests | |||
| 83 | // if a new table is added, it has to be dropped here | 83 | // if a new table is added, it has to be dropped here |
| 84 | if (manager != null) | 84 | if (manager != null) |
| 85 | { | 85 | { |
| 86 | manager.ExecuteSql("drop table migrations"); | 86 | manager.ExecuteSql("drop table if exists migrations"); |
| 87 | manager.ExecuteSql("drop table prims"); | 87 | manager.ExecuteSql("drop table if exists prims"); |
| 88 | manager.ExecuteSql("drop table primshapes"); | 88 | manager.ExecuteSql("drop table if exists primshapes"); |
| 89 | manager.ExecuteSql("drop table primitems"); | 89 | manager.ExecuteSql("drop table if exists primitems"); |
| 90 | manager.ExecuteSql("drop table terrain"); | 90 | manager.ExecuteSql("drop table if exists terrain"); |
| 91 | manager.ExecuteSql("drop table land"); | 91 | manager.ExecuteSql("drop table if exists land"); |
| 92 | manager.ExecuteSql("drop table landaccesslist"); | 92 | manager.ExecuteSql("drop table if exists landaccesslist"); |
| 93 | manager.ExecuteSql("drop table regionban"); | 93 | manager.ExecuteSql("drop table if exists regionban"); |
| 94 | manager.ExecuteSql("drop table regionsettings"); | 94 | manager.ExecuteSql("drop table if exists regionsettings"); |
| 95 | manager.ExecuteSql("drop table estate_managers"); | 95 | manager.ExecuteSql("drop table if exists estate_managers"); |
| 96 | manager.ExecuteSql("drop table estate_groups"); | 96 | manager.ExecuteSql("drop table if exists estate_groups"); |
| 97 | manager.ExecuteSql("drop table estate_users"); | 97 | manager.ExecuteSql("drop table if exists estate_users"); |
| 98 | manager.ExecuteSql("drop table estateban"); | 98 | manager.ExecuteSql("drop table if exists estateban"); |
| 99 | manager.ExecuteSql("drop table estate_settings"); | 99 | manager.ExecuteSql("drop table if exists estate_settings"); |
| 100 | manager.ExecuteSql("drop table estate_map"); | 100 | manager.ExecuteSql("drop table if exists estate_map"); |
| 101 | } | 101 | } |
| 102 | } | 102 | } |
| 103 | } | 103 | } |
diff --git a/OpenSim/Data/MySQL/Tests/MySQLRegionTest.cs b/OpenSim/Data/MySQL/Tests/MySQLRegionTest.cs index e3f9413..b8fac69 100644 --- a/OpenSim/Data/MySQL/Tests/MySQLRegionTest.cs +++ b/OpenSim/Data/MySQL/Tests/MySQLRegionTest.cs | |||
| @@ -80,21 +80,21 @@ namespace OpenSim.Data.MySQL.Tests | |||
| 80 | { | 80 | { |
| 81 | if (manager != null) | 81 | if (manager != null) |
| 82 | { | 82 | { |
| 83 | manager.ExecuteSql("drop table migrations"); | 83 | manager.ExecuteSql("drop table if exists migrations"); |
| 84 | manager.ExecuteSql("drop table prims"); | 84 | manager.ExecuteSql("drop table if exists prims"); |
| 85 | manager.ExecuteSql("drop table primshapes"); | 85 | manager.ExecuteSql("drop table if exists primshapes"); |
| 86 | manager.ExecuteSql("drop table primitems"); | 86 | manager.ExecuteSql("drop table if exists primitems"); |
| 87 | manager.ExecuteSql("drop table terrain"); | 87 | manager.ExecuteSql("drop table if exists terrain"); |
| 88 | manager.ExecuteSql("drop table land"); | 88 | manager.ExecuteSql("drop table if exists land"); |
| 89 | manager.ExecuteSql("drop table landaccesslist"); | 89 | manager.ExecuteSql("drop table if exists landaccesslist"); |
| 90 | manager.ExecuteSql("drop table regionban"); | 90 | manager.ExecuteSql("drop table if exists regionban"); |
| 91 | manager.ExecuteSql("drop table regionsettings"); | 91 | manager.ExecuteSql("drop table if exists regionsettings"); |
| 92 | manager.ExecuteSql("drop table estate_managers"); | 92 | manager.ExecuteSql("drop table if exists estate_managers"); |
| 93 | manager.ExecuteSql("drop table estate_groups"); | 93 | manager.ExecuteSql("drop table if exists estate_groups"); |
| 94 | manager.ExecuteSql("drop table estate_users"); | 94 | manager.ExecuteSql("drop table if exists estate_users"); |
| 95 | manager.ExecuteSql("drop table estateban"); | 95 | manager.ExecuteSql("drop table if exists estateban"); |
| 96 | manager.ExecuteSql("drop table estate_settings"); | 96 | manager.ExecuteSql("drop table if exists estate_settings"); |
| 97 | manager.ExecuteSql("drop table estate_map"); | 97 | manager.ExecuteSql("drop table if exists estate_map"); |
| 98 | } | 98 | } |
| 99 | } | 99 | } |
| 100 | } | 100 | } |