modules/og_settings/og_settings.install

<?php
// og_settings.install

function og_settings_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      // the {tablename} syntax is so multisite installs can add a
      // prefix to the table name as set in the settings.php file
      db_query("CREATE TABLE {og_settings} (
          nid INT NOT NULL DEFAULT 0,
  		  name varchar(48) NOT NULL default '',
  		  value longtext NOT NULL,
  		  PRIMARY KEY (nid, name)
        ) /*!40100 DEFAULT CHARACTER SET utf8 */;");
      break;

    case 'pgsql':
      db_query("CREATE TABLE {og_settings} (
     		nid integer NOT NULL default '0',
  			name varchar(48) NOT NULL default '',
  			value text NOT NULL default '',
  			PRIMARY KEY (nid , name)
        )");
      break;
  }
}

function og_settings_uninstall() {
  // Drop database table
  db_query('DROP TABLE {og_settings}');
}
1	<?php
2	// og_settings.install
3
4	function og_settings_install() {
5	switch ($GLOBALS['db_type']) {
6	case 'mysql':
7	case 'mysqli':
8	// the {tablename} syntax is so multisite installs can add a
9	// prefix to the table name as set in the settings.php file
10	db_query("CREATE TABLE {og_settings} (
11	nid INT NOT NULL DEFAULT 0,
12	name varchar(48) NOT NULL default '',
13	value longtext NOT NULL,
14	PRIMARY KEY (nid, name)
15	) /!40100 DEFAULT CHARACTER SET utf8 /;");
16	break;
17
18	case 'pgsql':
19	db_query("CREATE TABLE {og_settings} (
20	nid integer NOT NULL default '0',
21	name varchar(48) NOT NULL default '',
22	value text NOT NULL default '',
23	PRIMARY KEY (nid , name)
24	)");
25	break;
26	}
27	}
28
29	function og_settings_uninstall() {
30	// Drop database table
31	db_query('DROP TABLE {og_settings}');
32	}