Francois Gouget : testbot/ddl: Add a 'USE winetestbot' statement to all the SQL update scripts.

[Alexandre Julliard]

Module: tools
Branch: master
Commit: 75eea6f9ae372e3a64e8bd609c7f85a105c70b96
URL:    http://source.winehq.org/git/tools.git/?a=commit;h=75eea6f9ae372e3a64e8bd609...

Author: Francois Gouget 
Date:   Mon Oct 22 12:09:13 2012 +0200

testbot/ddl: Add a 'USE winetestbot' statement to all the SQL update scripts.

This way they have all the instructions one needs to perform the updates.

---

testbot/ddl/update1.sql  |    2 ++
 testbot/ddl/update10.sql |    2 ++
 testbot/ddl/update11.sql |    2 ++
 testbot/ddl/update12.sql |    2 ++
 testbot/ddl/update14.sql |    2 ++
 testbot/ddl/update2.sql  |    2 ++
 testbot/ddl/update3.sql  |    2 ++
 testbot/ddl/update4.sql  |    2 ++
 testbot/ddl/update5.sql  |    2 ++
 testbot/ddl/update6.sql  |    2 ++
 testbot/ddl/update7.sql  |    2 ++
 testbot/ddl/update8.sql  |    2 ++
 testbot/ddl/update9.sql  |    2 ++
 13 files changed, 26 insertions(+), 0 deletions(-)

diff --git a/testbot/ddl/update1.sql b/testbot/ddl/update1.sql
index 89a5796..cf3039b 100644
--- a/testbot/ddl/update1.sql
+++ b/testbot/ddl/update1.sql
@@ -1,3 +1,5 @@
+USE winetestbot;
+
 ALTER TABLE Steps
   ADD DebugLevel INT(2) NULL,
   ADD ReportSuccessfulTests ENUM('Y', 'N') NULL;
diff --git a/testbot/ddl/update10.sql b/testbot/ddl/update10.sql
index d58ed25..05a816d 100644
--- a/testbot/ddl/update10.sql
+++ b/testbot/ddl/update10.sql
@@ -1,3 +1,5 @@
+USE winetestbot;
+
 ALTER TABLE Jobs
   ADD Archived ENUM('Y', 'N') NULL
       AFTER Id,
diff --git a/testbot/ddl/update11.sql b/testbot/ddl/update11.sql
index d3fa044..c8aed86 100644
--- a/testbot/ddl/update11.sql
+++ b/testbot/ddl/update11.sql
@@ -1,2 +1,4 @@
+USE winetestbot;
+
 ALTER TABLE VMs
   MODIFY Type ENUM('base', 'extra', 'build', 'retired') NOT NULL;
diff --git a/testbot/ddl/update12.sql b/testbot/ddl/update12.sql
index 41024c4..d920a8e 100644
--- a/testbot/ddl/update12.sql
+++ b/testbot/ddl/update12.sql
@@ -1,3 +1,5 @@
+USE winetestbot;
+
 ALTER TABLE Patches
   MODIFY Id INT(7) NOT NULL AUTO_INCREMENT,
   ADD WebPatchId INT(7) NULL
diff --git a/testbot/ddl/update14.sql b/testbot/ddl/update14.sql
index 9da8f58..55803f6 100644
--- a/testbot/ddl/update14.sql
+++ b/testbot/ddl/update14.sql
@@ -1,3 +1,5 @@
+USE winetestbot;
+
 ALTER TABLE VMs
   DROP VmxHost,
   DROP VmxFilePath,
diff --git a/testbot/ddl/update2.sql b/testbot/ddl/update2.sql
index 219d0f5..11446b5 100644
--- a/testbot/ddl/update2.sql
+++ b/testbot/ddl/update2.sql
@@ -1,3 +1,5 @@
+USE winetestbot;
+
 ALTER TABLE VMs
   ADD Type ENUM('base', 'extra', 'build') NULL AFTER BaseOS;

diff --git a/testbot/ddl/update3.sql b/testbot/ddl/update3.sql
index 4efd765..9b162c9 100644
--- a/testbot/ddl/update3.sql
+++ b/testbot/ddl/update3.sql
@@ -1,2 +1,4 @@
+USE winetestbot;
+
 ALTER TABLE VMs
   ADD VmxHost VARCHAR(64) NULL AFTER Status;
diff --git a/testbot/ddl/update4.sql b/testbot/ddl/update4.sql
index 835a17c..6a09c5a 100644
--- a/testbot/ddl/update4.sql
+++ b/testbot/ddl/update4.sql
@@ -1,2 +1,4 @@
+USE winetestbot;
+
 ALTER TABLE Steps
   MODIFY FileName VARCHAR(100) NOT NULL;
diff --git a/testbot/ddl/update5.sql b/testbot/ddl/update5.sql
index 7c0b4eb..45f9946 100644
--- a/testbot/ddl/update5.sql
+++ b/testbot/ddl/update5.sql
@@ -1,3 +1,5 @@
+USE winetestbot;
+
 CREATE TABLE Patches
 (
   Id          INT(7)       NOT NULL AUTO_INCREMENT,
diff --git a/testbot/ddl/update6.sql b/testbot/ddl/update6.sql
index 990fcd3..6242b74 100644
--- a/testbot/ddl/update6.sql
+++ b/testbot/ddl/update6.sql
@@ -1,3 +1,5 @@
+USE winetestbot;
+
 ALTER TABLE Steps
   ADD FileType ENUM('exe32', 'exe64', 'patchdlls', 'patchprograms') NULL
       AFTER FileName;
diff --git a/testbot/ddl/update7.sql b/testbot/ddl/update7.sql
index aa2629c..0d1db30 100644
--- a/testbot/ddl/update7.sql
+++ b/testbot/ddl/update7.sql
@@ -1,2 +1,4 @@
+USE winetestbot;
+
 ALTER TABLE Patches
   MODIFY Id INT(7) NOT NULL;
diff --git a/testbot/ddl/update8.sql b/testbot/ddl/update8.sql
index 18b3b92..caa5d1b 100644
--- a/testbot/ddl/update8.sql
+++ b/testbot/ddl/update8.sql
@@ -1,3 +1,5 @@
+USE winetestbot;
+
 ALTER TABLE Roles
   ADD IsDefaultRole ENUM('Y', 'N') NULL
       AFTER Name;
diff --git a/testbot/ddl/update9.sql b/testbot/ddl/update9.sql
index 535621f..2ba3da2 100644
--- a/testbot/ddl/update9.sql
+++ b/testbot/ddl/update9.sql
@@ -1,3 +1,5 @@
+USE winetestbot;
+
 ALTER TABLE Steps
   MODIFY FileType ENUM('exe32', 'exe64', 'patchdlls', 'patchprograms', 'dll32', 'dll64', 'zip') NOT NULL;