modules/object_driver/member_list.install

<?php
// $Id: member_list.module,v 1.2 2007/01/26 02:50:59 pwolanin Exp $

/**
 * Example module to show simple implementations of object_diver hooks.
 */


/**
 * implementation of hook_install
 *
 */
function member_list_install() {
  
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {household} (
        household_id int unsigned NOT NULL auto_increment,
        address varchar(128) NOT NULL default '',
        city varchar(128) NOT NULL default '',
        state varchar(4) NOT NULL default '',
        zip varchar(10) NOT NULL default '',
        howmany int NOT NULL default 0,
        member varchar(128) NOT NULL default '',
        mail varchar(128) NOT NULL default '',
        PRIMARY KEY (household_id)
      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
      break;
    case 'pgsql':
      db_query("CREATE TABLE {household} (
        household_id serial,
        address varchar(128) NOT NULL default '',
        city varchar(128) NOT NULL default '',
        state varchar(4) NOT NULL default '',
        zip varchar(10) NOT NULL default '',
        number int NOT NULL default 0,
        member varchar(128) NOT NULL default '',
        mail varchar(128) NOT NULL default '',
        PRIMARY KEY (household_id)
      )");
    break;
  }


}


/**
 * implementation of hook_uninstall
 *
 */
function member_list_uninstall() {

  db_query("DROP TABLE {household}");
}
1	<?php
2	// $Id: member_list.module,v 1.2 2007/01/26 02:50:59 pwolanin Exp $
3
4	/**
5	* Example module to show simple implementations of object_diver hooks.
6	*/
7
8
9
10	/**
11	* implementation of hook_install
12	*
13	*/
14	function member_list_install() {
15
16	switch ($GLOBALS['db_type']) {
17	case 'mysql':
18	case 'mysqli':
19	db_query("CREATE TABLE {household} (
20	household_id int unsigned NOT NULL auto_increment,
21	address varchar(128) NOT NULL default '',
22	city varchar(128) NOT NULL default '',
23	state varchar(4) NOT NULL default '',
24	zip varchar(10) NOT NULL default '',
25	howmany int NOT NULL default 0,
26	member varchar(128) NOT NULL default '',
27	mail varchar(128) NOT NULL default '',
28	PRIMARY KEY (household_id)
29	) /!40100 DEFAULT CHARACTER SET UTF8 / ");
30	break;
31	case 'pgsql':
32	db_query("CREATE TABLE {household} (
33	household_id serial,
34	address varchar(128) NOT NULL default '',
35	city varchar(128) NOT NULL default '',
36	state varchar(4) NOT NULL default '',
37	zip varchar(10) NOT NULL default '',
38	number int NOT NULL default 0,
39	member varchar(128) NOT NULL default '',
40	mail varchar(128) NOT NULL default '',
41	PRIMARY KEY (household_id)
42	)");
43	break;
44	}
45
46
47	}
48
49
50	/**
51	* implementation of hook_uninstall
52	*
53	*/
54	function member_list_uninstall() {
55
56	db_query("DROP TABLE {household}");
57	}