Chris@0: /**
Chris@0:  * Implements hook_schema().
Chris@0:  */
Chris@0: function {{ machine_name }}_schema() {
Chris@0:   $schema['node'] = [
Chris@0:     // Example (partial) specification for table "node".
Chris@0:     'description' => 'The base table for nodes.',
Chris@0:     'fields' => [
Chris@0:       'nid' => [
Chris@0:         'description' => 'The primary identifier for a node.',
Chris@0:         'type' => 'serial',
Chris@0:         'unsigned' => TRUE,
Chris@0:         'not null' => TRUE,
Chris@0:       ],
Chris@0:       'vid' => [
Chris@0:         'description' => 'The current {node_field_revision}.vid version identifier.',
Chris@0:         'type' => 'int',
Chris@0:         'unsigned' => TRUE,
Chris@0:         'not null' => TRUE,
Chris@0:         'default' => 0,
Chris@0:       ],
Chris@0:       'type' => [
Chris@0:         'description' => 'The type of this node.',
Chris@0:         'type' => 'varchar',
Chris@0:         'length' => 32,
Chris@0:         'not null' => TRUE,
Chris@0:         'default' => '',
Chris@0:       ],
Chris@0:       'title' => [
Chris@0:         'description' => 'The node title.',
Chris@0:         'type' => 'varchar',
Chris@0:         'length' => 255,
Chris@0:         'not null' => TRUE,
Chris@0:         'default' => '',
Chris@0:       ],
Chris@0:     ],
Chris@0:     'indexes' => [
Chris@0:       'node_changed'        => ['changed'],
Chris@0:       'node_created'        => ['created'],
Chris@0:     ],
Chris@0:     'unique keys' => [
Chris@0:       'nid_vid' => ['nid', 'vid'],
Chris@0:       'vid'     => ['vid'],
Chris@0:     ],
Chris@0:     // For documentation purposes only; foreign keys are not created in the
Chris@0:     // database.
Chris@0:     'foreign keys' => [
Chris@0:       'node_revision' => [
Chris@0:         'table' => 'node_field_revision',
Chris@0:         'columns' => ['vid' => 'vid'],
Chris@0:       ],
Chris@0:       'node_author' => [
Chris@0:         'table' => 'users',
Chris@0:         'columns' => ['uid' => 'uid'],
Chris@0:       ],
Chris@0:     ],
Chris@0:     'primary key' => ['nid'],
Chris@0:   ];
Chris@0:   return $schema;
Chris@0: }