modules/provisionator/provisionator.install

<?php

function provisionator_install() {
	switch ($GLOBALS['db_type']) {
		case 'mysql':
		case 'mysqli':
			db_query("
				CREATE TABLE `provisionatorclient` (
				  `nid` int(10) unsigned NOT NULL default '0',
				  `domainprefix` longtext,
				  `symlinkpath` longtext,
				  `dbprefix` varchar(20) default NULL,
				  `apachetargetdir` longtext,
				  PRIMARY KEY  (`nid`)
				) ENGINE=MyISAM DEFAULT CHARSET=latin1;
				
				CREATE TABLE `provisionatorsite` (
				  `nid` int(10) unsigned NOT NULL default '0',
				  `shortname` longtext,
				  `sitestatus` longtext,
				  `fullurl` longtext,
				  `clientid` int(10) default '0',
				  `profile` longtext,
				  PRIMARY KEY  (`nid`)
				) ENGINE=MyISAM DEFAULT CHARSET=latin1;
		");	
			break;
		case 'pgsql':
			break;
	}
}

?>
1	<?php
2
3	function provisionator_install() {
4	switch ($GLOBALS['db_type']) {
5	case 'mysql':
6	case 'mysqli':
7	db_query("
8	CREATE TABLE `provisionatorclient` (
9	`nid` int(10) unsigned NOT NULL default '0',
10	`domainprefix` longtext,
11	`symlinkpath` longtext,
12	`dbprefix` varchar(20) default NULL,
13	`apachetargetdir` longtext,
14	PRIMARY KEY (`nid`)
15	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
16
17	CREATE TABLE `provisionatorsite` (
18	`nid` int(10) unsigned NOT NULL default '0',
19	`shortname` longtext,
20	`sitestatus` longtext,
21	`fullurl` longtext,
22	`clientid` int(10) default '0',
23	`profile` longtext,
24	PRIMARY KEY (`nid`)
25	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
26	");
27	break;
28	case 'pgsql':
29	break;
30	}
31	}
32
33	?>