modules/pressflow_placement/pressflow_placement.install

<?php

function pressflow_placement_install()
{
	switch ($GLOBALS['db_type'])
	{
		case 'mysql':
		case 'mysqli':
		  db_query("CREATE TABLE `pressflow_placement` (
          `vid` int(10) unsigned NOT NULL,
          `nid` int(10) unsigned NOT NULL,
          `max_nodes` int(10) unsigned NOT NULL,
          `node_type` varchar(50) NOT NULL,
          PRIMARY KEY  (`vid`),
          KEY `nid` (`nid`),
          KEY `node_type` (`node_type`)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
        
        CREATE TABLE `pressflow_placement_teasers` (
          `vid` int(10) unsigned NOT NULL,
          `nid` int(10) unsigned NOT NULL,
          `weight` int(10) NOT NULL,
          `teaser_nid` int(10) unsigned NOT NULL,
          `teaser` text NOT NULL,
          PRIMARY KEY  (`vid`,`weight`),
          KEY `nid` (`nid`)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8;");
		  break;
		
		case 'pgsql':
			drupal_set_message('PostgreSQL is not currently supported.', 'error');
			break;
	}
}

function pressflow_placement_uninstall()
{
	db_query('DROP TABLE {pressflow_placement}');
	db_query('DROP TABLE {pressflow_placement_order}');	
}
1	<?php
2
3	function pressflow_placement_install()
4	{
5	switch ($GLOBALS['db_type'])
6	{
7	case 'mysql':
8	case 'mysqli':
9	db_query("CREATE TABLE `pressflow_placement` (
10	`vid` int(10) unsigned NOT NULL,
11	`nid` int(10) unsigned NOT NULL,
12	`max_nodes` int(10) unsigned NOT NULL,
13	`node_type` varchar(50) NOT NULL,
14	PRIMARY KEY (`vid`),
15	KEY `nid` (`nid`),
16	KEY `node_type` (`node_type`)
17	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
18
19	CREATE TABLE `pressflow_placement_teasers` (
20	`vid` int(10) unsigned NOT NULL,
21	`nid` int(10) unsigned NOT NULL,
22	`weight` int(10) NOT NULL,
23	`teaser_nid` int(10) unsigned NOT NULL,
24	`teaser` text NOT NULL,
25	PRIMARY KEY (`vid`,`weight`),
26	KEY `nid` (`nid`)
27	) ENGINE=InnoDB DEFAULT CHARSET=utf8;");
28	break;
29
30	case 'pgsql':
31	drupal_set_message('PostgreSQL is not currently supported.', 'error');
32	break;
33	}
34	}
35
36	function pressflow_placement_uninstall()
37	{
38	db_query('DROP TABLE {pressflow_placement}');
39	db_query('DROP TABLE {pressflow_placement_order}');
40	}