rsvp / rsvp_db_setup.inc.php

rsvp_db_setup.inc.php in RSVP and Event Management 1.6.2, at rsvp_db_setup.inc.php

118 lines 4.5 KB

Raw Download Zip

1	<?php
2	$installed_ver = get_option("rsvp_db_version");
3	$table = $wpdb->prefix."attendees";
4	if($wpdb->get_var("SHOW TABLES LIKE '$table'") != $table) {
5	$sql = "CREATE TABLE ".$table." (
6	`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
7	`firstName` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
8	`lastName` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
9	`rsvpDate` DATE NULL ,
10	`rsvpStatus` ENUM( 'Yes', 'No', 'NoResponse' ) NOT NULL DEFAULT 'NoResponse',
11	`note` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
12	`kidsMeal` ENUM( 'Y', 'N' ) NOT NULL DEFAULT 'N',
13	`additionalAttendee` ENUM( 'Y', 'N' ) NOT NULL DEFAULT 'N',
14	`veggieMeal` ENUM( 'Y', 'N' ) NOT NULL DEFAULT 'N',
15	`personalGreeting` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
16	);";
17	$wpdb->query($sql);
18	}
19	$table = $wpdb->prefix."associatedAttendees";
20	if($wpdb->get_var("SHOW TABLES LIKE '$table'") != $table) {
21	$sql = "CREATE TABLE ".$table." (
22	`attendeeID` INT NOT NULL ,
23	`associatedAttendeeID` INT NOT NULL
24	);";
25	$wpdb->query($sql);
26	$sql = "ALTER TABLE `".$table."` ADD INDEX ( `attendeeID` ) ";
27	$wpdb->query($sql);
28	$sql = "ALTER TABLE `".$table."` ADD INDEX ( `associatedAttendeeID` )";
29	$wpdb->query($sql);
30	}
31	add_option("rsvp_db_version", "4");
32
33	if((int)$installed_ver < 2) {
34	$table = $wpdb->prefix."attendees";
35	$sql = "ALTER TABLE ".$table." ADD `personalGreeting` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ;";
36	$wpdb->query($sql);
37	update_option( "rsvp_db_version", RSVP_DB_VERSION);
38	}
39
40	if((int)$installed_ver < 4) {
41	$table = $wpdb->prefix."rsvpCustomQuestions";
42	$sql = "ALTER TABLE ".$table." ADD `sortOrder` INT NOT NULL DEFAULT '99';";
43	$wpdb->query($sql);
44	update_option( "rsvp_db_version", RSVP_DB_VERSION);
45	}
46
47	$table = $wpdb->prefix."rsvpCustomQuestions";
48	if($wpdb->get_var("SHOW TABLES LIKE '$table'") != $table) {
49	$sql = " CREATE TABLE $table (
50	`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
51	`question` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
52	`questionTypeID` INT NOT NULL,
53	`sortOrder` INT NOT NULL DEFAULT '99',
54	`permissionLevel` ENUM( 'public', 'private' ) NOT NULL DEFAULT 'public'
55	);";
56	$wpdb->query($sql);
57	}
58
59	$table = $wpdb->prefix."rsvpQuestionTypes";
60	if($wpdb->get_var("SHOW TABLES LIKE '$table'") != $table) {
61	$sql = " CREATE TABLE $table (
62	`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
63	`questionType` VARCHAR( 100 ) NOT NULL ,
64	`friendlyName` VARCHAR(100) NOT NULL
65	);";
66	$wpdb->query($sql);
67
68	$wpdb->insert($table, array("questionType" => "shortAnswer", "friendlyName" => "Short Answer"), array('%s', '%s'));
69	$wpdb->insert($table, array("questionType" => "multipleChoice", "friendlyName" => "Multiple Choice"), array('%s', '%s'));
70	$wpdb->insert($table, array("questionType" => "longAnswer", "friendlyName" => "Long Answer"), array('%s', '%s'));
71	$wpdb->insert($table, array("questionType" => "dropdown", "friendlyName" => "Drop Down"), array('%s', '%s'));
72	$wpdb->insert($table, array("questionType" => "radio", "friendlyName" => "Radio"), array('%s', '%s'));
73	} else if((int)$installed_ver < 6) {
74	$wpdb->insert($table, array("questionType" => "radio", "friendlyName" => "Radio"), array('%s', '%s'));
75	}
76
77	$table = $wpdb->prefix."rsvpCustomQuestionAnswers";
78	if($wpdb->get_var("SHOW TABLES LIKE '$table'") != $table) {
79	$sql = "CREATE TABLE $table (
80	`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
81	`questionID` INT NOT NULL,
82	`answer` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
83	);";
84	$wpdb->query($sql);
85	}
86
87	$table = $wpdb->prefix."attendeeAnswers";
88	if($wpdb->get_var("SHOW TABLES LIKE '$table'") != $table) {
89	$sql = "CREATE TABLE $table (
90	`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
91	`questionID` INT NOT NULL,
92	`answer` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
93	`attendeeID` INT NOT NULL
94	);";
95	$wpdb->query($sql);
96	}
97
98	$table = $wpdb->prefix."rsvpCustomQuestionAttendees";
99	if($wpdb->get_var("SHOW TABLES LIKE '$table'") != $table) {
100	$sql = "CREATE TABLE $table (
101	`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
102	`questionID` INT NOT NULL ,
103	`attendeeID` INT NOT NULL
104	);";
105	$wpdb->query($sql);
106	}
107
108	if((int)$installed_ver < 5) {
109	$table = QUESTIONS_TABLE;
110	$sql = "ALTER TABLE `$table` ADD `permissionLevel` ENUM( 'public', 'private' ) NOT NULL DEFAULT 'public';";
111	$wpdb->query($sql);
112	}
113
114	if((int)$installed_ver < 9) {
115	rsvp_install_passcode_field();
116	}
117	update_option( "rsvp_db_version", RSVP_DB_VERSION);
118	?>