| 1 |
<?php |
<?php |
| 2 |
// $Id$ |
// $Id: shazamgallery.install,v 1.1.2.1 2006/09/15 13:12:15 ber Exp $ |
| 3 |
|
|
| 4 |
function shazamgallery_install() { |
function shazamgallery_install() { |
| 5 |
switch ($GLOBALS['db_type']) { |
switch ($GLOBALS['db_type']) { |
| 6 |
case 'mysql': |
case 'mysql': |
| 7 |
case 'mysqli': |
case 'mysqli': |
| 8 |
db_query("CREATE TABLE IF NOT EXISTS shazamgallery ( |
db_query("CREATE TABLE IF NOT EXISTS {shazamgallery} ( |
| 9 |
nid int(10) UNSIGNED NOT NULL, |
nid int(10) UNSIGNED NOT NULL, |
| 10 |
tid int(10) UNSIGNED NOT NULL, |
tid int(10) UNSIGNED NOT NULL, |
| 11 |
gdefault int(10) UNSIGNED NOT NULL, |
gdefault int(10) UNSIGNED NOT NULL, |
| 12 |
weight tinyint(3), |
weight tinyint(3), |
| 13 |
PRIMARY KEY (nid, tid) |
PRIMARY KEY (nid, tid) |
| 14 |
) ENGINE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;"); |
) ENGINE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;"); |
| 15 |
db_query("CREATE TABLE IF NOT EXISTS `relations` ( |
db_query("CREATE TABLE IF NOT EXISTS {relations} ( |
| 16 |
`rid` int(10) NOT NULL auto_increment, |
`rid` int(10) NOT NULL auto_increment, |
| 17 |
`left_id` int(10) NOT NULL default '0', |
`left_id` int(10) NOT NULL default '0', |
| 18 |
`relationship` text NOT NULL, |
`relationship` text NOT NULL, |