modules/simple_review/simple_review.install

<?php
// $Id: simple_review.install,v 1.1 2007/09/09 17:07:10 smk Exp $

function simple_review_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {simple_review} (
          cid int(10) unsigned NOT NULL,
          vid int(10) unsigned NOT NULL,
          PRIMARY KEY (cid)
      )");
      break;

    case 'pgsql':
      db_query("CREATE TABLE {simple_review} (
          cid INTEGER NOT NULL,
          vid INTEGER NOT NULL,
          PRIMARY KEY (cid)
      )");
      break;
  }
}

function simple_review_uninstall() {
  db_query("DROP TABLE {simple_review}");
  db_query("DELETE FROM {variable} WHERE name LIKE 'simple_review_%%'");
  cache_clear_all('variables', 'cache');
}

1	<?php
2	// $Id: simple_review.install,v 1.1 2007/09/09 17:07:10 smk Exp $
3
4	function simple_review_install() {
5	switch ($GLOBALS['db_type']) {
6	case 'mysql':
7	case 'mysqli':
8	db_query("CREATE TABLE {simple_review} (
9	cid int(10) unsigned NOT NULL,
10	vid int(10) unsigned NOT NULL,
11	PRIMARY KEY (cid)
12	)");
13	break;
14
15	case 'pgsql':
16	db_query("CREATE TABLE {simple_review} (
17	cid INTEGER NOT NULL,
18	vid INTEGER NOT NULL,
19	PRIMARY KEY (cid)
20	)");
21	break;
22	}
23	}
24
25	function simple_review_uninstall() {
26	db_query("DROP TABLE {simple_review}");
27	db_query("DELETE FROM {variable} WHERE name LIKE 'simple_review_%%'");
28	cache_clear_all('variables', 'cache');
29	}
30