modules/promise/promise.install

<?php
// $Id: promise.install,v 1.1 2007/01/28 23:17:08 kreynen Exp $

/**
 * Implementation of hook_install().
 */
function promise_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
        db_query("CREATE TABLE {promise} (
          nid int(10) unsigned NOT NULL default '0',
          duedate int(11) unsigned NOT NULL default '0',
          quota int(10) unsigned NOT NULL default '0',
          PRIMARY KEY (nid)
        ) /*!40100 DEFAULT CHARACTER SET utf8 */;"
      );
     db_query("CREATE TABLE {promise_signed} (
          id int(11) unsigned NOT NULL default '0',
          nid int(11) unsigned NOT NULL default '0',
          uid int(11) unsigned NOT NULL default '0',
          signed int(11) unsigned NOT NULL default '0',
          PRIMARY KEY (id)
        )/*!40100 DEFAULT CHARACTER SET utf8 AUTO_INCREMENT=2 */;"
      );
    break;
    case 'mysqli':
      db_query("CREATE TABLE {promise} (
          nid int(10) unsigned NOT NULL default '0',
          duedate int(11) unsigned NOT NULL default '0',
          quota int(10) unsigned NOT NULL default '0',
          PRIMARY KEY (nid)
        ) /*!40100 DEFAULT CHARACTER SET utf8 */;"
      );
      db_query("CREATE TABLE {promise_signed} (
          id int(11) unsigned NOT NULL default '0',
          nid int(11) unsigned NOT NULL default '0',
          uid int(11) unsigned NOT NULL default '0',
          signed int(11) unsigned NOT NULL default '0',
          PRIMARY KEY (id)
        )/*!40100 DEFAULT CHARACTER SET utf8 AUTO_INCREMENT=2 */;"
      );
      break;
    case 'pgsql':
      break;
  }
}

/**
 * Implementation of hook_uninstall().
 */
function promise_uninstall() {
  db_query('DROP TABLE {promise, promise_signed}');
}
1	<?php
2	// $Id: promise.install,v 1.1 2007/01/28 23:17:08 kreynen Exp $
3
4	/**
5	* Implementation of hook_install().
6	*/
7	function promise_install() {
8	switch ($GLOBALS['db_type']) {
9	case 'mysql':
10	db_query("CREATE TABLE {promise} (
11	nid int(10) unsigned NOT NULL default '0',
12	duedate int(11) unsigned NOT NULL default '0',
13	quota int(10) unsigned NOT NULL default '0',
14	PRIMARY KEY (nid)
15	) /!40100 DEFAULT CHARACTER SET utf8 /;"
16	);
17	db_query("CREATE TABLE {promise_signed} (
18	id int(11) unsigned NOT NULL default '0',
19	nid int(11) unsigned NOT NULL default '0',
20	uid int(11) unsigned NOT NULL default '0',
21	signed int(11) unsigned NOT NULL default '0',
22	PRIMARY KEY (id)
23	)/!40100 DEFAULT CHARACTER SET utf8 AUTO_INCREMENT=2 /;"
24	);
25	break;
26	case 'mysqli':
27	db_query("CREATE TABLE {promise} (
28	nid int(10) unsigned NOT NULL default '0',
29	duedate int(11) unsigned NOT NULL default '0',
30	quota int(10) unsigned NOT NULL default '0',
31	PRIMARY KEY (nid)
32	) /!40100 DEFAULT CHARACTER SET utf8 /;"
33	);
34	db_query("CREATE TABLE {promise_signed} (
35	id int(11) unsigned NOT NULL default '0',
36	nid int(11) unsigned NOT NULL default '0',
37	uid int(11) unsigned NOT NULL default '0',
38	signed int(11) unsigned NOT NULL default '0',
39	PRIMARY KEY (id)
40	)/!40100 DEFAULT CHARACTER SET utf8 AUTO_INCREMENT=2 /;"
41	);
42	break;
43	case 'pgsql':
44	break;
45	}
46	}
47
48	/**
49	* Implementation of hook_uninstall().
50	*/
51	function promise_uninstall() {
52	db_query('DROP TABLE {promise, promise_signed}');
53	}