modules/multireference/multireference.install

<?php
// $Id$

/**
 * Implementation of hook_uninstall().
 */
function multireference_uninstall() {
  db_query('DROP TABLE {node_field_multireference_data};');
}

/**
 * Implementation of hook_install().
 */
function multireference_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query( "CREATE TABLE {node_field_multireference_data} (
        id int(11) NOT NULL auto_increment,
        nid int(10) unsigned NOT NULL default '0',
        vid int(10) unsigned NOT NULL default '0',
        reference varchar(32) NOT NULL default '',
        field_name varchar(32) NOT NULL default '',
        r_id int(10) unsigned NOT NULL default '0',
        r_text varchar(255) NOT NULL default '',
        description varchar(255) NOT NULL default '',
        description2 varchar(255) NOT NULL default '',
        weight int(11) default NULL,
        PRIMARY KEY (id)
        ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */"
      );
      break;

    case 'pgsql':
      db_query( "CREATE TABLE {node_field_multireference_data} (
        id SERIAL,
        nid integer unsigned NOT NULL default '0',
        vid integer unsigned NOT NULL default '0',
        reference varchar(32) NOT NULL default '',
        field_name varchar(32) NOT NULL default '',
        r_id integer unsigned NOT NULL default '0',
        r_text varchar(255) NOT NULL default '',
        description varchar(255) NOT NULL default '',
        description2 varchar(255) NOT NULL default '',
        weight integer default NULL,
        PRIMARY KEY (id)
        )"
      );
      break;
  }
}
1	<?php
2	// $Id$
3
4	/**
5	* Implementation of hook_uninstall().
6	*/
7	function multireference_uninstall() {
8	db_query('DROP TABLE {node_field_multireference_data};');
9	}
10
11	/**
12	* Implementation of hook_install().
13	*/
14	function multireference_install() {
15	switch ($GLOBALS['db_type']) {
16	case 'mysql':
17	case 'mysqli':
18	db_query( "CREATE TABLE {node_field_multireference_data} (
19	id int(11) NOT NULL auto_increment,
20	nid int(10) unsigned NOT NULL default '0',
21	vid int(10) unsigned NOT NULL default '0',
22	reference varchar(32) NOT NULL default '',
23	field_name varchar(32) NOT NULL default '',
24	r_id int(10) unsigned NOT NULL default '0',
25	r_text varchar(255) NOT NULL default '',
26	description varchar(255) NOT NULL default '',
27	description2 varchar(255) NOT NULL default '',
28	weight int(11) default NULL,
29	PRIMARY KEY (id)
30	) TYPE=MyISAM /!40100 DEFAULT CHARACTER SET utf8 /"
31	);
32	break;
33
34	case 'pgsql':
35	db_query( "CREATE TABLE {node_field_multireference_data} (
36	id SERIAL,
37	nid integer unsigned NOT NULL default '0',
38	vid integer unsigned NOT NULL default '0',
39	reference varchar(32) NOT NULL default '',
40	field_name varchar(32) NOT NULL default '',
41	r_id integer unsigned NOT NULL default '0',
42	r_text varchar(255) NOT NULL default '',
43	description varchar(255) NOT NULL default '',
44	description2 varchar(255) NOT NULL default '',
45	weight integer default NULL,
46	PRIMARY KEY (id)
47	)"
48	);
49	break;
50	}
51	}