Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | -- +--------------------------------------------------------------------+ |
2 | -- | CiviCRM version 3.2 | | |
3 | -- +--------------------------------------------------------------------+ | |
4 | -- | Copyright CiviCRM LLC (c) 2004-2010 | | |
5 | -- +--------------------------------------------------------------------+ | |
6 | -- | This file is a part of CiviCRM. | | |
7 | -- | | | |
8 | -- | CiviCRM is free software; you can copy, modify, and distribute it | | |
9 | -- | under the terms of the GNU Affero General Public License | | |
10 | -- | Version 3, 19 November 2007 and the CiviCRM Licensing Exception. | | |
11 | -- | | | |
12 | -- | CiviCRM is distributed in the hope that it will be useful, but | | |
13 | -- | WITHOUT ANY WARRANTY; without even the implied warranty of | | |
14 | -- | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. | | |
15 | -- | See the GNU Affero General Public License for more details. | | |
16 | -- | | | |
17 | -- | You should have received a copy of the GNU Affero General Public | | |
18 | -- | License and the CiviCRM Licensing Exception along | | |
19 | -- | with this program; if not, contact CiviCRM LLC | | |
20 | -- | at info[AT]civicrm[DOT]org. If you have questions about the | | |
21 | -- | GNU Affero General Public License or the licensing of CiviCRM, | | |
22 | -- | see the CiviCRM license FAQ at http://civicrm.org/licensing | | |
23 | -- +--------------------------------------------------------------------+ | |
24 | -- /******************************************************* | |
25 | -- * | |
26 | -- * adding of new tables | |
27 | -- * | |
28 | -- *******************************************************/ | |
29 | ||
30 | -- /******************************************************* | |
31 | -- * | |
32 | -- * civicrm_event | |
33 | -- * | |
34 | -- *******************************************************/ | |
35 | CREATE TABLE civicrm_event ( | |
36 | id int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Event', | |
37 | domain_id int unsigned NOT NULL DEFAULT 0 COMMENT 'Event belongs to which Domain?', | |
38 | title varchar(255) COMMENT 'Event Title (e.g. Fall Fundraiser Dinner)', | |
39 | summary text COMMENT 'Brief summary of event. Text and html allowed. Displayed on Event Registration form and can be used on other CMS pages which need an event summary.', | |
40 | description text COMMENT 'Full description of event. Text and html allowed. Displayed on built-in Event Information screens.', | |
41 | event_type_id int unsigned DEFAULT 0 COMMENT 'Event Type ID.Implicit FK to civicrm_option_value where option_group = event_type.', | |
42 | is_public tinyint DEFAULT 1 COMMENT 'Public events will be included in the iCal feeds. Access to private event information may be limited using ACLs.', | |
43 | start_date datetime COMMENT 'Date and time that event starts.', | |
44 | end_date datetime COMMENT 'Date and time that event ends. May be NULL if no defined end date/time', | |
45 | is_online_registration tinyint DEFAULT 0 COMMENT 'If true, include registration link on Event Info page.', | |
46 | registration_link_text varchar(255) COMMENT 'Text for link to Event Registration form which is displayed on Event Information screen when is_online_registration is true.', | |
47 | max_participants int unsigned DEFAULT 0 COMMENT 'Maximum number of registered participants to allow. After max is reached, a custom Event Full message is displayed. If NULL, allow unlimited number of participants.', | |
48 | event_full_text text COMMENT 'Message to display on Event Information page and INSTEAD OF Event Registration form if maximum participants are signed up. Can include email address/info about getting on a waiting list, etc. Text and html allowed.', | |
49 | is_monetary tinyint DEFAULT 0 COMMENT 'Is this a PAID event? If true, one or more fee amounts must be set and a Payment Processor must be configured for Online Event Registration.', | |
50 | contribution_type_id int unsigned DEFAULT 0 COMMENT 'Contribution type assigned to paid event registrations for this event. Required if is_monetary is true.', | |
51 | is_map tinyint DEFAULT 0 COMMENT 'Include a map block on the Event Information page when geocode info is available and a mapping provider has been specified?', | |
52 | is_active tinyint DEFAULT 0 COMMENT 'Is this Event enabled or disabled/cancelled?' | |
53 | , | |
54 | PRIMARY KEY ( id ) | |
55 | , | |
56 | CONSTRAINT FK_civicrm_event_domain_id FOREIGN KEY (domain_id) REFERENCES civicrm_domain(id) | |
57 | ||
58 | ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ; | |
59 | ||
60 | -- /******************************************************* | |
61 | -- * | |
62 | -- * civicrm_event_page | |
63 | -- * | |
64 | -- *******************************************************/ | |
65 | CREATE TABLE civicrm_event_page ( | |
66 | ||
67 | ||
68 | id int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Event Page ID', | |
69 | event_id int unsigned NOT NULL COMMENT 'Event which this page belongs to.', | |
70 | intro_text text COMMENT 'Introductory message for Event Registration page. Text and html allowed. Displayed at the top of Event Registration form.', | |
71 | footer_text text COMMENT 'Footer message for Event Registration page. Text and html allowed. Displayed at the bottom of Event Registration form.', | |
72 | confirm_title varchar(255) DEFAULT NULL COMMENT 'Title for Confirmation page.', | |
73 | confirm_text text COMMENT 'Introductory message for Event Registration page. Text and html allowed. Displayed at the top of Event Registration form.', | |
74 | confirm_footer_text text COMMENT 'Footer message for Event Registration page. Text and html allowed. Displayed at the bottom of Event Registration form.', | |
75 | is_email_confirm tinyint DEFAULT 1 COMMENT 'If true, confirmation is automatically emailed to contact on successful registration.', | |
76 | confirm_email_text text COMMENT 'text to include above standard event info on confirmation email. emails are text-only, so do not allow html for now', | |
77 | confirm_from_name varchar(255) COMMENT 'FROM email name used for confirmation emails.', | |
78 | confirm_from_email varchar(255) COMMENT 'FROM email address used for confirmation emails.', | |
79 | cc_confirm varchar(255) COMMENT 'comma-separated list of email addresses to cc each time a confirmation is sent', | |
80 | bcc_confirm varchar(255) COMMENT 'comma-separated list of email addresses to bcc each time a confirmation is sent', | |
81 | default_fee_id int unsigned NOT NULL COMMENT 'FK to civicrm_custom_option.', | |
82 | thankyou_title varchar(255) DEFAULT NULL COMMENT 'Title for ThankYou page.', | |
83 | thankyou_text text COMMENT 'ThankYou Text.', | |
84 | thankyou_footer_text text COMMENT 'Footer message.' | |
85 | , | |
86 | PRIMARY KEY ( id ) | |
87 | ||
88 | ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ; | |
89 | ||
90 | -- /******************************************************* | |
91 | -- * | |
92 | -- * civicrm_participant | |
93 | -- * | |
94 | -- *******************************************************/ | |
95 | CREATE TABLE civicrm_participant ( | |
96 | ||
97 | ||
98 | id int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Participant Id', | |
99 | contact_id int unsigned DEFAULT 0 COMMENT 'FK to Contact ID', | |
100 | event_id int unsigned DEFAULT 0 COMMENT 'FK to Event ID', | |
101 | status_id int unsigned DEFAULT 1 COMMENT 'Participant status ID. Implicit FK to civicrm_option_value where option_group = participant_status. Default of 1 should map to status = Registered.', | |
102 | role_id int unsigned DEFAULT NULL COMMENT 'Participant role ID. Implicit FK to civicrm_option_value where option_group = participant_role.', | |
103 | register_date datetime COMMENT 'When did contact register for event?', | |
104 | source varchar(128) COMMENT 'Source of this event registration.', | |
105 | event_level varchar(255) COMMENT 'Populate with the label (text) associated with a fee level for paid events with multiple levels. Note that we store the label value rather than an FK as the label stored in custom_option may change, but we dont want that to change the label in place at time of this registration.', | |
106 | is_test tinyint DEFAULT 0 | |
107 | , | |
108 | PRIMARY KEY ( id ) | |
109 | , | |
110 | CONSTRAINT FK_civicrm_participant_contact_id FOREIGN KEY (contact_id) REFERENCES civicrm_contact(id) | |
111 | , | |
112 | CONSTRAINT FK_civicrm_participant_event_id FOREIGN KEY (event_id) REFERENCES civicrm_event(id) | |
113 | ||
114 | ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ; | |
115 | ||
116 | -- /******************************************************* | |
117 | -- * | |
118 | -- * civicrm_participant_payment | |
119 | -- * | |
120 | -- *******************************************************/ | |
121 | CREATE TABLE civicrm_participant_payment ( | |
122 | ||
123 | ||
124 | id int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Participant Payment Id', | |
125 | participant_id int unsigned NOT NULL COMMENT 'Participant Id (FK)', | |
126 | payment_entity_table varchar(128) COMMENT 'Table being referenced for payment entity (expected usage is civicrm_contribution).', | |
127 | payment_entity_id int unsigned NOT NULL COMMENT 'FK to table with payment record (e.g. civicrm_contribution.id).' | |
128 | , | |
129 | PRIMARY KEY ( id ) | |
130 | , | |
131 | CONSTRAINT FK_civicrm_participant_payment_participant_id FOREIGN KEY (participant_id) REFERENCES civicrm_participant(id) | |
132 | ||
133 | ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ; | |
134 | ||
135 | -- /******************************************************* | |
136 | -- * | |
137 | -- * civicrm_currency | |
138 | -- * | |
139 | -- *******************************************************/ | |
140 | CREATE TABLE civicrm_currency ( | |
141 | ||
142 | ||
143 | id int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Currency Id', | |
144 | name varchar(64) COMMENT 'Currency Name', | |
145 | symbol varchar(8) COMMENT 'Currency Symbol' | |
146 | , | |
147 | PRIMARY KEY ( id ) | |
148 | ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ; | |
149 | ||
150 | -- /******************************************************* | |
151 | -- * | |
152 | -- * Insert sample data to | |
153 | -- * | |
154 | -- *******************************************************/ | |
155 | INSERT INTO `civicrm_currency` VALUES (1,'AUD','$'),(2,'CAD','$'),(3,'EUR','€'),(4,'GBP','£'),(5,'ILS','₪'),(6,'INR','₨'),(7,'JPY','¥'),(8,'KRW','₩'),(9,'LAK','₭'),(10,'MNT','₮'),(11,'NGN','₦'),(12,'PLN','zł'),(13,'THB','฿'),(14,'USD','$'),(15,'VND','₫'),(16,'ZAR','R'); | |
156 | ||
157 | ||
158 | -- /******************************************************* | |
159 | -- * | |
160 | -- * civicrm_address | |
161 | -- * | |
162 | -- *******************************************************/ | |
163 | ||
164 | ALTER TABLE `civicrm_address` | |
165 | MODIFY `geo_code_1` double NULL DEFAULT NULL COMMENT 'Latitude or UTM (Universal Transverse Mercator Grid) Northing.', | |
166 | MODIFY `geo_code_2` double NULL DEFAULT NULL COMMENT 'Longitude or UTM (Universal Transverse Mercator Grid) Easting.'; | |
167 | ||
168 | -- /******************************************************* | |
169 | -- * | |
170 | -- * civicrm_contact | |
171 | -- * | |
172 | -- *******************************************************/ | |
173 | ||
174 | ALTER TABLE `civicrm_contact` ADD INDEX `UI_external_identifier` (`external_identifier`); | |
175 | ||
176 | -- /******************************************************* | |
177 | -- * | |
178 | -- * civicrm_contribution_page | |
179 | -- * | |
180 | -- *******************************************************/ | |
181 | ALTER TABLE `civicrm_contribution_page` ADD `default_amount_id` int unsigned NOT NULL COMMENT 'FK to civicrm_custom_option.'; | |
182 | ALTER TABLE `civicrm_contribution_page` DROP `default_amount`; | |
183 | ||
184 | -- /******************************************************* | |
185 | -- * | |
186 | -- * civicrm_custom_group | |
187 | -- * | |
188 | -- *******************************************************/ | |
189 | ||
190 | ALTER TABLE `civicrm_custom_group` MODIFY extends enum('Contact','Individual','Household','Organization','Location','Address','Contribution','Activity','Relationship','Phonecall','Meeting','Group','Membership','Participant','Event') NULL DEFAULT 'Contact' COMMENT 'Type of object this group extends (can add other options later e.g. contact_address, etc.).'; | |
191 | ||
192 | ||
193 | -- /******************************************************* | |
194 | -- * | |
195 | -- * civicrm_custom_value | |
196 | -- * | |
197 | -- *******************************************************/ | |
198 | ||
199 | ALTER TABLE `civicrm_custom_value` MODIFY float_data double NULL DEFAULT NULL COMMENT 'stores data for ext property data_type = float.'; | |
200 | ||
201 | -- /******************************************************* | |
202 | -- * | |
203 | -- * civicrm_location_type | |
204 | -- * | |
205 | -- *******************************************************/ | |
206 | ||
207 | ALTER TABLE `civicrm_location_type` MODIFY vcard_name varchar(64) NULL DEFAULT NULL COMMENT 'vCard Location Type Name.'; | |
208 | ||
209 | -- /******************************************************* | |
210 | -- * | |
211 | -- * civicrm_mapping | |
212 | -- * | |
213 | -- *******************************************************/ | |
214 | ||
215 | ALTER TABLE civicrm_mapping MODIFY mapping_type enum('Export','Import','Export Contributions','Import Contributions','Import Activity History','Search Builder','Import Memberships','Import Participants') NULL DEFAULT NULL COMMENT 'Type of Mapping.'; | |
216 | ||
217 | -- /******************************************************* | |
218 | -- * | |
219 | -- * civicrm_membership | |
220 | -- * | |
221 | -- *******************************************************/ | |
222 | ALTER TABLE civicrm_membership ADD owner_membership_id int(10) UNSIGNED NULL DEFAULT NULL COMMENT 'Optional FK to Parent Membership.'; | |
223 | ALTER TABLE civicrm_membership ADD INDEX index_owner_membership_id( owner_membership_id ); | |
224 | ||
225 | -- /******************************************************* | |
226 | -- * | |
227 | -- * civicrm_membership_type | |
228 | -- * | |
229 | -- *******************************************************/ | |
230 | ||
231 | ALTER TABLE `civicrm_membership_type` ADD `relationship_direction` varchar(6) NULL DEFAULT NULL COMMENT ''; | |
232 | UPDATE `civicrm_membership_type` SET `relationship_direction`='a_b'; | |
233 | ||
234 | ||
235 | -- /******************************************************* | |
236 | -- * | |
237 | -- * civicrm_mapping_field | |
238 | -- * | |
239 | -- *******************************************************/ | |
240 | ||
241 | ALTER TABLE civicrm_mapping_field ADD `relationship_direction` varchar(6) NULL DEFAULT NULL COMMENT ''; | |
242 | UPDATE `civicrm_mapping_field` SET `relationship_direction`='a_b'; | |
243 | ||
244 | ||
245 | -- /******************************************************* | |
246 | -- * | |
247 | -- * civicrm_note | |
248 | -- * | |
249 | -- *******************************************************/ | |
250 | INSERT INTO `civicrm_note` | |
251 | (`entity_table`, `contact_id`, `entity_id`, `note`) | |
252 | SELECT 'civicrm_contribution', `contact_id`, `civicrm_contribution`.`id`, `civicrm_contribution`.`note` | |
253 | FROM civicrm_contribution; | |
254 | ||
255 | -- /******************************************************* | |
256 | -- * | |
257 | -- * civicrm_contribution | |
258 | -- * | |
259 | -- *******************************************************/ | |
260 | ||
261 | ALTER TABLE `civicrm_contribution` ADD INDEX `received_date` (`receive_date`); | |
262 | ALTER TABLE `civicrm_contribution` ADD `amount_level` varchar(255) NULL DEFAULT NULL COMMENT '' AFTER source; | |
263 | ALTER TABLE `civicrm_contribution` DROP `note`; | |
264 | ||
265 | -- /******************************************************* | |
266 | -- * | |
267 | -- * civicrm_uf_group | |
268 | -- * | |
269 | -- *******************************************************/ | |
270 | ||
271 | ALTER TABLE `civicrm_uf_group` ADD `is_uf_link` tinyint(4) NULL DEFAULT '0' COMMENT 'Should we display a link to the website profile in profile selector' AFTER is_edit_link; | |
272 | ALTER TABLE `civicrm_uf_group` ADD `is_update_dupe` tinyint(4) NULL DEFAULT '0' COMMENT 'Should we update the contact record if we find a duplicate' AFTER is_uf_link; | |
273 | ||
274 | -- /******************************************************* | |
275 | -- * | |
276 | -- * civicrm_uf_match | |
277 | -- * | |
278 | -- *******************************************************/ | |
279 | ||
280 | ALTER TABLE `civicrm_uf_match` DROP INDEX `UI_uf_id`; | |
281 | ALTER TABLE `civicrm_uf_match` ADD UNIQUE `UI_uf_domain_id`(`uf_id`, `domain_id`); | |
282 | ||
283 | -- /******************************************************* | |
284 | -- * | |
285 | -- * CRM-1570 - migrate the old, CiviCRM 1.4 callbacks | |
286 | -- * and fix (un-translate) localized activity names | |
287 | -- * | |
288 | -- *******************************************************/ | |
289 | ||
290 | UPDATE civicrm_activity_history SET callback = 'CRM_Activity_BAO_Activity::showActivityDetails' WHERE callback IN ('CRM_Activity_Form_Meeting::showMeetingDetails', 'CRM_Activity_Form_OtherActivity::showOtherActivityDetails', 'CRM_Activity_Form_Phonecall::showCallDetails'); | |
291 | ||
292 | UPDATE civicrm_activity_history SET activity_type = 'Meeting' WHERE activity_type IN ('Treffen', 'Cita', 'Tapaaminen', 'Reunion', 'Riunione', 'Bijeenkomst', 'Spotkanie'); | |
293 | UPDATE civicrm_activity_history SET activity_type = 'Meeting' WHERE activity_type LIKE 'R%union'; | |
294 | UPDATE civicrm_activity_history SET activity_type = 'Meeting' WHERE activity_type LIKE 'Tal%lkoz%'; | |
295 | UPDATE civicrm_activity_history SET activity_type = 'Meeting' WHERE activity_type LIKE 'Reuni%o'; | |
296 | UPDATE civicrm_activity_history SET activity_type = 'Meeting' WHERE activity_type LIKE '%nt%lnire'; | |
297 | UPDATE civicrm_activity_history SET activity_type = 'Meeting' WHERE activity_type LIKE 'M%te(n)'; | |
298 | ||
299 | UPDATE civicrm_activity_history SET activity_type = 'Phone Call' WHERE activity_type IN ('Telefonanruf', 'Puhelu', 'Appel', 'Telefonata', 'Telefoonoproep', 'Telefonsamtale', 'Rozmowa', 'Telefonema', 'Apel telefon', 'Telefonkontakt'); | |
300 | UPDATE civicrm_activity_history SET activity_type = 'Phone Call' WHERE activity_type LIKE 'Llamada telef%nica'; | |
301 | UPDATE civicrm_activity_history SET activity_type = 'Phone Call' WHERE activity_type LIKE 'Appel t%l%phonique'; | |
302 | UPDATE civicrm_activity_history SET activity_type = 'Phone Call' WHERE activity_type LIKE 'Telefonh%v%s'; | |
303 | ||
304 | UPDATE civicrm_activity_history SET activity_type = 'Email' WHERE activity_type IN ('Courriel', 'Epost', 'E-post'); | |
305 | UPDATE civicrm_activity_history SET activity_type = 'Email' WHERE activity_type LIKE 'S%hk%posti'; | |
306 | ||
307 | UPDATE civicrm_activity_history SET activity_type = 'Event' WHERE activity_type IN ('Evenement', 'Wydarzenie', 'Evento'); | |
308 | ||
309 | ||
310 | -- /******************************************************* | |
311 | -- * | |
312 | -- * Insert Billing location type (used for billing address | |
313 | -- * entered in online contribution forms) | |
314 | -- * | |
315 | -- *******************************************************/ | |
316 | ||
317 | SELECT @domain_id := id from civicrm_domain; | |
318 | INSERT INTO `civicrm_location_type` ( `domain_id`, `name`, `vcard_name`, `description`, `is_reserved`, `is_active` ) | |
319 | VALUES | |
320 | ( @domain_id, 'Billing', NULL, 'Billing Address location', 1, 1 ); | |
321 | ||
322 | -- /******************************************************* | |
323 | -- * | |
324 | -- * civicrm_option_group | |
325 | -- * | |
326 | -- *******************************************************/ | |
327 | ||
328 | SELECT @domain_id := id from civicrm_domain; | |
329 | INSERT INTO `civicrm_option_group` (`domain_id`, `name`, `description`, `is_reserved`, `is_active`) | |
330 | VALUES | |
331 | (@domain_id, 'participant_status', 'Participant Status', 0, 1), | |
332 | (@domain_id, 'participant_role', 'Participant Role', 0, 1), | |
333 | (@domain_id, 'event_type', 'Event Type', 0, 1); | |
334 | ||
335 | ||
336 | -- /******************************************************* | |
337 | -- * | |
338 | -- * civicrm_option_value | |
339 | -- * | |
340 | -- *******************************************************/ | |
341 | ||
342 | SELECT @option_group_id_ps := max(id) from civicrm_option_group where name = 'participant_status'; | |
343 | SELECT @option_group_id_pRole := max(id) from civicrm_option_group where name = 'participant_role'; | |
344 | SELECT @option_group_id_etype := max(id) from civicrm_option_group where name = 'event_type'; | |
345 | ||
346 | INSERT INTO `civicrm_option_value` (`option_group_id`, `label`, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, `description`, `is_optgroup`, `is_reserved`, `is_active`) | |
347 | VALUES | |
348 | (@option_group_id_ps, 'Registered', 1, 'Registered', NULL, 0, NULL, 1, NULL, 0, 1, 1), | |
349 | (@option_group_id_ps, 'Attended', 2, 'Attended', NULL, 0, NULL, 2, NULL, 0, 0, 1), | |
350 | (@option_group_id_ps, 'No-show', 3, 'No-show', NULL, 0, NULL, 3, NULL, 0, 0, 1), | |
351 | (@option_group_id_ps, 'Cancelled', 4, 'Cancelled', NULL, 0, NULL, 4, NULL, 0, 1, 1), | |
352 | ||
353 | (@option_group_id_pRole, 'Attendee', 1, 'Attendee', NULL, 0, NULL, 1, NULL, 0, 0, 1), | |
354 | (@option_group_id_pRole, 'Volunteer', 2, 'Volunteer', NULL, 0, NULL, 2, NULL, 0, 0, 1), | |
355 | (@option_group_id_pRole, 'Host', 3, 'Host', NULL, 0, NULL, 3, NULL, 0, 0, 1), | |
356 | (@option_group_id_pRole, 'Speaker', 4, 'Speaker', NULL, 0, NULL, 4, NULL, 0, 0, 1), | |
357 | ||
358 | (@option_group_id_etype, 'Conference', 1, 'Conference', NULL, 0, NULL, 1, NULL, 0, 0, 1 ), | |
359 | (@option_group_id_etype, 'Exhibition', 2, 'Exhibition', NULL, 0, NULL, 2, NULL, 0, 0, 1 ), | |
360 | (@option_group_id_etype, 'Fundraiser', 3, 'Fundraiser', NULL, 0, NULL, 3, NULL, 0, 0, 1 ), | |
361 | (@option_group_id_etype, 'Meeting', 4, 'Meeting', NULL, 0, NULL, 4, NULL, 0, 0, 1 ), | |
362 | (@option_group_id_etype, 'Performance',5, 'Performance', NULL, 0, NULL, 5, NULL, 0, 0, 1 ), | |
363 | (@option_group_id_etype, 'Workshop', 6, 'Workshop', NULL, 0, NULL, 6, NULL, 0, 0, 1 ); |