modules/lmo/lmo.install

<?
// $Id: lmo.install,v 1.1 2007/09/21 09:06:28 martinsfromb Exp $

function lmo_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysqli':
    case 'mysql':     
      $result = db_query("
        CREATE TABLE {lmo_blocks} (
    		id INT( 11 ) NOT NULL AUTO_INCREMENT ,
    		type VARCHAR( 50 ) ,
        option1 VARCHAR( 50 ) ,
        option2 VARCHAR( 50 ) ,
        option3 VARCHAR( 50 ) ,
        title VARCHAR( 50 ) ,
        intro TEXT NULL DEFAULT NULL,
        conclusion TEXT NULL DEFAULT NULL,
    		PRIMARY KEY ( id ) ,
    		INDEX ( type))"
  		); 
      break;
    case 'pgsql':
      $result = db_query("
    	  CREATE TABLE {lmo_blocks} (
    		id numeric( 11 ) NOT NULL AUTO_INCREMENT ,
        type VARCHAR( 50 ) ,
        option1 VARCHAR( 50 ) ,
        option2 VARCHAR( 50 ) ,
        option3 VARCHAR( 50 ) ,
        title VARCHAR( 50 ) ,
        intro varchar(255) NULL DEFAULT NULL,
        conclusion varchar(255) NULL DEFAULT NULL,
    		PRIMARY KEY ( id ) ,
    		INDEX ( type))"
  		); 
  		break;
    default:
      break;
  }
  
  if ($result) {
    drupal_set_message(t('LMO module database tables installed successfully.'));
  }
  else {
    drupal_set_message(t('LMO module database table creation was unsuccessful.'), 'error');
  }
}

function lmo_uninstall() {
  db_query('DROP TABLE {lmo_blocks}');
}

function lmo_update_1() {
    lmo_install();
}
?>
1	<?
2	// $Id: lmo.install,v 1.1 2007/09/21 09:06:28 martinsfromb Exp $
3
4	function lmo_install() {
5	switch ($GLOBALS['db_type']) {
6	case 'mysqli':
7	case 'mysql':
8	$result = db_query("
9	CREATE TABLE {lmo_blocks} (
10	id INT( 11 ) NOT NULL AUTO_INCREMENT ,
11	type VARCHAR( 50 ) ,
12	option1 VARCHAR( 50 ) ,
13	option2 VARCHAR( 50 ) ,
14	option3 VARCHAR( 50 ) ,
15	title VARCHAR( 50 ) ,
16	intro TEXT NULL DEFAULT NULL,
17	conclusion TEXT NULL DEFAULT NULL,
18	PRIMARY KEY ( id ) ,
19	INDEX ( type))"
20	);
21	break;
22	case 'pgsql':
23	$result = db_query("
24	CREATE TABLE {lmo_blocks} (
25	id numeric( 11 ) NOT NULL AUTO_INCREMENT ,
26	type VARCHAR( 50 ) ,
27	option1 VARCHAR( 50 ) ,
28	option2 VARCHAR( 50 ) ,
29	option3 VARCHAR( 50 ) ,
30	title VARCHAR( 50 ) ,
31	intro varchar(255) NULL DEFAULT NULL,
32	conclusion varchar(255) NULL DEFAULT NULL,
33	PRIMARY KEY ( id ) ,
34	INDEX ( type))"
35	);
36	break;
37	default:
38	break;
39	}
40
41	if ($result) {
42	drupal_set_message(t('LMO module database tables installed successfully.'));
43	}
44	else {
45	drupal_set_message(t('LMO module database table creation was unsuccessful.'), 'error');
46	}
47	}
48
49	function lmo_uninstall() {
50	db_query('DROP TABLE {lmo_blocks}');
51	}
52
53	function lmo_update_1() {
54	lmo_install();
55	}
56	?>