modules/emailmarketer/emailmarketer.install

<?php
/* $Id$ */

define('EMAILMARKETER_TABLE', 'emailmarketer');
define('EMAILMARKETER_QUEUE', 'emailmarketer_queue');

/**
 * Install procedure
 */
function emailmarketer_install() {
  if (!db_table_exists(EMAILMARKETER_TABLE)) {
    switch ($GLOBALS['db_type']) {
      case 'mysql':
      case 'mysqli':
        db_query("CREATE TABLE {%s} (
          eid int unsigned NOT NULL auto_increment,
          email varchar(255) NOT NULL,
          version varchar(15) default '1.80',
          activated varchar(5) NOT NULL default 'True',
          name varchar(255) NOT NULL,
          email_subscribe varchar(255),
          subject_subscribe varchar(255),
          email_unsubscribe varchar(255),
          subject_unsubscribe varchar(255),
          subscribe_text text,
          subscribe_html text,
          roles varchar(255),
          fields_fixed text,
          add_fields text,
          PRIMARY KEY (eid),
          UNIQUE KEY idx (email)
        ) /*!40100 DEFAULT CHARACTER SET utf8 */", EMAILMARKETER_TABLE);
      break;
      case 'pgsql':
        db_query("CREATE TABLE {%s} (
          eid serial,
          email varchar(255) NOT NULL,
          version varchar(15) default '1.80',
          activated varchar(5) NOT NULL default 'True',
          name varchar(255) NOT NULL,
          email_subscribe varchar(255),
          subject_subscribe varchar(255),
          email_unsubscribe varchar(255),
          subject_unsubscribe varchar(255),
          subscribe_text text,
          subscribe_html text,
          roles varchar(255),
          fields_fixed text,
          add_fields text,
          PRIMARY KEY (eid),
          UNIQUE idx (email)
        )", EMAILMARKETER_TABLE);
      break;
    }
  }
  if (!db_table_exists(EMAILMARKETER_QUEUE)) {
    switch ($GLOBALS['db_type']) {
      case 'mysql':
      case 'mysqli':
        db_query("CREATE TABLE {%s} (
          qid varchar(32) NOT NULL,
          eid int unsigned NOT NULL,
          registered int(11) unsigned NOT NULL,
          email varchar(255) NOT NULL,
          subscribe_fields longtext,
          PRIMARY KEY (qid),
          UNIQUE KEY idx (eid, email)
        ) /*!40100 DEFAULT CHARACTER SET utf8 */", EMAILMARKETER_QUEUE);
      break;
      case 'pgsql':
        db_query("CREATE TABLE {%s} (
          qid varchar(32) NOT NULL,
          eid integer NOT NULL,
          registered integer NOT NULL,
          email varchar(255) NOT NULL,
          subscribe_fields text,
          PRIMARY KEY (qid),
          UNIQUE idx (eid, email)
        )", EMAILMARKETER_QUEUE);
      break;
    }
  }
        
}

/**
 * Uninstall procedure
 */
function emailmarketer_uninstall() {
  if (db_table_exists(EMAILMARKETER_TABLE)) {
    db_query("DROP TABLE {%s}", EMAILMARKETER_TABLE);
  }
  if (db_table_exists(EMAILMARKETER_QUEUE)) {
    db_query("DROP TABLE {%s}", EMAILMARKETER_QUEUE);
  }
  variable_del('emailmarketer_message');
  variable_del('emailmarketer_title');
}
1	<?php
2	/* $Id$ */
3
4	define('EMAILMARKETER_TABLE', 'emailmarketer');
5	define('EMAILMARKETER_QUEUE', 'emailmarketer_queue');
6
7	/**
8	* Install procedure
9	*/
10	function emailmarketer_install() {
11	if (!db_table_exists(EMAILMARKETER_TABLE)) {
12	switch ($GLOBALS['db_type']) {
13	case 'mysql':
14	case 'mysqli':
15	db_query("CREATE TABLE {%s} (
16	eid int unsigned NOT NULL auto_increment,
17	email varchar(255) NOT NULL,
18	version varchar(15) default '1.80',
19	activated varchar(5) NOT NULL default 'True',
20	name varchar(255) NOT NULL,
21	email_subscribe varchar(255),
22	subject_subscribe varchar(255),
23	email_unsubscribe varchar(255),
24	subject_unsubscribe varchar(255),
25	subscribe_text text,
26	subscribe_html text,
27	roles varchar(255),
28	fields_fixed text,
29	add_fields text,
30	PRIMARY KEY (eid),
31	UNIQUE KEY idx (email)
32	) /!40100 DEFAULT CHARACTER SET utf8 /", EMAILMARKETER_TABLE);
33	break;
34	case 'pgsql':
35	db_query("CREATE TABLE {%s} (
36	eid serial,
37	email varchar(255) NOT NULL,
38	version varchar(15) default '1.80',
39	activated varchar(5) NOT NULL default 'True',
40	name varchar(255) NOT NULL,
41	email_subscribe varchar(255),
42	subject_subscribe varchar(255),
43	email_unsubscribe varchar(255),
44	subject_unsubscribe varchar(255),
45	subscribe_text text,
46	subscribe_html text,
47	roles varchar(255),
48	fields_fixed text,
49	add_fields text,
50	PRIMARY KEY (eid),
51	UNIQUE idx (email)
52	)", EMAILMARKETER_TABLE);
53	break;
54	}
55	}
56	if (!db_table_exists(EMAILMARKETER_QUEUE)) {
57	switch ($GLOBALS['db_type']) {
58	case 'mysql':
59	case 'mysqli':
60	db_query("CREATE TABLE {%s} (
61	qid varchar(32) NOT NULL,
62	eid int unsigned NOT NULL,
63	registered int(11) unsigned NOT NULL,
64	email varchar(255) NOT NULL,
65	subscribe_fields longtext,
66	PRIMARY KEY (qid),
67	UNIQUE KEY idx (eid, email)
68	) /!40100 DEFAULT CHARACTER SET utf8 /", EMAILMARKETER_QUEUE);
69	break;
70	case 'pgsql':
71	db_query("CREATE TABLE {%s} (
72	qid varchar(32) NOT NULL,
73	eid integer NOT NULL,
74	registered integer NOT NULL,
75	email varchar(255) NOT NULL,
76	subscribe_fields text,
77	PRIMARY KEY (qid),
78	UNIQUE idx (eid, email)
79	)", EMAILMARKETER_QUEUE);
80	break;
81	}
82	}
83
84	}
85
86	/**
87	* Uninstall procedure
88	*/
89	function emailmarketer_uninstall() {
90	if (db_table_exists(EMAILMARKETER_TABLE)) {
91	db_query("DROP TABLE {%s}", EMAILMARKETER_TABLE);
92	}
93	if (db_table_exists(EMAILMARKETER_QUEUE)) {
94	db_query("DROP TABLE {%s}", EMAILMARKETER_QUEUE);
95	}
96	variable_del('emailmarketer_message');
97	variable_del('emailmarketer_title');
98	}