modules/menutranslation/menutranslation.install

<?php

function menutranslation_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {menutranslation} (
          mid int unsigned NOT NULL,
          lang varchar(12) NOT NULL,
          title varchar(255) NOT NULL default '',
          PRIMARY KEY (mid,lang)
        ) /*!40100 DEFAULT CHARACTER SET utf8 */;");
      break;
    case 'pgsql':
      db_query("CREATE TABLE {menutranslation} (
          mid int4 NOT NULL,
          lang varchar(12) NOT NULL,
          title varchar(256) NOT NULL,
          CONSTRAINT menutranslation_pkey PRIMARY KEY (mid, lang)
        );");
      break;    
  }
}

function menutranslation_uninstall() {
  db_query('DROP TABLE {menutranslation}');
  variable_del('menutranslation_menu');
}
?>
1	<?php
2
3	function menutranslation_install() {
4	switch ($GLOBALS['db_type']) {
5	case 'mysql':
6	case 'mysqli':
7	db_query("CREATE TABLE {menutranslation} (
8	mid int unsigned NOT NULL,
9	lang varchar(12) NOT NULL,
10	title varchar(255) NOT NULL default '',
11	PRIMARY KEY (mid,lang)
12	) /!40100 DEFAULT CHARACTER SET utf8 /;");
13	break;
14	case 'pgsql':
15	db_query("CREATE TABLE {menutranslation} (
16	mid int4 NOT NULL,
17	lang varchar(12) NOT NULL,
18	title varchar(256) NOT NULL,
19	CONSTRAINT menutranslation_pkey PRIMARY KEY (mid, lang)
20	);");
21	break;
22	}
23	}
24
25	function menutranslation_uninstall() {
26	db_query('DROP TABLE {menutranslation}');
27	variable_del('menutranslation_menu');
28	}
29	?>