modules/connect/connect.install

<?php
// $Id$

/**
 * Implementation of hook_uninstall().
 */
function connect_uninstall() {
  db_query('DROP TABLE {connect_data};');
  db_query('DROP TABLE {connect_cache};');
  db_query('DELETE FROM {variable} WHERE name LIKE \'connect_%\';');
}

/**
 * Implementation of hook_install().
 */
function connect_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query( "CREATE TABLE {connect_data} (
        id int(11) NOT NULL auto_increment,
        nid int(10) unsigned NOT NULL default '0',
        pid int(10) unsigned NOT NULL default '0',
        PRIMARY KEY (id)
        ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */"
      );
      break;
  }
}

/**
 *
 */

function connect_update_1() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query( "CREATE TABLE {connect_cache} (
        id int(11) NOT NULL auto_increment,
        type varchar(64) NOT NULL default '',
        source varchar(128) NOT NULL default '',
        target TEXT NOT NULL,
        created int(11) NOT NULL default '0',
        PRIMARY KEY (id)
        ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */"
      );
      break;
  }
}

1	<?php
2	// $Id$
3
4	/**
5	* Implementation of hook_uninstall().
6	*/
7	function connect_uninstall() {
8	db_query('DROP TABLE {connect_data};');
9	db_query('DROP TABLE {connect_cache};');
10	db_query('DELETE FROM {variable} WHERE name LIKE \'connect_%\';');
11	}
12
13	/**
14	* Implementation of hook_install().
15	*/
16	function connect_install() {
17	switch ($GLOBALS['db_type']) {
18	case 'mysql':
19	case 'mysqli':
20	db_query( "CREATE TABLE {connect_data} (
21	id int(11) NOT NULL auto_increment,
22	nid int(10) unsigned NOT NULL default '0',
23	pid int(10) unsigned NOT NULL default '0',
24	PRIMARY KEY (id)
25	) TYPE=MyISAM /!40100 DEFAULT CHARACTER SET utf8 /"
26	);
27	break;
28	}
29	}
30
31	/**
32	*
33	*/
34
35	function connect_update_1() {
36	switch ($GLOBALS['db_type']) {
37	case 'mysql':
38	case 'mysqli':
39	db_query( "CREATE TABLE {connect_cache} (
40	id int(11) NOT NULL auto_increment,
41	type varchar(64) NOT NULL default '',
42	source varchar(128) NOT NULL default '',
43	target TEXT NOT NULL,
44	created int(11) NOT NULL default '0',
45	PRIMARY KEY (id)
46	) TYPE=MyISAM /!40100 DEFAULT CHARACTER SET utf8 /"
47	);
48	break;
49	}
50	}
51