--- a/persistentstorage/sql/TEST/t_sqldefect2.cpp	Thu Aug 19 11:36:21 2010 +0300
+++ b/persistentstorage/sql/TEST/t_sqldefect2.cpp	Tue Aug 31 16:57:14 2010 +0300
@@ -377,46 +377,10 @@
     //
     TheDb1.Close();
     err = RSqlDatabase::Delete(KTestDatabase1);
-    TEST2(err, KErrNone);    
+    TEST2(err, KErrNone);
 	}
 
 /**
-@SYMTestCaseID          PDS-SQL-CT-4214
-@SYMTestCaseDesc        Test for the change "After *#7370# Java apps are not preinstalled again" 
-@SYMTestPriority        High
-@SYMTestActions         The test makes sure there are no issues if the temp folder is removed after the server 
-                        has already started. The test performs the following actions - 
-                        1. Delete the 'temp' directory.
-                        2. Create a transaction which creates temp files.
-                        3. Check 'temp' folder exists at the end
-@SYMTestExpectedResults Test must not fail
-*/
-void DeleteTempFolder()
-    {
-    //1. Delete 'temp' folder
-    TInt err = TheFs.RmDir(KServerTempDir);
-    TEST2(err, KErrNone);
-	
-    //2. Create a transaction which creates temp files.
-    (void)RSqlDatabase::Delete(KTestDatabase1);
-    err = TheDb1.Create(KTestDatabase1);
-    TEST2(err, KErrNone);
-    
-    err = TheDb1.Exec(_L("CREATE TABLE t1(x UNIQUE); INSERT INTO t1 VALUES(1)"));
-    TEST(err >= 0);
-    err = TheDb1.Exec(_L("BEGIN; UPDATE t1 SET x = 2; UPDATE t1 SET x = 3; COMMIT"));
-    TEST(err >= 0);
-    
-    TheDb1.Close();
-    err = RSqlDatabase::Delete(KTestDatabase1);
-    TEST2(err, KErrNone);
-    
-    //3. Check 'temp' folder exists
-    err = TheFs.MkDir(KServerTempDir);
-    TEST2(err, KErrAlreadyExists);
-    }
-
-/**
 @SYMTestCaseID          PDS-SQL-CT-4213
 @SYMTestCaseDesc        Tests the ability of the SQL server to store empty strings and retrieve them as 
 						text column values, not NULLs.
@@ -503,6 +467,42 @@
 		}
 	}
 
+/**
+@SYMTestCaseID          PDS-SQL-CT-4214
+@SYMTestCaseDesc        Test for the change "After *#7370# Java apps are not preinstalled again" 
+@SYMTestPriority        High
+@SYMTestActions         The test makes sure there are no issues if the temp folder is removed after the server 
+                        has already started. The test performs the following actions - 
+                        1. Delete the 'temp' directory.
+                        2. Create a transaction which creates temp files.
+                        3. Check 'temp' folder exists at the end
+@SYMTestExpectedResults Test must not fail
+*/
+void DeleteTempFolder()
+    {
+    //1. Delete 'temp' folder
+    TInt err = TheFs.RmDir(KServerTempDir);
+    TEST2(err, KErrNone);
+	
+    //2. Create a transaction which creates temp files.
+    (void)RSqlDatabase::Delete(KTestDatabase1);
+    err = TheDb1.Create(KTestDatabase1);
+    TEST2(err, KErrNone);
+    
+    err = TheDb1.Exec(_L("CREATE TABLE t1(x UNIQUE); INSERT INTO t1 VALUES(1)"));
+    TEST(err >= 0);
+    err = TheDb1.Exec(_L("BEGIN; UPDATE t1 SET x = 2; UPDATE t1 SET x = 3; COMMIT"));
+    TEST(err >= 0);
+    
+    TheDb1.Close();
+    err = RSqlDatabase::Delete(KTestDatabase1);
+    TEST2(err, KErrNone);
+    
+    //3. Check 'temp' folder exists
+    err = TheFs.MkDir(KServerTempDir);
+    TEST2(err, KErrAlreadyExists);
+    }	
+	
 void DoTestsL()
 	{
 	TheTest.Start(_L(" @SYMTestCaseID:SYSLIB-SQL-CT-4154 DEF143062: SQL, \"CREATE INDEX\" sql crashes SQL server"));
@@ -514,16 +514,16 @@
     TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-CT-4156 DEF143150: SQL, strftime() returns incorrect result"));
     DEF143150();
     
-    TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-CT-4210 Temp files created during sql operations are not deleted after rebooting the phone - 1"));
+    TheTest.Next(_L(" @SYMTestCaseID:PDS-SQL-CT-4210 Temp files created during sql operations are not deleted after rebooting the phone - 1"));
     DeleteTempFile();
     
-    TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-CT-4211 Temp files created during sql operations are not deleted after rebooting the phone - 2"));
+    TheTest.Next(_L(" @SYMTestCaseID:PDS-SQL-CT-4211 Temp files created during sql operations are not deleted after rebooting the phone - 2"));
     TempFileTest();
     
     TheTest.Next(_L(" @SYMTestCaseID:PDS-SQL-CT-4213 No support to store an empty string in symbian's sqlite."));
     EmptyTextColumnTest();
-
-    TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-CT-4214 After *#7370# Java apps are not preinstalled again"));
+	
+	TheTest.Next(_L(" @SYMTestCaseID:PDS-SQL-CT-4214 After *#7370# Java apps are not preinstalled again"));
     DeleteTempFolder();
 	}