Product Install/Uninstall XML Code

[Nullifi3d]

For some reason my install code is not creating the table in the db. I have tried the following two codes variations:

	<codes>
		<code version="1.0.0">
			<installcode><![CDATA[$install[] = "CREATE TABLE " . TABLE_PREFIX . "banners (
	userid int(10) unsigned NOT NULL default '0',
	username varchar(100) NOT NULL default '',
	title varchar(250) NOT NULL default '',
	url varchar(250) NOT NULL default '',
	link varchar(250) NOT NULL default '',
	ext varchar(4) NOT NULL default '',
	width int(3) NOT NULL default '0',
	height int(3) NOT NULL default '0',
	clicks int(10) NOT NULL default '0',
	available int(10) NOT NULL default '0',
	impressions int(10) NOT NULL default '0',
	status varchar(8) NOT NULL default '',
	PRIMARY KEY  (`userid`)
) ENGINE=MyISAM";]]></installcode>
			<uninstallcode><![CDATA[$uninstall[] = "DROP TABLE " . TABLE_PREFIX . "banners";]]></uninstallcode>
		</code>
	</codes>

&

	<codes>
		<code version="1.0.0">
			<installcode><![CDATA[$db->query_write = "CREATE TABLE " . TABLE_PREFIX . "banners (
	userid int(10) unsigned NOT NULL default '0',
	username varchar(100) NOT NULL default '',
	title varchar(250) NOT NULL default '',
	url varchar(250) NOT NULL default '',
	link varchar(250) NOT NULL default '',
	ext varchar(4) NOT NULL default '',
	width int(3) NOT NULL default '0',
	height int(3) NOT NULL default '0',
	clicks int(10) NOT NULL default '0',
	available int(10) NOT NULL default '0',
	impressions int(10) NOT NULL default '0',
	status varchar(8) NOT NULL default '',
	PRIMARY KEY  (`userid`)
) ENGINE=MyISAM";]]></installcode>
			<uninstallcode><![CDATA[$db->query_write = "DROP TABLE " . TABLE_PREFIX . "banners";]]></uninstallcode>
		</code>
	</codes>

[Nullifi3d]

Does anyone know why these would not work?

[Andreas]

I'd suggest to use proper codes

Install

PHP Code:

$db->query_write("CREATE TABLE " . TABLE_PREFIX . "banners (
    userid int(10) unsigned NOT NULL default '0',
    username varchar(100) NOT NULL default '',
    title varchar(250) NOT NULL default '',
    url varchar(250) NOT NULL default '',
    link varchar(250) NOT NULL default '',
    ext varchar(4) NOT NULL default '',
    width int(3) NOT NULL default '0',
    height int(3) NOT NULL default '0',
    clicks int(10) NOT NULL default '0',
    available int(10) NOT NULL default '0',
    impressions int(10) NOT NULL default '0',
    status varchar(8) NOT NULL default '',
    PRIMARY KEY  (`userid`))
"); 


Uninstall

PHP Code:

$db->query_write("DROP TABLE " . TABLE_PREFIX . "banners");