ActionApps PHP Cross Reference Groupware Applications

Source: /include/metabase.class.php3 - 903 lines - 160579 bytes - Summary - Text - Print

Description: PHP versions 4 and 5

   1  <?php
   2  /**

   3   *

   4   * PHP versions 4 and 5

   5   *

   6   * LICENSE: This program is free software; you can redistribute it and/or modify

   7   * it under the terms of the GNU General Public License as published by

   8   * the Free Software Foundation; either version 2 of the License, or

   9   * (at your option) any later version.

  10   *

  11   * This program is distributed in the hope that it will be useful,

  12   * but WITHOUT ANY WARRANTY; without even the implied warranty of

  13   * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

  14   * GNU General Public License for more details.

  15   *

  16   * You should have received a copy of the GNU General Public License

  17   * along with this program (LICENSE); if not, write to the Free Software

  18   * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

  19   *

  20   * @package   Include

  21   * @version   $Id: menu_util.php3 2357 2007-02-06 12:03:49Z honzam $

  22   * @author    Honza Malik <honza.malik@ecn.cz>

  23   * @license   http://opensource.org/licenses/gpl-license.php GNU Public License

  24   * @copyright Copyright (C) 1999, 2000 Association for Progressive Communications

  25   * @link      http://www.apc.org/ APC

  26   *

  27  */
  28  
  29  /** AA_Metabase holds the database structure of AA

  30   *  The database structure in metabase is used for

  31   *    1) creating database

  32   *    2) updating the database structure

  33   *    3) constructing queries to database with data type checking

  34   *

  35   *  Inner structure looks like (generated with getDefinition() method):

  36   *

  37   *       'central_conf' => array(

  38   *           'id' => array(

  39   *                0 => "id",                         // 'Field'

  40   *                1 => "int(10) unsigned",           // 'Type'

  41   *                2 => "NO",                         // 'Null'

  42   *                3 => "PRI",                        // 'Key'

  43   *                4 => "0",                          // 'Default'

  44   *                5 => "auto_increment",             // 'Extra'

  45   *                6 => "AA identifier",              // 'Comment'

  46   *           ),

  47   *           'dns_conf' => array(

  48   *               'Field'   => "dns_conf",

  49   *               'Type'    => "varbinary(255)",

  50   *               'Null'    => "NO",

  51   *           ),

  52   *           ...

  53   */
  54  
  55  
  56  class AA_Metabase_Column {
  57  
  58      /** Column definition array

  59       *             0     1    2     3      4       5       6

  60       *  array ( field, type, null, key, default, extra, comment )

  61       *

  62       *  The reason, why we store it in array is, that the metabase is here

  63       *  stored as serialized string and I want to keep it as short as possible

  64       */
  65      var $c;
  66  
  67      function AA_Metabase_Column($column) {
  68          $this->c = array( $column['Field'], $column['Type'], $column['Null']=='YES', $column['Key'], $column['Default'], $column['Extra'], $column['Comment'] );
  69      }
  70  
  71      function isKey() {
  72          return strpos($this->c[3], 'PRI')!==false;
  73      }
  74  
  75      function getCreateSql() {
  76          $SQL  = '`'.  $this->c[0] .'`';                     // column name

  77          $SQL .= ' '.  $this->c[1];                          // column definition

  78          if (!$this->c[2]) {                                 // NULL ?
  79              $SQL .= ' NOT NULL';
  80          }
  81          if (strlen($this->c[4]) > 0) {
  82              // look for keywords for default

  83              if ( $this->c[4] === 'CURRENT_TIMESTAMP' ) {
  84                  // we ignore it, because DEFAULT CURRENT_TIMESTAMP is

  85                  // not supported in MySQL < 4.1.x and it is not needed for

  86                  // MySQL > 4.1.x, because standard settings of any timestamp

  87                  // column is:

  88                  //     DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

  89              } elseif ( $this->c[4] === 'NULL' ) {
  90                  $SQL .= " default ". $this->c[4];     // default

  91              } else {
  92                  $SQL .= " default '". $this->c[4] ."'";     // default

  93              }
  94          }
  95          $SQL .= ' '.  $this->c[5];                          // extra - like auto_increment

  96          return $SQL;
  97      }
  98  
  99      /** returns database structure definition as PHP code (array)

 100       *  not used, yet (and question is, if ever) */
 101      function getDefinition() {
 102          $ret  = "\n        '".$this->c[0]."' => array(";
 103          if ($this->c[0]) { $ret .= "\n            'Field'   => \"".$this->c[0].'",';  }
 104          if ($this->c[1]) { $ret .= "\n            'Type'    => \"".$this->c[1].'",';  }
 105          if ($this->c[2]) { $ret .= "\n            'Null'    => \"".($this->c[2] ? 'YES' : 'NO').'",';  }
 106          if ($this->c[3]) { $ret .= "\n            'Key'     => \"".$this->c[3].'",';  }
 107          if ($this->c[4]) { $ret .= "\n            'Default' => \"".$this->c[4].'",';  }
 108          if ($this->c[5]) { $ret .= "\n            'Extra'   => \"".$this->c[5].'",';  }
 109          if ($this->c[6]) { $ret .= "\n            'Comment' => \"".$this->c[6].'"';   }
 110          $ret .= "\n        )";
 111          return $ret;
 112      }
 113  }
 114  
 115  class AA_Metabase_Index {
 116      /**

 117       *  The reason, why we use this short variables is, that the metabase is here

 118       *  stored as serialized string and I want to keep it as short as possible

 119       */
 120      var $t; // table name

 121      var $n; // index name

 122      var $s; // sort of index P|U|I  (= PRIMARY|UNIQUE|INDEX)

 123      var $c; // columns array (array of column names of array (name,part) for partial column index (like text(10))

 124  
 125      function AA_Metabase_Index($table, $name, $sort) {
 126          $this->t = $table;
 127          $this->n = $name;
 128          $this->s = $sort;
 129          $this->c = array();
 130      }
 131  
 132      function addColumn($position, $column, $sub_part='') {
 133          $this->c[(int)$position] = $sub_part ? array($column, $sub_part) : $column;
 134      }
 135  
 136      function getCreateSql() {
 137          $cols = array();
 138          foreach ($this->c as $col) {
 139              $cols[] = is_array($col) ? '`'.$col[0].'`('.$col[1].')' : "`$col`";
 140          }
 141          $cols_list = join(',', $cols);
 142          switch ($this->s) {
 143              case 'P': return "PRIMARY KEY ($cols_list)";
 144              case 'U': return 'UNIQUE KEY '.$this->n." ($cols_list)";
 145          }
 146          return 'KEY '.$this->n." ($cols_list)";
 147      }
 148  }
 149  
 150  
 151  class AA_Metabase_Table {
 152      /** Name of the table */

 153      var $tablename;
 154      /** array of PRIMARY KEY columns */

 155      var $primary_key;
 156      /** array of INDEXES: array(index_name => AA_Metabase_Index) */

 157      var $index;
 158      /** array of table columns */

 159      var $column;
 160      /** array of table flags - like ENGINE=InnoDB, DEFAULT CHARSET=cp1250 */

 161      var $flags;
 162  
 163      // This is temporary solution - we will use some better structure (MDB2?)

 164      // for table definition in order we can check the field type,

 165      // the indexes, generate sql_update script, ...

 166      function AA_Metabase_Table($tablename, $columns, $indexes='') {
 167          $this->tablename   = $tablename;
 168          $this->column      = array();
 169          $this->primary_key = array();
 170          $this->index       = array();
 171          foreach ($columns as $column) {
 172              $aa_column  = new AA_Metabase_Column($column);
 173              $this->column[$column['Field']] = new AA_Metabase_Column($column);
 174              if ($aa_column->isKey()) {
 175                  $this->primary_key[$column['Field']] = true;
 176              }
 177          }
 178          if (!empty($indexes)) {
 179              // indexes array looks like:

 180              // [0] => Array (

 181              //      [Table] => email [Non_unique] => 0 [Key_name] => PRIMARY [Seq_in_index] => 1 [Column_name] => id [Collation] => A [Cardinality] => 71 [Sub_part] => [Packed] => [Null] => [Index_type] => BTREE [Comment] => )

 182              foreach ($indexes as $index_part) {
 183                  if ( !isset($this->index[$index_part['Key_name']])) {
 184                      $index_type = ($index_part['Key_name'] == 'PRIMARY') ? 'P' : (($index_part['Non_unique']) ? 'I': 'U' );
 185                      $this->index[$index_part['Key_name']] = new AA_Metabase_Index($index_part['Table'], $index_part['Key_name'], $index_type);
 186                  }
 187                  $idx = &$this->index[$index_part['Key_name']]; // to work in php4

 188                  $idx->addColumn((int)$index_part['Seq_in_index'], $index_part['Column_name'], $index_part['Sub_part']);
 189              }
 190          }
 191      }
 192  
 193      function factoryFromDb($tablename) {
 194          $columns = GetTable2Array("SHOW FULL COLUMNS FROM `$tablename`", 'Field');
 195          $indexes = GetTable2Array("SHOW INDEX FROM `$tablename`", '');
 196          return new AA_Metabase_Table($tablename, $columns, $indexes);
 197      }
 198  
 199      function getColumnNames() {
 200          return array_keys($this->column);
 201      }
 202  
 203      /** Is the $columnname the column in this table? */

 204      function isColumn($columnname) {
 205          return isset($this->column[$columnname]);
 206      }
 207  
 208      function getKeys() {
 209          return array_keys($this->primary_key);
 210      }
 211  
 212      function isKey($columnname) {
 213          return ($this->primary_key[$columnname] ? true : false);
 214      }
 215  
 216      function getCreateSql($prefix='') {
 217          $sql_parts = array();
 218          foreach ($this->column as $column) {
 219              $sql_parts[] = $column->getCreateSql();
 220          }
 221          foreach ($this->index as $index) {
 222              $sql_parts[] = $index->getCreateSql();
 223          }
 224          return "CREATE TABLE IF NOT EXISTS `$prefix".$this->tablename."` (\n". join(",\n",$sql_parts) ."\n)";
 225      }
 226  
 227      /** returns database structure definition as PHP code (array) */

 228      function getDefinition() {
 229          $defs = array();
 230          foreach ($this->column as $column) {
 231              $defs[] = $column->getDefinition();
 232          }
 233          $ret  = "\n    '". $this->tablename ."' => array(";
 234          $ret .= join(",", $defs);
 235          $ret .= "\n    )";
 236          return $ret;
 237      }
 238  
 239  
 240      /** setFromSql function

 241       *  Fills AA_Metabase_Table structure from the result of SQL command:

 242       *     SHOW CREATE TABLE $tablename

 243       * @param $tablename

 244       * @param $create_SQL

 245       */
 246      function setFromSql($tablename, $create_SQL) {
 247          $this->tablename = $tablename;
 248          foreach (explode("\n", $create_SQL) as $row) {
 249              $row = trim($row);
 250              // first row - CREATE TABLE - no need to grab anything from it

 251              if ( strpos($row, 'CREATE TABLE') === 0 ) {
 252                  continue;
 253              }
 254              // field definition row - grab it

 255              if ( (strpos($row, 'KEY') === 0) OR
 256                   (strpos($row, 'UNIQUE KEY') === 0) OR
 257                   (strpos($row, 'PRIMARY KEY') === 0) ) {
 258                  $this->_setIndexFromSql($row);
 259                  continue;
 260              }
 261              if ( strpos($row, ')') === 0 ) {
 262                  $this->_setFlagFromSql($row);
 263                  continue;
 264              }
 265              // else urecognized row

 266              echo $row;
 267          }
 268      }
 269  }
 270  
 271  /** @todo convert to static class variables after move to PHP5 */

 272  class AA_Metabase {
 273      var $tables;
 274  
 275      /** AA_Metabase function - constructor

 276       *  Do not use it - use $metabase = AA_Metabase::singleton() instead

 277       */
 278      function AA_Metabase() {
 279          $this->tables   = array();
 280      }
 281  
 282      /** Static function called like $metabase = AA_Metabase::singleton() */

 283      function singleton() {
 284          static $instance = null;
 285          if (is_null($instance)) {
 286              // Now create the metabase object

 287              // It is serialized for quicker processing in PHP

 288              //

 289              // the code below was generated by following code

 290              //     $metabase  = new AA_Metabase;

 291              //     $metabase->loadFromDb();

 292              //     echo '$instance = unserialize(\''. str_replace("'", '\\\'', serialize($metabase)) .'\');';

 293              //     exit;

 294              // generated also by "Generate metabase PHP row" optimize action on  AA -> Optimize page

 295              $instance = unserialize('O:11:"AA_Metabase":1:{s:6:"tables";a:71:{s:15:"active_sessions";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:15:"active_sessions";s:11:"primary_key";a:2:{s:3:"sid";b:1;s:4:"name";b:1;}s:5:"index";a:2:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:15:"active_sessions";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:2:{i:1;s:4:"name";i:2;s:3:"sid";}}s:7:"changed";O:17:"AA_Metabase_Index":4:{s:1:"t";s:15:"active_sessions";s:1:"n";s:7:"changed";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:7:"changed";}}}s:6:"column";a:4:{s:3:"sid";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:3:"sid";i:1;s:13:"varbinary(32)";i:2;b:0;i:3;s:3:"PRI";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:4:"name";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"name";i:1;s:11:"varchar(32)";i:2;b:0;i:3;s:3:"PRI";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:3:"val";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:3:"val";i:1;s:10:"mediumtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:7:"changed";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"changed";i:1;s:11:"varchar(14)";i:2;b:0;i:3;s:3:"MUL";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:17:"alerts_collection";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:17:"alerts_collection";s:11:"primary_key";a:1:{s:2:"id";b:1;}s:5:"index";a:2:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:17:"alerts_collection";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:2:"id";}}s:9:"module_id";O:17:"AA_Metabase_Index":4:{s:1:"t";s:17:"alerts_collection";s:1:"n";s:9:"module_id";s:1:"s";s:1:"U";s:1:"c";a:1:{i:1;s:9:"module_id";}}}s:6:"column";a:5:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:7:"char(6)";i:2;b:0;i:3;s:3:"PRI";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:9:"module_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"module_id";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:3:"UNI";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:15:"emailid_welcome";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:15:"emailid_welcome";i:1;s:7:"int(11)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:13:"emailid_alert";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:13:"emailid_alert";i:1;s:7:"int(11)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:8:"slice_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"slice_id";i:1;s:13:"varbinary(16)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:24:"alerts_collection_filter";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:24:"alerts_collection_filter";s:11:"primary_key";a:2:{s:12:"collectionid";b:1;s:8:"filterid";b:1;}s:5:"index";a:1:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:24:"alerts_collection_filter";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:2:{i:1;s:12:"collectionid";i:2;s:8:"filterid";}}}s:6:"column";a:3:{s:12:"collectionid";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:12:"collectionid";i:1;s:12:"varbinary(6)";i:2;b:0;i:3;s:3:"PRI";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:8:"filterid";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"filterid";i:1;s:7:"int(11)";i:2;b:0;i:3;s:3:"PRI";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:7:"myindex";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"myindex";i:1;s:7:"int(11)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:26:"alerts_collection_howoften";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:26:"alerts_collection_howoften";s:11:"primary_key";a:2:{s:12:"collectionid";b:1;s:8:"howoften";b:1;}s:5:"index";a:1:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:26:"alerts_collection_howoften";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:2:{i:1;s:12:"collectionid";i:2;s:8:"howoften";}}}s:6:"column";a:3:{s:12:"collectionid";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:12:"collectionid";i:1;s:12:"varbinary(6)";i:2;b:0;i:3;s:3:"PRI";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:8:"howoften";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"howoften";i:1;s:8:"char(20)";i:2;b:0;i:3;s:3:"PRI";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"last";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"last";i:1;s:7:"int(10)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:13:"alerts_filter";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:13:"alerts_filter";s:11:"primary_key";a:1:{s:2:"id";b:1;}s:5:"index";a:1:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:13:"alerts_filter";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:2:"id";}}}s:6:"column";a:4:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:7:"int(11)";i:2;b:0;i:3;s:3:"PRI";i:4;N;i:5;s:14:"auto_increment";i:6;s:0:"";}}s:3:"vid";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:3:"vid";i:1;s:7:"int(11)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:5:"conds";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:5:"conds";i:1;s:4:"text";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:11:"description";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"description";i:1;s:4:"text";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:10:"auth_group";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:10:"auth_group";s:11:"primary_key";a:2:{s:8:"username";b:1;s:6:"groups";b:1;}s:5:"index";a:1:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:10:"auth_group";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:2:{i:1;s:8:"username";i:2;s:6:"groups";}}}s:6:"column";a:3:{s:8:"username";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"username";i:1;s:11:"varchar(50)";i:2;b:0;i:3;s:3:"PRI";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:6:"groups";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:6:"groups";i:1;s:11:"varchar(50)";i:2;b:0;i:3;s:3:"PRI";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:12:"last_changed";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:12:"last_changed";i:1;s:7:"int(11)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:8:"auth_log";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:8:"auth_log";s:11:"primary_key";a:1:{s:7:"created";b:1;}s:5:"index";a:1:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:8:"auth_log";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:7:"created";}}}s:6:"column";a:2:{s:6:"result";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:6:"result";i:1;s:4:"text";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:7:"created";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"created";i:1;s:7:"int(11)";i:2;b:0;i:3;s:3:"PRI";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:9:"auth_user";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:9:"auth_user";s:11:"primary_key";a:1:{s:8:"username";b:1;}s:5:"index";a:1:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:9:"auth_user";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:8:"username";}}}s:6:"column";a:3:{s:8:"username";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"username";i:1;s:11:"varchar(50)";i:2;b:0;i:3;s:3:"PRI";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:6:"passwd";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:6:"passwd";i:1;s:11:"varchar(50)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:12:"last_changed";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:12:"last_changed";i:1;s:7:"int(11)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:12:"central_conf";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:12:"central_conf";s:11:"primary_key";a:1:{s:2:"id";b:1;}s:5:"index";a:2:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:12:"central_conf";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:2:"id";}}s:5:"AA_ID";O:17:"AA_Metabase_Index":4:{s:1:"t";s:12:"central_conf";s:1:"n";s:5:"AA_ID";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:5:"AA_ID";}}}s:6:"column";a:31:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:16:"int(10) unsigned";i:2;b:0;i:3;s:3:"PRI";i:4;N;i:5;s:14:"auto_increment";i:6;s:0:"";}}s:8:"dns_conf";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"dns_conf";i:1;s:14:"varbinary(255)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:10:"dns_serial";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:10:"dns_serial";i:1;s:7:"int(11)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:7:"dns_web";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"dns_web";i:1;s:13:"varbinary(15)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:6:"dns_mx";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:6:"dns_mx";i:1;s:13:"varbinary(15)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:6:"dns_db";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:6:"dns_db";i:1;s:13:"varbinary(15)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:8:"dns_prim";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"dns_prim";i:1;s:14:"varbinary(255)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:7:"dns_sec";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"dns_sec";i:1;s:14:"varbinary(255)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:8:"web_conf";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"web_conf";i:1;s:14:"varbinary(255)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:8:"web_path";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"web_path";i:1;s:14:"varbinary(255)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:9:"db_server";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"db_server";i:1;s:14:"varbinary(255)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:7:"db_name";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"db_name";i:1;s:14:"varbinary(255)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:7:"db_user";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"db_user";i:1;s:14:"varbinary(255)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:6:"db_pwd";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:6:"db_pwd";i:1;s:14:"varbinary(255)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:12:"AA_SITE_PATH";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:12:"AA_SITE_PATH";i:1;s:14:"varbinary(255)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:11:"AA_BASE_DIR";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"AA_BASE_DIR";i:1;s:14:"varbinary(255)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:14:"AA_HTTP_DOMAIN";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:14:"AA_HTTP_DOMAIN";i:1;s:14:"varbinary(255)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:5:"AA_ID";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:5:"AA_ID";i:1;s:13:"varbinary(32)";i:2;b:0;i:3;s:3:"MUL";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:8:"ORG_NAME";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"ORG_NAME";i:1;s:14:"varbinary(255)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:21:"ERROR_REPORTING_EMAIL";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:21:"ERROR_REPORTING_EMAIL";i:1;s:14:"varbinary(255)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:12:"ALERTS_EMAIL";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:12:"ALERTS_EMAIL";i:1;s:14:"varbinary(255)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:19:"IMG_UPLOAD_MAX_SIZE";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:19:"IMG_UPLOAD_MAX_SIZE";i:1;s:10:"bigint(20)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:14:"IMG_UPLOAD_URL";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:14:"IMG_UPLOAD_URL";i:1;s:14:"varbinary(255)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:15:"IMG_UPLOAD_PATH";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:15:"IMG_UPLOAD_PATH";i:1;s:14:"varbinary(255)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:15:"SCROLLER_LENGTH";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:15:"SCROLLER_LENGTH";i:1;s:7:"int(11)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:16:"FILEMAN_BASE_DIR";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:16:"FILEMAN_BASE_DIR";i:1;s:14:"varbinary(255)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:16:"FILEMAN_BASE_URL";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:16:"FILEMAN_BASE_URL";i:1;s:14:"varbinary(255)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:25:"FILEMAN_UPLOAD_TIME_LIMIT";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:25:"FILEMAN_UPLOAD_TIME_LIMIT";i:1;s:7:"int(11)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:13:"AA_ADMIN_USER";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:13:"AA_ADMIN_USER";i:1;s:13:"varbinary(30)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:12:"AA_ADMIN_PWD";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:12:"AA_ADMIN_PWD";i:1;s:13:"varbinary(30)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:11:"status_code";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"status_code";i:1;s:11:"smallint(5)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:6:"change";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:6:"change";s:11:"primary_key";a:1:{s:2:"id";b:1;}s:5:"index";a:2:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:6:"change";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:2:"id";}}s:18:"type_resource_time";O:17:"AA_Metabase_Index":4:{s:1:"t";s:6:"change";s:1:"n";s:18:"type_resource_time";s:1:"s";s:1:"I";s:1:"c";a:3:{i:1;s:4:"type";i:2;s:11:"resource_id";i:3;s:4:"time";}}}s:6:"column";a:5:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:13:"varbinary(32)";i:2;b:0;i:3;s:3:"PRI";i:4;s:32:"                                ";i:5;s:0:"";i:6;s:0:"";}}s:11:"resource_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"resource_id";i:1;s:13:"varbinary(32)";i:2;b:0;i:3;s:0:"";i:4;s:32:"                                ";i:5;s:0:"";i:6;s:0:"";}}s:4:"type";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"type";i:1;s:8:"char(20)";i:2;b:1;i:3;s:3:"MUL";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"user";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"user";i:1;s:8:"char(60)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"time";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"time";i:1;s:10:"bigint(20)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:13:"change_record";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:13:"change_record";s:11:"primary_key";a:1:{s:2:"id";b:1;}s:5:"index";a:1:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:13:"change_record";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:2:"id";}}}s:6:"column";a:6:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:10:"bigint(20)";i:2;b:0;i:3;s:3:"PRI";i:4;N;i:5;s:14:"auto_increment";i:6;s:0:"";}}s:9:"change_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"change_id";i:1;s:13:"varbinary(32)";i:2;b:0;i:3;s:0:"";i:4;s:32:"                                ";i:5;s:0:"";i:6;s:0:"";}}s:8:"selector";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"selector";i:1;s:14:"varbinary(255)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:8:"priority";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"priority";i:1;s:7:"int(11)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:5:"value";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:5:"value";i:1;s:8:"longtext";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"type";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"type";i:1;s:11:"varchar(32)";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:8:"constant";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:8:"constant";s:11:"primary_key";a:1:{s:2:"id";b:1;}s:5:"index";a:3:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:8:"constant";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:2:"id";}}s:8:"group_id";O:17:"AA_Metabase_Index":4:{s:1:"t";s:8:"constant";s:1:"n";s:8:"group_id";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:8:"group_id";}}s:8:"short_id";O:17:"AA_Metabase_Index":4:{s:1:"t";s:8:"constant";s:1:"n";s:8:"short_id";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:8:"short_id";}}}s:6:"column";a:9:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:3:"PRI";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:8:"group_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"group_id";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:3:"MUL";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"name";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"name";i:1;s:9:"char(150)";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:5:"value";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:5:"value";i:1;s:9:"char(255)";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:5:"class";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:5:"class";i:1;s:13:"varbinary(16)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:3:"pri";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:3:"pri";i:1;s:11:"smallint(5)";i:2;b:0;i:3;s:0:"";i:4;s:3:"100";i:5;s:0:"";i:6;s:0:"";}}s:9:"ancestors";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"ancestors";i:1;s:9:"char(160)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:11:"description";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"description";i:1;s:9:"char(250)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:8:"short_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"short_id";i:1;s:7:"int(11)";i:2;b:0;i:3;s:3:"MUL";i:4;N;i:5;s:14:"auto_increment";i:6;s:0:"";}}}s:5:"flags";N;}s:14:"constant_slice";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:14:"constant_slice";s:11:"primary_key";a:1:{s:8:"group_id";b:1;}s:5:"index";a:1:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:14:"constant_slice";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:8:"group_id";}}}s:6:"column";a:7:{s:8:"slice_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"slice_id";i:1;s:13:"varbinary(16)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:8:"group_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"group_id";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:3:"PRI";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:9:"propagate";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"propagate";i:1;s:10:"tinyint(1)";i:2;b:0;i:3;s:0:"";i:4;s:1:"1";i:5;s:0:"";i:6;s:0:"";}}s:10:"levelcount";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:10:"levelcount";i:1;s:10:"tinyint(2)";i:2;b:0;i:3;s:0:"";i:4;s:1:"2";i:5;s:0:"";i:6;s:0:"";}}s:10:"horizontal";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:10:"horizontal";i:1;s:10:"tinyint(1)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:9:"hidevalue";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"hidevalue";i:1;s:10:"tinyint(1)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:8:"hierarch";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"hierarch";i:1;s:10:"tinyint(1)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:7:"content";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:7:"content";s:11:"primary_key";a:0:{}s:5:"index";a:2:{s:7:"item_id";O:17:"AA_Metabase_Index":4:{s:1:"t";s:7:"content";s:1:"n";s:7:"item_id";s:1:"s";s:1:"I";s:1:"c";a:3:{i:1;s:7:"item_id";i:2;s:8:"field_id";i:3;a:2:{i:0;s:4:"text";i:1;s:2:"16";}}}s:4:"text";O:17:"AA_Metabase_Index":4:{s:1:"t";s:7:"content";s:1:"n";s:4:"text";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;a:2:{i:0;s:4:"text";i:1;s:2:"12";}}}}s:6:"column";a:5:{s:7:"item_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"item_id";i:1;s:13:"varbinary(16)";i:2;b:1;i:3;s:3:"MUL";i:4;s:16:"                ";i:5;s:0:"";i:6;s:0:"";}}s:8:"field_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"field_id";i:1;s:13:"varbinary(16)";i:2;b:1;i:3;s:0:"";i:4;s:16:"                ";i:5;s:0:"";i:6;s:0:"";}}s:6:"number";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:6:"number";i:1;s:10:"bigint(20)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"text";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"text";i:1;s:10:"mediumtext";i:2;b:1;i:3;s:3:"MUL";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"flag";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"flag";i:1;s:11:"smallint(6)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:4:"cron";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:4:"cron";s:11:"primary_key";a:1:{s:2:"id";b:1;}s:5:"index";a:1:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:4:"cron";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:2:"id";}}}s:6:"column";a:9:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:10:"bigint(30)";i:2;b:0;i:3;s:3:"PRI";i:4;N;i:5;s:14:"auto_increment";i:6;s:0:"";}}s:7:"minutes";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"minutes";i:1;s:11:"varchar(30)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:5:"hours";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:5:"hours";i:1;s:11:"varchar(30)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"mday";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"mday";i:1;s:11:"varchar(30)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:3:"mon";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:3:"mon";i:1;s:11:"varchar(30)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"wday";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"wday";i:1;s:11:"varchar(30)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:6:"script";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:6:"script";i:1;s:12:"varchar(100)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:6:"params";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:6:"params";i:1;s:12:"varchar(200)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:8:"last_run";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"last_run";i:1;s:10:"bigint(30)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:10:"discussion";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:10:"discussion";s:11:"primary_key";a:1:{s:2:"id";b:1;}s:5:"index";a:2:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:10:"discussion";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:2:"id";}}s:12:"item_id_date";O:17:"AA_Metabase_Index":4:{s:1:"t";s:10:"discussion";s:1:"n";s:12:"item_id_date";s:1:"s";s:1:"I";s:1:"c";a:2:{i:1;s:7:"item_id";i:2;s:4:"date";}}}s:6:"column";a:15:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:3:"PRI";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:6:"parent";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:6:"parent";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:7:"item_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"item_id";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:3:"MUL";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:4:"date";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"date";i:1;s:10:"bigint(20)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:7:"subject";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"subject";i:1;s:4:"text";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:6:"author";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:6:"author";i:1;s:12:"varchar(255)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:6:"e_mail";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:6:"e_mail";i:1;s:11:"varchar(80)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"body";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"body";i:1;s:4:"text";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:5:"state";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:5:"state";i:1;s:7:"int(11)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:4:"flag";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"flag";i:1;s:7:"int(11)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:11:"url_address";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"url_address";i:1;s:12:"varchar(255)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:15:"url_description";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:15:"url_description";i:1;s:4:"text";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:11:"remote_addr";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"remote_addr";i:1;s:12:"varchar(255)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:5:"free1";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:5:"free1";i:1;s:4:"text";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:5:"free2";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:5:"free2";i:1;s:4:"text";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:13:"ef_categories";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:13:"ef_categories";s:11:"primary_key";a:2:{s:11:"category_id";b:1;s:7:"feed_id";b:1;}s:5:"index";a:1:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:13:"ef_categories";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:2:{i:1;s:11:"category_id";i:2;s:7:"feed_id";}}}s:6:"column";a:6:{s:8:"category";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"category";i:1;s:12:"varchar(255)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:13:"category_name";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:13:"category_name";i:1;s:12:"varchar(255)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:11:"category_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"category_id";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:3:"PRI";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:7:"feed_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"feed_id";i:1;s:7:"int(11)";i:2;b:0;i:3;s:3:"PRI";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:18:"target_category_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:18:"target_category_id";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:8:"approved";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"approved";i:1;s:7:"int(11)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:14:"ef_permissions";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:14:"ef_permissions";s:11:"primary_key";a:3:{s:8:"slice_id";b:1;s:4:"node";b:1;s:4:"user";b:1;}s:5:"index";a:1:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:14:"ef_permissions";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:3:{i:1;s:8:"slice_id";i:2;s:4:"node";i:3;s:4:"user";}}}s:6:"column";a:3:{s:8:"slice_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"slice_id";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:3:"PRI";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:4:"node";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"node";i:1;s:12:"varchar(150)";i:2;b:0;i:3;s:3:"PRI";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:4:"user";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"user";i:1;s:11:"varchar(50)";i:2;b:0;i:3;s:3:"PRI";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:5:"email";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:5:"email";s:11:"primary_key";a:1:{s:2:"id";b:1;}s:5:"index";a:1:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:5:"email";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:2:"id";}}}s:6:"column";a:12:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:7:"int(11)";i:2;b:0;i:3;s:3:"PRI";i:4;N;i:5;s:14:"auto_increment";i:6;s:0:"";}}s:11:"description";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"description";i:1;s:12:"varchar(255)";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:7:"subject";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"subject";i:1;s:4:"text";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"body";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"body";i:1;s:4:"text";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:11:"header_from";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"header_from";i:1;s:4:"text";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:8:"reply_to";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"reply_to";i:1;s:4:"text";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:9:"errors_to";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"errors_to";i:1;s:4:"text";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:6:"sender";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:6:"sender";i:1;s:4:"text";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"lang";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"lang";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:0:"";i:4;s:2:"en";i:5;s:0:"";i:6;s:0:"";}}s:15:"owner_module_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:15:"owner_module_id";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"html";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"html";i:1;s:11:"smallint(1)";i:2;b:0;i:3;s:0:"";i:4;s:1:"1";i:5;s:0:"";i:6;s:0:"";}}s:4:"type";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"type";i:1;s:11:"varchar(20)";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:12:"email_notify";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:12:"email_notify";s:11:"primary_key";a:3:{s:8:"slice_id";b:1;s:3:"uid";b:1;s:8:"function";b:1;}s:5:"index";a:1:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:12:"email_notify";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:3:{i:1;s:8:"slice_id";i:2;s:3:"uid";i:3;s:8:"function";}}}s:6:"column";a:3:{s:8:"slice_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"slice_id";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:3:"PRI";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:3:"uid";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:3:"uid";i:1;s:8:"char(60)";i:2;b:0;i:3;s:3:"PRI";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:8:"function";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"function";i:1;s:11:"smallint(5)";i:2;b:0;i:3;s:3:"PRI";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:5:"event";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:5:"event";s:11:"primary_key";a:1:{s:2:"id";b:1;}s:5:"index";a:3:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:5:"event";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:2:"id";}}s:10:"type_class";O:17:"AA_Metabase_Index":4:{s:1:"t";s:5:"event";s:1:"n";s:10:"type_class";s:1:"s";s:1:"I";s:1:"c";a:2:{i:1;s:4:"type";i:2;s:5:"class";}}s:13:"type_selector";O:17:"AA_Metabase_Index":4:{s:1:"t";s:5:"event";s:1:"n";s:13:"type_selector";s:1:"s";s:1:"I";s:1:"c";a:2:{i:1;s:4:"type";i:2;a:2:{i:0;s:8:"selector";i:1;s:2:"32";}}}}s:6:"column";a:6:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:13:"varbinary(32)";i:2;b:0;i:3;s:3:"PRI";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:4:"type";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"type";i:1;s:11:"varchar(32)";i:2;b:0;i:3;s:3:"MUL";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:5:"class";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:5:"class";i:1;s:11:"varchar(32)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:8:"selector";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"selector";i:1;s:12:"varchar(255)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:8:"reaction";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"reaction";i:1;s:11:"varchar(50)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:6:"params";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:6:"params";i:1;s:4:"text";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:14:"external_feeds";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:14:"external_feeds";s:11:"primary_key";a:1:{s:7:"feed_id";b:1;}s:5:"index";a:1:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:14:"external_feeds";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:7:"feed_id";}}}s:6:"column";a:8:{s:7:"feed_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"feed_id";i:1;s:7:"int(11)";i:2;b:0;i:3;s:3:"PRI";i:4;N;i:5;s:14:"auto_increment";i:6;s:0:"";}}s:8:"slice_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"slice_id";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:9:"node_name";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"node_name";i:1;s:12:"varchar(150)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:15:"remote_slice_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:15:"remote_slice_id";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:7:"user_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"user_id";i:1;s:12:"varchar(200)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:11:"newest_item";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"newest_item";i:1;s:11:"varchar(40)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:17:"remote_slice_name";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:17:"remote_slice_name";i:1;s:12:"varchar(200)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:9:"feed_mode";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"feed_mode";i:1;s:11:"varchar(10)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:7:"feedmap";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:7:"feedmap";s:11:"primary_key";a:0:{}s:5:"index";a:1:{s:13:"from_slice_id";O:17:"AA_Metabase_Index":4:{s:1:"t";s:7:"feedmap";s:1:"n";s:13:"from_slice_id";s:1:"s";s:1:"I";s:1:"c";a:2:{i:1;s:13:"from_slice_id";i:2;s:11:"to_slice_id";}}}s:6:"column";a:7:{s:13:"from_slice_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:13:"from_slice_id";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:3:"MUL";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:13:"from_field_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:13:"from_field_id";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:11:"to_slice_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"to_slice_id";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:11:"to_field_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"to_field_id";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:4:"flag";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"flag";i:1;s:7:"int(11)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:5:"value";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:5:"value";i:1;s:10:"mediumtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:15:"from_field_name";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:15:"from_field_name";i:1;s:12:"varchar(255)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:9:"feedperms";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:9:"feedperms";s:11:"primary_key";a:0:{}s:5:"index";a:2:{s:7:"from_id";O:17:"AA_Metabase_Index":4:{s:1:"t";s:9:"feedperms";s:1:"n";s:7:"from_id";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:7:"from_id";}}s:5:"to_id";O:17:"AA_Metabase_Index":4:{s:1:"t";s:9:"feedperms";s:1:"n";s:5:"to_id";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:5:"to_id";}}}s:6:"column";a:3:{s:7:"from_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"from_id";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:3:"MUL";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:5:"to_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:5:"to_id";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:3:"MUL";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:4:"flag";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"flag";i:1;s:7:"int(11)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:5:"feeds";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:5:"feeds";s:11:"primary_key";a:0:{}s:5:"index";a:1:{s:7:"from_id";O:17:"AA_Metabase_Index":4:{s:1:"t";s:5:"feeds";s:1:"n";s:7:"from_id";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:7:"from_id";}}}s:6:"column";a:6:{s:7:"from_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"from_id";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:3:"MUL";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:5:"to_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:5:"to_id";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:11:"category_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"category_id";i:1;s:13:"varbinary(16)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:14:"all_categories";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:14:"all_categories";i:1;s:11:"smallint(5)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:11:"to_approved";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"to_approved";i:1;s:11:"smallint(5)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:14:"to_category_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:14:"to_category_id";i:1;s:13:"varbinary(16)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:5:"field";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:5:"field";s:11:"primary_key";a:2:{s:2:"id";b:1;s:8:"slice_id";b:1;}s:5:"index";a:1:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:5:"field";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:2:{i:1;s:8:"slice_id";i:2;s:2:"id";}}}s:6:"column";a:40:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:3:"PRI";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:4:"type";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"type";i:1;s:11:"varchar(16)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:8:"slice_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"slice_id";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:3:"PRI";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:4:"name";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"name";i:1;s:12:"varchar(255)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:9:"input_pri";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"input_pri";i:1;s:11:"smallint(5)";i:2;b:0;i:3;s:0:"";i:4;s:3:"100";i:5;s:0:"";i:6;s:0:"";}}s:10:"input_help";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:10:"input_help";i:1;s:12:"varchar(255)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:13:"input_morehlp";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:13:"input_morehlp";i:1;s:4:"text";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:13:"input_default";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:13:"input_default";i:1;s:10:"mediumtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:8:"required";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"required";i:1;s:11:"smallint(5)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"feed";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"feed";i:1;s:11:"smallint(5)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:8:"multiple";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"multiple";i:1;s:11:"smallint(5)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:15:"input_show_func";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:15:"input_show_func";i:1;s:4:"text";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:10:"content_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:10:"content_id";i:1;s:13:"varbinary(16)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:10:"search_pri";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:10:"search_pri";i:1;s:11:"smallint(5)";i:2;b:0;i:3;s:0:"";i:4;s:3:"100";i:5;s:0:"";i:6;s:0:"";}}s:11:"search_type";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"search_type";i:1;s:11:"varchar(16)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:11:"search_help";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"search_help";i:1;s:12:"varchar(255)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:13:"search_before";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:13:"search_before";i:1;s:4:"text";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:16:"search_more_help";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:16:"search_more_help";i:1;s:4:"text";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:11:"search_show";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"search_show";i:1;s:11:"smallint(5)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:14:"search_ft_show";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:14:"search_ft_show";i:1;s:11:"smallint(5)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:17:"search_ft_default";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:17:"search_ft_default";i:1;s:11:"smallint(5)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:6:"alias1";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:6:"alias1";i:1;s:11:"varchar(10)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:11:"alias1_func";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"alias1_func";i:1;s:4:"text";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:11:"alias1_help";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"alias1_help";i:1;s:12:"varchar(255)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:6:"alias2";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:6:"alias2";i:1;s:11:"varchar(10)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:11:"alias2_func";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"alias2_func";i:1;s:4:"text";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:11:"alias2_help";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"alias2_help";i:1;s:12:"varchar(255)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:6:"alias3";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:6:"alias3";i:1;s:11:"varchar(10)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:11:"alias3_func";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"alias3_func";i:1;s:4:"text";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:11:"alias3_help";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"alias3_help";i:1;s:12:"varchar(255)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:12:"input_before";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:12:"input_before";i:1;s:4:"text";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:9:"aditional";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"aditional";i:1;s:4:"text";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:12:"content_edit";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:12:"content_edit";i:1;s:11:"smallint(5)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:12:"html_default";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:12:"html_default";i:1;s:11:"smallint(5)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:9:"html_show";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"html_show";i:1;s:11:"smallint(5)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:11:"in_item_tbl";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"in_item_tbl";i:1;s:11:"varchar(16)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:14:"input_validate";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:14:"input_validate";i:1;s:12:"varchar(255)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:17:"input_insert_func";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:17:"input_insert_func";i:1;s:12:"varchar(255)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:10:"input_show";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:10:"input_show";i:1;s:11:"smallint(5)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:11:"text_stored";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"text_stored";i:1;s:11:"smallint(5)";i:2;b:1;i:3;s:0:"";i:4;s:1:"1";i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:6:"groups";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:6:"groups";s:11:"primary_key";a:1:{s:4:"name";b:1;}s:5:"index";a:1:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:6:"groups";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:4:"name";}}}s:6:"column";a:2:{s:4:"name";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"name";i:1;s:11:"varchar(32)";i:2;b:0;i:3;s:3:"PRI";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:11:"description";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"description";i:1;s:12:"varchar(255)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:11:"hit_archive";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:11:"hit_archive";s:11:"primary_key";a:0:{}s:5:"index";a:2:{s:4:"time";O:17:"AA_Metabase_Index":4:{s:1:"t";s:11:"hit_archive";s:1:"n";s:4:"time";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:4:"time";}}s:2:"id";O:17:"AA_Metabase_Index":4:{s:1:"t";s:11:"hit_archive";s:1:"n";s:2:"id";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:2:"id";}}}s:6:"column";a:3:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:7:"int(11)";i:2;b:0;i:3;s:3:"MUL";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"time";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"time";i:1;s:7:"int(11)";i:2;b:0;i:3;s:3:"MUL";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"hits";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"hits";i:1;s:12:"mediumint(9)";i:2;b:0;i:3;s:0:"";i:4;s:1:"1";i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:11:"hit_long_id";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:11:"hit_long_id";s:11:"primary_key";a:0:{}s:5:"index";a:1:{s:4:"time";O:17:"AA_Metabase_Index":4:{s:1:"t";s:11:"hit_long_id";s:1:"n";s:4:"time";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:4:"time";}}}s:6:"column";a:4:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:10:"binary(16)";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"time";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"time";i:1;s:7:"int(11)";i:2;b:0;i:3;s:3:"MUL";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:5:"agent";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:5:"agent";i:1;s:12:"varchar(255)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"info";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"info";i:1;s:12:"varchar(255)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:12:"hit_short_id";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:12:"hit_short_id";s:11:"primary_key";a:0:{}s:5:"index";a:1:{s:4:"time";O:17:"AA_Metabase_Index":4:{s:1:"t";s:12:"hit_short_id";s:1:"n";s:4:"time";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:4:"time";}}}s:6:"column";a:4:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:7:"int(11)";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"time";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"time";i:1;s:7:"int(11)";i:2;b:0;i:3;s:3:"MUL";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:5:"agent";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:5:"agent";i:1;s:12:"varchar(255)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"info";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"info";i:1;s:12:"varchar(255)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:4:"item";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:4:"item";s:11:"primary_key";a:1:{s:2:"id";b:1;}s:5:"index";a:5:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:4:"item";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:2:"id";}}s:8:"short_id";O:17:"AA_Metabase_Index":4:{s:1:"t";s:4:"item";s:1:"n";s:8:"short_id";s:1:"s";s:1:"U";s:1:"c";a:1:{i:1;s:8:"short_id";}}s:11:"expiry_date";O:17:"AA_Metabase_Index":4:{s:1:"t";s:4:"item";s:1:"n";s:11:"expiry_date";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:11:"expiry_date";}}s:12:"publish_date";O:17:"AA_Metabase_Index":4:{s:1:"t";s:4:"item";s:1:"n";s:12:"publish_date";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:12:"publish_date";}}s:10:"slice_id_2";O:17:"AA_Metabase_Index":4:{s:1:"t";s:4:"item";s:1:"n";s:10:"slice_id_2";s:1:"s";s:1:"I";s:1:"c";a:3:{i:1;s:8:"slice_id";i:2;s:11:"status_code";i:3;s:12:"publish_date";}}}s:6:"column";a:17:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:3:"PRI";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:8:"short_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"short_id";i:1;s:7:"int(11)";i:2;b:0;i:3;s:3:"UNI";i:4;N;i:5;s:14:"auto_increment";i:6;s:0:"";}}s:8:"slice_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"slice_id";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:3:"MUL";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:11:"status_code";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"status_code";i:1;s:11:"smallint(5)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:9:"post_date";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"post_date";i:1;s:10:"bigint(20)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:12:"publish_date";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:12:"publish_date";i:1;s:10:"bigint(20)";i:2;b:1;i:3;s:3:"MUL";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:11:"expiry_date";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"expiry_date";i:1;s:10:"bigint(20)";i:2;b:1;i:3;s:3:"MUL";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:9:"highlight";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"highlight";i:1;s:11:"smallint(5)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:9:"posted_by";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"posted_by";i:1;s:8:"char(60)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:9:"edited_by";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"edited_by";i:1;s:8:"char(60)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:9:"last_edit";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"last_edit";i:1;s:10:"bigint(20)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:13:"display_count";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:13:"display_count";i:1;s:7:"int(11)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:5:"flags";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:5:"flags";i:1;s:8:"char(30)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:10:"disc_count";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:10:"disc_count";i:1;s:7:"int(11)";i:2;b:1;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:8:"disc_app";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"disc_app";i:1;s:7:"int(11)";i:2;b:1;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:14:"externally_fed";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:14:"externally_fed";i:1;s:9:"char(150)";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:12:"moved2active";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:12:"moved2active";i:1;s:7:"int(10)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:4:"jump";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:4:"jump";s:11:"primary_key";a:1:{s:8:"slice_id";b:1;}s:5:"index";a:1:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:4:"jump";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:8:"slice_id";}}}s:6:"column";a:3:{s:8:"slice_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"slice_id";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:3:"PRI";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:11:"destination";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"destination";i:1;s:12:"varchar(255)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:13:"dest_slice_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:13:"dest_slice_id";i:1;s:13:"varbinary(16)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:5:"links";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:5:"links";s:11:"primary_key";a:1:{s:2:"id";b:1;}s:5:"index";a:1:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:5:"links";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:2:"id";}}}s:6:"column";a:6:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:3:"PRI";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:8:"start_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"start_id";i:1;s:7:"int(10)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:10:"tree_start";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:10:"tree_start";i:1;s:7:"int(11)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:12:"select_start";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:12:"select_start";i:1;s:7:"int(11)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:16:"default_cat_tmpl";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:16:"default_cat_tmpl";i:1;s:8:"char(60)";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:9:"link_tmpl";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"link_tmpl";i:1;s:8:"char(60)";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:13:"links_cat_cat";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:13:"links_cat_cat";s:11:"primary_key";a:1:{s:4:"a_id";b:1;}s:5:"index";a:3:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:13:"links_cat_cat";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:4:"a_id";}}s:7:"what_id";O:17:"AA_Metabase_Index":4:{s:1:"t";s:13:"links_cat_cat";s:1:"n";s:7:"what_id";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:7:"what_id";}}s:11:"category_id";O:17:"AA_Metabase_Index":4:{s:1:"t";s:13:"links_cat_cat";s:1:"n";s:11:"category_id";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:11:"category_id";}}}s:6:"column";a:8:{s:11:"category_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"category_id";i:1;s:16:"int(10) unsigned";i:2;b:0;i:3;s:3:"MUL";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:7:"what_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"what_id";i:1;s:16:"int(10) unsigned";i:2;b:0;i:3;s:3:"MUL";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:4:"base";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"base";i:1;s:13:"enum(\'n\',\'y\')";i:2;b:0;i:3;s:0:"";i:4;s:1:"y";i:5;s:0:"";i:6;s:0:"";}}s:5:"state";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:5:"state";i:1;s:36:"enum(\'hidden\',\'highlight\',\'visible\')";i:2;b:0;i:3;s:0:"";i:4;s:7:"visible";i:5;s:0:"";i:6;s:0:"";}}s:8:"proposal";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"proposal";i:1;s:13:"enum(\'n\',\'y\')";i:2;b:0;i:3;s:0:"";i:4;s:1:"n";i:5;s:0:"";i:6;s:0:"";}}s:8:"priority";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"priority";i:1;s:11:"float(10,2)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:15:"proposal_delete";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:15:"proposal_delete";i:1;s:13:"enum(\'n\',\'y\')";i:2;b:0;i:3;s:0:"";i:4;s:1:"n";i:5;s:0:"";i:6;s:0:"";}}s:4:"a_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"a_id";i:1;s:16:"int(10) unsigned";i:2;b:0;i:3;s:3:"PRI";i:4;N;i:5;s:14:"auto_increment";i:6;s:0:"";}}}s:5:"flags";N;}s:16:"links_categories";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:16:"links_categories";s:11:"primary_key";a:1:{s:2:"id";b:1;}s:5:"index";a:3:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:16:"links_categories";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:2:"id";}}s:4:"path";O:17:"AA_Metabase_Index":4:{s:1:"t";s:16:"links_categories";s:1:"n";s:4:"path";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:4:"path";}}s:2:"id";O:17:"AA_Metabase_Index":4:{s:1:"t";s:16:"links_categories";s:1:"n";s:2:"id";s:1:"s";s:1:"I";s:1:"c";a:2:{i:1;s:2:"id";i:2;s:4:"path";}}}s:6:"column";a:13:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:16:"int(10) unsigned";i:2;b:0;i:3;s:3:"PRI";i:4;N;i:5;s:14:"auto_increment";i:6;s:0:"";}}s:4:"name";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"name";i:1;s:12:"varchar(255)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:13:"html_template";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:13:"html_template";i:1;s:12:"varchar(255)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:7:"deleted";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"deleted";i:1;s:13:"enum(\'n\',\'y\')";i:2;b:0;i:3;s:0:"";i:4;s:1:"n";i:5;s:0:"";i:6;s:0:"";}}s:4:"path";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"path";i:1;s:12:"varchar(255)";i:2;b:1;i:3;s:3:"MUL";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:9:"inc_file1";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"inc_file1";i:1;s:12:"varchar(255)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:10:"link_count";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:10:"link_count";i:1;s:12:"mediumint(9)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:9:"inc_file2";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"inc_file2";i:1;s:12:"varchar(255)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:11:"banner_file";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"banner_file";i:1;s:12:"varchar(255)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:11:"description";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"description";i:1;s:4:"text";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:10:"additional";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:10:"additional";i:1;s:4:"text";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"note";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"note";i:1;s:4:"text";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:7:"nolinks";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"nolinks";i:1;s:10:"tinyint(4)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:13:"links_changes";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:13:"links_changes";s:11:"primary_key";a:0:{}s:5:"index";a:3:{s:16:"proposal_link_id";O:17:"AA_Metabase_Index":4:{s:1:"t";s:13:"links_changes";s:1:"n";s:16:"proposal_link_id";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:16:"proposal_link_id";}}s:8:"rejected";O:17:"AA_Metabase_Index":4:{s:1:"t";s:13:"links_changes";s:1:"n";s:8:"rejected";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:8:"rejected";}}s:15:"changed_link_id";O:17:"AA_Metabase_Index":4:{s:1:"t";s:13:"links_changes";s:1:"n";s:15:"changed_link_id";s:1:"s";s:1:"I";s:1:"c";a:2:{i:1;s:15:"changed_link_id";i:2;s:8:"rejected";}}}s:6:"column";a:3:{s:15:"changed_link_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:15:"changed_link_id";i:1;s:16:"int(10) unsigned";i:2;b:0;i:3;s:3:"MUL";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:16:"proposal_link_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:16:"proposal_link_id";i:1;s:16:"int(10) unsigned";i:2;b:0;i:3;s:3:"MUL";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:8:"rejected";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"rejected";i:1;s:13:"enum(\'n\',\'y\')";i:2;b:0;i:3;s:3:"MUL";i:4;s:1:"n";i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:15:"links_languages";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:15:"links_languages";s:11:"primary_key";a:1:{s:2:"id";b:1;}s:5:"index";a:2:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:15:"links_languages";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:2:"id";}}s:4:"name";O:17:"AA_Metabase_Index":4:{s:1:"t";s:15:"links_languages";s:1:"n";s:4:"name";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:4:"name";}}}s:6:"column";a:3:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:16:"int(10) unsigned";i:2;b:0;i:3;s:3:"PRI";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:4:"name";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"name";i:1;s:11:"varchar(20)";i:2;b:0;i:3;s:3:"MUL";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:10:"short_name";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:10:"short_name";i:1;s:10:"varchar(5)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:14:"links_link_cat";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:14:"links_link_cat";s:11:"primary_key";a:1:{s:4:"a_id";b:1;}s:5:"index";a:4:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:14:"links_link_cat";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:4:"a_id";}}s:8:"proposal";O:17:"AA_Metabase_Index":4:{s:1:"t";s:14:"links_link_cat";s:1:"n";s:8:"proposal";s:1:"s";s:1:"I";s:1:"c";a:3:{i:1;s:8:"proposal";i:2;s:4:"base";i:3;s:5:"state";}}s:11:"category_id";O:17:"AA_Metabase_Index":4:{s:1:"t";s:14:"links_link_cat";s:1:"n";s:11:"category_id";s:1:"s";s:1:"I";s:1:"c";a:4:{i:1;s:11:"category_id";i:2;s:8:"proposal";i:3;s:4:"base";i:4;s:5:"state";}}s:7:"what_id";O:17:"AA_Metabase_Index":4:{s:1:"t";s:14:"links_link_cat";s:1:"n";s:7:"what_id";s:1:"s";s:1:"I";s:1:"c";a:4:{i:1;s:7:"what_id";i:2;s:8:"proposal";i:3;s:4:"base";i:4;s:5:"state";}}}s:6:"column";a:8:{s:11:"category_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"category_id";i:1;s:16:"int(10) unsigned";i:2;b:0;i:3;s:3:"MUL";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:7:"what_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"what_id";i:1;s:16:"int(10) unsigned";i:2;b:0;i:3;s:3:"MUL";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:4:"base";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"base";i:1;s:13:"enum(\'n\',\'y\')";i:2;b:0;i:3;s:0:"";i:4;s:1:"y";i:5;s:0:"";i:6;s:0:"";}}s:5:"state";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:5:"state";i:1;s:36:"enum(\'hidden\',\'highlight\',\'visible\')";i:2;b:0;i:3;s:0:"";i:4;s:7:"visible";i:5;s:0:"";i:6;s:0:"";}}s:8:"proposal";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"proposal";i:1;s:13:"enum(\'n\',\'y\')";i:2;b:0;i:3;s:3:"MUL";i:4;s:1:"n";i:5;s:0:"";i:6;s:0:"";}}s:8:"priority";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"priority";i:1;s:11:"float(10,2)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:15:"proposal_delete";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:15:"proposal_delete";i:1;s:13:"enum(\'n\',\'y\')";i:2;b:0;i:3;s:0:"";i:4;s:1:"n";i:5;s:0:"";i:6;s:0:"";}}s:4:"a_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"a_id";i:1;s:16:"int(10) unsigned";i:2;b:0;i:3;s:3:"PRI";i:4;N;i:5;s:14:"auto_increment";i:6;s:0:"";}}}s:5:"flags";N;}s:15:"links_link_lang";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:15:"links_link_lang";s:11:"primary_key";a:0:{}s:5:"index";a:1:{s:7:"link_id";O:17:"AA_Metabase_Index":4:{s:1:"t";s:15:"links_link_lang";s:1:"n";s:7:"link_id";s:1:"s";s:1:"I";s:1:"c";a:2:{i:1;s:7:"link_id";i:2;s:7:"lang_id";}}}s:6:"column";a:2:{s:7:"link_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"link_id";i:1;s:16:"int(10) unsigned";i:2;b:0;i:3;s:3:"MUL";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:7:"lang_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"lang_id";i:1;s:16:"int(10) unsigned";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:14:"links_link_reg";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:14:"links_link_reg";s:11:"primary_key";a:0:{}s:5:"index";a:1:{s:7:"link_id";O:17:"AA_Metabase_Index":4:{s:1:"t";s:14:"links_link_reg";s:1:"n";s:7:"link_id";s:1:"s";s:1:"I";s:1:"c";a:2:{i:1;s:7:"link_id";i:2;s:9:"region_id";}}}s:6:"column";a:2:{s:7:"link_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"link_id";i:1;s:16:"int(10) unsigned";i:2;b:0;i:3;s:3:"MUL";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:9:"region_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"region_id";i:1;s:16:"int(10) unsigned";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:11:"links_links";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:11:"links_links";s:11:"primary_key";a:1:{s:2:"id";b:1;}s:5:"index";a:8:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:11:"links_links";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:2:"id";}}s:7:"checked";O:17:"AA_Metabase_Index":4:{s:1:"t";s:11:"links_links";s:1:"n";s:7:"checked";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:7:"checked";}}s:4:"type";O:17:"AA_Metabase_Index":4:{s:1:"t";s:11:"links_links";s:1:"n";s:4:"type";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:4:"type";}}s:9:"validated";O:17:"AA_Metabase_Index":4:{s:1:"t";s:11:"links_links";s:1:"n";s:9:"validated";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:9:"validated";}}s:10:"valid_rank";O:17:"AA_Metabase_Index":4:{s:1:"t";s:11:"links_links";s:1:"n";s:10:"valid_rank";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:10:"valid_rank";}}s:4:"name";O:17:"AA_Metabase_Index":4:{s:1:"t";s:11:"links_links";s:1:"n";s:4:"name";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:4:"name";}}s:2:"id";O:17:"AA_Metabase_Index":4:{s:1:"t";s:11:"links_links";s:1:"n";s:2:"id";s:1:"s";s:1:"I";s:1:"c";a:2:{i:1;s:2:"id";i:2;s:6:"folder";}}s:6:"folder";O:17:"AA_Metabase_Index":4:{s:1:"t";s:11:"links_links";s:1:"n";s:6:"folder";s:1:"s";s:1:"I";s:1:"c";a:2:{i:1;s:6:"folder";i:2;s:2:"id";}}}s:6:"column";a:29:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:16:"int(10) unsigned";i:2;b:0;i:3;s:3:"PRI";i:4;N;i:5;s:14:"auto_increment";i:6;s:0:"";}}s:4:"name";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"name";i:1;s:12:"varchar(255)";i:2;b:1;i:3;s:3:"MUL";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:11:"description";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"description";i:1;s:4:"text";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"rate";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"rate";i:1;s:7:"int(10)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:5:"votes";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:5:"votes";i:1;s:7:"int(11)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:10:"plus_votes";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:10:"plus_votes";i:1;s:7:"int(11)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:10:"created_by";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:10:"created_by";i:1;s:11:"varchar(60)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:9:"edited_by";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"edited_by";i:1;s:11:"varchar(60)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:10:"checked_by";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:10:"checked_by";i:1;s:11:"varchar(60)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:9:"initiator";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"initiator";i:1;s:12:"varchar(255)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:3:"url";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:3:"url";i:1;s:4:"text";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:7:"created";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"created";i:1;s:7:"int(11)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:9:"last_edit";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"last_edit";i:1;s:7:"int(11)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:7:"checked";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"checked";i:1;s:7:"int(11)";i:2;b:0;i:3;s:3:"MUL";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:5:"voted";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:5:"voted";i:1;s:7:"int(11)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:4:"flag";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"flag";i:1;s:7:"int(11)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:13:"original_name";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:13:"original_name";i:1;s:12:"varchar(255)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"type";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"type";i:1;s:12:"varchar(120)";i:2;b:1;i:3;s:3:"MUL";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:8:"org_city";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"org_city";i:1;s:12:"varchar(255)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:13:"org_post_code";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:13:"org_post_code";i:1;s:11:"varchar(20)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:9:"org_phone";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"org_phone";i:1;s:12:"varchar(120)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:7:"org_fax";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"org_fax";i:1;s:12:"varchar(120)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:9:"org_email";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"org_email";i:1;s:12:"varchar(120)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:10:"org_street";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:10:"org_street";i:1;s:12:"varchar(255)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:6:"folder";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:6:"folder";i:1;s:7:"int(11)";i:2;b:0;i:3;s:3:"MUL";i:4;s:1:"1";i:5;s:0:"";i:6;s:0:"";}}s:4:"note";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"note";i:1;s:4:"text";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:9:"validated";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"validated";i:1;s:7:"int(11)";i:2;b:0;i:3;s:3:"MUL";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:11:"valid_codes";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"valid_codes";i:1;s:4:"text";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:10:"valid_rank";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:10:"valid_rank";i:1;s:7:"int(11)";i:2;b:0;i:3;s:3:"MUL";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:13:"links_regions";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:13:"links_regions";s:11:"primary_key";a:1:{s:2:"id";b:1;}s:5:"index";a:2:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:13:"links_regions";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:2:"id";}}s:4:"name";O:17:"AA_Metabase_Index":4:{s:1:"t";s:13:"links_regions";s:1:"n";s:4:"name";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:4:"name";}}}s:6:"column";a:3:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:16:"int(10) unsigned";i:2;b:0;i:3;s:3:"PRI";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:4:"name";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"name";i:1;s:11:"varchar(60)";i:2;b:0;i:3;s:3:"MUL";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:5:"level";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:5:"level";i:1;s:10:"tinyint(4)";i:2;b:0;i:3;s:0:"";i:4;s:1:"1";i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:3:"log";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:3:"log";s:11:"primary_key";a:1:{s:2:"id";b:1;}s:5:"index";a:3:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:3:"log";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:2:"id";}}s:4:"time";O:17:"AA_Metabase_Index":4:{s:1:"t";s:3:"log";s:1:"n";s:4:"time";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:4:"time";}}s:9:"type_time";O:17:"AA_Metabase_Index":4:{s:1:"t";s:3:"log";s:1:"n";s:9:"type_time";s:1:"s";s:1:"I";s:1:"c";a:2:{i:1;s:4:"type";i:2;s:4:"time";}}}s:6:"column";a:6:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:7:"int(11)";i:2;b:0;i:3;s:3:"PRI";i:4;N;i:5;s:14:"auto_increment";i:6;s:0:"";}}s:4:"time";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"time";i:1;s:10:"bigint(20)";i:2;b:0;i:3;s:3:"MUL";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:4:"user";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"user";i:1;s:11:"varchar(60)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"type";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"type";i:1;s:11:"varchar(10)";i:2;b:1;i:3;s:3:"MUL";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:8:"selector";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"selector";i:1;s:12:"varchar(255)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:6:"params";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:6:"params";i:1;s:12:"varchar(128)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:10:"membership";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:10:"membership";s:11:"primary_key";a:2:{s:7:"groupid";b:1;s:8:"memberid";b:1;}s:5:"index";a:2:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:10:"membership";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:2:{i:1;s:7:"groupid";i:2;s:8:"memberid";}}s:8:"memberid";O:17:"AA_Metabase_Index":4:{s:1:"t";s:10:"membership";s:1:"n";s:8:"memberid";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:8:"memberid";}}}s:6:"column";a:3:{s:7:"groupid";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"groupid";i:1;s:7:"int(11)";i:2;b:0;i:3;s:3:"PRI";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:8:"memberid";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"memberid";i:1;s:13:"varbinary(32)";i:2;b:0;i:3;s:3:"PRI";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:8:"last_mod";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"last_mod";i:1;s:9:"timestamp";i:2;b:0;i:3;s:0:"";i:4;s:17:"CURRENT_TIMESTAMP";i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:6:"module";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:6:"module";s:11:"primary_key";a:1:{s:2:"id";b:1;}s:5:"index";a:1:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:6:"module";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:2:"id";}}}s:6:"column";a:12:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:3:"PRI";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"name";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"name";i:1;s:9:"char(100)";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:7:"deleted";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"deleted";i:1;s:11:"smallint(5)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"type";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"type";i:1;s:8:"char(16)";i:2;b:1;i:3;s:0:"";i:4;s:1:"S";i:5;s:0:"";i:6;s:0:"";}}s:9:"slice_url";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"slice_url";i:1;s:9:"char(255)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:9:"lang_file";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"lang_file";i:1;s:8:"char(50)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:10:"created_at";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:10:"created_at";i:1;s:10:"bigint(20)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:10:"created_by";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:10:"created_by";i:1;s:9:"char(255)";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:5:"owner";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:5:"owner";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:6:"app_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:6:"app_id";i:1;s:13:"varbinary(16)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:8:"priority";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"priority";i:1;s:11:"smallint(6)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:4:"flag";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"flag";i:1;s:7:"int(11)";i:2;b:1;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:5:"nodes";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:5:"nodes";s:11:"primary_key";a:1:{s:4:"name";b:1;}s:5:"index";a:1:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:5:"nodes";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:4:"name";}}}s:6:"column";a:3:{s:4:"name";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"name";i:1;s:12:"varchar(150)";i:2;b:0;i:3;s:3:"PRI";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:10:"server_url";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:10:"server_url";i:1;s:12:"varchar(200)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:8:"password";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"password";i:1;s:11:"varchar(50)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:12:"object_float";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:12:"object_float";s:11:"primary_key";a:1:{s:2:"id";b:1;}s:5:"index";a:3:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:12:"object_float";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:2:"id";}}s:7:"item_id";O:17:"AA_Metabase_Index":4:{s:1:"t";s:12:"object_float";s:1:"n";s:7:"item_id";s:1:"s";s:1:"I";s:1:"c";a:3:{i:1;s:9:"object_id";i:2;s:8:"property";i:3;s:5:"value";}}s:8:"property";O:17:"AA_Metabase_Index":4:{s:1:"t";s:12:"object_float";s:1:"n";s:8:"property";s:1:"s";s:1:"I";s:1:"c";a:2:{i:1;s:8:"property";i:2;s:5:"value";}}}s:6:"column";a:6:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:10:"bigint(20)";i:2;b:0;i:3;s:3:"PRI";i:4;N;i:5;s:14:"auto_increment";i:6;s:0:"";}}s:9:"object_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"object_id";i:1;s:13:"varbinary(32)";i:2;b:0;i:3;s:3:"MUL";i:4;s:32:"                                ";i:5;s:0:"";i:6;s:0:"";}}s:8:"property";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"property";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:3:"MUL";i:4;s:16:"                ";i:5;s:0:"";i:6;s:0:"";}}s:8:"priority";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"priority";i:1;s:12:"smallint(20)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:5:"value";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:5:"value";i:1;s:6:"double";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"flag";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"flag";i:1;s:11:"smallint(6)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:14:"object_integer";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:14:"object_integer";s:11:"primary_key";a:1:{s:2:"id";b:1;}s:5:"index";a:3:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:14:"object_integer";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:2:"id";}}s:7:"item_id";O:17:"AA_Metabase_Index":4:{s:1:"t";s:14:"object_integer";s:1:"n";s:7:"item_id";s:1:"s";s:1:"I";s:1:"c";a:3:{i:1;s:9:"object_id";i:2;s:8:"property";i:3;s:5:"value";}}s:8:"property";O:17:"AA_Metabase_Index":4:{s:1:"t";s:14:"object_integer";s:1:"n";s:8:"property";s:1:"s";s:1:"I";s:1:"c";a:2:{i:1;s:8:"property";i:2;s:5:"value";}}}s:6:"column";a:6:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:10:"bigint(20)";i:2;b:0;i:3;s:3:"PRI";i:4;N;i:5;s:14:"auto_increment";i:6;s:0:"";}}s:9:"object_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"object_id";i:1;s:13:"varbinary(32)";i:2;b:0;i:3;s:3:"MUL";i:4;s:32:"                                ";i:5;s:0:"";i:6;s:0:"";}}s:8:"property";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"property";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:3:"MUL";i:4;s:16:"                ";i:5;s:0:"";i:6;s:0:"";}}s:8:"priority";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"priority";i:1;s:12:"smallint(20)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:5:"value";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:5:"value";i:1;s:10:"bigint(20)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"flag";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"flag";i:1;s:11:"smallint(6)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:11:"object_text";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:11:"object_text";s:11:"primary_key";a:1:{s:2:"id";b:1;}s:5:"index";a:3:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:11:"object_text";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:2:"id";}}s:9:"object_id";O:17:"AA_Metabase_Index":4:{s:1:"t";s:11:"object_text";s:1:"n";s:9:"object_id";s:1:"s";s:1:"I";s:1:"c";a:3:{i:1;s:9:"object_id";i:2;s:8:"property";i:3;a:2:{i:0;s:5:"value";i:1;s:2:"16";}}}s:8:"property";O:17:"AA_Metabase_Index":4:{s:1:"t";s:11:"object_text";s:1:"n";s:8:"property";s:1:"s";s:1:"I";s:1:"c";a:2:{i:1;s:8:"property";i:2;a:2:{i:0;s:5:"value";i:1;s:2:"10";}}}}s:6:"column";a:6:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:10:"bigint(20)";i:2;b:0;i:3;s:3:"PRI";i:4;N;i:5;s:14:"auto_increment";i:6;s:0:"";}}s:9:"object_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"object_id";i:1;s:13:"varbinary(32)";i:2;b:0;i:3;s:3:"MUL";i:4;s:32:"                                ";i:5;s:0:"";i:6;s:0:"";}}s:8:"property";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"property";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:3:"MUL";i:4;s:16:"                ";i:5;s:0:"";i:6;s:0:"";}}s:8:"priority";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"priority";i:1;s:12:"smallint(20)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:5:"value";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:5:"value";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"flag";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"flag";i:1;s:11:"smallint(6)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:7:"offline";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:7:"offline";s:11:"primary_key";a:1:{s:2:"id";b:1;}s:5:"index";a:2:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:7:"offline";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:2:"id";}}s:6:"digest";O:17:"AA_Metabase_Index":4:{s:1:"t";s:7:"offline";s:1:"n";s:6:"digest";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:6:"digest";}}}s:6:"column";a:3:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:3:"PRI";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:6:"digest";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:6:"digest";i:1;s:13:"varbinary(32)";i:2;b:0;i:3;s:3:"MUL";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:4:"flag";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"flag";i:1;s:7:"int(11)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:9:"pagecache";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:9:"pagecache";s:11:"primary_key";a:1:{s:2:"id";b:1;}s:5:"index";a:2:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:9:"pagecache";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:2:"id";}}s:6:"stored";O:17:"AA_Metabase_Index":4:{s:1:"t";s:9:"pagecache";s:1:"n";s:6:"stored";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:6:"stored";}}}s:6:"column";a:4:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:13:"varbinary(32)";i:2;b:0;i:3;s:3:"PRI";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:7:"content";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"content";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:6:"stored";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:6:"stored";i:1;s:10:"bigint(20)";i:2;b:0;i:3;s:3:"MUL";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:4:"flag";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"flag";i:1;s:7:"int(11)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:18:"pagecache_str2find";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:18:"pagecache_str2find";s:11:"primary_key";a:1:{s:2:"id";b:1;}s:5:"index";a:3:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:18:"pagecache_str2find";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:2:"id";}}s:8:"str2find";O:17:"AA_Metabase_Index":4:{s:1:"t";s:18:"pagecache_str2find";s:1:"n";s:8:"str2find";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;a:2:{i:0;s:8:"str2find";i:1;s:2:"20";}}}s:12:"pagecache_id";O:17:"AA_Metabase_Index":4:{s:1:"t";s:18:"pagecache_str2find";s:1:"n";s:12:"pagecache_id";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:12:"pagecache_id";}}}s:6:"column";a:3:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:10:"bigint(20)";i:2;b:0;i:3;s:3:"PRI";i:4;N;i:5;s:14:"auto_increment";i:6;s:0:"";}}s:12:"pagecache_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:12:"pagecache_id";i:1;s:13:"varbinary(32)";i:2;b:0;i:3;s:3:"MUL";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:8:"str2find";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"str2find";i:1;s:4:"text";i:2;b:0;i:3;s:3:"MUL";i:4;N;i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:5:"perms";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:5:"perms";s:11:"primary_key";a:3:{s:11:"object_type";b:1;s:8:"objectid";b:1;s:6:"userid";b:1;}s:5:"index";a:2:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:5:"perms";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:3:{i:1;s:8:"objectid";i:2;s:6:"userid";i:3;s:11:"object_type";}}s:6:"userid";O:17:"AA_Metabase_Index":4:{s:1:"t";s:5:"perms";s:1:"n";s:6:"userid";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:6:"userid";}}}s:6:"column";a:5:{s:11:"object_type";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"object_type";i:1;s:8:"char(30)";i:2;b:0;i:3;s:3:"PRI";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:8:"objectid";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"objectid";i:1;s:13:"varbinary(32)";i:2;b:0;i:3;s:3:"PRI";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:6:"userid";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:6:"userid";i:1;s:13:"varbinary(32)";i:2;b:0;i:3;s:3:"PRI";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:4:"perm";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"perm";i:1;s:13:"varbinary(32)";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:8:"last_mod";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"last_mod";i:1;s:9:"timestamp";i:2;b:0;i:3;s:0:"";i:4;s:17:"CURRENT_TIMESTAMP";i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:5:"polls";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:5:"polls";s:11:"primary_key";a:1:{s:2:"id";b:1;}s:5:"index";a:2:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:5:"polls";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:2:"id";}}s:2:"id";O:17:"AA_Metabase_Index":4:{s:1:"t";s:5:"polls";s:1:"n";s:2:"id";s:1:"s";s:1:"I";s:1:"c";a:3:{i:1;s:9:"module_id";i:2;s:11:"status_code";i:3;s:11:"expiry_date";}}}s:6:"column";a:15:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:13:"varbinary(32)";i:2;b:0;i:3;s:3:"PRI";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:9:"module_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"module_id";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:3:"MUL";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:11:"status_code";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"status_code";i:1;s:10:"tinyint(4)";i:2;b:0;i:3;s:0:"";i:4;s:1:"1";i:5;s:0:"";i:6;s:0:"";}}s:8:"headline";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"headline";i:1;s:4:"text";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:12:"publish_date";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:12:"publish_date";i:1;s:7:"int(11)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:11:"expiry_date";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"expiry_date";i:1;s:7:"int(11)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:6:"locked";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:6:"locked";i:1;s:10:"tinyint(4)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:7:"logging";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"logging";i:1;s:10:"tinyint(1)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:10:"ip_locking";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:10:"ip_locking";i:1;s:10:"tinyint(1)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:15:"ip_lock_timeout";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:15:"ip_lock_timeout";i:1;s:6:"int(4)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:11:"set_cookies";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"set_cookies";i:1;s:10:"tinyint(1)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:14:"cookies_prefix";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:14:"cookies_prefix";i:1;s:13:"varbinary(16)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:9:"design_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"design_id";i:1;s:13:"varbinary(32)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:19:"aftervote_design_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:19:"aftervote_design_id";i:1;s:13:"varbinary(32)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:6:"params";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:6:"params";i:1;s:4:"text";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:12:"polls_answer";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:12:"polls_answer";s:11:"primary_key";a:1:{s:2:"id";b:1;}s:5:"index";a:2:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:12:"polls_answer";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:2:"id";}}s:7:"poll_id";O:17:"AA_Metabase_Index":4:{s:1:"t";s:12:"polls_answer";s:1:"n";s:7:"poll_id";s:1:"s";s:1:"I";s:1:"c";a:2:{i:1;s:7:"poll_id";i:2;s:8:"priority";}}}s:6:"column";a:5:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:13:"varbinary(32)";i:2;b:0;i:3;s:3:"PRI";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:7:"poll_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"poll_id";i:1;s:13:"varbinary(32)";i:2;b:0;i:3;s:3:"MUL";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:6:"answer";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:6:"answer";i:1;s:4:"text";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:5:"votes";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:5:"votes";i:1;s:7:"int(11)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:8:"priority";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"priority";i:1;s:7:"int(11)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:12:"polls_design";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:12:"polls_design";s:11:"primary_key";a:1:{s:2:"id";b:1;}s:5:"index";a:2:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:12:"polls_design";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:2:"id";}}s:9:"module_id";O:17:"AA_Metabase_Index":4:{s:1:"t";s:12:"polls_design";s:1:"n";s:9:"module_id";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:9:"module_id";}}}s:6:"column";a:7:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:13:"varbinary(32)";i:2;b:0;i:3;s:3:"PRI";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:9:"module_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"module_id";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:3:"MUL";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"name";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"name";i:1;s:4:"text";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:7:"comment";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"comment";i:1;s:4:"text";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:3:"top";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:3:"top";i:1;s:4:"text";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:6:"answer";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:6:"answer";i:1;s:4:"text";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:6:"bottom";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:6:"bottom";i:1;s:4:"text";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:13:"polls_ip_lock";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:13:"polls_ip_lock";s:11:"primary_key";a:0:{}s:5:"index";a:2:{s:7:"poll_id";O:17:"AA_Metabase_Index":4:{s:1:"t";s:13:"polls_ip_lock";s:1:"n";s:7:"poll_id";s:1:"s";s:1:"I";s:1:"c";a:2:{i:1;s:7:"poll_id";i:2;s:9:"voters_ip";}}s:12:"poll_id_time";O:17:"AA_Metabase_Index":4:{s:1:"t";s:13:"polls_ip_lock";s:1:"n";s:12:"poll_id_time";s:1:"s";s:1:"I";s:1:"c";a:2:{i:1;s:7:"poll_id";i:2;s:9:"timestamp";}}}s:6:"column";a:3:{s:7:"poll_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"poll_id";i:1;s:13:"varbinary(32)";i:2;b:0;i:3;s:3:"MUL";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:9:"voters_ip";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"voters_ip";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:9:"timestamp";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"timestamp";i:1;s:7:"int(11)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:9:"polls_log";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:9:"polls_log";s:11:"primary_key";a:1:{s:2:"id";b:1;}s:5:"index";a:1:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:9:"polls_log";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:2:"id";}}}s:6:"column";a:4:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:7:"int(11)";i:2;b:0;i:3;s:3:"PRI";i:4;N;i:5;s:14:"auto_increment";i:6;s:0:"";}}s:9:"answer_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"answer_id";i:1;s:13:"varbinary(32)";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:9:"voters_ip";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"voters_ip";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:9:"timestamp";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"timestamp";i:1;s:7:"int(11)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:10:"post2shtml";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:10:"post2shtml";s:11:"primary_key";a:1:{s:2:"id";b:1;}s:5:"index";a:1:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:10:"post2shtml";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:2:"id";}}}s:6:"column";a:3:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:13:"varbinary(32)";i:2;b:0;i:3;s:3:"PRI";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:4:"vars";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"vars";i:1;s:4:"text";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"time";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"time";i:1;s:7:"int(11)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:7:"profile";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:7:"profile";s:11:"primary_key";a:1:{s:2:"id";b:1;}s:5:"index";a:2:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:7:"profile";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:2:"id";}}s:13:"slice_user_id";O:17:"AA_Metabase_Index":4:{s:1:"t";s:7:"profile";s:1:"n";s:13:"slice_user_id";s:1:"s";s:1:"I";s:1:"c";a:2:{i:1;s:8:"slice_id";i:2;s:3:"uid";}}}s:6:"column";a:6:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:7:"int(11)";i:2;b:0;i:3;s:3:"PRI";i:4;N;i:5;s:14:"auto_increment";i:6;s:0:"";}}s:8:"slice_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"slice_id";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:3:"MUL";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:3:"uid";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:3:"uid";i:1;s:11:"varchar(60)";i:2;b:0;i:3;s:0:"";i:4;s:1:"*";i:5;s:0:"";i:6;s:0:"";}}s:8:"property";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"property";i:1;s:11:"varchar(20)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:8:"selector";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"selector";i:1;s:12:"varchar(255)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:5:"value";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:5:"value";i:1;s:4:"text";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:8:"relation";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:8:"relation";s:11:"primary_key";a:0:{}s:5:"index";a:2:{s:9:"source_id";O:17:"AA_Metabase_Index":4:{s:1:"t";s:8:"relation";s:1:"n";s:9:"source_id";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:9:"source_id";}}s:14:"destination_id";O:17:"AA_Metabase_Index":4:{s:1:"t";s:8:"relation";s:1:"n";s:14:"destination_id";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:14:"destination_id";}}}s:6:"column";a:3:{s:9:"source_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"source_id";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:3:"MUL";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:14:"destination_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:14:"destination_id";i:1;s:13:"varbinary(32)";i:2;b:0;i:3;s:3:"MUL";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:4:"flag";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"flag";i:1;s:7:"int(11)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:8:"rssfeeds";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:8:"rssfeeds";s:11:"primary_key";a:1:{s:7:"feed_id";b:1;}s:5:"index";a:1:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:8:"rssfeeds";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:7:"feed_id";}}}s:6:"column";a:4:{s:7:"feed_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"feed_id";i:1;s:7:"int(11)";i:2;b:0;i:3;s:3:"PRI";i:4;N;i:5;s:14:"auto_increment";i:6;s:0:"";}}s:4:"name";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"name";i:1;s:12:"varchar(150)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:10:"server_url";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:10:"server_url";i:1;s:12:"varchar(200)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:8:"slice_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"slice_id";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:9:"searchlog";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:9:"searchlog";s:11:"primary_key";a:1:{s:2:"id";b:1;}s:5:"index";a:2:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:9:"searchlog";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:2:"id";}}s:4:"date";O:17:"AA_Metabase_Index":4:{s:1:"t";s:9:"searchlog";s:1:"n";s:4:"date";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:4:"date";}}}s:6:"column";a:7:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:7:"int(11)";i:2;b:0;i:3;s:3:"PRI";i:4;N;i:5;s:14:"auto_increment";i:6;s:0:"";}}s:4:"date";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"date";i:1;s:7:"int(14)";i:2;b:1;i:3;s:3:"MUL";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:5:"query";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:5:"query";i:1;s:4:"text";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:11:"found_count";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"found_count";i:1;s:7:"int(11)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:11:"search_time";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"search_time";i:1;s:7:"int(11)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"user";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"user";i:1;s:4:"text";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:11:"additional1";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"additional1";i:1;s:4:"text";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:4:"site";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:4:"site";s:11:"primary_key";a:1:{s:2:"id";b:1;}s:5:"index";a:1:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:4:"site";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:2:"id";}}}s:6:"column";a:4:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:3:"PRI";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:10:"state_file";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:10:"state_file";i:1;s:12:"varchar(255)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:9:"structure";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"structure";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"flag";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"flag";i:1;s:7:"int(11)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:9:"site_spot";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:9:"site_spot";s:11:"primary_key";a:1:{s:2:"id";b:1;}s:5:"index";a:2:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:9:"site_spot";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:2:"id";}}s:4:"spot";O:17:"AA_Metabase_Index":4:{s:1:"t";s:9:"site_spot";s:1:"n";s:4:"spot";s:1:"s";s:1:"I";s:1:"c";a:2:{i:1;s:7:"site_id";i:2;s:7:"spot_id";}}}s:6:"column";a:5:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:7:"int(11)";i:2;b:0;i:3;s:3:"PRI";i:4;N;i:5;s:14:"auto_increment";i:6;s:0:"";}}s:7:"spot_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"spot_id";i:1;s:7:"int(11)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:7:"site_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"site_id";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:3:"MUL";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:7:"content";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"content";i:1;s:8:"longtext";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"flag";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"flag";i:1;s:10:"bigint(20)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:5:"slice";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:5:"slice";s:11:"primary_key";a:1:{s:2:"id";b:1;}s:5:"index";a:2:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:5:"slice";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:2:"id";}}s:4:"type";O:17:"AA_Metabase_Index":4:{s:1:"t";s:5:"slice";s:1:"n";s:4:"type";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:4:"type";}}}s:6:"column";a:62:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:3:"PRI";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:4:"name";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"name";i:1;s:12:"varchar(100)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:5:"owner";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:5:"owner";i:1;s:11:"varchar(16)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:7:"deleted";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"deleted";i:1;s:11:"smallint(5)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:10:"created_by";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:10:"created_by";i:1;s:12:"varchar(255)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:10:"created_at";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:10:"created_at";i:1;s:10:"bigint(20)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:13:"export_to_all";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:13:"export_to_all";i:1;s:11:"smallint(5)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"type";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"type";i:1;s:13:"varbinary(16)";i:2;b:1;i:3;s:3:"MUL";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:8:"template";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"template";i:1;s:11:"smallint(5)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:19:"fulltext_format_top";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:19:"fulltext_format_top";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:15:"fulltext_format";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:15:"fulltext_format";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:22:"fulltext_format_bottom";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:22:"fulltext_format_bottom";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:14:"odd_row_format";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:14:"odd_row_format";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:15:"even_row_format";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:15:"even_row_format";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:15:"even_odd_differ";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:15:"even_odd_differ";i:1;s:11:"smallint(5)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:11:"compact_top";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"compact_top";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:14:"compact_bottom";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:14:"compact_bottom";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:12:"category_top";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:12:"category_top";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:15:"category_format";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:15:"category_format";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:15:"category_bottom";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:15:"category_bottom";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:13:"category_sort";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:13:"category_sort";i:1;s:11:"smallint(5)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:9:"slice_url";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"slice_url";i:1;s:12:"varchar(255)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:9:"d_listlen";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"d_listlen";i:1;s:11:"smallint(5)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:9:"lang_file";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"lang_file";i:1;s:11:"varchar(50)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:15:"fulltext_remove";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:15:"fulltext_remove";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:14:"compact_remove";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:14:"compact_remove";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:16:"email_sub_enable";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:16:"email_sub_enable";i:1;s:11:"smallint(5)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:16:"exclude_from_dir";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:16:"exclude_from_dir";i:1;s:11:"smallint(5)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:15:"notify_sh_offer";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:15:"notify_sh_offer";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:16:"notify_sh_accept";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:16:"notify_sh_accept";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:16:"notify_sh_remove";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:16:"notify_sh_remove";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:21:"notify_holding_item_s";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:21:"notify_holding_item_s";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:21:"notify_holding_item_b";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:21:"notify_holding_item_b";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:26:"notify_holding_item_edit_s";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:26:"notify_holding_item_edit_s";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:26:"notify_holding_item_edit_b";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:26:"notify_holding_item_edit_b";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:25:"notify_active_item_edit_s";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:25:"notify_active_item_edit_s";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:25:"notify_active_item_edit_b";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:25:"notify_active_item_edit_b";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:20:"notify_active_item_s";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:20:"notify_active_item_s";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:20:"notify_active_item_b";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:20:"notify_active_item_b";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:10:"noitem_msg";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:10:"noitem_msg";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:16:"admin_format_top";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:16:"admin_format_top";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:12:"admin_format";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:12:"admin_format";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:19:"admin_format_bottom";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:19:"admin_format_bottom";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:12:"admin_remove";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:12:"admin_remove";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:16:"admin_noitem_msg";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:16:"admin_noitem_msg";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:21:"permit_anonymous_post";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:21:"permit_anonymous_post";i:1;s:11:"smallint(5)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:21:"permit_anonymous_edit";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:21:"permit_anonymous_edit";i:1;s:11:"smallint(5)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:19:"permit_offline_fill";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:19:"permit_offline_fill";i:1;s:11:"smallint(5)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:9:"aditional";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"aditional";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"flag";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"flag";i:1;s:7:"int(11)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:3:"vid";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:3:"vid";i:1;s:7:"int(11)";i:2;b:1;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:12:"gb_direction";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:12:"gb_direction";i:1;s:10:"tinyint(4)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:8:"group_by";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"group_by";i:1;s:11:"varchar(16)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:9:"gb_header";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"gb_header";i:1;s:10:"tinyint(4)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:7:"gb_case";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"gb_case";i:1;s:11:"varchar(15)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:10:"javascript";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:10:"javascript";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:14:"fileman_access";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:14:"fileman_access";i:1;s:11:"varchar(20)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:11:"fileman_dir";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"fileman_dir";i:1;s:11:"varchar(50)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:16:"auth_field_group";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:16:"auth_field_group";i:1;s:11:"varchar(16)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:19:"mailman_field_lists";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:19:"mailman_field_lists";i:1;s:11:"varchar(16)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:16:"reading_password";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:16:"reading_password";i:1;s:12:"varchar(100)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:7:"mlxctrl";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"mlxctrl";i:1;s:13:"varbinary(32)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:11:"slice_owner";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:11:"slice_owner";s:11:"primary_key";a:1:{s:2:"id";b:1;}s:5:"index";a:1:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:11:"slice_owner";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:2:"id";}}}s:6:"column";a:3:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:3:"PRI";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"name";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"name";i:1;s:8:"char(80)";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:5:"email";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:5:"email";i:1;s:8:"char(80)";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:9:"toexecute";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:9:"toexecute";s:11:"primary_key";a:1:{s:2:"id";b:1;}s:5:"index";a:4:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:9:"toexecute";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:2:"id";}}s:4:"time";O:17:"AA_Metabase_Index":4:{s:1:"t";s:9:"toexecute";s:1:"n";s:4:"time";s:1:"s";s:1:"I";s:1:"c";a:2:{i:1;s:13:"execute_after";i:2;s:8:"priority";}}s:8:"priority";O:17:"AA_Metabase_Index":4:{s:1:"t";s:9:"toexecute";s:1:"n";s:8:"priority";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:8:"priority";}}s:8:"selector";O:17:"AA_Metabase_Index":4:{s:1:"t";s:9:"toexecute";s:1:"n";s:8:"selector";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:8:"selector";}}}s:6:"column";a:8:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:7:"int(11)";i:2;b:0;i:3;s:3:"PRI";i:4;N;i:5;s:14:"auto_increment";i:6;s:0:"";}}s:7:"created";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"created";i:1;s:10:"bigint(20)";i:2;b:0;i:3;s:0:"";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:13:"execute_after";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:13:"execute_after";i:1;s:10:"bigint(20)";i:2;b:0;i:3;s:3:"MUL";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:7:"aa_user";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"aa_user";i:1;s:11:"varchar(60)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:8:"priority";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"priority";i:1;s:7:"int(11)";i:2;b:0;i:3;s:3:"MUL";i:4;s:1:"0";i:5;s:0:"";i:6;s:0:"";}}s:8:"selector";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"selector";i:1;s:12:"varchar(255)";i:2;b:0;i:3;s:3:"MUL";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:6:"object";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:6:"object";i:1;s:8:"longtext";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:6:"params";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:6:"params";i:1;s:8:"longtext";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:5:"users";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:5:"users";s:11:"primary_key";a:1:{s:2:"id";b:1;}s:5:"index";a:5:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:5:"users";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:2:"id";}}s:4:"type";O:17:"AA_Metabase_Index":4:{s:1:"t";s:5:"users";s:1:"n";s:4:"type";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:4:"type";}}s:4:"mail";O:17:"AA_Metabase_Index":4:{s:1:"t";s:5:"users";s:1:"n";s:4:"mail";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:4:"mail";}}s:4:"name";O:17:"AA_Metabase_Index":4:{s:1:"t";s:5:"users";s:1:"n";s:4:"name";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:4:"name";}}s:2:"sn";O:17:"AA_Metabase_Index":4:{s:1:"t";s:5:"users";s:1:"n";s:2:"sn";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:2:"sn";}}}s:6:"column";a:10:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:7:"int(11)";i:2;b:0;i:3;s:3:"PRI";i:4;N;i:5;s:14:"auto_increment";i:6;s:0:"";}}s:4:"type";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"type";i:1;s:13:"varbinary(10)";i:2;b:0;i:3;s:3:"MUL";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:8:"password";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"password";i:1;s:14:"varbinary(255)";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:3:"uid";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:3:"uid";i:1;s:13:"varbinary(40)";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"mail";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"mail";i:1;s:8:"char(40)";i:2;b:0;i:3;s:3:"MUL";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"name";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"name";i:1;s:8:"char(80)";i:2;b:0;i:3;s:3:"MUL";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:11:"description";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"description";i:1;s:9:"char(255)";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:9:"givenname";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"givenname";i:1;s:8:"char(40)";i:2;b:0;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:2:"sn";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"sn";i:1;s:8:"char(40)";i:2;b:0;i:3;s:3:"MUL";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:8:"last_mod";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"last_mod";i:1;s:9:"timestamp";i:2;b:0;i:3;s:0:"";i:4;s:17:"CURRENT_TIMESTAMP";i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:4:"view";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:4:"view";s:11:"primary_key";a:1:{s:2:"id";b:1;}s:5:"index";a:2:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:4:"view";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:2:"id";}}s:8:"slice_id";O:17:"AA_Metabase_Index":4:{s:1:"t";s:4:"view";s:1:"n";s:8:"slice_id";s:1:"s";s:1:"I";s:1:"c";a:1:{i:1;s:8:"slice_id";}}}s:6:"column";a:52:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:16:"int(10) unsigned";i:2;b:0;i:3;s:3:"PRI";i:4;N;i:5;s:14:"auto_increment";i:6;s:0:"";}}s:8:"slice_id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"slice_id";i:1;s:13:"varbinary(16)";i:2;b:0;i:3;s:3:"MUL";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:4:"name";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"name";i:1;s:11:"varchar(50)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"type";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"type";i:1;s:11:"varchar(10)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:6:"before";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:6:"before";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"even";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"even";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:3:"odd";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:3:"odd";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:15:"even_odd_differ";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:15:"even_odd_differ";i:1;s:19:"tinyint(3) unsigned";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:13:"row_delimiter";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:13:"row_delimiter";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:5:"after";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:5:"after";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:13:"remove_string";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:13:"remove_string";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:11:"group_title";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"group_title";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:6:"order1";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:6:"order1";i:1;s:13:"varbinary(16)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:12:"o1_direction";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:12:"o1_direction";i:1;s:19:"tinyint(3) unsigned";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:6:"order2";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:6:"order2";i:1;s:13:"varbinary(16)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:12:"o2_direction";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:12:"o2_direction";i:1;s:19:"tinyint(3) unsigned";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:9:"group_by1";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"group_by1";i:1;s:13:"varbinary(16)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:12:"g1_direction";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:12:"g1_direction";i:1;s:19:"tinyint(3) unsigned";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:9:"gb_header";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"gb_header";i:1;s:10:"tinyint(4)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:9:"group_by2";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"group_by2";i:1;s:13:"varbinary(16)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:12:"g2_direction";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:12:"g2_direction";i:1;s:19:"tinyint(3) unsigned";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:10:"cond1field";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:10:"cond1field";i:1;s:13:"varbinary(16)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:7:"cond1op";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"cond1op";i:1;s:13:"varbinary(10)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:9:"cond1cond";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"cond1cond";i:1;s:12:"varchar(255)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:10:"cond2field";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:10:"cond2field";i:1;s:13:"varbinary(16)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:7:"cond2op";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"cond2op";i:1;s:13:"varbinary(10)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:9:"cond2cond";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"cond2cond";i:1;s:12:"varchar(255)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:10:"cond3field";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:10:"cond3field";i:1;s:13:"varbinary(16)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:7:"cond3op";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"cond3op";i:1;s:13:"varbinary(10)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:9:"cond3cond";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"cond3cond";i:1;s:12:"varchar(255)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:7:"listlen";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:7:"listlen";i:1;s:16:"int(10) unsigned";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:8:"scroller";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:8:"scroller";i:1;s:19:"tinyint(3) unsigned";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:13:"selected_item";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:13:"selected_item";i:1;s:19:"tinyint(3) unsigned";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:12:"modification";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:12:"modification";i:1;s:16:"int(10) unsigned";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:9:"parameter";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"parameter";i:1;s:12:"varchar(255)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"img1";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"img1";i:1;s:12:"varchar(255)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"img2";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"img2";i:1;s:12:"varchar(255)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"img3";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"img3";i:1;s:12:"varchar(255)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"img4";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"img4";i:1;s:12:"varchar(255)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:4:"flag";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:4:"flag";i:1;s:16:"int(10) unsigned";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:9:"aditional";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:9:"aditional";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:10:"aditional2";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:10:"aditional2";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:10:"aditional3";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:10:"aditional3";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:10:"aditional4";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:10:"aditional4";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:10:"aditional5";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:10:"aditional5";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:10:"aditional6";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:10:"aditional6";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:10:"noitem_msg";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:10:"noitem_msg";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:12:"group_bottom";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:12:"group_bottom";i:1;s:8:"longtext";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:6:"field1";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:6:"field1";i:1;s:13:"varbinary(16)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:6:"field2";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:6:"field2";i:1;s:13:"varbinary(16)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:6:"field3";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:6:"field3";i:1;s:13:"varbinary(16)";i:2;b:1;i:3;s:0:"";i:4;N;i:5;s:0:"";i:6;s:0:"";}}s:13:"calendar_type";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:13:"calendar_type";i:1;s:12:"varchar(100)";i:2;b:1;i:3;s:0:"";i:4;s:3:"mon";i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}s:15:"wizard_template";O:17:"AA_Metabase_Table":5:{s:9:"tablename";s:15:"wizard_template";s:11:"primary_key";a:1:{s:2:"id";b:1;}s:5:"index";a:2:{s:7:"PRIMARY";O:17:"AA_Metabase_Index":4:{s:1:"t";s:15:"wizard_template";s:1:"n";s:7:"PRIMARY";s:1:"s";s:1:"P";s:1:"c";a:1:{i:1;s:2:"id";}}s:3:"dir";O:17:"AA_Metabase_Index":4:{s:1:"t";s:15:"wizard_template";s:1:"n";s:3:"dir";s:1:"s";s:1:"U";s:1:"c";a:1:{i:1;s:3:"dir";}}}s:6:"column";a:3:{s:2:"id";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:2:"id";i:1;s:11:"tinyint(10)";i:2;b:0;i:3;s:3:"PRI";i:4;N;i:5;s:14:"auto_increment";i:6;s:0:"";}}s:3:"dir";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:3:"dir";i:1;s:9:"char(100)";i:2;b:0;i:3;s:3:"UNI";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}s:11:"description";O:18:"AA_Metabase_Column":1:{s:1:"c";a:7:{i:0;s:11:"description";i:1;s:9:"char(255)";i:2;b:0;i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}}}s:5:"flags";N;}}}');
 296          }
 297          return $instance;
 298      }
 299  
 300      /** Returns array of all table names */

 301      function getTableNames() {
 302          return array_keys($this->tables);
 303      }
 304  
 305      /** Returns array of keys for given table */

 306      function getKeys($tablename) {
 307          $table = $this->tables[$tablename];
 308          return is_object($table) ? $table->getKeys() : array();
 309      }
 310  
 311      /** is the $columnname the key for given table */

 312      function isKey($tablename, $columnname) {
 313          $table = $this->tables[$tablename];
 314          return is_object($table) ? $table->isKey($columnname) : false;
 315      }
 316  
 317      /** Returns array of all columns */

 318      function getColumnNames($tablename) {
 319          $table = $this->tables[$tablename];
 320          return is_object($table) ? $table->getColumnNames() : array();
 321      }
 322  
 323      /** Is the $columnname the column in the $tablename? */

 324      function isColumn($tablename, $columnname) {
 325          $table = $this->tables[$tablename];
 326          return is_object($table) ? $table->isColumn($columnname) : false;
 327      }
 328  
 329      function fillKeys(&$data, $identifier) {
 330  
 331          $module_id  = $identifier->getModuleId();
 332          $tablename  = $identifier->getTable();
 333          $row        = $identifier->getRow();
 334  
 335          if (!AA_Metabase::isTableKeysSupported($tablename)) {
 336              // you can't use this function for that the table - this is programmers mistake - correct the code

 337              echo "table $tablename not supported in AA_Metabase::fillKeys()";
 338              exit;
 339          }
 340          $table      = $this->tables[$tablename];
 341          $keys       = $table->getKeys();
 342  
 343          // make sense just for single-keys or two-key, where second key

 344          // is replaced by $module_field below (for field table)

 345          $module_field = AA_Metabase::getModuleField($tablename);
 346          foreach ($keys as $key) {
 347              if ($key == $module_field) {
 348                  // we will assign it in nex step - reassignModule()

 349                  continue;
 350              }
 351              $data[$key] = AA_Metabase::isPacked($tablename, $key) ? pack_id($row) : $row;
 352          }
 353          $this->reassignModule($data, $tablename, $module_id);
 354      }
 355  
 356      /** changes the column of the table which identifies to which module it

 357       *  belongs. That way you just move the data to another module

 358       *  It modifies $data parameter

 359       */
 360      function reassignModule(&$data, $tablename, $module_id) {
 361          $module_field = AA_Metabase::getModuleField($tablename);
 362          if ($module_field) {
 363              $data[$module_field] = AA_Metabase::isPacked($tablename, $module_field) ? pack_id($module_id) : $module_id;
 364          }
 365      }
 366  
 367      /** static method */

 368      function isTableKeysSupported($tablename) {
 369          return in_array($tablename, AA_Metabase::_getSupportedTables());
 370      }
 371  
 372      /** static method */

 373      function isPacked($tablename, $column) {
 374          return in_array($column, AA_Metabase::getPacked($tablename));
 375      }
 376  
 377      /** static method */

 378      function getModuleField($tablename) {
 379          static $MODULE_KEYS = array(
 380                                       'alerts_collection'   => 'module_id',
 381                                       'constant_slice'      => 'slice_id',
 382                                       'ef_permissions'      => 'slice_id',
 383                                       'email'               => 'owner_module_id',
 384                                       'email_notify'        => 'slice_id',
 385                                       'external_feeds'      => 'slice_id',
 386                                       'field'               => 'slice_id',
 387                                       'item'                => 'slice_id',
 388                                       'links'               => 'id',
 389                                       'module'              => 'id',
 390                                       'mysql_auth_group'    => 'slice_id',
 391                                       'mysql_auth_userinfo' => 'slice_id',
 392                                       'polls'               => 'module_id',
 393                                       'profile'             => 'slice_id',
 394                                       'rssfeeds'            => 'slice_id',
 395                                       'site'                => 'id',
 396                                       'site_spot'           => 'site_id',
 397                                       'slice'               => 'id',
 398                                       'view'                => 'slice_id'
 399              );
 400          return $MODULE_KEYS[$tablename];
 401      }
 402  
 403  
 404  
 405      /** static method

 406       *  @todo - would be probably better to move it to AA_Metabase_Table

 407       *  @todo - convert to static class members for PHP5

 408       **/
 409      function getPacked($tablename) {
 410          static $PACKED = array(
 411                    'alerts_collection'   => array('module_id','slice_id'),
 412                    'constant'            => array('id','ancestors'), // ancestors are multiple - joined!
 413                    'constant_slice'      => array('slice_id'),
 414                    'content'             => array('item_id'),
 415                    'discussion'          => array('id','item_id'),
 416                    'ef_categories'       => array('category_id','target_category_id'),
 417                    'ef_permissions'      => array('slice_id'),
 418                    'email'               => array('owner_module_id'),
 419                    'email_notify'        => array('slice_id'),
 420                    'external_feeds'      => array('slice_id', 'remote_slice_id'),
 421                    'feedmap'             => array('from_slice_id', 'to_slice_id'),
 422                    'feedperms'           => array('from_id','to_id'),
 423                    'feeds'               => array('from_id','to_id','category_id','to_category_id'),
 424                    'field'               => array('slice_id'),
 425                    'hit_long_id'         => array('id'),
 426                    'item'                => array('id','slice_id'),  // slice_id is not part of key, here
 427                    'jump'                => array('slice_id', 'dest_slice_id'),
 428                    'links'               => array('id'),             // special meaning of first characters - category!!!
 429                    'module'              => array('id', 'owner'),
 430                    'mysql_auth_group'    => array('slice_id'),
 431                    'mysql_auth_userinfo' => array('slice_id'),
 432                    'offline'             => array('id'),
 433                    'polls'               => array('module_id'),
 434                    'polls_design'        => array('module_id'),
 435                    'profile'             => array('slice_id'),
 436                    'relation'            => array('source_id', 'destination_id'),
 437                    'rssfeeds'            => array('slice_id'),
 438                    'site'                => array('id'),
 439                    'site_spot'           => array('site_id'),
 440                    'slice'               => array('id', 'owner', 'mlxctrl'),
 441                    'slice_owner'         => array('id'),
 442                    'subscriptions'       => array('slice_owner'),
 443                    'view'                => array('slice_id')
 444                    );
 445          return isset($PACKED[$tablename]) ? $PACKED[$tablename] : array();
 446      }
 447  
 448      /** static method

 449       *  @todo - would be probably better to move it to AA_Metabase_Table

 450       *  @todo - convert to static class members for PHP5

 451       **/
 452      function &_getSupportedTables() {
 453          static $SUPPORTED_TABLES = array(
 454                    // single keys

 455                    'alerts_admin', 'alerts_collection', 'alerts_filter',
 456                    'auth_log', 'auth_user', 'change', 'change_record',
 457                    'central_conf', 'constant', 'constant_slice', 'cron',
 458                    'db_sequence', 'discussion', 'email', 'email_auto_user',
 459                    'event', 'external_feeds', 'groups', 'item', 'jump', 'links',
 460                    'links_cat_cat', 'links_categories', 'links_languages',
 461                    'links_link_cat', 'links_links', 'links_regions', 'log',
 462                    'module', 'mysql_auth_user', 'mysql_auth_userinfo', 'nodes',
 463                    'offline', 'object_float', 'object_integer', 'object_text',
 464                    'pagecache', 'pagecache_str2find', 'polls', 'polls_answer', 'polls_design',
 465                    'polls_log', 'post2shtml', 'profile', 'rssfeeds', 'searchlog',
 466                    'site', 'site_spot', 'slice', 'slice_owner', 'toexecute',
 467                    'users', 'view', 'wizard_template', 'wizard_welcome',
 468                    // supported table using double keys (slice_id,id)

 469                    'field'
 470                    // unsupported table using triple keys (slice_id,uid,`function`)

 471                    // 'email_notify'

 472              );
 473               // search and replace should be done here

 474               // feeds from_id to_id

 475               // feedmap   from_slice_id, to_slice_id

 476               // feedperms from_id,       to_id

 477               // relation  source_id,     destination_id

 478           return $SUPPORTED_TABLES;
 479      }
 480  
 481      /** static method

 482       *  @todo - would be probably better to move it to AA_Metabase_Table

 483       *  @todo - convert to static class members for PHP5

 484       **/
 485      function &_getUnsupportedTables() {
 486          static $UNSUPPORTED_TABLES = array(
 487                    'active_sessions', 'alerts_collection_filter',
 488                    'alerts_collection_howoften', 'auth_group', 'content',
 489                    'ef_categories', 'ef_permissions', 'email_notify', 'feedmap', 'feedperms',
 490                    'hit_archive', 'hit_long_id', 'hit_short_id', 'links_changes',
 491                    'links_link_lang', 'links_link_reg', 'membership',
 492                    'mysql_auth_group', 'mysql_auth_user_group',
 493                    'mysql_auth_userlog', 'perms', 'polls_ip_lock',
 494                    'relation', 'subscriptions');
 495          return $UNSUPPORTED_TABLES;
 496      }
 497  
 498      function doUpdate($tablename, $data) {
 499          $varset     = new Cvarset();
 500          $table      = $this->tables[$tablename];
 501  
 502          foreach ( $data as $key => $val ) {
 503              // @todo - do some validity checks for the data

 504              if ($table->isKey($key)) {
 505                  $varset->addkey($key, 'text', $val);
 506              } else {
 507                  $varset->add($key, 'text', $val);
 508              }
 509          }
 510          return $varset->doUpdate($tablename);
 511      }
 512  
 513      function doInsert($tablename, $data, $nohalt=null) {
 514          $varset     = new Cvarset();
 515          $varset->resetFromRecord($data);
 516          return $varset->doInsert($tablename, $nohalt);
 517      }
 518  
 519      function doDelete($tablename, $data) {
 520          $varset     = new Cvarset();
 521          $table      = $this->tables[$tablename];
 522          $table_keys = $table->getKeys();
 523  
 524          foreach ( $table_keys as $key ) {
 525              // @todo - do some validity checks for the data

 526              if (!$data[$key]) {
 527                  // you can't use this function for that table - this is programmers mistake - correct the code

 528                  echo "Missing key $key for table $tablename in AA_Metabase::doDelete()";
 529                  exit;
 530              }
 531              $varset->addkey($key, 'text', $data[$key]);
 532          }
 533          return $varset->doDelete($tablename);
 534      }
 535  
 536      /** analyzeStructure - reads table and column definitions form database */

 537      function loadFromDb() {
 538          $db     = getDb();
 539          $tables = $db->table_names();
 540          foreach ($tables as $table) {
 541              $this->tables[$table['table_name']] = AA_Metabase_Table::factoryFromDb($table['table_name']);
 542          }
 543      }
 544  
 545      function getCreateSql($tablename='', $prefix='') {
 546          $sql_parts = array();
 547          $tables = $tablename ? array($this->tables[$tablename]) : $this->tables;
 548          foreach ($tables as $table) {
 549              if ( is_object($table) ) {
 550                  $sql_parts[] = $table->getCreateSql($prefix);
 551              }
 552          }
 553          return join("\n",$sql_parts);
 554      }
 555  
 556      /** returns database structure definition as PHP code (array) */

 557      function getDefinition() {
 558          $defs = array();
 559          foreach ($this->tables as $table) {
 560              $defs[]= $table->getDefinition();
 561          }
 562          $ret = "array(";
 563          $ret .= join(",", $defs);
 564          $ret .= "\n);\n";
 565          return $ret;
 566      }
 567  
 568      /** addTableFromSql function

 569       * @param $tablename

 570       * @param $create_SQL

 571       */
 572      function addTableFromSql($tablename, $create_SQL) {
 573          $this->tables[$tablename] = new AA_Metabase_Table;
 574          $this->tables[$tablename]->setFromSQL($tablename, $create_SQL);
 575      }
 576  
 577      /** getSearchArray function

 578       *

 579       */
 580      function getSearchArray($tablename) {
 581          $i = 0;
 582          $table         = $this->tables[$tablename];
 583          $table_columns = $table->getColumnNames();
 584          foreach ($table_columns as $column_name) { // in priority order
 585              $field_type = 'text';    // @todo - get the type from field type

 586              // we can hide the field, if we put in fields.search_pri=0

 587              $search_pri = ++$i;
 588                                 //             $name,        $field,       $operators, $table, $search_pri, $order_pri

 589              $ret[$column_name] = GetFieldDef( $column_name, $column_name, $field_type, false, $search_pri, $search_pri);
 590          }
 591          return $ret;
 592      }
 593  
 594      /** generateAliases

 595       *

 596       */
 597      function generateAliases($tablename) {
 598          $aliases = array();
 599          $table         = $this->tables[$tablename];
 600          $table_columns = $table->getColumnNames();
 601          foreach ($table_columns as $column_name) { // in priority order
 602              // @todo - make alias field type aware

 603              $aliases["_#". substr(str_pad(strtoupper($column_name),8,'_'),0,8)] = GetAliasDef( "f_h", $column_name, $column_name);
 604          }
 605          return $aliases;
 606      }
 607  
 608      /** @return rows from $tablename for given $module_id in form

 609       *          ret[id] = array('column'=>value, ...)

 610       *  @param  ids are always UNPACKED (as keys as well as in values)

 611       */
 612      function getModuleRows($tablename, $module_id) {
 613          $JOIN = array(
 614            // @todo - do the 'constant' better - check the fields setting, and get all the constants used

 615            'constant'   => array('scr_field' => 'group_id', 'dest_table' => 'constant_slice', 'dest_field' => 'group_id'),
 616  
 617            'content'    => array('scr_field' => 'item_id',  'dest_table' => 'item',           'dest_field' => 'id'),
 618            'discussion' => array('scr_field' => 'item_id',  'dest_table' => 'item',           'dest_field' => 'id'),
 619  
 620            'alerts_collection_filter'   => array('scr_field' => 'collectionid',  'dest_table' => 'alerts_collection', 'dest_field' => 'id'),
 621            'alerts_collection_howoften' => array('scr_field' => 'collectionid',  'dest_table' => 'alerts_collection', 'dest_field' => 'id')
 622          );
 623  
 624          $module_table = $tablename;
 625          $join_sql     = '';
 626  
 627          if ( isset($JOIN[$tablename]) ) {
 628              $j = $JOIN[$tablename];
 629              $module_table = $j['dest_table'];
 630              $join_sql     = "INNER JOIN $module_table ON $tablename.". $j['scr_field']."=$module_table.".$j['dest_field'];
 631          }
 632  
 633          $module_field = $this->getModuleField($module_table);
 634          if (!$module_field) {
 635              // you can't use this function for that table - this is programmers mistake - correct the code

 636              echo "table $tablename not supported in AA_Metabase::getModuleRows() - no module field";
 637              exit;
 638          }
 639  
 640          $table_keys   = $this->getKeys($tablename);
 641          if (count($table_keys) == 1) {
 642              $table_key = $table_keys[0];
 643          }
 644          elseif ((count($table_keys) == 2) AND in_array($module_field, $table_keys)) {
 645              // two keys, but one of them is module_id, which is OK

 646              $table_key = ($table_keys[0] == $module_field) ? $table_keys[1] : $table_keys[0];
 647          }
 648          else {
 649              // you can't use this function for that table - this is programmers mistake - correct the code

 650              //echo "table $tablename not supported in AA_Metabase::getModuleRows() - too much keys";

 651              //exit;

 652              $table_key = '';  // we do not use the key

 653          }
 654  
 655          $module_val   = $this->isPacked($module_table, $module_field) ? q_pack_id($module_id) : $module_id;
 656          $key_used     = !$table_key ? '' : ($this->isPacked($tablename, $table_key) ? "unpack:$table_key" : $table_key);
 657  
 658          $SQL = "SELECT $tablename.* FROM $tablename $join_sql WHERE $module_table.$module_field = '$module_val'";
 659  
 660          $ret            = GetTable2Array($SQL, $key_used, 'aa_fields');
 661          if (!is_array($ret)) {
 662              $ret = array();
 663          }
 664  
 665          $this->unpackIds($tablename, $ret);
 666          return $ret;
 667      }
 668  
 669      function unpackIds($tablename, &$data) {
 670          $packed_columns = $this->getPacked($tablename);
 671          foreach ($packed_columns as $column) {
 672              foreach ($data as $k => $v) {
 673                  $data[$k][$column] = unpack_id($v[$column]);
 674              }
 675          }
 676      }
 677  
 678      function packIds($tablename, &$data) {
 679          $packed_columns = $this->getPacked($tablename);
 680          foreach ($packed_columns as $column) {
 681              foreach ($data as $k => $v) {
 682                  $data[$k][$column] = pack_id($v[$column]);
 683              }
 684          }
 685      }
 686  
 687  
 688      /** Compares two metabases - this and the $metabase supplied by the parameter

 689       *  You can use it to check, which tables should be updated

 690       *  @param $metabase - the second metabase which will be compated to $this

 691       **/
 692      function compare($metabase) {
 693          $diffs = array();
 694  
 695          // for us are varchar and char the same - some tables are never converted

 696          // to char in some versions of MySQL, so the test is always false

 697          $eq_vars   = array('varchar', " default '                '", " default '                                '", " default '0'", "timestamp NOT NULL", 'varbinary');
 698          $eq_novars = array('char'   , '', '', '', 'timestamp', 'binary');
 699  
 700          foreach ($this->tables as $tablename => $table) {
 701              $table_sql_1 = $table->getCreateSql();
 702              $table_sql_2 = $metabase->getCreateSql($tablename);
 703  
 704              $diffs[$tablename] = array('equal'  => (str_replace($eq_vars, $eq_novars, $table_sql_1) == str_replace($eq_vars, $eq_novars, $table_sql_2)),
 705                                         'table1' => $table_sql_1,
 706                                         'table2' => $table_sql_2
 707                                        );
 708          }
 709          return $diffs;
 710      }
 711  
 712      /** getContent function for loading content of specified table for manager

 713       *  class

 714       *

 715       * Loads data from database for given table ids (called in itemview class)

 716       * and stores it in the 'Abstract Data Structure' for use with 'item' class

 717       *

 718       * @see GetItemContent(), itemview class, item class

 719       * @param array $zids array if ids to get from database

 720       * @param array $settings array - just one parameter: table, where to search

 721       * @return array - Abstract Data Structure containing the links data

 722       *                 {@link http://apc-aa.sourceforge.net/faq/#1337}

 723       */
 724      function getContent($settings, $zids) {
 725          $content = array();
 726          $ret     = array();
 727  
 728          $tablename   = $settings['table'];
 729          $metabase    = AA_Metabase::singleton();
 730          $keys        = $metabase->getKeys($tablename);
 731          if (count($keys) != 1) {
 732              // you can't use this function for that table - this is programmers mistake - correct the code

 733              echo "Missing key for table $tablename in AA_Metabase::getContent()";
 734              exit;
 735          }
 736          $key = $keys[0];
 737  
 738  
 739          // construct WHERE clausule

 740          $sel_in = $zids->sqlin( false , true);  // asis

 741          $SQL = "SELECT * FROM $tablename WHERE $key $sel_in";
 742          StoreTable2Content($content, $SQL, '', $key);
 743          // it is unordered, so we have to sort it:

 744          for($i=0; $i<$zids->count(); $i++ ) {
 745              $ret[(string)$zids->id($i)] = $content[$zids->id($i)];
 746          }
 747          return $ret;
 748      }
 749  
 750      /** Central_QueryZids - Finds link IDs for links according to given  conditions

 751       *  @param array  $settings - array - just one parameter: table, where to search

 752       *  @param array  $set      - AA_Set object which specifies Sortorder and Conditions

 753       *                          - there we store also BINs conditions, since each

 754       *                            table/module can use different Bins AND for other

 755       *                            the idea of BINs makes no sense at all

 756       *  @global int  $QueryIDsCount - set to the count of IDs returned

 757       *  @global bool $debug=1       - many debug messages

 758       *  @global bool $nocache       - do not use cache, even if use_cache is set

 759       */
 760      function queryZids($settings, $set) {
 761          global $debug;                 // displays debug messages

 762          global $nocache;               // do not use cache, if set

 763  
 764          $tablename = $settings['table'];
 765          $conds     = $set->getConds();
 766          $sort      = $set->getSort();
 767  
 768          if ( $debug ) huhl( "<br>Conds:", $conds, "<br>--<br>Sort:", $sort, "<br>--");
 769  
 770          $metabase    = AA_Metabase::singleton();
 771  
 772          $fields      = $metabase->getSearchArray($tablename);
 773          $join_tables = array();   // not used in this function

 774  
 775          $keys        = $metabase->getKeys($tablename);
 776          if (count($keys) != 1) {
 777              // you can't use this function for that table - this is programmers mistake - correct the code

 778              echo "Missing key for table $tablename in AA_Metabase::queryZids()";
 779              exit;
 780          }
 781          $key = $keys[0];
 782  
 783          $SQL    = "SELECT DISTINCT $key FROM $tablename ";
 784  //        $SQL .= CreateBinCondition($type, $tablename);

 785          $where  = MakeSQLConditions($fields, $conds, $fields, $join_tables);
 786          $SQL   .= ($where ? "WHERE (1=1) $where" : '');
 787          $SQL   .= MakeSQLOrderBy($fields, $sort, $join_tables);
 788  
 789          return GetZidsFromSQL($SQL, $key);
 790      }
 791  
 792      function queryCount($settings, $set) {
 793          $tablename = $settings['table'];
 794          $conds     = $set->getConds();
 795  
 796          $metabase    = AA_Metabase::singleton();
 797  
 798          $fields      = $metabase->getSearchArray($tablename);
 799          $join_tables = array();   // not used in this function

 800  
 801          $SQL    = "SELECT count(*) as count FROM $tablename ";
 802          $where  = MakeSQLConditions($fields, $conds, $fields, $join_tables);
 803          $SQL   .= ($where ? "WHERE (1=1) $where" : '');
 804  
 805          return GetTable2Array($SQL, 'aa_first', 'count');
 806      }
 807  
 808  
 809      /** Get tabledit cofiguration for easy edit and add to the table */

 810      function getTableditConf($tablename) {
 811          $ret = array (
 812              "table"     => $tablename,
 813              "type"      => "edit",
 814  //          "mainmenu"  => "modadmin",

 815  //          "submenu"   => "design",

 816              "readonly"  => false,
 817              "addrecord" => false,
 818  //          "cond"      => CheckPerms( $auth->auth["uid"], "slice", $slice_id, PS_MODP_EDIT_DESIGN),

 819  //          "title"     => $title,

 820  //          "caption"   => $title,

 821              "attrs"     => array ("table"=>"border=0 cellpadding=3 cellspacing=0 bgcolor='".COLOR_TABBG."'"),
 822  //          "gotoview"  => "polls_designs_edit",

 823          );
 824  
 825          $table         = $this->tables[$tablename];
 826          $table_columns = $table->getColumnNames();
 827          foreach ($table_columns as $column_name) { // in priority order
 828              $field_type = 'text';    // @todo - get the type from field type

 829              $ret['fields'][$column_name] = array('caption' => $column_name,
 830                                                   'view'    => array('type' => $field_type)
 831                                                  );
 832              // @todo - do better check - based on table setting

 833              if ($column_name = 'id') {
 834                  $ret['fields'][$column_name]['view']['readonly'] = true;
 835              }
 836          }
 837          return $ret;
 838      }
 839  
 840      /** generate manager from database structure

 841       * @param $classname

 842       * @param $params

 843       */
 844      function getManagerConf($tablename, $actions=null, $switches=null, $manager_id=null) {
 845          $manager_id    = is_null($manager_id) ? $manager_id : $tablename;   // or something more concrete?

 846          $aliases       = $this->generateAliases($tablename);
 847          $search_fields = $this->getSearchArray($tablename);
 848  
 849          $manager_settings = array(
 850               'module_id' => $manager_id,
 851               'show'      =>  MGR_ACTIONS | MGR_SB_SEARCHROWS | MGR_SB_ORDERROWS | MGR_SB_BOOKMARKS,    // MGR_ACTIONS | MGR_SB_SEARCHROWS | MGR_SB_ORDERROWS | MGR_SB_BOOKMARKS
 852               'searchbar' => array(
 853                   'fields'               => $search_fields,
 854                   'search_row_count_min' => 1,
 855                   'order_row_count_min'  => 1,
 856                   'add_empty_search_row' => true,
 857                   'function'             => false  // name of function for aditional action hooked on standard filter action
 858                                   ),
 859               'scroller'  => array(
 860                   'listlen'              => EDIT_ITEM_COUNT
 861                                   ),
 862               'itemview'  => array(
 863                   'manager_vid'          => false,    // $slice_info['manager_vid'],      // id of view which controls the design
 864                   'format'               => array(    // optionaly to manager_vid you can set format array
 865                       'compact_top'      => '<table border="0" cellspacing="0" cellpadding="5">
 866                                              <tr>
 867                                                <th width="30">&nbsp;</td>
 868                                                <th>'.join("</th>\n<th>", array_keys($search_fields)).'</th>
 869                                              </tr>
 870                                              ',
 871                       'category_sort'    => false,
 872                       'category_format'  => "",
 873                       'category_top'     => "",
 874                       'category_bottom'  => "",
 875                       'even_odd_differ'  => false,
 876                       'even_row_format'  => "",
 877                       'odd_row_format'   => '
 878                                              <tr class=tabtxt>
 879                                                <td width="30"><input type="checkbox" name="chb[x_#ID______]" value=""></td>
 880                                                <td class=tabtxt>'.join("</td>\n<td class=tabtxt>", array_keys($aliases)).'</td>
 881                                              </tr>
 882                                             ',
 883                       'compact_remove'   => "",
 884                       'compact_bottom'   => "</table>",
 885                       'id'               => $manager_id ),
 886                   'fields'               => $this->getSearchArray($tablename),
 887                   'aliases'              => $aliases,
 888                                             //    static class method               , first parameter to the method

 889                   'get_content_funct'    => array(array('AA_Metabase', 'getContent'), array('table'=>$tablename))
 890                                   ),
 891               'actions'   => $actions,
 892               'switches'  => $switches,
 893               'bin'       => 'app',
 894               'messages'  => array(
 895                   'title'       => _m('Manage %1', array($tablename))
 896                                   )
 897                   );
 898  
 899          return $manager_settings;
 900      }
 901  }
 902  
 903  ?>

title

Description

title

Description

title

Description

title

title

Body