Module: tools Branch: master Commit: 75eea6f9ae372e3a64e8bd609c7f85a105c70b96 URL: http://source.winehq.org/git/tools.git/?a=commit;h=75eea6f9ae372e3a64e8bd609...
Author: Francois Gouget fgouget@codeweavers.com 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;