modules/daemon/daemon.install

<?php
// $Id$

// Implements hook_install().
function daemon_install() {
  switch ($GLOBALS['db_type']) {
  case 'mysqli':
  case 'mysql':
    db_query("CREATE TABLE {daemon_daemon} (
      did int(10) unsigned NOT NULL default '0',
      name varchar(32) NOT NULL UNIQUE,
      description varchar(255),
      PRIMARY KEY (did),
      KEY (name)
    ) /*!40100 DEFAULT CHARACTER SET utf8 */");

    db_query("CREATE TABLE {daemon_listener} (
      did int(10) unsigned NOT NULL default '0',
      module varchar(64) NOT NULL,
      id varchar(64) NOT NULL,
      type varchar(5) NOT NULL,
      port smallint unsigned NOT NULL,
      KEY (did)
    ) /*!40100 DEFAULT CHARACTER SET utf8 */");

    db_query("CREATE TABLE {daemon_timer} (
      tid int(10) unsigned NOT NULL default '0',
      name varchar(32) NOT NULL,
      description varchar(255),
      timeout int unsigned NOT NULL,
      php text NOT NULL,
      PRIMARY KEY (name)
    ) /*!40100 DEFAULT CHARACTER SET utf8 */");

    db_query("CREATE TABLE {daemon_timer_daemon} (
      did int(10) unsigned NOT NULL default '0',
      tid int(10) unsigned NOT NULL default '0',
      KEY (did),
      KEY (tid),
      PRIMARY KEY (tid, did)
    ) /*!40100 DEFAULT CHARACTER SET utf8 */");
    break;
  
  case 'pgsql':
    db_query("CREATE TABLE {daemon_daemon} (
      did SERIAL,
      name varchar(32) NOT NULL UNIQUE,
      description varchar(255),
      PRIMARY KEY (did)
    )");
    db_query("CREATE INDEX {daemon_daemon}_name_idx ON {daemon_daemon} (name)");

    db_query("CREATE TABLE {daemon_listener} (
      did integer NOT NULL default '0',
      module varchar(64) NOT NULL,
      id varchar(64) NOT NULL,
      type varchar(5) NOT NULL,
      port smallint_unsigned NOT NULL
    )");
    db_query("CREATE INDEX {daemon_listener}_did_idx ON {daemon_listener} (did)");

    db_query("CREATE TABLE {daemon_timer} (
      tid SERIAL,
      name varchar(32) NOT NULL UNIQUE,
      description varchar(255),
      timeout int_unsigned NOT NULL,
      php text NOT NULL,
      PRIMARY KEY (tid)
    )");
    db_query("CREATE INDEX {daemon_timer}_name_idx ON {daemon_timer} (name)");

    db_query("CREATE TABLE {daemon_timer_daemon} (
      did integer NOT NULL default '0',
      tid integer NOT NULL default '0',
      PRIMARY KEY (tid, did)
    )");
    db_query("CREATE INDEX {daemon_timer_daemon}_did_idx ON {daemon_timer_daemon} (did)");
    db_query("CREATE INDEX {daemon_timer_daemon}_tid_idx ON {daemon_timer_daemon} (tid)");
    break;
  }
}

// Implements hook_uninstall().
function daemon_uninstall() {
  if (db_table_exists('daemon_daemon')) {
    db_query("DROP TABLE {daemon_daemon}");
  }
  
  if (db_table_exists('daemon_listener')) {
    db_query("DROP TABLE {daemon_listener}");
  }
  
  if (db_table_exists('daemon_timer')) {
    db_query("DROP TABLE {daemon_timer}");
  }
  
  if (db_table_exists('daemon_timer_daemon')) {
    db_query("DROP TABLE {daemon_timer_daemon}");
  }
}
1	<?php
2	// $Id$
3
4	// Implements hook_install().
5	function daemon_install() {
6	switch ($GLOBALS['db_type']) {
7	case 'mysqli':
8	case 'mysql':
9	db_query("CREATE TABLE {daemon_daemon} (
10	did int(10) unsigned NOT NULL default '0',
11	name varchar(32) NOT NULL UNIQUE,
12	description varchar(255),
13	PRIMARY KEY (did),
14	KEY (name)
15	) /!40100 DEFAULT CHARACTER SET utf8 /");
16
17	db_query("CREATE TABLE {daemon_listener} (
18	did int(10) unsigned NOT NULL default '0',
19	module varchar(64) NOT NULL,
20	id varchar(64) NOT NULL,
21	type varchar(5) NOT NULL,
22	port smallint unsigned NOT NULL,
23	KEY (did)
24	) /!40100 DEFAULT CHARACTER SET utf8 /");
25
26	db_query("CREATE TABLE {daemon_timer} (
27	tid int(10) unsigned NOT NULL default '0',
28	name varchar(32) NOT NULL,
29	description varchar(255),
30	timeout int unsigned NOT NULL,
31	php text NOT NULL,
32	PRIMARY KEY (name)
33	) /!40100 DEFAULT CHARACTER SET utf8 /");
34
35	db_query("CREATE TABLE {daemon_timer_daemon} (
36	did int(10) unsigned NOT NULL default '0',
37	tid int(10) unsigned NOT NULL default '0',
38	KEY (did),
39	KEY (tid),
40	PRIMARY KEY (tid, did)
41	) /!40100 DEFAULT CHARACTER SET utf8 /");
42	break;
43
44	case 'pgsql':
45	db_query("CREATE TABLE {daemon_daemon} (
46	did SERIAL,
47	name varchar(32) NOT NULL UNIQUE,
48	description varchar(255),
49	PRIMARY KEY (did)
50	)");
51	db_query("CREATE INDEX {daemon_daemon}_name_idx ON {daemon_daemon} (name)");
52
53	db_query("CREATE TABLE {daemon_listener} (
54	did integer NOT NULL default '0',
55	module varchar(64) NOT NULL,
56	id varchar(64) NOT NULL,
57	type varchar(5) NOT NULL,
58	port smallint_unsigned NOT NULL
59	)");
60	db_query("CREATE INDEX {daemon_listener}_did_idx ON {daemon_listener} (did)");
61
62	db_query("CREATE TABLE {daemon_timer} (
63	tid SERIAL,
64	name varchar(32) NOT NULL UNIQUE,
65	description varchar(255),
66	timeout int_unsigned NOT NULL,
67	php text NOT NULL,
68	PRIMARY KEY (tid)
69	)");
70	db_query("CREATE INDEX {daemon_timer}_name_idx ON {daemon_timer} (name)");
71
72	db_query("CREATE TABLE {daemon_timer_daemon} (
73	did integer NOT NULL default '0',
74	tid integer NOT NULL default '0',
75	PRIMARY KEY (tid, did)
76	)");
77	db_query("CREATE INDEX {daemon_timer_daemon}_did_idx ON {daemon_timer_daemon} (did)");
78	db_query("CREATE INDEX {daemon_timer_daemon}_tid_idx ON {daemon_timer_daemon} (tid)");
79	break;
80	}
81	}
82
83	// Implements hook_uninstall().
84	function daemon_uninstall() {
85	if (db_table_exists('daemon_daemon')) {
86	db_query("DROP TABLE {daemon_daemon}");
87	}
88
89	if (db_table_exists('daemon_listener')) {
90	db_query("DROP TABLE {daemon_listener}");
91	}
92
93	if (db_table_exists('daemon_timer')) {
94	db_query("DROP TABLE {daemon_timer}");
95	}
96
97	if (db_table_exists('daemon_timer_daemon')) {
98	db_query("DROP TABLE {daemon_timer_daemon}");
99	}
100	}