modules/bookmarks/bookmarks.install

<?php
function bookmarks_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      $result = db_query("CREATE TABLE {bookmarks} (
                  uid int UNSIGNED NOT NULL,
                  url varchar(128) NOT NULL,
                  title varchar(128) NOT NULL
      )");
      
      $result = db_query("ALTER TABLE {bookmarks} ADD INDEX (uid);");
      break;
    case 'pgsql':  
        $result = db_query("CREATE TABLE {bookmarks} (
                    uid SERIAL PRIMARY KEY,
                    url VARCHAR(255) NOT NULL,
                    title VARCHAR(255) NOT NULL
        )");
      break;
  }  
}

function bookmarks_uninstall() {
  $result = db_query("DROP TABLE {bookmarks}");
}

?>
1	<?php
2	function bookmarks_install() {
3	switch ($GLOBALS['db_type']) {
4	case 'mysql':
5	case 'mysqli':
6	$result = db_query("CREATE TABLE {bookmarks} (
7	uid int UNSIGNED NOT NULL,
8	url varchar(128) NOT NULL,
9	title varchar(128) NOT NULL
10	)");
11
12	$result = db_query("ALTER TABLE {bookmarks} ADD INDEX (uid);");
13	break;
14	case 'pgsql':
15	$result = db_query("CREATE TABLE {bookmarks} (
16	uid SERIAL PRIMARY KEY,
17	url VARCHAR(255) NOT NULL,
18	title VARCHAR(255) NOT NULL
19	)");
20	break;
21	}
22	}
23
24	function bookmarks_uninstall() {
25	$result = db_query("DROP TABLE {bookmarks}");
26	}
27
28	?>