modules/level1/level1.install

<?php

/**
 * Implementation of hook_install().
 */
function level1_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {level1_access} (
                nid int(10) unsigned NOT NULL default '0',
                gid int(10) unsigned NOT NULL default '0',
                realm varchar(255) NOT NULL default '',
                grant_view tinyint(3) unsigned NOT NULL default '0',
                grant_update tinyint(3) unsigned NOT NULL default '0',
                grant_delete tinyint(3) unsigned NOT NULL default '0',
                PRIMARY KEY  (nid,gid,realm))");
      break;
  }
}

/**
 * Implementation of hook_uninstall().
 */
function level1_uninstall() {
  db_query('DROP TABLE {level1_access}');
}
1	<?php
2
3	/**
4	* Implementation of hook_install().
5	*/
6	function level1_install() {
7	switch ($GLOBALS['db_type']) {
8	case 'mysql':
9	case 'mysqli':
10	db_query("CREATE TABLE {level1_access} (
11	nid int(10) unsigned NOT NULL default '0',
12	gid int(10) unsigned NOT NULL default '0',
13	realm varchar(255) NOT NULL default '',
14	grant_view tinyint(3) unsigned NOT NULL default '0',
15	grant_update tinyint(3) unsigned NOT NULL default '0',
16	grant_delete tinyint(3) unsigned NOT NULL default '0',
17	PRIMARY KEY (nid,gid,realm))");
18	break;
19	}
20	}
21
22	/**
23	* Implementation of hook_uninstall().
24	*/
25	function level1_uninstall() {
26	db_query('DROP TABLE {level1_access}');
27	}