90Ev2fNu

1//check for existance of extensions table
2
3		// Table structure for table `mail_extensions`
4		$query = tbox_query("
5		CREATE TABLE IF NOT EXISTS `mail_extensions` (
6		  `ID` int(4) NOT NULL auto_increment,
7		  `name` varchar(50) default NULL,
8		  `url` varchar(180) default NULL,
9		  `sort_order` int(11) default NULL,
10		  PRIMARY KEY  (`ID`)
11		) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=0");
12		
13		// Table structure for table `mail_extensions_parameters`
14		$query = tbox_query("
15		CREATE TABLE IF NOT EXISTS `mail_extensions_parameters` (
16		  `ID` int(11) NOT NULL auto_increment,
17		  `extension` int(3) default NULL,
18		  `name` varchar(40) default NULL,
19		  `data_type` int(1) default NULL,
20		  PRIMARY KEY  (`ID`)
21		) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=0");
22		
23		// Table structure for table `mail_extensions_templates`
24		$query = tbox_query("
25		CREATE TABLE IF NOT EXISTS `mail_extensions_templates` (
26		  `ID` int(11) NOT NULL auto_increment,
27		  `extension` int(3) default NULL,
28		  `template` int(3) default NULL,
29		  PRIMARY KEY  (`ID`)
30		) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=0");