Subversion Repositories computer_asset_manager_v1

Rev

Rev 101 | Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | Download | RSS feed

<?php
global $DATABASE_DEFINITION;
   $DATABASE_DEFINITION['attrib'] = array(
      'table name' => 'attrib',
      'key field' => 'attrib_id',
      'display columns' => array('Name','KeyName','Added'),
      'display query' => 'select attrib_id,name Name,keyname KeyName,added_date Added from attrib',
      'field info' => array(
         /* date record was deleted/supserceded */
         'removed_date' => array('display name' => 'removed_date' , 'type' => 'date'),
         'attrib_id' => array('display name' => 'file_id' , 'keyfield' => true , 'required' => true , 'readonly' => true , 'type' => 'int'),
         'name' => array('display name' => 'name' , 'type' => 'string' , 'width' => 64),
         /* date record was added */
         'added_date' => array('display name' => 'added_date' , 'type' => 'date'),
         /* A brief (or long) description of this file */
         'keyname' => array('display name' => 'Key Name', 'type' => 'string' , 'width' => 32),
      )
   );
   /* FIX THIS
   $DATABASE_DEFINITION['attrib_device'] = array(
      'table name' => 'attrib_device',
      'key field' => 'attrib_device_id',
      'display columns' => array('site','file_link_id','owner_type','file_id','site_id','owner_id'),
      'display query' => 'select site,file_link_id,owner_type,file_id,site_id,owner_id from file_link',
      'field info' => array(
         'site' => array('display name' => 'site' , 'type' => 'or'),
         'file_link_id' => array('display name' => 'file_link_id' , 'keyfield' => true , 'required' => true , 'readonly' => true , 'type' => 'int'),
         'owner_type' => array('display name' => 'owner_type' , 'default' => 'd', 'type' => 'string'),
         'file_id' => array('display name' => 'file_id' , 'type' => 'lookup', 'table' => 'file', 'keyfield' => 'file_id', 'display_field' => 'name'),
         'site_id' => array('display name' => 'site_id' , 'type' => 'or'),
         'owner_id' => array('display name' => 'owner_id' , 'required' => true , 'type' => 'int')
      )
   );
   $DATABASE_DEFINITION['file_mime_type'] = array(
      'table name' => 'file_mime_type',
      'key field' => 'file_mime_type_id',
      'display columns' => array('Extension','Type'),
      'display query' => 'select extension Extension ,file_mime_type_id,mime_type Type from file_mime_type',
      'field info' => array(
         // a file name extension commonly associated with this file
         'extension' => array('display name' => 'extension' , 'type' => 'string' , 'width' => 10),
         'file_mime_type_id' => array('display name' => 'file_mime_type_id' , 'keyfield' => true , 'required' => true , 'readonly' => true , 'type' => 'int'),
         // The standardized mime type
         'mime_type' => array('display name' => 'mime_type' , 'keyfield' => true , 'type' => 'string' , 'width' => 64)
      )
   );
   */
?>