summaryrefslogtreecommitdiff
path: root/sqlbox/db/upgrade.php
diff options
context:
space:
mode:
authorBenjamin Franzke <benjaminfranzke@googlemail.com>2012-11-23 10:15:28 +0100
committerBenjamin Franzke <benjaminfranzke@googlemail.com>2012-11-23 10:38:38 +0100
commitd1aaba539247b3602d8e7351ecdc694c5cdc33d1 (patch)
tree798cd2289245f8da3cafe5430693b90c64582d0d /sqlbox/db/upgrade.php
parente20a959086a9f1a9680c0a1cf89c8782a8f0cdb9 (diff)
downloadsqltutor-plugin-d1aaba539247b3602d8e7351ecdc694c5cdc33d1.tar.gz
sqltutor-plugin-d1aaba539247b3602d8e7351ecdc694c5cdc33d1.tar.bz2
sqltutor-plugin-d1aaba539247b3602d8e7351ecdc694c5cdc33d1.zip
sqlbox: Compare user query results from a definable query
Diffstat (limited to 'sqlbox/db/upgrade.php')
-rw-r--r--sqlbox/db/upgrade.php12
1 files changed, 12 insertions, 0 deletions
diff --git a/sqlbox/db/upgrade.php b/sqlbox/db/upgrade.php
index 83540aa..fb0c671 100644
--- a/sqlbox/db/upgrade.php
+++ b/sqlbox/db/upgrade.php
@@ -68,6 +68,18 @@ function xmldb_sqlbox_upgrade($oldversion) {
// and to play with the XMLDB Editor (in the admin menu) and its
// PHP generation posibilities.
+ if ($oldversion < 20121223) {
+ // Define field query to be added to sqlbox
+ $table = new xmldb_table('sqlbox');
+ $field = new xmldb_field('query', XMLDB_TYPE_TEXT, 'medium',
+ null, null, null, null, 'query');
+
+ // Add field query
+ if (!$dbman->field_exists($table, $field)) {
+ $dbman->add_field($table, $field);
+ }
+ }
+
// First example, some fields were added to install.xml on 2007/04/01
if ($oldversion < 2007040100) {