Mercurial > hg > rr-repo

comparison modules/simpletest/tests/upgrade/drupal-6.forum.database.php @ 0:ff03f76ab3fe

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
initial version
author danieleb <danielebarchiesi@me.com>
date Wed, 21 Aug 2013 18:51:11 +0100
parents
children
comparison
equal deleted inserted replaced
-1:000000000000 0:ff03f76ab3fe
1 <?php
2
3 /**
4 * Database additions for forum tests.
5 */
6
7 db_create_table('forum', array(
8 'fields' => array(
9 'nid' => array(
10 'type' => 'int',
11 'unsigned' => TRUE,
12 'not null' => TRUE,
13 'default' => 0,
14 ),
15 'vid' => array(
16 'type' => 'int',
17 'unsigned' => TRUE,
18 'not null' => TRUE,
19 'default' => 0,
20 ),
21 'tid' => array(
22 'type' => 'int',
23 'unsigned' => TRUE,
24 'not null' => TRUE,
25 'default' => 0,
26 ),
27 ),
28 'indexes' => array(
29 'nid' => array(
30 'nid',
31 ),
32 'tid' => array(
33 'tid',
34 ),
35 ),
36 'primary key' => array(
37 'vid',
38 ),
39 'module' => 'forum',
40 'name' => 'forum',
41 ));
42 db_insert('forum')->fields(array(
43 'nid',
44 'vid',
45 'tid',
46 ))
47 ->values(array(
48 'nid' => '51',
49 'vid' => '61',
50 'tid' => '81',
51 ))
52 ->execute();
53
54 db_insert('node')->fields(array(
55 'nid',
56 'vid',
57 'type',
58 'language',
59 'title',
60 'uid',
61 'status',
62 'created',
63 'changed',
64 'comment',
65 'promote',
66 'moderate',
67 'sticky',
68 'tnid',
69 'translate',
70 ))
71 ->values(array(
72 'nid' => '51',
73 'vid' => '61',
74 'type' => 'forum',
75 'language' => '',
76 'title' => 'Apples',
77 'uid' => '1',
78 'status' => '1',
79 'created' => '1298363952',
80 'changed' => '1298363952',
81 'comment' => '2',
82 'promote' => '0',
83 'moderate' => '0',
84 'sticky' => '0',
85 'tnid' => '0',
86 'translate' => '0',
87 ))
88 ->execute();
89
90 db_insert('node_revisions')->fields(array(
91 'nid',
92 'vid',
93 'uid',
94 'title',
95 'body',
96 'teaser',
97 'log',
98 'timestamp',
99 'format',
100 ))
101 ->values(array(
102 'nid' => '51',
103 'vid' => '61',
104 'uid' => '1',
105 'title' => 'Apples',
106 'body' => 'A fruit.',
107 'teaser' => 'A fruit.',
108 'log' => '',
109 'timestamp' => '1298363952',
110 'format' => '1',
111 ))
112 ->execute();
113
114 db_insert('node_comment_statistics')->fields(array(
115 'nid',
116 'last_comment_timestamp',
117 'last_comment_name',
118 'last_comment_uid',
119 'comment_count',
120 ))
121 ->values(array(
122 'nid' => '51',
123 'last_comment_timestamp' => '1298363952',
124 'last_comment_name' => NULL,
125 'last_comment_uid' => '1',
126 'comment_count' => '0',
127 ))
128 ->execute();
129
130 db_insert('node_type')->fields(array(
131 'type',
132 'name',
133 'module',
134 'description',
135 'help',
136 'has_title',
137 'title_label',
138 'has_body',
139 'body_label',
140 'min_word_count',
141 'custom',
142 'modified',
143 'locked',
144 'orig_type',
145 ))
146 ->values(array(
147 'type' => 'forum',
148 'name' => 'Forum topic',
149 'module' => 'forum',
150 'description' => 'A <em>forum topic</em> is the initial post to a new discussion thread within a forum.',
151 'help' => '',
152 'has_title' => '1',
153 'title_label' => 'Subject',
154 'has_body' => '1',
155 'body_label' => 'Body',
156 'min_word_count' => '0',
157 'custom' => '0',
158 'modified' => '0',
159 'locked' => '1',
160 'orig_type' => 'forum',
161 ))
162 ->execute();
163
164 db_update('system')->fields(array(
165 'schema_version' => '6000',
166 'status' => '1',
167 ))
168 ->condition('filename', 'modules/forum/forum.module')
169 ->execute();
170
171 db_insert('term_data')->fields(array(
172 'tid',
173 'vid',
174 'name',
175 'description',
176 'weight',
177 ))
178 ->values(array(
179 'tid' => '81',
180 'vid' => '101',
181 'name' => 'Fruits',
182 'description' => 'Fruits.',
183 'weight' => '0',
184 ))
185 ->execute();
186
187 db_insert('term_hierarchy')->fields(array(
188 'tid',
189 'parent',
190 ))
191 ->values(array(
192 'tid' => '81',
193 'parent' => '0',
194 ))
195 ->execute();
196
197 db_insert('term_node')->fields(array(
198 'nid',
199 'vid',
200 'tid',
201 ))
202 ->values(array(
203 'nid' => '51',
204 'vid' => '61',
205 'tid' => '81',
206 ))
207 ->execute();
208
209 db_insert('variable')->fields(array(
210 'name',
211 'value',
212 ))
213 ->values(array(
214 'name' => 'forum_nav_vocabulary',
215 'value' => 's:3:"101";',
216 ))
217 ->values(array(
218 'name' => 'forum_containers',
219 'value' => 'a:1:{i:0;s:3:"101";}',
220 ))
221 ->execute();
222
223 db_insert('vocabulary')->fields(array(
224 'vid',
225 'name',
226 'description',
227 'help',
228 'relations',
229 'hierarchy',
230 'multiple',
231 'required',
232 'tags',
233 'module',
234 'weight',
235 ))
236 ->values(array(
237 'vid' => '101',
238 'name' => 'Upgrade test for forums',
239 'description' => 'Vocabulary used for Forums. The name is changed from the default "Forums" so that the upgrade path may be tested.',
240 'help' => '',
241 'relations' => '1',
242 'hierarchy' => '1',
243 'multiple' => '0',
244 'required' => '0',
245 'tags' => '0',
246 'module' => 'forum',
247 'weight' => '-10',
248 ))
249 ->execute();
250
251 db_insert('vocabulary_node_types')->fields(array(
252 'vid',
253 'type',
254 ))
255 ->values(array(
256 'vid' => '101',
257 'type' => 'forum',
258 ))
259 ->execute();
260
261 // Provide all users with the ability to create forum topics.
262 $results = db_select('permission', 'p')
263 ->fields('p')
264 ->execute();
265
266 foreach ($results as $result) {
267 $permissions = $result->perm . ', create forum topics';
268 db_update('permission')
269 ->fields(array(
270 'perm' => $permissions,
271 ))
272 ->condition('rid', $result->rid)
273 ->execute();
274 }