modules/dependent/dependent.install

<?php
// $Id: dependent.install,v 1.1 2008/03/07 09:42:10 levyofi Exp $

function dependent_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysqli':
    case 'mysql':
    case 'pgsql':
      db_query("CREATE TABLE if not exists {field_dependencies} (
        parent_field_name varchar(32) NOT NULL,
        child_field_name varchar(32) NOT NULL,
        parent_node_type_name varchar(32) NOT NULL,
        child_node_type_name varchar(32) NOT NULL,
        option_text varchar(255),
        put_after_parent boolean default 0,
        is_required boolean default 0,
        PRIMARY KEY(parent_field_name,child_field_name,parent_node_type_name,child_node_type_name)                                         
      ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;");
      break;
       default:
      break;
  }
}  

function dependent_uninstall() {
   db_query("DROP TABLE {field_dependencies}");
}
1	<?php
2	// $Id: dependent.install,v 1.1 2008/03/07 09:42:10 levyofi Exp $
3
4	function dependent_install() {
5	switch ($GLOBALS['db_type']) {
6	case 'mysqli':
7	case 'mysql':
8	case 'pgsql':
9	db_query("CREATE TABLE if not exists {field_dependencies} (
10	parent_field_name varchar(32) NOT NULL,
11	child_field_name varchar(32) NOT NULL,
12	parent_node_type_name varchar(32) NOT NULL,
13	child_node_type_name varchar(32) NOT NULL,
14	option_text varchar(255),
15	put_after_parent boolean default 0,
16	is_required boolean default 0,
17	PRIMARY KEY(parent_field_name,child_field_name,parent_node_type_name,child_node_type_name)
18	) TYPE=MyISAM /!40100 DEFAULT CHARACTER SET utf8 /;");
19	break;
20	default:
21	break;
22	}
23	}
24
25	function dependent_uninstall() {
26	db_query("DROP TABLE {field_dependencies}");
27	}