| 1 |
<?php |
<?php |
| 2 |
// $Id: path_image.install,v 1.2.2.2 2007/05/25 10:50:47 robrechtj Exp $ |
// $Id: path_image.install,v 1.2.2.3 2007/05/27 10:07:15 robrechtj Exp $ |
| 3 |
|
|
| 4 |
/** |
/** |
| 5 |
* @file |
* @file |
| 6 |
* Installs, upgrades or uninstalls the path_image module. |
* Module installation and update functionality for Path image. |
| 7 |
*/ |
*/ |
| 8 |
|
|
| 9 |
/** |
/** |
| 15 |
switch ($db_type) { |
switch ($db_type) { |
| 16 |
case 'mysql': |
case 'mysql': |
| 17 |
case 'mysqli': |
case 'mysqli': |
| 18 |
db_query("CREATE TABLE IF NOT EXISTS {path_image_data} (". |
db_query("CREATE TABLE {path_image_data} ( |
| 19 |
"pid INT(10) NOT NULL,". |
pid INT(10) NOT NULL, |
| 20 |
"path VARCHAR(128) NOT NULL,". |
path VARCHAR(128) NOT NULL, |
| 21 |
"image_file VARCHAR(32) NOT NULL,". |
image_file VARCHAR(32) NOT NULL, |
| 22 |
"PRIMARY KEY(pid),". |
PRIMARY KEY(pid), |
| 23 |
"INDEX(path(32)))"); |
INDEX(path(32)) |
| 24 |
|
)"); |
| 25 |
break; |
break; |
| 26 |
|
|
| 27 |
case 'pgsql': |
case 'pgsql': |
| 28 |
db_query("CREATE TABLE {path_image_data} (". |
db_query("CREATE TABLE {path_image_data} ( |
| 29 |
"pid INT(10) NOT NULL,". |
pid INT(10) NOT NULL, |
| 30 |
"path VARCHAR(128) NOT NULL,". |
path VARCHAR(128) NOT NULL, |
| 31 |
"image_file VARCHAR(32) NOT NULL,". |
image_file VARCHAR(32) NOT NULL, |
| 32 |
"PRIMARY KEY(pid))"); |
PRIMARY KEY(pid) |
| 33 |
|
)"); |
| 34 |
db_query("CREATE INDEX {path_image_data}_path_idx ON {path_image_data} (path)"); |
db_query("CREATE INDEX {path_image_data}_path_idx ON {path_image_data} (path)"); |
|
|
|
| 35 |
break; |
break; |
| 36 |
} |
} |
|
|
|
| 37 |
db_query("UPDATE {system} SET weight = 5 WHERE name = 'path_image'"); |
db_query("UPDATE {system} SET weight = 5 WHERE name = 'path_image'"); |
| 38 |
} |
} |
| 39 |
|
|