| 99 |
rodolico |
1 |
<?php
|
|
|
2 |
global $DATABASE_DEFINITION;
|
|
|
3 |
$DATABASE_DEFINITION['attrib'] = array(
|
|
|
4 |
'table name' => 'attrib',
|
|
|
5 |
'key field' => 'attrib_id',
|
|
|
6 |
'display columns' => array('Name','KeyName','Added'),
|
|
|
7 |
'display query' => 'select attrib_id,name Name,keyname KeyName,added_date Added from attrib',
|
|
|
8 |
'field info' => array(
|
|
|
9 |
/* date record was deleted/supserceded */
|
|
|
10 |
'removed_date' => array('display name' => 'removed_date' , 'type' => 'date'),
|
|
|
11 |
'attrib_id' => array('display name' => 'file_id' , 'keyfield' => true , 'required' => true , 'readonly' => true , 'type' => 'int'),
|
|
|
12 |
'name' => array('display name' => 'name' , 'type' => 'string' , 'width' => 64),
|
|
|
13 |
/* date record was added */
|
|
|
14 |
'added_date' => array('display name' => 'added_date' , 'type' => 'date'),
|
|
|
15 |
/* A brief (or long) description of this file */
|
|
|
16 |
'keyname' => array('display name' => 'Key Name', 'type' => 'string' , 'width' => 32),
|
|
|
17 |
)
|
|
|
18 |
);
|
|
|
19 |
/* FIX THIS
|
|
|
20 |
$DATABASE_DEFINITION['attrib_device'] = array(
|
|
|
21 |
'table name' => 'attrib_device',
|
|
|
22 |
'key field' => 'attrib_device_id',
|
|
|
23 |
'display columns' => array('site','file_link_id','owner_type','file_id','site_id','owner_id'),
|
|
|
24 |
'display query' => 'select site,file_link_id,owner_type,file_id,site_id,owner_id from file_link',
|
|
|
25 |
'field info' => array(
|
|
|
26 |
'site' => array('display name' => 'site' , 'type' => 'or'),
|
|
|
27 |
'file_link_id' => array('display name' => 'file_link_id' , 'keyfield' => true , 'required' => true , 'readonly' => true , 'type' => 'int'),
|
|
|
28 |
'owner_type' => array('display name' => 'owner_type' , 'default' => 'd', 'type' => 'string'),
|
|
|
29 |
'file_id' => array('display name' => 'file_id' , 'type' => 'lookup', 'table' => 'file', 'keyfield' => 'file_id', 'display_field' => 'name'),
|
|
|
30 |
'site_id' => array('display name' => 'site_id' , 'type' => 'or'),
|
|
|
31 |
'owner_id' => array('display name' => 'owner_id' , 'required' => true , 'type' => 'int')
|
|
|
32 |
)
|
|
|
33 |
);
|
|
|
34 |
$DATABASE_DEFINITION['file_mime_type'] = array(
|
|
|
35 |
'table name' => 'file_mime_type',
|
|
|
36 |
'key field' => 'file_mime_type_id',
|
|
|
37 |
'display columns' => array('Extension','Type'),
|
|
|
38 |
'display query' => 'select extension Extension ,file_mime_type_id,mime_type Type from file_mime_type',
|
|
|
39 |
'field info' => array(
|
|
|
40 |
// a file name extension commonly associated with this file
|
|
|
41 |
'extension' => array('display name' => 'extension' , 'type' => 'string' , 'width' => 10),
|
|
|
42 |
'file_mime_type_id' => array('display name' => 'file_mime_type_id' , 'keyfield' => true , 'required' => true , 'readonly' => true , 'type' => 'int'),
|
|
|
43 |
// The standardized mime type
|
|
|
44 |
'mime_type' => array('display name' => 'mime_type' , 'keyfield' => true , 'type' => 'string' , 'width' => 64)
|
|
|
45 |
)
|
|
|
46 |
);
|
|
|
47 |
*/
|
|
|
48 |
?>
|