spaces/spaces_announce/spaces_announce.install

<?php
// $Id:$

/**
 * Implementaton of hook_install().
 */
function spaces_announce_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysqli':
    case 'mysql':
      db_query("UPDATE {system} SET weight = 25 WHERE name = 'spaces_announce'");
      db_query("CREATE TABLE {spaces_announce} (
                nid int(10) NOT NULL default '0',
                gid int(10) NOT NULL default '0',
                KEY (nid),
                KEY (gid)
                ) /*!40100 DEFAULT CHARACTER SET UTF8 */");
      db_query("CREATE TABLE {spaces_announce_log} (
                nid int(10) NOT NULL default '0',
                count int NOT NULL default '0',
                viewed int unsigned NOT NULL default '0',
                KEY (nid)
                ) /*!40100 DEFAULT CHARACTER SET UTF8 */");
  }
}

/**
 * Implmentation of hook_uninstall().
 */
function spaces_announce_uninstall() {
  db_query('DROP TABLE {spaces_announce}');
  db_query('DROP TABLE {spaces_announce_log}');
}
1	<?php
2	// $Id:$
3
4	/**
5	* Implementaton of hook_install().
6	*/
7	function spaces_announce_install() {
8	switch ($GLOBALS['db_type']) {
9	case 'mysqli':
10	case 'mysql':
11	db_query("UPDATE {system} SET weight = 25 WHERE name = 'spaces_announce'");
12	db_query("CREATE TABLE {spaces_announce} (
13	nid int(10) NOT NULL default '0',
14	gid int(10) NOT NULL default '0',
15	KEY (nid),
16	KEY (gid)
17	) /!40100 DEFAULT CHARACTER SET UTF8 /");
18	db_query("CREATE TABLE {spaces_announce_log} (
19	nid int(10) NOT NULL default '0',
20	count int NOT NULL default '0',
21	viewed int unsigned NOT NULL default '0',
22	KEY (nid)
23	) /!40100 DEFAULT CHARACTER SET UTF8 /");
24	}
25	}
26
27	/**
28	* Implmentation of hook_uninstall().
29	*/
30	function spaces_announce_uninstall() {
31	db_query('DROP TABLE {spaces_announce}');
32	db_query('DROP TABLE {spaces_announce_log}');
33	}