testbot/ddl: Add a 'USE winetestbot' statement to all the SQL update scripts.
Francois Gouget
fgouget at codeweavers.com
Mon Oct 22 05:09:13 CDT 2012
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(+)
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;
--
1.7.10.4
More information about the wine-patches
mailing list