Subversion Repositories computer_asset_manager_v2

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
53 rodolico 1
<?php
2
   require_once( 'camp.class.php' );
3
 
4
   class Location extends Camp {
5
      protected static $dbStructure = array(
6
         'table' => array( 
7
            'tableName' => 'location',
8
            'primaryKey' => 'location_id',
9
            'selectionDisplay' => 'name',
10
            'fields' => array(
56 rodolico 11
                  'id' => array (
12
                     'fieldname' => 'location_id',
53 rodolico 13
                     'displayName' => 'ID',
14
                     'type' => 'int unsigned',
15
                     'nullable' => false
16
                  ),
17
                  'name' => array (
56 rodolico 18
                     'fieldname' => 'name',
19
                     'displayName' => 'Location',
53 rodolico 20
                     'type' => 'varchar',
21
                     'size' => 64,
22
                     'list' => true
23
                  ),
24
                  'created' => array (
56 rodolico 25
                     'fieldname' => 'created',
53 rodolico 26
                     'displayName' => 'Created',
27
                     'type' => 'date'
28
                  ),
29
                  'removed' => array(
56 rodolico 30
                     'fieldname' => 'removed',
53 rodolico 31
                     'displayName' => 'Removed',
32
                     'type' => 'date'
33
                  )
34
            ) // fields
56 rodolico 35
         ), // table
36
         'view' => array(
37
            'viewName' => 'view_device_location_owner_type',
38
            'primaryKey' => 'location_id',
39
            'selectionDisplay' => 'location',
40
            'fields' => array(
41
               'removed' => array( 
42
                  'fieldname' => 'location_removed'
43
               )
44
            )
45
         )
53 rodolico 46
      ); // dbStructure
47
   }
48
 
49
?>