modules/fieldgroup/fieldgroup.install

<?php
// $Id: fieldgroup.install,v 1.1 2006/08/14 12:11:54 fago Exp $

function fieldgroup_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {node_group} (
                `type_name` varchar(32) NOT NULL default '',
                `group_name` varchar(32) NOT NULL default '',
                `label` varchar(255) NOT NULL default '',
                `settings` varchar(255) NOT NULL default '',
                `description` mediumtext NOT NULL,
                `weight` tinyint(4) NOT NULL,
                 PRIMARY KEY(`type_name`, `group_name`)
              ) /*!40100 DEFAULT CHARACTER SET utf8 */;");
      db_query("CREATE TABLE {node_group_fields} (
                `type_name` varchar(32) NOT NULL default '',
                `group_name` varchar(32) NOT NULL default '',
                `field_name` varchar(32) NOT NULL default '',
                 PRIMARY KEY(`type_name`, `group_name`, `field_name`)
              ) /*!40100 DEFAULT CHARACTER SET utf8 */;");
      break;
    case 'pgsql':
      db_query("CREATE TABLE {node_group} (
                type_name varchar(32) NOT NULL default '',
                group_name varchar(32) NOT NULL default '',
                label varchar(255) NOT NULL default '',
                settings varchar(255) NOT NULL default '',
                description text NOT NULL,
                weight smallint NOT NULL,
                PRIMARY KEY(type_name, group_name)
      )");
      db_query("CREATE TABLE {node_group_fields} (
                type_name varchar(32) NOT NULL default '',
                group_name varchar(32) NOT NULL default '',
                field_name varchar(32) NOT NULL default '',
                PRIMARY KEY(type_name, group_name, field_name)
      )");
    break;
  }
}


1	<?php
2	// $Id: fieldgroup.install,v 1.1 2006/08/14 12:11:54 fago Exp $
3
4	function fieldgroup_install() {
5	switch ($GLOBALS['db_type']) {
6	case 'mysql':
7	case 'mysqli':
8	db_query("CREATE TABLE {node_group} (
9	`type_name` varchar(32) NOT NULL default '',
10	`group_name` varchar(32) NOT NULL default '',
11	`label` varchar(255) NOT NULL default '',
12	`settings` varchar(255) NOT NULL default '',
13	`description` mediumtext NOT NULL,
14	`weight` tinyint(4) NOT NULL,
15	PRIMARY KEY(`type_name`, `group_name`)
16	) /!40100 DEFAULT CHARACTER SET utf8 /;");
17	db_query("CREATE TABLE {node_group_fields} (
18	`type_name` varchar(32) NOT NULL default '',
19	`group_name` varchar(32) NOT NULL default '',
20	`field_name` varchar(32) NOT NULL default '',
21	PRIMARY KEY(`type_name`, `group_name`, `field_name`)
22	) /!40100 DEFAULT CHARACTER SET utf8 /;");
23	break;
24	case 'pgsql':
25	db_query("CREATE TABLE {node_group} (
26	type_name varchar(32) NOT NULL default '',
27	group_name varchar(32) NOT NULL default '',
28	label varchar(255) NOT NULL default '',
29	settings varchar(255) NOT NULL default '',
30	description text NOT NULL,
31	weight smallint NOT NULL,
32	PRIMARY KEY(type_name, group_name)
33	)");
34	db_query("CREATE TABLE {node_group_fields} (
35	type_name varchar(32) NOT NULL default '',
36	group_name varchar(32) NOT NULL default '',
37	field_name varchar(32) NOT NULL default '',
38	PRIMARY KEY(type_name, group_name, field_name)
39	)");
40	break;
41	}
42	}
43
44