modules/multiblock/multiblock.install

<?php
// $Id$

function multiblock_install() {
  switch($GLOBALS['db_type']) {
    case 'pgsql':
      db_query("CREATE TABLE {multiblock} (
        delta int_unsigned NOT NULL default '1',
        title varchar(64) NOT NULL default '',
        module varchar(64) NOT NULL default '',
 	    orig_delta varchar(32) NOT NULL default '',
        multi_settings int_unsigned NOT NULL default '0',
        PRIMARY KEY (delta)
       )");
      db_query("CREATE SEQUENCE {multiblock}_delta_seq INCREMENT 1 START 1;");
     break;
     case 'mysql':
     case 'mysqli':
      db_query(" CREATE TABLE {multiblock} (
        `delta` INT( 11 ) UNSIGNED NOT NULL DEFAULT '1',
        `title` VARCHAR( 64 ) NOT NULL ,
        `module` VARCHAR( 64 ) NOT NULL ,
        `orig_delta` VARCHAR( 32 ) NOT NULL ,
        `multi_settings` INT( 10 ) NOT NULL DEFAULT '0',
        PRIMARY KEY ( `delta` )
      )");
     break;
  }
}
1	<?php
2	// $Id$
3
4	function multiblock_install() {
5	switch($GLOBALS['db_type']) {
6	case 'pgsql':
7	db_query("CREATE TABLE {multiblock} (
8	delta int_unsigned NOT NULL default '1',
9	title varchar(64) NOT NULL default '',
10	module varchar(64) NOT NULL default '',
11	orig_delta varchar(32) NOT NULL default '',
12	multi_settings int_unsigned NOT NULL default '0',
13	PRIMARY KEY (delta)
14	)");
15	db_query("CREATE SEQUENCE {multiblock}_delta_seq INCREMENT 1 START 1;");
16	break;
17	case 'mysql':
18	case 'mysqli':
19	db_query(" CREATE TABLE {multiblock} (
20	`delta` INT( 11 ) UNSIGNED NOT NULL DEFAULT '1',
21	`title` VARCHAR( 64 ) NOT NULL ,
22	`module` VARCHAR( 64 ) NOT NULL ,
23	`orig_delta` VARCHAR( 32 ) NOT NULL ,
24	`multi_settings` INT( 10 ) NOT NULL DEFAULT '0',
25	PRIMARY KEY ( `delta` )
26	)");
27	break;
28	}
29	}