| 1 |
<?php |
<?php |
| 2 |
// $Id: views.schema,v 1.2 2007/08/12 23:50:08 merlinofchaos Exp $ |
// $Id: views.schema,v 1.3 2007/08/19 23:29:50 merlinofchaos Exp $ |
| 3 |
/** |
/** |
| 4 |
* @file views.schema |
* @file views.schema |
| 5 |
* Defines the schema for tables used in Views. |
* Defines the schema for tables used in Views. |
| 54 |
'unique key' => array('name' => array('name')), |
'unique key' => array('name' => array('name')), |
| 55 |
); |
); |
| 56 |
|
|
| 57 |
$schema['views_displays'] = array( |
$schema['views_display'] = array( |
| 58 |
'description' => t('Stores information about each display attached to a view.'), |
'description' => t('Stores information about each display attached to a view.'), |
| 59 |
'fields' => array( |
'fields' => array( |
| 60 |
'vid' => array( |
'vid' => array( |
| 64 |
'default' => 0, |
'default' => 0, |
| 65 |
'description' => t('The view this display is attached to.'), |
'description' => t('The view this display is attached to.'), |
| 66 |
), |
), |
| 67 |
'type' => array( |
'display_plugin' => array( |
| 68 |
'type' => 'varchar', |
'type' => 'varchar', |
| 69 |
'length' => '64', |
'length' => '64', |
| 70 |
'default' => '', |
'default' => '', |
| 71 |
'not null' => TRUE, |
'not null' => TRUE, |
| 72 |
'description' => t('The type of the display. Usually page, block or embed, but is pluggable so may be other things.'), |
'description' => t('The type of the display. Usually page, block or embed, but is pluggable so may be other things.'), |
| 73 |
), |
), |
| 74 |
|
'id' => array( |
| 75 |
|
'type' => 'varchar', |
| 76 |
|
'length' => '64', |
| 77 |
|
'default' => '', |
| 78 |
|
'not null' => TRUE, |
| 79 |
|
'description' => t('An identifier for this display; usually generated from the display_plugin, so should be something like page or page_1 or block_2, etc.'), |
| 80 |
|
), |
| 81 |
'access' => array( |
'access' => array( |
| 82 |
'type' => 'varchar', |
'type' => 'varchar', |
| 83 |
'length' => 255, |
'length' => 255, |
| 84 |
'description' => t('A serialized array describing who can access this display of the view.'), |
'description' => t('A serialized array describing who can access this display of the view.'), |
| 85 |
'serialize' => TRUE, |
'serialize' => TRUE, |
| 86 |
), |
), |
| 87 |
'output_type' => array( |
'style_plugin' => array( |
| 88 |
'type' => 'varchar', |
'type' => 'varchar', |
| 89 |
'length' => '64', |
'length' => '64', |
| 90 |
'default' => '', |
'default' => '', |
| 152 |
), |
), |
| 153 |
'display_options' => array( |
'display_options' => array( |
| 154 |
'type' => 'blob', |
'type' => 'blob', |
| 155 |
'description' => t('A serialized array of options for this display; it contains options that are generally only pertinent to that display type.'), |
'description' => t('A serialized array of options for this display; it contains options that are generally only pertinent to that display plugin type.'), |
| 156 |
'serialize' => TRUE, |
'serialize' => TRUE, |
| 157 |
), |
), |
| 158 |
'output_options' => array( |
'style_options' => array( |
| 159 |
'type' => 'blob', |
'type' => 'blob', |
| 160 |
'description' => t('A serialized array of options for this display\'s output type; it contains options that are generally only pertinent to that type.'), |
'description' => t('A serialized array of options for this display\'s style plugin; it contains options that are generally only pertinent to that type.'), |
| 161 |
'serialize' => TRUE, |
'serialize' => TRUE, |
| 162 |
), |
), |
| 163 |
'filter_options' => array( |
'filter_options' => array( |
| 169 |
'indexes' => array('vid' => array('vid', 'position')), |
'indexes' => array('vid' => array('vid', 'position')), |
| 170 |
); |
); |
| 171 |
|
|
| 172 |
$schema['views_arguments'] = array( |
$schema['views_argument'] = array( |
| 173 |
'description' => t('Stores information about each argument attached to a view.'), |
'description' => t('Stores information about each argument attached to a view.'), |
| 174 |
'fields' => array( |
'fields' => array( |
| 175 |
'vid' => array( |
'vid' => array( |
| 184 |
'default' => 0, |
'default' => 0, |
| 185 |
'description' => t('The order in which this information is loaded.'), |
'description' => t('The order in which this information is loaded.'), |
| 186 |
), |
), |
| 187 |
'table' => array( |
'tablename' => array( |
| 188 |
'type' => 'varchar', |
'type' => 'varchar', |
| 189 |
'length' => '255', |
'length' => '255', |
| 190 |
'description' => t('The name of the table this field is attached to.'), |
'description' => t('The name of the table this field is attached to.'), |
| 206 |
'not null' => TRUE, |
'not null' => TRUE, |
| 207 |
'description' => t('The type of the display. Usually page, block or embed, but is pluggable so may be other things.'), |
'description' => t('The type of the display. Usually page, block or embed, but is pluggable so may be other things.'), |
| 208 |
), |
), |
| 209 |
|
'style' => array( |
| 210 |
|
'type' => 'varchar', |
| 211 |
|
'length' => '64', |
| 212 |
|
'default' => '', |
| 213 |
|
'not null' => TRUE, |
| 214 |
|
'description' => t('The type of the display. Usually page, block or embed, but is pluggable so may be other things.'), |
| 215 |
|
), |
| 216 |
'default_action' => array( |
'default_action' => array( |
| 217 |
'type' => 'varchar', |
'type' => 'varchar', |
| 218 |
'length' => '32', |
'length' => '32', |
| 248 |
'indexes' => array('vid' => array('vid', 'position')), |
'indexes' => array('vid' => array('vid', 'position')), |
| 249 |
); |
); |
| 250 |
|
|
| 251 |
$schema['views_fields'] = array( |
$schema['views_field'] = array( |
| 252 |
'description' => t('Stores information about each field attached to a view.'), |
'description' => t('Stores information about each field attached to a view.'), |
| 253 |
'fields' => array( |
'fields' => array( |
| 254 |
'vid' => array( |
'vid' => array( |
| 263 |
'default' => 0, |
'default' => 0, |
| 264 |
'description' => t('The order in which this information is loaded.'), |
'description' => t('The order in which this information is loaded.'), |
| 265 |
), |
), |
| 266 |
'table' => array( |
'display_id' => array( |
| 267 |
|
'type' => 'int', |
| 268 |
|
'default' => 0, |
| 269 |
|
'description' => t('The display for which these fields are valid.'), |
| 270 |
|
), |
| 271 |
|
'tablename' => array( |
| 272 |
'type' => 'varchar', |
'type' => 'varchar', |
| 273 |
'length' => '255', |
'length' => '255', |
| 274 |
'description' => t('The name of the table this field is attached to.'), |
'description' => t('The name of the table this field is attached to.'), |
| 292 |
'indexes' => array('vid' => array('vid', 'position')), |
'indexes' => array('vid' => array('vid', 'position')), |
| 293 |
); |
); |
| 294 |
|
|
| 295 |
$schema['views_sorts'] = array( |
$schema['views_sort'] = array( |
| 296 |
'description' => t('Stores information about each sort criterion attached to a view.'), |
'description' => t('Stores information about each sort criterion attached to a view.'), |
| 297 |
'fields' => array( |
'fields' => array( |
| 298 |
'vid' => array( |
'vid' => array( |
| 307 |
'default' => 0, |
'default' => 0, |
| 308 |
'description' => t('The order in which this information is loaded.'), |
'description' => t('The order in which this information is loaded.'), |
| 309 |
), |
), |
| 310 |
'table' => array( |
'tablename' => array( |
| 311 |
'type' => 'varchar', |
'type' => 'varchar', |
| 312 |
'length' => '255', |
'length' => '255', |
| 313 |
'description' => t('The name of the table this field is attached to.'), |
'description' => t('The name of the table this field is attached to.'), |
| 347 |
'indexes' => array('vid' => array('vid', 'position')), |
'indexes' => array('vid' => array('vid', 'position')), |
| 348 |
); |
); |
| 349 |
|
|
| 350 |
$schema['views_filters'] = array( |
$schema['views_filter'] = array( |
| 351 |
'description' => t('Stores information about each filter attached to a view.'), |
'description' => t('Stores information about each filter attached to a view.'), |
| 352 |
'fields' => array( |
'fields' => array( |
| 353 |
'vid' => array( |
'vid' => array( |
| 367 |
'default' => 0, |
'default' => 0, |
| 368 |
'description' => t('Which filter group this filter belongs to, so that AND and OR can be separated properly.'), |
'description' => t('Which filter group this filter belongs to, so that AND and OR can be separated properly.'), |
| 369 |
), |
), |
| 370 |
'table' => array( |
'tablename' => array( |
| 371 |
'type' => 'varchar', |
'type' => 'varchar', |
| 372 |
'length' => '255', |
'length' => '255', |
| 373 |
'description' => t('The name of the table this field is attached to.'), |
'description' => t('The name of the table this field is attached to.'), |
| 413 |
'indexes' => array('vid' => array('vid', 'position')), |
'indexes' => array('vid' => array('vid', 'position')), |
| 414 |
); |
); |
| 415 |
|
|
| 416 |
$schema['views_relationships'] = array( |
$schema['views_relationship'] = array( |
| 417 |
'description' => t('Stores information about each filter attached to a view.'), |
'description' => t('Stores information about each filter attached to a view.'), |
| 418 |
'fields' => array( |
'fields' => array( |
| 419 |
'vid' => array( |
'vid' => array( |