--- Untitled2.txt	Mon Oct 5 21:22:46 2009 UTC
+++ Untitled1.txt	Mon Oct 5 21:22:46 2009 UTC
@@ -91,10 +91,9 @@
         'description' => 'Unique identifier of this string.',
       ),
       'location' => array(
-        'type' => 'varchar',
-        'length' => 255,
-        'not null' => TRUE,
-        'default' => '',
+        'type' => 'text',
+        'not null' => FALSE,
+        'size' => 'big',
         'description' => 'Drupal path in case of online discovered translations or file path in case of imported strings.',
       ),
       'textgroup' => array(
@@ -110,6 +109,13 @@
         'not null' => TRUE,
         'description' => 'The original string in English.',
       ),
+      'context' => array(
+        'type' => 'varchar',
+        'length' => 255,
+        'not null' => TRUE,
+        'default' => '',
+        'description' => 'The context this string applies to.',
+      ),
       'version' => array(
         'type' => 'varchar',
         'length' => 20,
@@ -120,7 +126,7 @@
     ),
     'primary key' => array('lid'),
     'indexes' => array(
-      'source' => array(array('source', 30)),
+      'source_context' => array(array('source', 30), 'context'),
     ),
   );
 
@@ -160,6 +166,9 @@
       ),
     ),
     'primary key' => array('language', 'lid', 'plural'),
+    'foreign keys' => array(
+      'lid' => array('locales_source' => 'lid'),
+    ),
     'indexes' => array(
       'lid'      => array('lid'),
       'plid'     => array('plid'),