modules/multiforms/multiforms.install

<?php

function multiforms_install() {

  switch ($GLOBALS['db_type']) {

    case 'mysql':
    case 'mysqli':

      db_query("CREATE TABLE {multiforms} (
        multiform_id int(10) NOT NULL auto_increment,
        multiform_create_date datetime DEFAULT NULL,
        multiform_name varchar(255) DEFAULT NULL,
        multiform_friendly_name varchar(255) DEFAULT NULL,
        multiform_description longtext,
        multiform_end_notification longtext,
        multiform_end_text longtext,
        multiform_completion_threshold int(10) DEFAULT NULL,
        multiform_section_text longtext,
        multiform_email_allow int(1) DEFAULT NULL,
        multiform_email_subject varchar(255) DEFAULT NULL,
        multiform_email_body longtext,
        multiform_draw_entry_on_submission int(1) DEFAULT NULL,
        multiform_draw_entry_on_rererral int(1) DEFAULT NULL,
        multiform_email_thanks longtext,
        multiform_footer longtext,
        multiform_section_footer longtext,
        nid int(10) DEFAULT NULL,
        multiform_closing_enabled int(1) DEFAULT NULL,
        multiform_closing_date varchar(255) DEFAULT NULL,
        multiform_closing_time varchar(255) DEFAULT NULL,
        multiform_closing_text longtext,
        multiform_completion_redirect varchar(255),
        multiform_submit_button_text varchar(255),
        multiform_completion_submit_button_text varchar(255),
        multiform_flow_type int(1) DEFAULT 1,
        PRIMARY KEY  (multiform_id)
      ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

      db_query("CREATE TABLE {multiform_sections} (
        multiform_section_id int(10) NOT NULL auto_increment,
        multiform_section_multiform_id int(10) default NULL,
        multiform_section_sortorder int(10) default NULL,
        multiform_section_name varchar(255) default NULL,
        multiform_section_description longtext,
        multiform_section_submit_button_text varchar(255),
        KEY multiform_section_multiform_id_key (multiform_section_multiform_id),
        PRIMARY KEY  (multiform_section_id)
      ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

      db_query("CREATE TABLE {multiform_fields} (
        multiform_field_id int(10) NOT NULL auto_increment,
        multiform_field_section_id int(10) default NULL,
        multiform_field_sortorder int(10) default NULL,
        multiform_field_name varchar(255) default NULL,
        multiform_field_description longtext,
        multiform_field_type varchar(255) default NULL,
        multiform_field_validation_type varchar(255) default NULL,
        KEY multiform_field_section_id_key (multiform_field_section_id),
        PRIMARY KEY  (multiform_field_id)
      ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

      db_query("CREATE TABLE {multiform_submissions} (
        multiform_submission_id int(10) NOT NULL auto_increment,
        multiform_submission_parent_multiform_id int(10) default NULL,
        multiform_submission_ip varchar(255) default NULL,
        multiform_submission_datetime datetime default NULL,
        multiform_submission_status varchar(255) default NULL,
        multiform_submission_unique_key longtext,
        multiform_submission_edit_username varchar(255),
        multiform_submission_edit_password varchar(255),
        multiform_submission_draw_entry_counter int(10) default 0,
        multiform_submission_total_answered int(10) default 0,
        KEY multiform_submission_parent_multiform_id_key (multiform_submission_parent_multiform_id),
        PRIMARY KEY  (multiform_submission_id)
      ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

      db_query("CREATE TABLE {multiform_field_submissions} (
        multiform_field_submission_id int(10) NOT NULL auto_increment,
        multiform_field_submission_parent_submission_id int(10) default NULL,
        multiform_field_submission_parent_field_id int(10) default NULL,
        multiform_field_submission_value longtext,
        KEY multiform_field_submission_parent_field_id_key (multiform_field_submission_parent_field_id),
        KEY multiform_field_submission_parent_submission_id_key (multiform_field_submission_parent_submission_id),
        PRIMARY KEY  (multiform_field_submission_id)
      ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

      db_query("CREATE TABLE {multiform_draw_entries} (
        multiform_draw_entry_id int(10) NOT NULL auto_increment,
        multiform_draw_entry_parent_multiform_id int(10) default NULL,
        multiform_draw_entry_parent_submission_id int(10) default NULL,
        PRIMARY KEY  (multiform_draw_entry_id)
      ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

      db_query("CREATE TABLE {multiform_snippets} (
        multiform_snippet_id int(10) NOT NULL auto_increment,
        multiform_snippet_name varchar(255) default NULL,
        PRIMARY KEY  (multiform_snippet_id)
      ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

      db_query("CREATE TABLE {multiform_snippet_fields} (
        multiform_snippet_field_id int(10) NOT NULL auto_increment,
        multiform_snippet_field_parent_id int(10) default NULL,
        multiform_snippet_field_sortorder int(10) default NULL,
        multiform_snippet_field_name varchar(255) default NULL,
        multiform_snippet_field_description longtext,
        multiform_snippet_field_type varchar(255) default NULL,
        multiform_snippet_field_validation_type varchar(255) default NULL,
        PRIMARY KEY  (multiform_snippet_field_id)
      ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

      db_query("CREATE TABLE {multiform_snippet_field_options} (
        multiform_snippet_field_option_id int(10) NOT NULL auto_increment,
        multiform_snippet_field_option_parent_field_id int(10) default NULL,
        multiform_snippet_field_option_text varchar(255) default NULL,
        multiform_snippet_field_option_value varchar(255) default NULL,
        multiform_snippet_field_option_sortorder int(10) default NULL,
        KEY multiform_field_option_parent_field_id_key (multiform_field_option_parent_field_id),
        PRIMARY KEY  (multiform_snippet_field_option_id)
      ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

      db_query("CREATE TABLE {multiform_actions} (
        multiform_action_id int(10) NOT NULL auto_increment,
        multiform_action_type varchar(255) default NULL,
        multiform_action_sortorder int(10) default NULL,
        multiform_action_params longtext,
        multiform_action_parent_type varchar(255) default NULL,
        multiform_action_parent_id int(10) default NULL,
        multiform_action_parent_trigger varchar(255) default NULL,
        PRIMARY KEY  (multiform_action_id)
      ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

      db_query("CREATE TABLE {multiform_field_options} (
        multiform_field_option_id int(10) NOT NULL auto_increment,
        multiform_field_option_parent_field_id int(10) default NULL,
        multiform_field_option_text varchar(255),
        multiform_field_option_value varchar(255),
        multiform_field_option_sortorder int(10),
        PRIMARY KEY  (multiform_field_option_id)
      ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

      break;

    case 'pgsql':

      db_query("CREATE TABLE {multiforms} (
        multiform_id SERIAL,
        multiform_create_date timestamp default NULL,
        multiform_name varchar(255) default NULL,
        multiform_friendly_name varchar(255) default NULL,
        multiform_description text,
        multiform_end_notification text,
        multiform_end_text text,
        multiform_completion_threshold integer default NULL,
        multiform_section_text text,
        multiform_email_allow smallint default NULL,
        multiform_email_subject varchar(255) default NULL,
        multiform_email_body text,
        multiform_draw_entry_on_submission smallint default NULL,
        multiform_draw_entry_on_rererral smallint default NULL,
        multiform_email_thanks text,
        multiform_footer text,
        multiform_section_footer text,
        nid integer default NULL,
        multiform_closing_enabled smallint default NULL,
        multiform_closing_date varchar(255) default NULL,
        multiform_closing_time varchar(255) default NULL,
        multiform_closing_text text,
        multiform_flow_type int(1) DEFAULT 1,
        PRIMARY KEY  (multiform_id)
      );");

      db_query("CREATE TABLE {multiform_sections} (
        multiform_section_id SERIAL,
        multiform_section_multiform_id integer default NULL,
        multiform_section_sortorder integer default NULL,
        multiform_section_name varchar(255) default NULL,
        multiform_section_description text,
        KEY multiform_section_multiform_id_key (multiform_section_multiform_id),
        PRIMARY KEY  (multiform_section_id)
      );");

      db_query("CREATE TABLE {multiform_fields} (
        multiform_field_id SERIAL,
        multiform_field_section_id integer default NULL,
        multiform_field_sortorder integer default NULL,
        multiform_field_name varchar(255) default NULL,
        multiform_field_description text,
        multiform_field_type varchar(255) default NULL,
        multiform_field_validation_type varchar(255) default NULL,
        KEY multiform_field_section_id_key (multiform_field_section_id),
        PRIMARY KEY  (multiform_field_id)
      );");

      db_query("CREATE TABLE {multiform_submissions} (
        multiform_submission_id SERIAL,
        multiform_submission_parent_multiform_id integer default NULL,
        multiform_submission_ip varchar(255) default NULL,
        multiform_submission_datetime timestamp default NULL,
        multiform_submission_status varchar(255) default NULL,
        multiform_submission_unique_key text,
        multiform_submission_edit_username varchar(255),
        multiform_submission_edit_password varchar(255),
        multiform_submission_draw_entry_counter integer default 0,
        multiform_submission_total_answered int(10) default 0,
        KEY multiform_submission_parent_multiform_id_key (multiform_submission_parent_multiform_id),
        PRIMARY KEY  (multiform_submission_id)
      );");

      db_query("CREATE TABLE {multiform_field_submissions} (
        multiform_field_submission_id SERIAL,
        multiform_field_submission_parent_submission_id integer default NULL,
        multiform_field_submission_parent_field_id integer default NULL,
        multiform_field_submission_value text,
        KEY multiform_field_submission_parent_field_id_key (multiform_field_submission_parent_field_id),
        KEY multiform_field_submission_parent_submission_id_key (multiform_field_submission_parent_submission_id),
        PRIMARY KEY  (multiform_field_submission_id)
      );");

      db_query("CREATE TABLE {multiform_draw_entries} (
        multiform_draw_entry_id SERIAL,
        multiform_draw_entry_parent_multiform_id integer default NULL,
        multiform_draw_entry_parent_submission_id integer default NULL,
        PRIMARY KEY  (multiform_draw_entry_id)
      );");

      db_query("CREATE TABLE {multiform_snippets} (
        multiform_snippet_id SERIAL,
        multiform_snippet_name varchar(255) default NULL,
        PRIMARY KEY  (multiform_snippet_id)
      );");

      db_query("CREATE TABLE {multiform_snippet_fields} (
        multiform_snippet_field_id SERIAL,
        multiform_snippet_field_parent_id integer default NULL,
        multiform_snippet_field_sortorder integer default NULL,
        multiform_snippet_field_name varchar(255) default NULL,
        multiform_snippet_field_description text,
        multiform_snippet_field_type varchar(255) default NULL,
        multiform_snippet_field_validation_type varchar(255) default NULL,
        PRIMARY KEY  (multiform_snippet_field_id)
      );");

      db_query("CREATE TABLE {multiform_snippet_field_options} (
        multiform_snippet_field_option_id int(10) NOT NULL auto_increment,
        multiform_snippet_field_option_parent_field_id int(10) default NULL,
        multiform_snippet_field_option_text varchar(255) default NULL,
        multiform_snippet_field_option_value varchar(255) default NULL,
        multiform_snippet_field_option_sortorder int(10) default NULL,
        KEY multiform_field_option_parent_field_id_key (multiform_field_option_parent_field_id),
        PRIMARY KEY  (multiform_snippet_field_option_id)
      );");

      db_query("CREATE TABLE {multiform_actions} (
        multiform_action_id SERIAL,
        multiform_action_type varchar(255) default NULL,
        multiform_action_sortorder integer default NULL,
        multiform_action_params text,
        multiform_action_parent_type varchar(255) default NULL,
        multiform_action_parent_id integer default NULL,
        multiform_action_parent_trigger varchar(255) default NULL,
        PRIMARY KEY  (multiform_action_id)
      );");

      db_query("CREATE TABLE {multiform_field_options} (
        multiform_field_option_id SERIAL,
        multiform_field_option_parent_field_id integer default NULL,
        multiform_field_option_text varchar(255),
        multiform_field_option_value varchar(255),
        multiform_field_option_sortorder integer,
        PRIMARY KEY  (multiform_field_option_id)
      );");

      break;
  }

  // Notify of changes
  drupal_set_message(t('The multiforms module was successfully installed.'));
}

function multiforms_uninstall() {

  db_query('DROP TABLE {multiforms}');
  db_query('DROP TABLE {multiform_sections}');
  db_query('DROP TABLE {multiform_fields}');
  db_query('DROP TABLE {multiform_submissions}');
  db_query('DROP TABLE {multiform_field_submissions}');
  db_query('DROP TABLE {multiform_draw_entries}');
  db_query('DROP TABLE {multiform_snippets}');
  db_query('DROP TABLE {multiform_snippet_fields}');
  db_query('DROP TABLE {multiform_actions}');

  variable_del('multiform_default_completion_text');
  variable_del('multiform_default_footer_text');
}

function multiforms_update_1() {

  $items = array();

  switch ($GLOBALS['db_type']) {

    case 'mysql':
    case 'mysqli':

  	  $items[] = update_sql("CREATE TABLE {multiform_actions} (
         multiform_action_id int(10) NOT NULL auto_increment,
         multiform_action_type varchar(255) default NULL,
         multiform_action_sortorder int(10) default NULL,
         multiform_action_params longtext,
         multiform_action_parent_type varchar(255) default NULL,
         multiform_action_parent_id int(10) default NULL,
         multiform_action_parent_trigger varchar(255) default NULL,
         PRIMARY KEY  (multiform_action_id)
      ) /*!40100 DEFAULT CHARACTER SET utf8 */;");
	    break;

    case 'pgsql':

  	  $items[] = update_sql("CREATE TABLE {multiform_actions} (
        multiform_action_id SERIAL,
        multiform_action_type varchar(255) default NULL,
        multiform_action_sortorder integer default NULL,
        multiform_action_params text,
        multiform_action_parent_type varchar(255) default NULL,
        multiform_action_parent_id integer default NULL,
        multiform_action_parent_trigger varchar(255) default NULL,
        PRIMARY KEY  (multiform_action_id)
      );");
	    break;
  }
  
  return $items;
}

function multiforms_update_2() {

  $items = array();
  $items[] = update_sql("ALTER TABLE {multiform_submissions} ADD COLUMN multiform_submission_edit_username varchar(255)");
  $items[] = update_sql("ALTER TABLE {multiform_submissions} ADD COLUMN multiform_submission_edit_password varchar(255)");

  return $items;
}

function multiforms_update_3() {

  $items = array();

  switch ($GLOBALS['db_type']) {

    case 'mysql':
    case 'mysqli':

      $items[] = update_sql("ALTER TABLE {multiform_submissions} ADD COLUMN multiform_submission_draw_entry_counter int(10) default 0");
   	  break;

    case 'pgsql':

      $items[] = update_sql("ALTER TABLE {multiform_submissions} ADD COLUMN multiform_submission_draw_entry_counter integer default 0");
	    break;
  }

  return $items;
}

function multiforms_update_4() {

  $items = array();

  $items[] = update_sql("CREATE TABLE {multiform_field_options} (
    multiform_field_option_id int(10) NOT NULL auto_increment,
    multiform_field_option_parent_field_id int(10) default NULL,
    multiform_field_option_text varchar(255),
    multiform_field_option_value varchar(255),
    multiform_field_option_sortorder int(10),
    PRIMARY KEY  (multiform_field_option_id)
  ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

  return $items;
}

function multiforms_update_5() {

  $items = array();

  $items[] = update_sql("ALTER TABLE {multiform_sections} ADD COLUMN multiform_section_submit_button_text varchar(255)");

  return $items;
}

function multiforms_update_6() {

  $items = array();

  $items[] = update_sql("ALTER TABLE {multiforms} ADD COLUMN multiform_completion_redirect varchar(255)");

  return $items;
}

function multiforms_update_7() {

  $items = array();

  $items[] = update_sql("CREATE TABLE multiform_snippet_field_options (
    multiform_snippet_field_option_id int(10) NOT NULL auto_increment,
    multiform_snippet_field_option_parent_field_id int(10) default NULL,
    multiform_snippet_field_option_text varchar(255) default NULL,
    multiform_snippet_field_option_value varchar(255) default NULL,
    multiform_snippet_field_option_sortorder int(10) default NULL,
    PRIMARY KEY  (multiform_snippet_field_option_id)
  ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

  return $items;
}

function multiforms_update_8() {

  $items = array();

  $items[] = update_sql("ALTER TABLE {multiforms} ADD COLUMN multiform_submit_button_text varchar(255)");

  return $items;
}

function multiforms_update_9() {

  $items = array();

  $items[] = update_sql("ALTER TABLE {multiforms} ADD COLUMN multiform_completion_submit_button_text varchar(255)");

  return $items;
}

function multiforms_update_10() {

  $items = array();
  $items[] = update_sql("CREATE INDEX multiform_field_submission_parent_field_id_key ON {multiform_field_submissions} (multiform_field_submission_parent_field_id)");
  $items[] = update_sql("CREATE INDEX multiform_field_submission_parent_submission_id_key ON {multiform_field_submissions} (multiform_field_submission_parent_submission_id)");
  $items[] = update_sql("CREATE INDEX multiform_field_section_id_key ON {multiform_fields} (multiform_field_section_id)");
  $items[] = update_sql("CREATE INDEX multiform_section_multiform_id_key ON {multiform_sections} (multiform_section_multiform_id)");
  $items[] = update_sql("CREATE INDEX multiform_submission_parent_multiform_id_key ON {multiform_submissions} (multiform_submission_parent_multiform_id)");
  $items[] = update_sql("CREATE INDEX multiform_field_option_parent_field_id_key ON {multiform_field_options} (multiform_field_option_parent_field_id)");

  return $items;
}

function multiforms_update_11() {

  $items = array();

  $items[] = update_sql("ALTER TABLE {multiform_submissions} ADD COLUMN multiform_submission_total_answered INT(10) DEFAULT 0");

  return $items;
}

function multiforms_update_12() {

  $items = array();

  $items[] = update_sql("ALTER TABLE {multiforms} ADD COLUMN multiform_flow_type INT(1) DEFAULT 1");

  return $items;
}

1	<?php
2
3	function multiforms_install() {
4
5	switch ($GLOBALS['db_type']) {
6
7	case 'mysql':
8	case 'mysqli':
9
10	db_query("CREATE TABLE {multiforms} (
11	multiform_id int(10) NOT NULL auto_increment,
12	multiform_create_date datetime DEFAULT NULL,
13	multiform_name varchar(255) DEFAULT NULL,
14	multiform_friendly_name varchar(255) DEFAULT NULL,
15	multiform_description longtext,
16	multiform_end_notification longtext,
17	multiform_end_text longtext,
18	multiform_completion_threshold int(10) DEFAULT NULL,
19	multiform_section_text longtext,
20	multiform_email_allow int(1) DEFAULT NULL,
21	multiform_email_subject varchar(255) DEFAULT NULL,
22	multiform_email_body longtext,
23	multiform_draw_entry_on_submission int(1) DEFAULT NULL,
24	multiform_draw_entry_on_rererral int(1) DEFAULT NULL,
25	multiform_email_thanks longtext,
26	multiform_footer longtext,
27	multiform_section_footer longtext,
28	nid int(10) DEFAULT NULL,
29	multiform_closing_enabled int(1) DEFAULT NULL,
30	multiform_closing_date varchar(255) DEFAULT NULL,
31	multiform_closing_time varchar(255) DEFAULT NULL,
32	multiform_closing_text longtext,
33	multiform_completion_redirect varchar(255),
34	multiform_submit_button_text varchar(255),
35	multiform_completion_submit_button_text varchar(255),
36	multiform_flow_type int(1) DEFAULT 1,
37	PRIMARY KEY (multiform_id)
38	) /!40100 DEFAULT CHARACTER SET utf8 /;");
39
40	db_query("CREATE TABLE {multiform_sections} (
41	multiform_section_id int(10) NOT NULL auto_increment,
42	multiform_section_multiform_id int(10) default NULL,
43	multiform_section_sortorder int(10) default NULL,
44	multiform_section_name varchar(255) default NULL,
45	multiform_section_description longtext,
46	multiform_section_submit_button_text varchar(255),
47	KEY multiform_section_multiform_id_key (multiform_section_multiform_id),
48	PRIMARY KEY (multiform_section_id)
49	) /!40100 DEFAULT CHARACTER SET utf8 /;");
50
51	db_query("CREATE TABLE {multiform_fields} (
52	multiform_field_id int(10) NOT NULL auto_increment,
53	multiform_field_section_id int(10) default NULL,
54	multiform_field_sortorder int(10) default NULL,
55	multiform_field_name varchar(255) default NULL,
56	multiform_field_description longtext,
57	multiform_field_type varchar(255) default NULL,
58	multiform_field_validation_type varchar(255) default NULL,
59	KEY multiform_field_section_id_key (multiform_field_section_id),
60	PRIMARY KEY (multiform_field_id)
61	) /!40100 DEFAULT CHARACTER SET utf8 /;");
62
63	db_query("CREATE TABLE {multiform_submissions} (
64	multiform_submission_id int(10) NOT NULL auto_increment,
65	multiform_submission_parent_multiform_id int(10) default NULL,
66	multiform_submission_ip varchar(255) default NULL,
67	multiform_submission_datetime datetime default NULL,
68	multiform_submission_status varchar(255) default NULL,
69	multiform_submission_unique_key longtext,
70	multiform_submission_edit_username varchar(255),
71	multiform_submission_edit_password varchar(255),
72	multiform_submission_draw_entry_counter int(10) default 0,
73	multiform_submission_total_answered int(10) default 0,
74	KEY multiform_submission_parent_multiform_id_key (multiform_submission_parent_multiform_id),
75	PRIMARY KEY (multiform_submission_id)
76	) /!40100 DEFAULT CHARACTER SET utf8 /;");
77
78	db_query("CREATE TABLE {multiform_field_submissions} (
79	multiform_field_submission_id int(10) NOT NULL auto_increment,
80	multiform_field_submission_parent_submission_id int(10) default NULL,
81	multiform_field_submission_parent_field_id int(10) default NULL,
82	multiform_field_submission_value longtext,
83	KEY multiform_field_submission_parent_field_id_key (multiform_field_submission_parent_field_id),
84	KEY multiform_field_submission_parent_submission_id_key (multiform_field_submission_parent_submission_id),
85	PRIMARY KEY (multiform_field_submission_id)
86	) /!40100 DEFAULT CHARACTER SET utf8 /;");
87
88	db_query("CREATE TABLE {multiform_draw_entries} (
89	multiform_draw_entry_id int(10) NOT NULL auto_increment,
90	multiform_draw_entry_parent_multiform_id int(10) default NULL,
91	multiform_draw_entry_parent_submission_id int(10) default NULL,
92	PRIMARY KEY (multiform_draw_entry_id)
93	) /!40100 DEFAULT CHARACTER SET utf8 /;");
94
95	db_query("CREATE TABLE {multiform_snippets} (
96	multiform_snippet_id int(10) NOT NULL auto_increment,
97	multiform_snippet_name varchar(255) default NULL,
98	PRIMARY KEY (multiform_snippet_id)
99	) /!40100 DEFAULT CHARACTER SET utf8 /;");
100
101	db_query("CREATE TABLE {multiform_snippet_fields} (
102	multiform_snippet_field_id int(10) NOT NULL auto_increment,
103	multiform_snippet_field_parent_id int(10) default NULL,
104	multiform_snippet_field_sortorder int(10) default NULL,
105	multiform_snippet_field_name varchar(255) default NULL,
106	multiform_snippet_field_description longtext,
107	multiform_snippet_field_type varchar(255) default NULL,
108	multiform_snippet_field_validation_type varchar(255) default NULL,
109	PRIMARY KEY (multiform_snippet_field_id)
110	) /!40100 DEFAULT CHARACTER SET utf8 /;");
111
112	db_query("CREATE TABLE {multiform_snippet_field_options} (
113	multiform_snippet_field_option_id int(10) NOT NULL auto_increment,
114	multiform_snippet_field_option_parent_field_id int(10) default NULL,
115	multiform_snippet_field_option_text varchar(255) default NULL,
116	multiform_snippet_field_option_value varchar(255) default NULL,
117	multiform_snippet_field_option_sortorder int(10) default NULL,
118	KEY multiform_field_option_parent_field_id_key (multiform_field_option_parent_field_id),
119	PRIMARY KEY (multiform_snippet_field_option_id)
120	) /!40100 DEFAULT CHARACTER SET utf8 /;");
121
122	db_query("CREATE TABLE {multiform_actions} (
123	multiform_action_id int(10) NOT NULL auto_increment,
124	multiform_action_type varchar(255) default NULL,
125	multiform_action_sortorder int(10) default NULL,
126	multiform_action_params longtext,
127	multiform_action_parent_type varchar(255) default NULL,
128	multiform_action_parent_id int(10) default NULL,
129	multiform_action_parent_trigger varchar(255) default NULL,
130	PRIMARY KEY (multiform_action_id)
131	) /!40100 DEFAULT CHARACTER SET utf8 /;");
132
133	db_query("CREATE TABLE {multiform_field_options} (
134	multiform_field_option_id int(10) NOT NULL auto_increment,
135	multiform_field_option_parent_field_id int(10) default NULL,
136	multiform_field_option_text varchar(255),
137	multiform_field_option_value varchar(255),
138	multiform_field_option_sortorder int(10),
139	PRIMARY KEY (multiform_field_option_id)
140	) /!40100 DEFAULT CHARACTER SET utf8 /;");
141
142	break;
143
144	case 'pgsql':
145
146	db_query("CREATE TABLE {multiforms} (
147	multiform_id SERIAL,
148	multiform_create_date timestamp default NULL,
149	multiform_name varchar(255) default NULL,
150	multiform_friendly_name varchar(255) default NULL,
151	multiform_description text,
152	multiform_end_notification text,
153	multiform_end_text text,
154	multiform_completion_threshold integer default NULL,
155	multiform_section_text text,
156	multiform_email_allow smallint default NULL,
157	multiform_email_subject varchar(255) default NULL,
158	multiform_email_body text,
159	multiform_draw_entry_on_submission smallint default NULL,
160	multiform_draw_entry_on_rererral smallint default NULL,
161	multiform_email_thanks text,
162	multiform_footer text,
163	multiform_section_footer text,
164	nid integer default NULL,
165	multiform_closing_enabled smallint default NULL,
166	multiform_closing_date varchar(255) default NULL,
167	multiform_closing_time varchar(255) default NULL,
168	multiform_closing_text text,
169	multiform_flow_type int(1) DEFAULT 1,
170	PRIMARY KEY (multiform_id)
171	);");
172
173	db_query("CREATE TABLE {multiform_sections} (
174	multiform_section_id SERIAL,
175	multiform_section_multiform_id integer default NULL,
176	multiform_section_sortorder integer default NULL,
177	multiform_section_name varchar(255) default NULL,
178	multiform_section_description text,
179	KEY multiform_section_multiform_id_key (multiform_section_multiform_id),
180	PRIMARY KEY (multiform_section_id)
181	);");
182
183	db_query("CREATE TABLE {multiform_fields} (
184	multiform_field_id SERIAL,
185	multiform_field_section_id integer default NULL,
186	multiform_field_sortorder integer default NULL,
187	multiform_field_name varchar(255) default NULL,
188	multiform_field_description text,
189	multiform_field_type varchar(255) default NULL,
190	multiform_field_validation_type varchar(255) default NULL,
191	KEY multiform_field_section_id_key (multiform_field_section_id),
192	PRIMARY KEY (multiform_field_id)
193	);");
194
195	db_query("CREATE TABLE {multiform_submissions} (
196	multiform_submission_id SERIAL,
197	multiform_submission_parent_multiform_id integer default NULL,
198	multiform_submission_ip varchar(255) default NULL,
199	multiform_submission_datetime timestamp default NULL,
200	multiform_submission_status varchar(255) default NULL,
201	multiform_submission_unique_key text,
202	multiform_submission_edit_username varchar(255),
203	multiform_submission_edit_password varchar(255),
204	multiform_submission_draw_entry_counter integer default 0,
205	multiform_submission_total_answered int(10) default 0,
206	KEY multiform_submission_parent_multiform_id_key (multiform_submission_parent_multiform_id),
207	PRIMARY KEY (multiform_submission_id)
208	);");
209
210	db_query("CREATE TABLE {multiform_field_submissions} (
211	multiform_field_submission_id SERIAL,
212	multiform_field_submission_parent_submission_id integer default NULL,
213	multiform_field_submission_parent_field_id integer default NULL,
214	multiform_field_submission_value text,
215	KEY multiform_field_submission_parent_field_id_key (multiform_field_submission_parent_field_id),
216	KEY multiform_field_submission_parent_submission_id_key (multiform_field_submission_parent_submission_id),
217	PRIMARY KEY (multiform_field_submission_id)
218	);");
219
220	db_query("CREATE TABLE {multiform_draw_entries} (
221	multiform_draw_entry_id SERIAL,
222	multiform_draw_entry_parent_multiform_id integer default NULL,
223	multiform_draw_entry_parent_submission_id integer default NULL,
224	PRIMARY KEY (multiform_draw_entry_id)
225	);");
226
227	db_query("CREATE TABLE {multiform_snippets} (
228	multiform_snippet_id SERIAL,
229	multiform_snippet_name varchar(255) default NULL,
230	PRIMARY KEY (multiform_snippet_id)
231	);");
232
233	db_query("CREATE TABLE {multiform_snippet_fields} (
234	multiform_snippet_field_id SERIAL,
235	multiform_snippet_field_parent_id integer default NULL,
236	multiform_snippet_field_sortorder integer default NULL,
237	multiform_snippet_field_name varchar(255) default NULL,
238	multiform_snippet_field_description text,
239	multiform_snippet_field_type varchar(255) default NULL,
240	multiform_snippet_field_validation_type varchar(255) default NULL,
241	PRIMARY KEY (multiform_snippet_field_id)
242	);");
243
244	db_query("CREATE TABLE {multiform_snippet_field_options} (
245	multiform_snippet_field_option_id int(10) NOT NULL auto_increment,
246	multiform_snippet_field_option_parent_field_id int(10) default NULL,
247	multiform_snippet_field_option_text varchar(255) default NULL,
248	multiform_snippet_field_option_value varchar(255) default NULL,
249	multiform_snippet_field_option_sortorder int(10) default NULL,
250	KEY multiform_field_option_parent_field_id_key (multiform_field_option_parent_field_id),
251	PRIMARY KEY (multiform_snippet_field_option_id)
252	);");
253
254	db_query("CREATE TABLE {multiform_actions} (
255	multiform_action_id SERIAL,
256	multiform_action_type varchar(255) default NULL,
257	multiform_action_sortorder integer default NULL,
258	multiform_action_params text,
259	multiform_action_parent_type varchar(255) default NULL,
260	multiform_action_parent_id integer default NULL,
261	multiform_action_parent_trigger varchar(255) default NULL,
262	PRIMARY KEY (multiform_action_id)
263	);");
264
265	db_query("CREATE TABLE {multiform_field_options} (
266	multiform_field_option_id SERIAL,
267	multiform_field_option_parent_field_id integer default NULL,
268	multiform_field_option_text varchar(255),
269	multiform_field_option_value varchar(255),
270	multiform_field_option_sortorder integer,
271	PRIMARY KEY (multiform_field_option_id)
272	);");
273
274	break;
275	}
276
277	// Notify of changes
278	drupal_set_message(t('The multiforms module was successfully installed.'));
279	}
280
281	function multiforms_uninstall() {
282
283	db_query('DROP TABLE {multiforms}');
284	db_query('DROP TABLE {multiform_sections}');
285	db_query('DROP TABLE {multiform_fields}');
286	db_query('DROP TABLE {multiform_submissions}');
287	db_query('DROP TABLE {multiform_field_submissions}');
288	db_query('DROP TABLE {multiform_draw_entries}');
289	db_query('DROP TABLE {multiform_snippets}');
290	db_query('DROP TABLE {multiform_snippet_fields}');
291	db_query('DROP TABLE {multiform_actions}');
292
293	variable_del('multiform_default_completion_text');
294	variable_del('multiform_default_footer_text');
295	}
296
297	function multiforms_update_1() {
298
299	$items = array();
300
301	switch ($GLOBALS['db_type']) {
302
303	case 'mysql':
304	case 'mysqli':
305
306	$items[] = update_sql("CREATE TABLE {multiform_actions} (
307	multiform_action_id int(10) NOT NULL auto_increment,
308	multiform_action_type varchar(255) default NULL,
309	multiform_action_sortorder int(10) default NULL,
310	multiform_action_params longtext,
311	multiform_action_parent_type varchar(255) default NULL,
312	multiform_action_parent_id int(10) default NULL,
313	multiform_action_parent_trigger varchar(255) default NULL,
314	PRIMARY KEY (multiform_action_id)
315	) /!40100 DEFAULT CHARACTER SET utf8 /;");
316	break;
317
318	case 'pgsql':
319
320	$items[] = update_sql("CREATE TABLE {multiform_actions} (
321	multiform_action_id SERIAL,
322	multiform_action_type varchar(255) default NULL,
323	multiform_action_sortorder integer default NULL,
324	multiform_action_params text,
325	multiform_action_parent_type varchar(255) default NULL,
326	multiform_action_parent_id integer default NULL,
327	multiform_action_parent_trigger varchar(255) default NULL,
328	PRIMARY KEY (multiform_action_id)
329	);");
330	break;
331	}
332
333	return $items;
334	}
335
336	function multiforms_update_2() {
337
338	$items = array();
339	$items[] = update_sql("ALTER TABLE {multiform_submissions} ADD COLUMN multiform_submission_edit_username varchar(255)");
340	$items[] = update_sql("ALTER TABLE {multiform_submissions} ADD COLUMN multiform_submission_edit_password varchar(255)");
341
342	return $items;
343	}
344
345	function multiforms_update_3() {
346
347	$items = array();
348
349	switch ($GLOBALS['db_type']) {
350
351	case 'mysql':
352	case 'mysqli':
353
354	$items[] = update_sql("ALTER TABLE {multiform_submissions} ADD COLUMN multiform_submission_draw_entry_counter int(10) default 0");
355	break;
356
357	case 'pgsql':
358
359	$items[] = update_sql("ALTER TABLE {multiform_submissions} ADD COLUMN multiform_submission_draw_entry_counter integer default 0");
360	break;
361	}
362
363	return $items;
364	}
365
366	function multiforms_update_4() {
367
368	$items = array();
369
370	$items[] = update_sql("CREATE TABLE {multiform_field_options} (
371	multiform_field_option_id int(10) NOT NULL auto_increment,
372	multiform_field_option_parent_field_id int(10) default NULL,
373	multiform_field_option_text varchar(255),
374	multiform_field_option_value varchar(255),
375	multiform_field_option_sortorder int(10),
376	PRIMARY KEY (multiform_field_option_id)
377	) /!40100 DEFAULT CHARACTER SET utf8 /;");
378
379	return $items;
380	}
381
382	function multiforms_update_5() {
383
384	$items = array();
385
386	$items[] = update_sql("ALTER TABLE {multiform_sections} ADD COLUMN multiform_section_submit_button_text varchar(255)");
387
388	return $items;
389	}
390
391	function multiforms_update_6() {
392
393	$items = array();
394
395	$items[] = update_sql("ALTER TABLE {multiforms} ADD COLUMN multiform_completion_redirect varchar(255)");
396
397	return $items;
398	}
399
400	function multiforms_update_7() {
401
402	$items = array();
403
404	$items[] = update_sql("CREATE TABLE multiform_snippet_field_options (
405	multiform_snippet_field_option_id int(10) NOT NULL auto_increment,
406	multiform_snippet_field_option_parent_field_id int(10) default NULL,
407	multiform_snippet_field_option_text varchar(255) default NULL,
408	multiform_snippet_field_option_value varchar(255) default NULL,
409	multiform_snippet_field_option_sortorder int(10) default NULL,
410	PRIMARY KEY (multiform_snippet_field_option_id)
411	) /!40100 DEFAULT CHARACTER SET utf8 /;");
412
413	return $items;
414	}
415
416	function multiforms_update_8() {
417
418	$items = array();
419
420	$items[] = update_sql("ALTER TABLE {multiforms} ADD COLUMN multiform_submit_button_text varchar(255)");
421
422	return $items;
423	}
424
425	function multiforms_update_9() {
426
427	$items = array();
428
429	$items[] = update_sql("ALTER TABLE {multiforms} ADD COLUMN multiform_completion_submit_button_text varchar(255)");
430
431	return $items;
432	}
433
434	function multiforms_update_10() {
435
436	$items = array();
437	$items[] = update_sql("CREATE INDEX multiform_field_submission_parent_field_id_key ON {multiform_field_submissions} (multiform_field_submission_parent_field_id)");
438	$items[] = update_sql("CREATE INDEX multiform_field_submission_parent_submission_id_key ON {multiform_field_submissions} (multiform_field_submission_parent_submission_id)");
439	$items[] = update_sql("CREATE INDEX multiform_field_section_id_key ON {multiform_fields} (multiform_field_section_id)");
440	$items[] = update_sql("CREATE INDEX multiform_section_multiform_id_key ON {multiform_sections} (multiform_section_multiform_id)");
441	$items[] = update_sql("CREATE INDEX multiform_submission_parent_multiform_id_key ON {multiform_submissions} (multiform_submission_parent_multiform_id)");
442	$items[] = update_sql("CREATE INDEX multiform_field_option_parent_field_id_key ON {multiform_field_options} (multiform_field_option_parent_field_id)");
443
444	return $items;
445	}
446
447	function multiforms_update_11() {
448
449	$items = array();
450
451	$items[] = update_sql("ALTER TABLE {multiform_submissions} ADD COLUMN multiform_submission_total_answered INT(10) DEFAULT 0");
452
453	return $items;
454	}
455
456	function multiforms_update_12() {
457
458	$items = array();
459
460	$items[] = update_sql("ALTER TABLE {multiforms} ADD COLUMN multiform_flow_type INT(1) DEFAULT 1");
461
462	return $items;
463	}
464