modules/vocab/vocab.install

<?php //$Id

function vocab_install()
{
	switch ($GLOBALS['db_type']) 
	{
		case 'mysql':
		case 'mysqli':
		db_query("CREATE TABLE `{vocab_data}` (
		  `id` int(11) NOT NULL auto_increment,
		  `nid` int(11) NOT NULL default '0',
		  `front` varchar(250) default NULL,
		  `back` varchar(250) default NULL,
		  `imageurl` longtext,
		  PRIMARY KEY  (`id`)
		) TYPE=MyISAM COMMENT='Data for vocabulary exercises'
		/*!40100 DEFAULT CHARACTER SET utf8 */;
		");
	}
}

function vocab_update_1(){
	db_query("
		CREATE TABLE vocab_labels(
		nid int( 10 ) ,
		flabel varchar( 255 ) ,
		blabel varchar( 255 ) ,
		PRIMARY KEY ( nid )
		)/*!40100 DEFAULT CHARACTER SET utf8 */;
	");
	return _system_update_utf8(array('vocab_data'));
}

?>
1	<?php //$Id
2
3	function vocab_install()
4	{
5	switch ($GLOBALS['db_type'])
6	{
7	case 'mysql':
8	case 'mysqli':
9	db_query("CREATE TABLE `{vocab_data}` (
10	`id` int(11) NOT NULL auto_increment,
11	`nid` int(11) NOT NULL default '0',
12	`front` varchar(250) default NULL,
13	`back` varchar(250) default NULL,
14	`imageurl` longtext,
15	PRIMARY KEY (`id`)
16	) TYPE=MyISAM COMMENT='Data for vocabulary exercises'
17	/!40100 DEFAULT CHARACTER SET utf8 /;
18	");
19	}
20	}
21
22	function vocab_update_1(){
23	db_query("
24	CREATE TABLE vocab_labels(
25	nid int( 10 ) ,
26	flabel varchar( 255 ) ,
27	blabel varchar( 255 ) ,
28	PRIMARY KEY ( nid )
29	)/!40100 DEFAULT CHARACTER SET utf8 /;
30	");
31	return _system_update_utf8(array('vocab_data'));
32	}
33
34	?>