forum_schema()
Implements hook_schema().
File
- core/modules/forum/forum.install, line 63
- Install, update, and uninstall functions for the Forum module.
Code
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 | function forum_schema() { $schema['forum'] = array( 'description' => 'Stores the relationship of nodes to forum terms.', 'fields' => array( 'nid' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0, 'description' => 'The {node}.nid of the node.', ), 'vid' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0, 'description' => 'Primary Key: The {node}.vid of the node.', ), 'tid' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0, 'description' => 'The {taxonomy_term_data}.tid of the forum term assigned to the node.', ), ), 'indexes' => array( 'forum_topic' => array('nid', 'tid'), 'tid' => array('tid'), ), 'primary key' => array('vid'), 'foreign keys' => array( 'forum_node' => array( 'table' => 'node', 'columns' => array( 'nid' => 'nid', 'vid' => 'vid', ), ), ), ); $schema['forum_index'] = array( 'description' => 'Maintains denormalized information about node/term relationships.', 'fields' => array( 'nid' => array( 'description' => 'The {node}.nid this record tracks.', 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0, ), 'title' => array( 'description' => 'The node title.', 'type' => 'varchar', 'length' => 255, 'not null' => TRUE, 'default' => '', ), 'tid' => array( 'description' => 'The term ID.', 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0, ), 'sticky' => array( 'description' => 'Boolean indicating whether the node is sticky.', 'type' => 'int', 'not null' => FALSE, 'default' => 0, 'size' => 'tiny', ), 'created' => array( 'description' => 'The Unix timestamp when the node was created.', 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0, ), 'last_comment_timestamp' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, 'description' => 'The Unix timestamp of the last comment that was posted within this node, from {comment}.timestamp.', ), 'comment_count' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0, 'description' => 'The total number of comments on this node.', ), ), 'indexes' => array( 'forum_topics' => array('nid', 'tid', 'sticky', 'last_comment_timestamp'), 'created' => array('created'), 'last_comment_timestamp' => array('last_comment_timestamp'), ), 'foreign keys' => array( 'tracked_node' => array( 'table' => 'node', 'columns' => array('nid' => 'nid'), ), 'term' => array( 'table' => 'taxonomy_term_data', 'columns' => array( 'tid' => 'tid', ), ), ), ); return $schema;} |
Please login to continue.