| 1 |
<?php |
<?php |
| 2 |
|
|
| 3 |
// $Id: aggregation.install,v 1.4.2.10 2007/04/21 21:58:24 mistknight Exp $ |
// $Id: aggregation.install,v 1.4.2.11 2007/04/28 21:32:13 mistknight Exp $ |
| 4 |
|
|
| 5 |
function aggregation_install() |
function aggregation_install() |
| 6 |
{ |
{ |
| 13 |
CREATE TABLE IF NOT EXISTS {aggregation_feed} ( |
CREATE TABLE IF NOT EXISTS {aggregation_feed} ( |
| 14 |
`nid` int(10) unsigned NOT NULL, |
`nid` int(10) unsigned NOT NULL, |
| 15 |
`original_author` varchar(100) NOT NULL default '', |
`original_author` varchar(100) NOT NULL default '', |
| 16 |
`url` varchar(125) NOT NULL, |
`url` varchar(250) NOT NULL, |
| 17 |
`username` varchar(50) NOT NULL default '', |
`username` varchar(50) NOT NULL default '', |
| 18 |
`password` varchar(50) NOT NULL default '', |
`password` varchar(50) NOT NULL default '', |
| 19 |
`refresh_interval` int(10) unsigned NOT NULL, |
`refresh_interval` int(10) unsigned NOT NULL, |
| 40 |
$query = <<<begin_create_query |
$query = <<<begin_create_query |
| 41 |
CREATE TABLE IF NOT EXISTS {aggregation_item} ( |
CREATE TABLE IF NOT EXISTS {aggregation_item} ( |
| 42 |
`nid` int(10) unsigned NOT NULL, |
`nid` int(10) unsigned NOT NULL, |
| 43 |
`url` varchar(125) NOT NULL default '', |
`url` varchar(250) NOT NULL default '', |
| 44 |
`link_to_original_url` enum('yes', 'no') NOT NULL default 'yes', |
`link_to_original_url` enum('yes', 'no') NOT NULL default 'yes', |
| 45 |
`original_author` varchar(100) NOT NULL default '', |
`original_author` varchar(100) NOT NULL default '', |
| 46 |
`story_guid` int unsigned NOT NULL default 0, |
`story_guid` int unsigned NOT NULL default 0, |
| 287 |
db_query("DROP TABLE {aggregator2_item}"); |
db_query("DROP TABLE {aggregator2_item}"); |
| 288 |
} |
} |
| 289 |
|
|
| 290 |
|
//update function for 4.7 & 5 branch |
| 291 |
|
function aggregation_update_7() |
| 292 |
|
{ |
| 293 |
|
$ret = array(); |
| 294 |
|
|
| 295 |
|
switch ($GLOBALS['db_type']) |
| 296 |
|
{ |
| 297 |
|
case 'mysql': |
| 298 |
|
case 'mysqli': |
| 299 |
|
$ret[] = update_sql("ALTER TABLE {aggregation_feed} modify `url` varchar(250) NOT NULL"); |
| 300 |
|
$ret[] = update_sql("ALTER TABLE {aggregation_item} modify `url` varchar(250) NOT NULL"); |
| 301 |
|
break; |
| 302 |
|
} |
| 303 |
|
|
| 304 |
|
return $ret; |
| 305 |
|
} |
| 306 |
|
|
| 307 |
|
|
| 308 |
function aggregation_uninstall() |
function aggregation_uninstall() |
| 309 |
{ |
{ |
| 310 |
// Delete all aggregation items |
// Delete all aggregation items |