move core schema to class files

[quix0rs-gnu-social.git] / classes / Schema_version.php

diff --git a/classes/Schema_version.php b/classes/Schema_version.php
index 6b464c6d1db5bee9e547b344a975baeac652b4b9..4a3f939e93aa8d20f916f2ccd0c5a05a87d74601 100644 (file)
--- a/classes/Schema_version.php
+++ b/classes/Schema_version.php
@@ -3,7 +3,7 @@
  * Table Definition for schema_version
  */
 
-class Schema_version extends Memcached_DataObject
+class Schema_version extends Managed_DataObject
 {
     ###START_AUTOCODE
     /* the code below is auto generated do not remove the above tag */
@@ -19,4 +19,17 @@ class Schema_version extends Memcached_DataObject
 
     /* the code above is auto generated do not remove the tag below */
     ###END_AUTOCODE
+
+    public static function schemaDef()
+    {
+        return array(
+            'description' => 'To avoid checking database structure all the time, we store a checksum of the expected schema info for each table here. If it has not changed since the last time we checked the table, we can leave it as is.',
+            'fields' => array(
+                'table_name' => array('type' => 'varchar', 'length' => '64', 'not null' => true, 'description' => 'Table name'),
+                'checksum' => array('type' => 'varchar', 'length' => '64', 'not null' => true, 'description' => 'Checksum of schema array; a mismatch indicates we should check the table more thoroughly.'),
+                'modified' => array('type' => 'timestamp', 'not null' => true, 'description' => 'date this record was modified'),
+            ),
+            'primary key' => array('table_name'),
+        );
+    }
 }