Subversion Repositories computer_asset_manager_v2

Rev

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

Rev Author Line No. Line
1 rodolico 1 
<?php
2 
 
19 rodolico 3 
/*
4 
   Auto generated from SQL script by ../library/sql2admin_hash.pl version 1.1.
5 
   do not edit this file. Edit DatabaseDefinition.local.php as changes
6 
   to that file will not be overwritten by subsequent runs of this
7 
   script.
8 
*/
1 rodolico 9 
 
10 
global $DATABASE_DEFINITION; // make variable available to all scripts
11 
 
12 
define ( 'MAX_INPUT_FIELD_DISPLAY', 40 ); // this is the maximum input field size
13 
define ( 'FILES_DIRECTORY', '/files/' );  // relative URL where pictures are stored
19 rodolico 14 
define ( 'EDIT_IMAGE_HEIGHT', 100 );      // height for thumbnail of picturse
1 rodolico 15 
define ( 'MAX_UPLOAD_FILE_SIZE', 1024*1024*10 ); // 10 meg
16 
define ( 'DEFAULT_TEXTAREA_HEIGHT', 5 );
19 rodolico 17 
define ( 'DEFAULT_TABLE', 'FILL ME IN');
1 rodolico 18 
 
19 
$DATABASE_DEFINITION = array(
19 rodolico 20 
   '_system' => array(
21 
      'table name' => '_system',
22 
      'display name' => 'System',
23 
      'comment' => 'Basically a configuration file equivilent to a windows INI ',
24 
      'key field' => '_system_id ',
1 rodolico 25 
      'display columns' => array(
19 rodolico 26 
         '_system_id',
27 
         'group_name',
28 
         'key_name',
29 
         'theValue'
1 rodolico 30 
      ),
19 rodolico 31 
      'display query' => 'select _system_id,group_name,key_name,theValue from _system',
1 rodolico 32 
      'field info' => array(
19 rodolico 33 
         '_system_id' => array(
34 
            'display name' => 'System Id' ,
1 rodolico 35 
            'keyfield' => true ,
36 
            'required' => true ,
37 
            'readonly' => true ,
38 
            'autoincrement' => true ,
39 
            'type' => 'int' ,
40 
            'width' => 0
41 
         ),
19 rodolico 42 
         'group_name' => array(
43 
            'display name' => 'Group Name' ,
44 
            'comment' => 'used to group keys together' ,
1 rodolico 45 
            'required' => true ,
46 
            'type' => 'string' ,
47 
            'width' => 64
48 
         ),
19 rodolico 49 
         'key_name' => array(
50 
            'display name' => 'Key Name' ,
51 
            'comment' => 'key into this value' ,
1 rodolico 52 
            'required' => true ,
19 rodolico 53 
            'type' => 'string' ,
54 
            'width' => 64
1 rodolico 55 
         ),
19 rodolico 56 
         'theValue' => array(
57 
            'display name' => 'Thevalue' ,
58 
            'comment' => 'the actual value of this entry' ,
59 
            'required' => false ,
1 rodolico 60 
            'type' => 'text' ,
61 
            'width' => 0
19 rodolico 62 
         )
63 
      )
64 
   ),
65 
   '_user' => array(
66 
      'table name' => '_user',
67 
      'display name' => 'User',
68 
      'comment' => 'user access to program',
69 
      'key field' => ' _user_id ',
70 
      'display columns' => array(
71 
         '_user_id',
72 
         'username',
73 
         'name',
74 
         'email',
75 
         'notes',
76 
         'pass',
77 
         'access',
78 
         'added_date',
79 
         'removed_date'
80 
      ),
81 
      'display query' => 'select _user_id,username,name,email,notes,pass,access,added_date,removed_date from _user',
82 
      'field info' => array(
83 
         '_user_id' => array(
84 
            'display name' => 'User Id' ,
85 
            'keyfield' => true ,
86 
            'required' => true ,
87 
            'readonly' => true ,
88 
            'autoincrement' => true ,
89 
            'type' => 'int' ,
90 
            'width' => 0
1 rodolico 91 
         ),
19 rodolico 92 
         'username' => array(
93 
            'display name' => 'Username' ,
94 
            'comment' => 'user name for logging in' ,
95 
            'required' => true ,
96 
            'type' => 'string' ,
97 
            'width' => 32
98 
         ),
99 
         'name' => array(
100 
            'display name' => 'Name' ,
101 
            'comment' => 'common name of user' ,
102 
            'type' => 'string' ,
103 
            'width' => 64
104 
         ),
1 rodolico 105 
         'email' => array(
106 
            'display name' => 'Email' ,
19 rodolico 107 
            'comment' => 'email address of user' ,
1 rodolico 108 
            'type' => 'string' ,
109 
            'width' => 64
110 
         ),
111 
         'notes' => array(
112 
            'display name' => 'Notes' ,
19 rodolico 113 
            'comment' => 'any notes about user' ,
1 rodolico 114 
            'type' => 'text' ,
115 
            'width' => 0
116 
         ),
19 rodolico 117 
         'pass' => array(
118 
            'display name' => 'Pass' ,
119 
            'comment' => 'encrypted password of user' ,
120 
            'type' => 'string' ,
121 
            'width' => 256
122 
         ),
123 
         'access' => array(
124 
            'display name' => 'Access' ,
125 
            'comment' => 'sql to determine what records user can view' ,
126 
            'type' => 'text' ,
127 
            'width' => 0
128 
         ),
129 
         'added_date' => array(
130 
            'display name' => 'Added Date' ,
131 
            'comment' => 'Date record added to database' ,
1 rodolico 132 
            'required' => true ,
19 rodolico 133 
            'type' => 'date' ,
1 rodolico 134 
            'width' => 0
135 
         ),
19 rodolico 136 
         'removed_date' => array(
137 
            'display name' => 'Removed Date' ,
138 
            'comment' => 'Date record marked as removed' ,
1 rodolico 139 
            'required' => false ,
19 rodolico 140 
            'type' => 'date' ,
1 rodolico 141 
            'width' => 0
142 
         )
143 
      )
144 
   ),
19 rodolico 145 
   '_menu' => array(
146 
      'table name' => '_menu',
147 
      'display name' => 'Menu',
148 
      'comment' => 'We keep the entire menu structure here so modules can modify it',
149 
      'key field' => '_menu_id',
1 rodolico 150 
      'display columns' => array(
19 rodolico 151 
         '_menu_id',
152 
         'parent_id',
153 
         'caption',
154 
         'url'
1 rodolico 155 
      ),
19 rodolico 156 
      'display query' => 'select _menu_id,parent_id,caption,url from _menu',
1 rodolico 157 
      'field info' => array(
19 rodolico 158 
         '_menu_id' => array(
159 
            'display name' => 'Menu Id' ,
1 rodolico 160 
            'keyfield' => true ,
161 
            'required' => true ,
162 
            'readonly' => true ,
163 
            'autoincrement' => true ,
164 
            'type' => 'int' ,
165 
            'width' => 0
166 
         ),
19 rodolico 167 
         'parent_id' => array(
168 
            'display name' => 'Parent Id' ,
169 
            'type' => 'lookup' ,
170 
            'table' => '_menu' ,
171 
            'keyfield' => '_menu_id' ,
172 
            'display_field' => 'name'
173 
         ),
174 
         'caption' => array(
175 
            'display name' => 'Caption' ,
176 
            'comment' => 'The actual caption displayed' ,
1 rodolico 177 
            'required' => true ,
178 
            'type' => 'string' ,
19 rodolico 179 
            'width' => 20
1 rodolico 180 
         ),
19 rodolico 181 
         'url' => array(
182 
            'display name' => 'Url' ,
183 
            'comment' => 'the url of the page/script to call or null if this contains sub-options' ,
1 rodolico 184 
            'required' => false ,
19 rodolico 185 
            'type' => 'string' ,
186 
            'width' => 120
1 rodolico 187 
         )
188 
      )
189 
   ),
19 rodolico 190 
   'client' => array(
191 
      'table name' => 'client',
192 
      'display name' => 'Client',
193 
      'comment' => 'Stores information about a particlar client/owner',
194 
      'key field' => 'client_id',
1 rodolico 195 
      'display columns' => array(
19 rodolico 196 
         'client_id',
1 rodolico 197 
         'name',
198 
         'notes',
19 rodolico 199 
         'added_date',
200 
         'removed_date'
1 rodolico 201 
      ),
19 rodolico 202 
      'display query' => 'select client_id,name,notes,added_date,removed_date from client',
1 rodolico 203 
      'field info' => array(
19 rodolico 204 
         'client_id' => array(
205 
            'display name' => 'Client Id' ,
1 rodolico 206 
            'keyfield' => true ,
207 
            'required' => true ,
208 
            'readonly' => true ,
209 
            'autoincrement' => true ,
210 
            'type' => 'int' ,
211 
            'width' => 0
212 
         ),
213 
         'name' => array(
214 
            'display name' => 'Name' ,
19 rodolico 215 
            'comment' => 'Name of the client' ,
1 rodolico 216 
            'type' => 'string' ,
217 
            'width' => 64
218 
         ),
219 
         'notes' => array(
220 
            'display name' => 'Notes' ,
19 rodolico 221 
            'comment' => 'Any notes you want to enter' ,
1 rodolico 222 
            'type' => 'text' ,
223 
            'width' => 0
224 
         ),
19 rodolico 225 
         'added_date' => array(
226 
            'display name' => 'Added Date' ,
227 
            'comment' => 'Date record added to database' ,
1 rodolico 228 
            'required' => true ,
19 rodolico 229 
            'type' => 'date' ,
1 rodolico 230 
            'width' => 0
231 
         ),
19 rodolico 232 
         'removed_date' => array(
233 
            'display name' => 'Removed Date' ,
234 
            'comment' => 'Date record marked as removed' ,
1 rodolico 235 
            'required' => false ,
19 rodolico 236 
            'type' => 'date' ,
1 rodolico 237 
            'width' => 0
238 
         )
239 
      )
240 
   ),
19 rodolico 241 
   'site' => array(
242 
      'table name' => 'site',
243 
      'display name' => 'Site',
244 
      'comment' => 'Stores information about a particlar physical site',
245 
      'key field' => 'site_id',
1 rodolico 246 
      'display columns' => array(
19 rodolico 247 
         'site_id',
1 rodolico 248 
         'name',
249 
         'notes',
19 rodolico 250 
         'added_date',
251 
         'removed_date'
1 rodolico 252 
      ),
19 rodolico 253 
      'display query' => 'select site_id,name,notes,added_date,removed_date from site',
1 rodolico 254 
      'field info' => array(
19 rodolico 255 
         'site_id' => array(
256 
            'display name' => 'Site Id' ,
1 rodolico 257 
            'keyfield' => true ,
258 
            'required' => true ,
259 
            'readonly' => true ,
260 
            'autoincrement' => true ,
261 
            'type' => 'int' ,
262 
            'width' => 0
263 
         ),
264 
         'name' => array(
265 
            'display name' => 'Name' ,
19 rodolico 266 
            'comment' => 'Name of the site' ,
1 rodolico 267 
            'type' => 'string' ,
268 
            'width' => 64
269 
         ),
270 
         'notes' => array(
271 
            'display name' => 'Notes' ,
19 rodolico 272 
            'comment' => 'Any notes you want to enter' ,
1 rodolico 273 
            'type' => 'text' ,
274 
            'width' => 0
275 
         ),
19 rodolico 276 
         'added_date' => array(
277 
            'display name' => 'Added Date' ,
278 
            'comment' => 'Date record added to database' ,
1 rodolico 279 
            'required' => true ,
19 rodolico 280 
            'type' => 'date' ,
1 rodolico 281 
            'width' => 0
282 
         ),
19 rodolico 283 
         'removed_date' => array(
284 
            'display name' => 'Removed Date' ,
285 
            'comment' => 'Date record marked as removed' ,
1 rodolico 286 
            'required' => false ,
19 rodolico 287 
            'type' => 'date' ,
1 rodolico 288 
            'width' => 0
289 
         )
290 
      )
291 
   ),
19 rodolico 292 
   'device' => array(
293 
      'table name' => 'device',
294 
      'display name' => 'Device',
295 
      'comment' => 'stores information about an individual device or other device',
296 
      'key field' => 'device_id',
1 rodolico 297 
      'display columns' => array(
19 rodolico 298 
         'device_id',
1 rodolico 299 
         'name',
300 
         'notes',
19 rodolico 301 
         'device_type_id',
302 
         'added_date',
303 
         'removed_date'
1 rodolico 304 
      ),
19 rodolico 305 
      'display query' => 'select device_id,name,notes,device_type_id,added_date,removed_date from device',
1 rodolico 306 
      'field info' => array(
19 rodolico 307 
         'device_id' => array(
308 
            'display name' => 'Device Id' ,
1 rodolico 309 
            'keyfield' => true ,
310 
            'required' => true ,
311 
            'readonly' => true ,
312 
            'autoincrement' => true ,
313 
            'type' => 'int' ,
314 
            'width' => 0
315 
         ),
316 
         'name' => array(
317 
            'display name' => 'Name' ,
19 rodolico 318 
            'comment' => 'name of the device or device' ,
1 rodolico 319 
            'type' => 'string' ,
320 
            'width' => 64
321 
         ),
322 
         'notes' => array(
323 
            'display name' => 'Notes' ,
19 rodolico 324 
            'comment' => 'any notes we want to store' ,
1 rodolico 325 
            'type' => 'text' ,
326 
            'width' => 0
327 
         ),
19 rodolico 328 
         'device_type_id' => array(
329 
            'display name' => 'Device Type Id' ,
330 
            'type' => 'lookup' ,
331 
            'table' => 'device_type' ,
332 
            'keyfield' => 'device_type_id' ,
333 
            'display_field' => 'name'
334 
         ),
335 
         'added_date' => array(
336 
            'display name' => 'Added Date' ,
337 
            'comment' => 'Date record added to database' ,
1 rodolico 338 
            'required' => true ,
19 rodolico 339 
            'type' => 'date' ,
1 rodolico 340 
            'width' => 0
341 
         ),
19 rodolico 342 
         'removed_date' => array(
343 
            'display name' => 'Removed Date' ,
344 
            'comment' => 'Date record marked as removed' ,
1 rodolico 345 
            'required' => false ,
19 rodolico 346 
            'type' => 'date' ,
1 rodolico 347 
            'width' => 0
348 
         )
349 
      )
350 
   ),
19 rodolico 351 
   'device_device' => array(
352 
      'table name' => 'device_device',
353 
      'display name' => 'Device Device',
354 
      'comment' => 'joins device to another device',
355 
      'key field' => 'device_device_id',
1 rodolico 356 
      'display columns' => array(
19 rodolico 357 
         'device_device_id',
358 
         'source',
359 
         'target',
360 
         'added_date',
361 
         'removed_date'
1 rodolico 362 
      ),
19 rodolico 363 
      'display query' => 'select device_device_id,source,target,added_date,removed_date from device_device',
1 rodolico 364 
      'field info' => array(
19 rodolico 365 
         'device_device_id' => array(
366 
            'display name' => 'Device Device Id' ,
1 rodolico 367 
            'keyfield' => true ,
368 
            'required' => true ,
369 
            'readonly' => true ,
370 
            'autoincrement' => true ,
371 
            'type' => 'int' ,
372 
            'width' => 0
373 
         ),
19 rodolico 374 
         'source' => array(
375 
            'display name' => 'Source' ,
376 
            'type' => 'lookup' ,
377 
            'table' => 'device' ,
378 
            'keyfield' => 'device_id' ,
379 
            'display_field' => 'name'
1 rodolico 380 
         ),
19 rodolico 381 
         'target' => array(
382 
            'display name' => 'Target' ,
383 
            'type' => 'lookup' ,
384 
            'table' => 'device' ,
385 
            'keyfield' => 'device_id' ,
386 
            'display_field' => 'name'
1 rodolico 387 
         ),
19 rodolico 388 
         'added_date' => array(
389 
            'display name' => 'Added Date' ,
390 
            'comment' => 'Date record added to database' ,
1 rodolico 391 
            'required' => true ,
19 rodolico 392 
            'type' => 'date' ,
1 rodolico 393 
            'width' => 0
394 
         ),
19 rodolico 395 
         'removed_date' => array(
396 
            'display name' => 'Removed Date' ,
397 
            'comment' => 'Date record marked as removed' ,
1 rodolico 398 
            'required' => false ,
19 rodolico 399 
            'type' => 'date' ,
1 rodolico 400 
            'width' => 0
401 
         )
402 
      )
403 
   ),
19 rodolico 404 
   'device_type' => array(
405 
      'table name' => 'device_type',
406 
      'display name' => 'Device Type',
407 
      'comment' => 'simply a list of device types ie computer printer whatever',
408 
      'key field' => 'device_type_id',
1 rodolico 409 
      'display columns' => array(
19 rodolico 410 
         'device_type_id',
1 rodolico 411 
         'name',
19 rodolico 412 
         'flags',
413 
         'added_date',
414 
         'removed_date'
1 rodolico 415 
      ),
19 rodolico 416 
      'display query' => 'select device_type_id,name,flags,added_date,removed_date from device_type',
1 rodolico 417 
      'field info' => array(
19 rodolico 418 
         'device_type_id' => array(
419 
            'display name' => 'Device Type Id' ,
1 rodolico 420 
            'keyfield' => true ,
421 
            'required' => true ,
422 
            'readonly' => true ,
423 
            'autoincrement' => true ,
424 
            'type' => 'int' ,
19 rodolico 425 
            'width' => 10
1 rodolico 426 
         ),
427 
         'name' => array(
428 
            'display name' => 'Name' ,
19 rodolico 429 
            'comment' => 'the visible displayed name' ,
1 rodolico 430 
            'required' => true ,
431 
            'type' => 'string' ,
19 rodolico 432 
            'width' => 64
1 rodolico 433 
         ),
19 rodolico 434 
         'flags' => array(
435 
            'display name' => 'Flags' ,
436 
            'comment' => 'flags for this device type' ,
437 
            'default' => 1 ,
438 
            'type' => 'int' ,
1 rodolico 439 
            'width' => 0
440 
         ),
19 rodolico 441 
         'added_date' => array(
442 
            'display name' => 'Added Date' ,
443 
            'comment' => 'date record was added' ,
1 rodolico 444 
            'required' => true ,
19 rodolico 445 
            'type' => 'date' ,
1 rodolico 446 
            'width' => 0
447 
         ),
19 rodolico 448 
         'removed_date' => array(
449 
            'display name' => 'Removed Date' ,
450 
            'comment' => 'date record was deleted/supserceded' ,
1 rodolico 451 
            'required' => false ,
19 rodolico 452 
            'type' => 'date' ,
1 rodolico 453 
            'width' => 0
454 
         )
455 
      )
456 
   ),
19 rodolico 457 
   'alias' => array(
458 
      'table name' => 'alias',
459 
      'display name' => 'Alias',
460 
      'comment' => 'Allows client, site and device to have multiple names',
461 
      'key field' => 'alias_id',
1 rodolico 462 
      'display columns' => array(
19 rodolico 463 
         'alias_id',
464 
         'source',
1 rodolico 465 
         'id',
19 rodolico 466 
         'site',
467 
         'name'
1 rodolico 468 
      ),
19 rodolico 469 
      'display query' => 'select alias_id,source,id,site,name from alias',
1 rodolico 470 
      'field info' => array(
19 rodolico 471 
         'alias_id' => array(
472 
            'display name' => 'Alias Id' ,
1 rodolico 473 
            'keyfield' => true ,
474 
            'required' => true ,
475 
            'readonly' => true ,
476 
            'autoincrement' => true ,
477 
            'type' => 'int' ,
478 
            'width' => 0
479 
         ),
19 rodolico 480 
         'source' => array(
481 
            'display name' => 'Source' ,
482 
            'comment' => 'the table this alias comes from' ,
1 rodolico 483 
            'type' => 'string' ,
484 
            'width' => 64
485 
         ),
19 rodolico 486 
         'id' => array(
487 
            'display name' => 'Id' ,
488 
            'keyfield' => true ,
489 
            'required' => true ,
490 
            'type' => 'int' ,
1 rodolico 491 
            'width' => 0
492 
         ),
19 rodolico 493 
         'site' => array(
494 
            'display name' => 'Site' ,
495 
            'type' => 'or' ,
1 rodolico 496 
            'width' => 0
497 
         ),
19 rodolico 498 
         'name' => array(
499 
            'display name' => 'Name' ,
500 
            'comment' => 'the alias for the device' ,
501 
            'type' => 'string' ,
502 
            'width' => 64
1 rodolico 503 
         )
504 
      )
505 
   ),
19 rodolico 506 
   'client_site' => array(
507 
      'table name' => 'client_site',
508 
      'display name' => 'Client Site',
509 
      'comment' => 'A client owns a site',
510 
      'key field' => 'client_site_id',
1 rodolico 511 
      'display columns' => array(
19 rodolico 512 
         'client_site_id',
513 
         'client_id',
514 
         'site_id',
515 
         'added_date',
516 
         'removed_date'
1 rodolico 517 
      ),
19 rodolico 518 
      'display query' => 'select client_site_id,client_id,site_id,added_date,removed_date from client_site',
1 rodolico 519 
      'field info' => array(
19 rodolico 520 
         'client_site_id' => array(
521 
            'display name' => 'Client Site Id' ,
1 rodolico 522 
            'keyfield' => true ,
523 
            'required' => true ,
524 
            'readonly' => true ,
525 
            'autoincrement' => true ,
526 
            'type' => 'int' ,
527 
            'width' => 0
528 
         ),
19 rodolico 529 
         'client_id' => array(
530 
            'display name' => 'Client Id' ,
1 rodolico 531 
            'type' => 'lookup' ,
19 rodolico 532 
            'table' => 'client' ,
533 
            'keyfield' => 'client_id' ,
1 rodolico 534 
            'display_field' => 'name'
535 
         ),
19 rodolico 536 
         'site_id' => array(
537 
            'display name' => 'Site Id' ,
1 rodolico 538 
            'type' => 'lookup' ,
19 rodolico 539 
            'table' => 'site' ,
540 
            'keyfield' => 'site_id' ,
1 rodolico 541 
            'display_field' => 'name'
542 
         ),
19 rodolico 543 
         'added_date' => array(
544 
            'display name' => 'Added Date' ,
545 
            'comment' => 'Date record added to database' ,
1 rodolico 546 
            'required' => true ,
19 rodolico 547 
            'type' => 'date' ,
1 rodolico 548 
            'width' => 0
549 
         ),
19 rodolico 550 
         'removed_date' => array(
551 
            'display name' => 'Removed Date' ,
552 
            'comment' => 'Date record marked as removed' ,
1 rodolico 553 
            'required' => false ,
19 rodolico 554 
            'type' => 'date' ,
1 rodolico 555 
            'width' => 0
556 
         )
557 
      )
558 
   ),
19 rodolico 559 
   'client_device' => array(
560 
      'table name' => 'client_device',
561 
      'display name' => 'Client Device',
562 
      'comment' => 'Links client and device tables',
563 
      'key field' => 'client_device_id',
1 rodolico 564 
      'display columns' => array(
19 rodolico 565 
         'client_device_id',
566 
         'client_id',
1 rodolico 567 
         'device_id',
19 rodolico 568 
         'added_date',
569 
         'removed_date'
1 rodolico 570 
      ),
19 rodolico 571 
      'display query' => 'select client_device_id,client_id,device_id,added_date,removed_date from client_device',
1 rodolico 572 
      'field info' => array(
19 rodolico 573 
         'client_device_id' => array(
574 
            'display name' => 'Client Device Id' ,
1 rodolico 575 
            'keyfield' => true ,
576 
            'required' => true ,
577 
            'readonly' => true ,
578 
            'autoincrement' => true ,
579 
            'type' => 'int' ,
580 
            'width' => 0
581 
         ),
19 rodolico 582 
         'client_id' => array(
583 
            'display name' => 'Client Id' ,
1 rodolico 584 
            'type' => 'lookup' ,
19 rodolico 585 
            'table' => 'client' ,
586 
            'keyfield' => 'client_id' ,
1 rodolico 587 
            'display_field' => 'name'
588 
         ),
589 
         'device_id' => array(
590 
            'display name' => 'Device Id' ,
591 
            'type' => 'lookup' ,
19 rodolico 592 
            'table' => 'device' ,
593 
            'keyfield' => 'device_id' ,
1 rodolico 594 
            'display_field' => 'name'
595 
         ),
19 rodolico 596 
         'added_date' => array(
597 
            'display name' => 'Added Date' ,
598 
            'comment' => 'Date record added to database' ,
1 rodolico 599 
            'required' => true ,
19 rodolico 600 
            'type' => 'date' ,
1 rodolico 601 
            'width' => 0
602 
         ),
19 rodolico 603 
         'removed_date' => array(
604 
            'display name' => 'Removed Date' ,
605 
            'comment' => 'Date record marked as removed' ,
1 rodolico 606 
            'required' => false ,
19 rodolico 607 
            'type' => 'date' ,
1 rodolico 608 
            'width' => 0
609 
         )
610 
      )
611 
   ),
19 rodolico 612 
   'site_device' => array(
613 
      'table name' => 'site_device',
614 
      'display name' => 'Site Device',
615 
      'comment' => 'Links site and device tables',
616 
      'key field' => ' site_device_id ',
1 rodolico 617 
      'display columns' => array(
19 rodolico 618 
         'site_device_id',
619 
         'site_id',
620 
         'device_id',
621 
         'added_date',
622 
         'removed_date'
1 rodolico 623 
      ),
19 rodolico 624 
      'display query' => 'select site_device_id,site_id,device_id,added_date,removed_date from site_device',
1 rodolico 625 
      'field info' => array(
19 rodolico 626 
         'site_device_id' => array(
627 
            'display name' => 'Site Device Id' ,
1 rodolico 628 
            'keyfield' => true ,
629 
            'required' => true ,
630 
            'readonly' => true ,
631 
            'autoincrement' => true ,
632 
            'type' => 'int' ,
633 
            'width' => 0
634 
         ),
19 rodolico 635 
         'site_id' => array(
636 
            'display name' => 'Site Id' ,
637 
            'type' => 'lookup' ,
638 
            'table' => 'site' ,
639 
            'keyfield' => 'site_id' ,
640 
            'display_field' => 'name'
641 
         ),
642 
         'device_id' => array(
643 
            'display name' => 'Device Id' ,
644 
            'type' => 'lookup' ,
645 
            'table' => 'device' ,
646 
            'keyfield' => 'device_id' ,
647 
            'display_field' => 'name'
648 
         ),
649 
         'added_date' => array(
650 
            'display name' => 'Added Date' ,
651 
            'comment' => 'Date record added to database' ,
1 rodolico 652 
            'required' => true ,
19 rodolico 653 
            'type' => 'date' ,
654 
            'width' => 0
1 rodolico 655 
         ),
19 rodolico 656 
         'removed_date' => array(
657 
            'display name' => 'Removed Date' ,
658 
            'comment' => 'Date record marked as removed' ,
659 
            'required' => false ,
660 
            'type' => 'date' ,
661 
            'width' => 0
1 rodolico 662 
         )
663 
      )
664 
   )
665 
);
19 rodolico 666 
include('DatabaseDefinition.local.php');
1 rodolico 667 
?>