#165957 by hswong3i: create the variables table early, to make some DB driver writing a happier process

1 files changed, 11 insertions, 8 deletions

diff --git a/modules/system/system.schema b/modules/system/system.schema
index 2e63b39ff..a3ee189b0 100644
--- a/modules/system/system.schema
+++ b/modules/system/system.schema
@@ -2,6 +2,17 @@
 // $Id$
 
 function system_schema() {
+  // NOTE: {variable} needs to be created before all other tables, as
+  // some database drivers, e.g. Oracle and DB2, will require variable_get()
+  // and variable_set() for overcoming some database specific limitations.
+  $schema['variable'] = array(
+    'fields' => array(
+      'name'     => array('type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => ''),
+      'value'    => array('type' => 'text', 'not null' => TRUE, 'size' => 'big'),
+    ),
+    'primary key' => array('name'),
+  );
+
   $schema['actions'] = array(
     'fields' => array(
       'aid' => array('type' => 'varchar', 'length' => 255, 'not null' => TRUE, 'default' => '0'),
@@ -205,13 +216,5 @@ function system_schema() {
     'indexes' => array('src' => array('src')),
   );
 
-  $schema['variable'] = array(
-    'fields' => array(
-      'name'     => array('type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => ''),
-      'value'    => array('type' => 'text', 'not null' => TRUE, 'size' => 'big'),
-    ),
-    'primary key' => array('name'),
-  );
-
   return $schema;
 }