modules/ec2/ec2.install

<?php
// $Id$

/**
 * @file
 * Update file for the ec2 module. All functions in this file are
 * implementations of hook_update_N(), unless indicated otherwise.
 */

/**
 * Implementation of hook_install().
 */
function ec2_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {ec2_instance} (
      	title varchar(128) NOT NULL default '',
        instance_id varchar(12) NOT NULL default '',
        PRIMARY KEY (title),
        KEY(instance_id)
        ) /*!40100 DEFAULT CHARACTER SET utf8 */
      ");
      db_query("CREATE TABLE {ec2_image} (
        image_id varchar(12) NOT NULL default '',
        PRIMARY KEY (image_id)
        ) /*!40100 DEFAULT CHARACTER SET utf8 */
      ");
      db_query("CREATE TABLE {ec2_key} (
        name varchar(128) NOT NULL default '',
        fingerprint varchar(128) NOT NULL default '',
        private_key text NOT NULL default '',
        PRIMARY KEY (name)
        ) /*!40100 DEFAULT CHARACTER SET utf8 */
      ");
      break;
    case 'pgsql':
      db_query("CREATE TABLE {ec2_instance} (
      	title varchar(128) NOT NULL default '',
        instance_id varchar(12) NOT NULL default '',
        PRIMARY KEY (title),
        KEY(instance_id)
        )
      ");
      db_query("CREATE TABLE {ec2_image} (
        image_id varchar(12) NOT NULL default '',
        PRIMARY KEY (image_id)
        )
      ");
      db_query("CREATE TABLE {ec2_key} (
        name varchar(128) NOT NULL default '',
        fingerprint varchar(128) NOT NULL default '',
        private_key text NOT NULL default '',
        PRIMARY KEY (name)
        ) 
      ");
      break;
  }
}


function ec2_uninstall() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
    case 'pgsql':
      db_query('DROP TABLE {ec2_instance}');
      db_query('DROP TABLE {ec2_image}');
      db_query('DROP TABLE {ec2_key}');
      break;
  }
}

?>
1	<?php
2	// $Id$
3
4	/**
5	* @file
6	* Update file for the ec2 module. All functions in this file are
7	* implementations of hook_update_N(), unless indicated otherwise.
8	*/
9
10	/**
11	* Implementation of hook_install().
12	*/
13	function ec2_install() {
14	switch ($GLOBALS['db_type']) {
15	case 'mysql':
16	case 'mysqli':
17	db_query("CREATE TABLE {ec2_instance} (
18	title varchar(128) NOT NULL default '',
19	instance_id varchar(12) NOT NULL default '',
20	PRIMARY KEY (title),
21	KEY(instance_id)
22	) /!40100 DEFAULT CHARACTER SET utf8 /
23	");
24	db_query("CREATE TABLE {ec2_image} (
25	image_id varchar(12) NOT NULL default '',
26	PRIMARY KEY (image_id)
27	) /!40100 DEFAULT CHARACTER SET utf8 /
28	");
29	db_query("CREATE TABLE {ec2_key} (
30	name varchar(128) NOT NULL default '',
31	fingerprint varchar(128) NOT NULL default '',
32	private_key text NOT NULL default '',
33	PRIMARY KEY (name)
34	) /!40100 DEFAULT CHARACTER SET utf8 /
35	");
36	break;
37	case 'pgsql':
38	db_query("CREATE TABLE {ec2_instance} (
39	title varchar(128) NOT NULL default '',
40	instance_id varchar(12) NOT NULL default '',
41	PRIMARY KEY (title),
42	KEY(instance_id)
43	)
44	");
45	db_query("CREATE TABLE {ec2_image} (
46	image_id varchar(12) NOT NULL default '',
47	PRIMARY KEY (image_id)
48	)
49	");
50	db_query("CREATE TABLE {ec2_key} (
51	name varchar(128) NOT NULL default '',
52	fingerprint varchar(128) NOT NULL default '',
53	private_key text NOT NULL default '',
54	PRIMARY KEY (name)
55	)
56	");
57	break;
58	}
59	}
60
61
62	function ec2_uninstall() {
63	switch ($GLOBALS['db_type']) {
64	case 'mysql':
65	case 'mysqli':
66	case 'pgsql':
67	db_query('DROP TABLE {ec2_instance}');
68	db_query('DROP TABLE {ec2_image}');
69	db_query('DROP TABLE {ec2_key}');
70	break;
71	}
72	}
73
74	?>