|
1 <?php |
|
2 // $Id: poll.install,v 1.13.2.1 2009/01/06 15:46:37 goba Exp $ |
|
3 |
|
4 /** |
|
5 * Implementation of hook_install(). |
|
6 */ |
|
7 function poll_install() { |
|
8 // Create tables. |
|
9 drupal_install_schema('poll'); |
|
10 } |
|
11 |
|
12 /** |
|
13 * Implementation of hook_uninstall(). |
|
14 */ |
|
15 function poll_uninstall() { |
|
16 // Remove tables. |
|
17 drupal_uninstall_schema('poll'); |
|
18 } |
|
19 |
|
20 /** |
|
21 * Implementation of hook_schema(). |
|
22 */ |
|
23 function poll_schema() { |
|
24 $schema['poll'] = array( |
|
25 'description' => 'Stores poll-specific information for poll nodes.', |
|
26 'fields' => array( |
|
27 'nid' => array( |
|
28 'type' => 'int', |
|
29 'unsigned' => TRUE, |
|
30 'not null' => TRUE, |
|
31 'default' => 0, |
|
32 'description' => "The poll's {node}.nid." |
|
33 ), |
|
34 'runtime' => array( |
|
35 'type' => 'int', |
|
36 'not null' => TRUE, |
|
37 'default' => 0, |
|
38 'description' => 'The number of seconds past {node}.created during which the poll is open.' |
|
39 ), |
|
40 'active' => array( |
|
41 'type' => 'int', |
|
42 'unsigned' => TRUE, |
|
43 'not null' => TRUE, |
|
44 'default' => 0, |
|
45 'description' => 'Boolean indicating whether or not the poll is open.', |
|
46 ), |
|
47 ), |
|
48 'primary key' => array('nid'), |
|
49 ); |
|
50 |
|
51 $schema['poll_choices'] = array( |
|
52 'description' => 'Stores information about all choices for all {poll}s.', |
|
53 'fields' => array( |
|
54 'chid' => array( |
|
55 'type' => 'serial', |
|
56 'unsigned' => TRUE, |
|
57 'not null' => TRUE, |
|
58 'description' => 'Unique identifier for a poll choice.', |
|
59 ), |
|
60 'nid' => array( |
|
61 'type' => 'int', |
|
62 'unsigned' => TRUE, |
|
63 'not null' => TRUE, |
|
64 'default' => 0, |
|
65 'description' => 'The {node}.nid this choice belongs to.', |
|
66 ), |
|
67 'chtext' => array( |
|
68 'type' => 'varchar', |
|
69 'length' => 128, |
|
70 'not null' => TRUE, |
|
71 'default' => '', |
|
72 'description' => 'The text for this choice.', |
|
73 ), |
|
74 'chvotes' => array( |
|
75 'type' => 'int', |
|
76 'not null' => TRUE, |
|
77 'default' => 0, |
|
78 'description' => 'The total number of votes this choice has received by all users.', |
|
79 ), |
|
80 'chorder' => array( |
|
81 'type' => 'int', |
|
82 'not null' => TRUE, |
|
83 'default' => 0, |
|
84 'description' => 'The sort order of this choice among all choices for the same node.', |
|
85 ) |
|
86 ), |
|
87 'indexes' => array( |
|
88 'nid' => array('nid') |
|
89 ), |
|
90 'primary key' => array('chid'), |
|
91 ); |
|
92 |
|
93 $schema['poll_votes'] = array( |
|
94 'description' => 'Stores per-{users} votes for each {poll}.', |
|
95 'fields' => array( |
|
96 'nid' => array( |
|
97 'type' => 'int', |
|
98 'unsigned' => TRUE, |
|
99 'not null' => TRUE, |
|
100 'description' => 'The {poll} node this vote is for.', |
|
101 ), |
|
102 'uid' => array( |
|
103 'type' => 'int', |
|
104 'unsigned' => TRUE, |
|
105 'not null' => TRUE, |
|
106 'default' => 0, |
|
107 'description' => 'The {users}.uid this vote is from unless the voter was anonymous.', |
|
108 ), |
|
109 'chorder' => array( |
|
110 'type' => 'int', |
|
111 'not null' => TRUE, |
|
112 'default' => -1, |
|
113 'description' => "The {users}'s vote for this poll.", |
|
114 ), |
|
115 'hostname' => array( |
|
116 'type' => 'varchar', |
|
117 'length' => 128, |
|
118 'not null' => TRUE, |
|
119 'default' => '', |
|
120 'description' => 'The IP address this vote is from unless the voter was logged in.', |
|
121 ), |
|
122 ), |
|
123 'primary key' => array('nid', 'uid', 'hostname'), |
|
124 'indexes' => array( |
|
125 'hostname' => array('hostname'), |
|
126 'uid' => array('uid'), |
|
127 ), |
|
128 ); |
|
129 |
|
130 return $schema; |
|
131 } |
|
132 |