modules/block_assign/block_assign.install

<?php
// $Id: block_assign.install,v 1.3 2008/02/04 14:14:41 daryl Exp $

function block_assign_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
  db_query('
    CREATE TABLE `{block_assign}` (
        `id` int(10) unsigned zerofill NOT NULL auto_increment,
        `module` varchar(30) default NULL,
        `condition_type` varchar(4) default NULL,
        `condition_value` text,
        `box_id` int(3) default NULL,
        PRIMARY KEY  (`id`)
      ) ENGINE=MyISAM DEFAULT CHARSET=latin1
  ');
  //By default, show the user block on all pages.
  db_query('
    INSERT INTO {block_assign} (module, condition_type, condition_value, box_id) VALUES("user", "uri", ".*", 1)
  ');
  }
}
1	<?php
2	// $Id: block_assign.install,v 1.3 2008/02/04 14:14:41 daryl Exp $
3
4	function block_assign_install() {
5	switch ($GLOBALS['db_type']) {
6	case 'mysql':
7	case 'mysqli':
8	db_query('
9	CREATE TABLE `{block_assign}` (
10	`id` int(10) unsigned zerofill NOT NULL auto_increment,
11	`module` varchar(30) default NULL,
12	`condition_type` varchar(4) default NULL,
13	`condition_value` text,
14	`box_id` int(3) default NULL,
15	PRIMARY KEY (`id`)
16	) ENGINE=MyISAM DEFAULT CHARSET=latin1
17	');
18	//By default, show the user block on all pages.
19	db_query('
20	INSERT INTO {block_assign} (module, condition_type, condition_value, box_id) VALUES("user", "uri", ".*", 1)
21	');
22	}
23	}