| 1 |
<?php |
<?php |
| 2 |
// $Id: taxonomy_other.install,v 1.1.4.1 2008/06/08 21:41:31 rellis Exp $ |
// $Id: taxonomy_other.install,v 1.1.4.2 2008/06/27 17:46:25 rellis Exp $ |
| 3 |
|
|
| 4 |
/** |
/** |
| 5 |
* Implementation of hook_install(). |
* Implementation of hook_install(). |
| 9 |
switch ($GLOBALS['db_type']) { |
switch ($GLOBALS['db_type']) { |
| 10 |
case 'mysql': |
case 'mysql': |
| 11 |
case 'mysqli': |
case 'mysqli': |
| 12 |
db_query("CREATE TABLE `taxonomy_other_queue` ( |
db_query("CREATE TABLE {taxonomy_other_queue} ( |
| 13 |
`nid` int(10) unsigned NOT NULL, |
`nid` int(10) unsigned NOT NULL, |
| 14 |
`vid` int(10) unsigned NOT NULL, |
`vid` int(10) unsigned NOT NULL, |
| 15 |
`name` varchar(255) NOT NULL default '', |
`name` varchar(255) NOT NULL default '', |
| 16 |
PRIMARY KEY (`nid`,`vid`) |
PRIMARY KEY (`nid`,`vid`) |
| 17 |
) /*!40100 DEFAULT CHARACTER SET UTF8 */ "); |
) /*!40100 DEFAULT CHARACTER SET UTF8 */ "); |
| 18 |
db_query("CREATE TABLE `taxonomy_other_term` ( |
db_query("CREATE TABLE {taxonomy_other_term} ( |
| 19 |
`tid` int(10) unsigned NOT NULL, |
`tid` int(10) unsigned NOT NULL, |
| 20 |
PRIMARY KEY (`tid`) |
PRIMARY KEY (`tid`) |
| 21 |
) /*!40100 DEFAULT CHARACTER SET UTF8 */ "); |
) /*!40100 DEFAULT CHARACTER SET UTF8 */ "); |
| 22 |
break; |
break; |
| 23 |
|
|
| 24 |
case 'pgsql': |
case 'pgsql': |
| 25 |
db_query("CREATE TABLE taxonomy_other_queue ( |
db_query("CREATE TABLE {taxonomy_other_queue} ( |
| 26 |
nid INTEGER NOT NULL, |
nid INTEGER NOT NULL, |
| 27 |
vid INTEGER NOT NULL, |
vid INTEGER NOT NULL, |
| 28 |
name VARCHAR(255) NOT NULL DEFAULT '', |
name VARCHAR(255) NOT NULL DEFAULT '', |
| 30 |
CHECK (nid>=0), |
CHECK (nid>=0), |
| 31 |
CHECK (vid>=0) |
CHECK (vid>=0) |
| 32 |
)"); |
)"); |
| 33 |
db_query("CREATE TABLE taxonomy_other_term ( |
db_query("CREATE TABLE {taxonomy_other_term} ( |
| 34 |
tid INTEGER NOT NULL, |
tid INTEGER NOT NULL, |
| 35 |
CONSTRAINT taxonomy_other_term_pk PRIMARY KEY (tid), |
CONSTRAINT taxonomy_other_term_pk PRIMARY KEY (tid), |
| 36 |
CHECK (tid>=0) |
CHECK (tid>=0) |