Subversion Repositories Applications.papyrus

Compare Revisions

Ignore whitespace Rev 830 → Rev 831

/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2003112001.php
New file
0,0 → 1,7
<?php
if(!defined("PHORUM_ADMIN")) return;
 
$upgrade_queries[]="CREATE TABLE {$PHORUM['private_message_table']} ( private_message_id int(10) unsigned NOT NULL auto_increment, from_username varchar(50) NOT NULL default '', to_username varchar(50) NOT NULL default '', from_user_id int(10) unsigned NOT NULL default '0', to_user_id int(10) unsigned NOT NULL default '0', subject varchar(100) NOT NULL default '', message text NOT NULL, datestamp int(10) unsigned NOT NULL default '0', read_flag tinyint(1) NOT NULL default '0', reply_flag tinyint(1) NOT NULL default '0', to_del_flag tinyint(1) NOT NULL default '0', from_del_flag tinyint(1) NOT NULL default '0', PRIMARY KEY (private_message_id), KEY to_user_id (to_user_id,to_del_flag,datestamp), KEY from_user_id (from_user_id,from_del_flag,datestamp), KEY to_del_flag (to_del_flag,from_del_flag) ) TYPE=MyISAM";
$upgrade_queries[]="alter table {$PHORUM['user_table']} modify active tinyint(1) NOT NULL default '0'";
 
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005100300.php
New file
0,0 → 1,6
<?php
if(!defined("PHORUM_ADMIN")) return;
 
$upgrade_queries[]= "alter table {$PHORUM["pm_buddies_table"]} add index buddy_user_id (buddy_user_id)";
 
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004071100.php
New file
0,0 → 1,8
<?php
if(!defined("PHORUM_ADMIN")) return;
 
// altering the message-table with an index for unapproved messages
$upgrade_queries[]="ALTER TABLE {$PHORUM['groups_table']} ADD open tinyint(3) NOT NULL default '0' AFTER name";
 
 
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005100701.php
New file
0,0 → 1,5
<?php
if(!defined("PHORUM_ADMIN")) return;
 
$upgrade_queries[]="ALTER TABLE {$PHORUM['message_table']} ADD INDEX next_prev_thread ( forum_id , status , thread ) ";
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005081000.php
New file
0,0 → 1,6
<?php
if(!defined("PHORUM_ADMIN")) return;
 
$upgrade_queries[]="insert into {$PHORUM['settings_table']} set name='installed', type='V', data='1'";
 
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2003011801.php
New file
0,0 → 1,4
<?php
if(!defined("PHORUM_ADMIN")) return;
$upgrade_queries[]="ALTER TABLE {$PHORUM['message_table']} ADD edit_count TINYINT unsigned NOT NULL DEFAULT 0, ADD edit_date datetime NOT NULL default '0000-00-00 00:00:00'";
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004061300.php
New file
0,0 → 1,6
<?php
if(!defined("PHORUM_ADMIN")) return;
 
// altering the files tables
$upgrade_queries[]="alter table {$PHORUM['user_group_xref_table']} add status tinyint(3) NOT NULL default '1'";
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005071200.php
New file
0,0 → 1,6
<?php
if(!defined("PHORUM_ADMIN")) return;
 
$upgrade_queries[]="alter table {$PHORUM['message_table']} CHANGE ip ip VARCHAR( 255 ) NOT NULL";
 
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004031700.php
New file
0,0 → 1,14
<?php
if(!defined("PHORUM_ADMIN")) return;
 
// altering the files tables
$upgrade_queries[]="alter table {$PHORUM['user_table']} add `date_added` int(10) unsigned NOT NULL default '0'";
$upgrade_queries[]="alter table {$PHORUM['user_table']} add `date_last_active` int(10) unsigned NOT NULL default '0'";
$upgrade_queries[]="alter table {$PHORUM['user_table']} add `hide_activity` tinyint(1) NOT NULL default '0'";
 
$upgrade_queries[]="alter table {$PHORUM['user_table']} add KEY `activity` (`date_last_active`,`hide_activity`)";
$upgrade_queries[]="alter table {$PHORUM['user_table']} add KEY `date_added` (`date_added`)";
$upgrade_queries[]="update {$PHORUM['user_table']} set date_last_active=UNIX_TIMESTAMP(NOW()), date_added=UNIX_TIMESTAMP(NOW())";
 
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004071500.php
New file
0,0 → 1,8
<?php
if(!defined("PHORUM_ADMIN")) return;
 
// altering the message-table with an index for unapproved messages
$upgrade_queries[]="ALTER TABLE {$PHORUM['forums_table']} CHANGE list_length list_length_flat INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL";
$upgrade_queries[]="ALTER TABLE {$PHORUM['forums_table']} ADD list_length_threaded INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL AFTER `list_length_flat` ";
$upgrade_queries[]="UPDATE {$PHORUM['forums_table']} SET list_length_threaded = list_length_flat/2 ";
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005091400.php
New file
0,0 → 1,87
<?php
if(!defined("PHORUM_ADMIN")) return;
 
// Create tables for the new PM system.
 
$upgrade_queries[]= "CREATE TABLE {$PHORUM["pm_messages_table"]} (
pm_message_id int(10) unsigned NOT NULL auto_increment,
from_user_id int(10) unsigned NOT NULL default '0',
from_username varchar(50) NOT NULL default '',
subject varchar(100) NOT NULL default '',
message text NOT NULL default '',
datestamp int(10) unsigned NOT NULL default '0',
meta mediumtext NOT NULL default '',
PRIMARY KEY (pm_message_id)
) TYPE=MyISAM";
 
$upgrade_queries[] = "CREATE TABLE {$PHORUM["pm_folders_table"]} (
pm_folder_id int(10) unsigned NOT NULL auto_increment,
user_id int(10) unsigned NOT NULL default '0',
foldername varchar(20) NOT NULL default '',
KEY user_id (user_id),
PRIMARY KEY (pm_folder_id)
) TYPE=MyISAM";
 
$upgrade_queries[] = "CREATE TABLE {$PHORUM["pm_xref_table"]} (
pm_xref_id int(10) unsigned NOT NULL auto_increment,
user_id int(10) unsigned NOT NULL default '0',
pm_folder_id int(10) unsigned NOT NULL default '0',
special_folder varchar(10),
pm_message_id int(10) unsigned NOT NULL default '0',
read_flag tinyint(1) NOT NULL default '0',
reply_flag tinyint(1) NOT NULL default '0',
PRIMARY KEY (pm_xref_id),
KEY xref (user_id,pm_folder_id,pm_message_id),
KEY read_flag (read_flag)
) TYPE=MyISAM";
 
// converting the old PM system to the new one.
$old_table = "{$PHORUM['DBCONFIG']['table_prefix']}_private_messages";
$res=mysql_query("SELECT * FROM $old_table");
while($row=mysql_fetch_assoc($res))
{
// Put the message in the message table.
$meta = serialize(array(
'recipients' => array(
$row["to_user_id"] => array (
'user_id' => $row["to_user_id"],
'username' => $row["to_username"],
'read_flag' => $row["read_flag"],
)
)
));
$sql = "INSERT INTO {$PHORUM["pm_messages_table"]} SET " .
"pm_message_id = {$row["private_message_id"]}, " .
"from_user_id = {$row["from_user_id"]}, " .
"from_username = '" . addslashes($row["from_username"]) . "', " .
"subject = '" . addslashes($row['subject']) . "', " .
"message = '" . addslashes($row['message']) . "', " .
"datestamp = {$row["datestamp"]}, " .
"meta = '" . addslashes($meta) . "'";
$upgrade_queries[] = $sql;
 
// Link message to recipient inbox.
if (! $row["to_del_flag"]) {
$sql = "INSERT INTO {$PHORUM["pm_xref_table"]} SET " .
"user_id = {$row["to_user_id"]}, " .
"pm_folder_id = 0, " .
"special_folder = '" . PHORUM_PM_INBOX . "', " .
"pm_message_id = {$row["private_message_id"]}, " .
"read_flag = {$row["read_flag"]}, " .
"reply_flag = {$row["reply_flag"]}";
$upgrade_queries[] = $sql;
}
 
// Link message to sender outbox.
if (! $row["from_del_flag"]) {
$sql = "INSERT INTO {$PHORUM["pm_xref_table"]} SET " .
"user_id = {$row["from_user_id"]}, " .
"pm_folder_id = 0, " .
"special_folder = '" . PHORUM_PM_OUTBOX . "', " .
"pm_message_id = {$row["private_message_id"]}, " .
"read_flag = 1, " .
"reply_flag = 0";
$upgrade_queries[] = $sql;
}
}
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004071900.php
New file
0,0 → 1,5
<?php
if(!defined("PHORUM_ADMIN")) return;
 
$upgrade_queries[]="ALTER TABLE {$PHORUM['forums_table']} ADD display_fixed TINYINT( 1 ) UNSIGNED DEFAULT '0' NOT NULL";
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004081900.php
New file
0,0 → 1,10
<?php
if(!defined("PHORUM_ADMIN")) return;
 
$upgrade_queries[]="alter table {$PHORUM['message_table']} drop key forum_max_message";
 
$upgrade_queries[]="alter table {$PHORUM['message_table']} add key forum_max_message (forum_id, message_id, status, parent_id)";
 
$upgrade_queries[]="insert into {$PHORUM['settings_table']} values ('show_new_on_index', 'V', '1')";
 
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004012400.php
New file
0,0 → 1,6
<?php
if(!defined("PHORUM_ADMIN")) return;
// altering the tables for the mixed mode
$upgrade_queries[]="ALTER TABLE {$PHORUM['forums_table']} CHANGE threaded threaded_list TINYINT( 4 ) DEFAULT '0' NOT NULL, ADD threaded_read TINYINT( 4 ) DEFAULT '0' NOT NULL";
$upgrade_queries[]="ALTER TABLE {$PHORUM['user_table']} CHANGE threaded threaded_list TINYINT( 4 ) DEFAULT '0' NOT NULL, ADD threaded_read TINYINT( 4 ) DEFAULT '0' NOT NULL";
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2003082100.php
New file
0,0 → 1,17
<?php
if(!defined("PHORUM_ADMIN")) return;
 
$upgrade_queries[]="alter table {$PHORUM['message_table']} drop KEY parent_thread";
$upgrade_queries[]="alter table {$PHORUM['message_table']} drop KEY modifystamp_thread";
$upgrade_queries[]="alter table {$PHORUM['message_table']} drop KEY parent_status_mod";
$upgrade_queries[]="alter table {$PHORUM['message_table']} drop KEY parent_status_thread";
$upgrade_queries[]="alter table {$PHORUM['message_table']} drop KEY message_status_thread";
$upgrade_queries[]="alter table {$PHORUM['message_table']} drop KEY message_status_mod";
$upgrade_queries[]="alter table {$PHORUM['message_table']} drop KEY parent_id";
$upgrade_queries[]="alter table {$PHORUM['message_table']} drop KEY parent_status_forum";
$upgrade_queries[]="alter table {$PHORUM['message_table']} add KEY list_page_flat (thread,forum_id,status,parent_id,sort)";
$upgrade_queries[]="alter table {$PHORUM['message_table']} add KEY special_threads (sort,forum_id)";
$upgrade_queries[]="alter table {$PHORUM['message_table']} add KEY list_page_float (modifystamp,forum_id,status,parent_id,sort)";
 
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004080300.php
New file
0,0 → 1,37
<?php
if(!defined("PHORUM_ADMIN")) return;
 
// wow doing it all by hand this time :(
 
$cid=phorum_db_mysql_connect();
// adding the new field
mysql_query("ALTER TABLE {$PHORUM['user_newflags_table']} ADD message_id INT( 11 ) NOT NULL",$cid);
// removing old primary-key
mysql_query("ALTER TABLE {$PHORUM['user_newflags_table']} DROP PRIMARY KEY",$cid);
// adding new primary-key
mysql_query("ALTER TABLE {$PHORUM['user_newflags_table']} ADD PRIMARY KEY ( user_id , forum_id , message_id )",$cid);
 
// converting the newflags
$res=mysql_query("SELECT * FROM {$PHORUM['user_newflags_table']} where message_id=0",$cid);
$olduser=$GLOBALS['PHORUM']['user']['user_id'];
while($row=mysql_fetch_assoc($res)) {
$forum=$row['forum_id'];
$data=unserialize($row['newflags']);
$GLOBALS['PHORUM']['user']['user_id']=$row['user_id'];
$newdata=array();
foreach($data as $mid1 => $mid2) {
if(is_int($mid1)) {
$newdata[]=array("id"=>$mid1,"forum"=>$forum);
}
}
phorum_db_newflag_add_read($newdata);
unset($data);
unset($newdata);
}
$GLOBALS['PHORUM']['user']['user_id']=$olduser;
mysql_query("DELETE FROM {$PHORUM['user_newflags_table']} where message_id=0",$cid);
 
// remove old column
mysql_query("ALTER TABLE {$PHORUM['user_newflags_table']} DROP newflags",$cid);
 
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2003060600.php
New file
0,0 → 1,4
<?php
if(!defined("PHORUM_ADMIN")) return;
$upgrade_queries[]="ALTER TABLE {$PHORUM['user_table']} ADD posts int(10) NOT NULL default '0'";
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005101800.php
New file
0,0 → 1,5
<?php
if(!defined("PHORUM_ADMIN")) return;
 
$upgrade_queries[]="ALTER TABLE {$PHORUM['forums_table']} add column sticky_count int(10) unsigned NOT NULL default '0'";
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005101801.php
New file
0,0 → 1,10
<?php
if(!defined("PHORUM_ADMIN")) return;
 
// Refresh all forum statistics for making bringing thread_count up to date.
$forums = phorum_db_get_forums();
foreach ($forums as $forum) {
$GLOBALS["PHORUM"]["forum_id"] = $forum["forum_id"];
phorum_db_update_forum_stats(true);
}
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004080500.php
New file
0,0 → 1,11
<?php
if(!defined("PHORUM_ADMIN")) return;
 
$upgrade_queries[]="alter table {$PHORUM['message_table']} drop key list_page_float";
$upgrade_queries[]="alter table {$PHORUM['message_table']} drop key list_page_flat";
 
$upgrade_queries[]="alter table {$PHORUM['message_table']} add key list_page_float (forum_id, parent_id, modifystamp)";
$upgrade_queries[]="alter table {$PHORUM['message_table']} add key list_page_flat (forum_id, parent_id, thread)";
 
 
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005082300.php
New file
0,0 → 1,10
<?php
if(!defined("PHORUM_ADMIN")) return;
 
$upgrade_queries[]="alter table {$PHORUM['files_table']} add column link varchar(10) NOT NULL DEFAULT ''";
$upgrade_queries[]="drop index message_id on {$PHORUM['files_table']}";
$upgrade_queries[]="create index message_id_link on {$PHORUM['files_table']} (message_id, link)";
$upgrade_queries[]="update {$PHORUM['files_table']} set link='message' where message_id != 0";
$upgrade_queries[]="update {$PHORUM['files_table']} set link='user' where message_id = 0";
 
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004080700.php
New file
0,0 → 1,6
<?php
if(!defined("PHORUM_ADMIN")) return;
 
$upgrade_queries[]="alter table {$PHORUM['user_table']} CHANGE email_temp email_temp VARCHAR( 110 )";
 
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005092300.php
New file
0,0 → 1,12
<?php
if(!defined("PHORUM_ADMIN")) return;
 
$upgrade_queries[]= "CREATE TABLE {$PHORUM["pm_buddies_table"]} (
pm_buddy_id int(10) unsigned NOT NULL auto_increment,
user_id int(10) unsigned NOT NULL,
buddy_user_id int(10) unsigned NOT NULL,
PRIMARY KEY pm_buddy_id (pm_buddy_id),
UNIQUE KEY userids (user_id, buddy_user_id)
) TYPE=MyISAM";
 
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004090700.php
New file
0,0 → 1,10
<?php
if(!defined("PHORUM_ADMIN")) return;
 
$upgrade_queries[]="alter table {$PHORUM['user_table']} ADD last_active_forum INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL AFTER date_last_active";
 
$upgrade_queries[]="alter table {$PHORUM['user_table']} drop key activity";
 
$upgrade_queries[]="alter table {$PHORUM['user_table']} add key activity (date_last_active,hide_activity,last_active_forum)";
 
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2003092700.php
New file
0,0 → 1,5
<?php
if(!defined("PHORUM_ADMIN")) return;
 
$upgrade_queries[]="CREATE TABLE {$PHORUM['banlist_table']} ( id int(11) NOT NULL auto_increment, forum_id int(11) NOT NULL default '0', type tinyint(4) NOT NULL default '0', pcre tinyint(4) NOT NULL default '0', string varchar(255) NOT NULL default '', PRIMARY KEY (id), KEY forum_id (forum_id)) TYPE=MyISAM";
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004031000.php
New file
0,0 → 1,7
<?php
if(!defined("PHORUM_ADMIN")) return;
 
// altering the files tables
$upgrade_queries[]="ALTER TABLE {$PHORUM['message_table']} drop index `search`";
 
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004021200.php
New file
0,0 → 1,8
<?php
if(!defined("PHORUM_ADMIN")) return;
 
// altering the files tables
$upgrade_queries[]="ALTER TABLE {$PHORUM['files_table']} add message_id int unsigned not null default 0";
$upgrade_queries[]="ALTER TABLE {$PHORUM['files_table']} add key (message_id)";
 
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004031200.php
New file
0,0 → 1,7
<?php
if(!defined("PHORUM_ADMIN")) return;
 
// altering the files tables
$upgrade_queries[]="UPDATE {$PHORUM['forums_table']} set active=1";
 
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005100400.php
New file
0,0 → 1,12
<?php
 
if(!defined("PHORUM_ADMIN")) return;
 
$upgrade_queries[]= "alter table {$PHORUM["forums_table"]} modify inherit_id int(10) unsigned default '0'";
 
$upgrade_queries[]= "update {$PHORUM["forums_table"]} set inherit_id=NULL where inherit_id=0";
 
$upgrade_queries[]= "insert into {$PHORUM["settings_table"]} set name='default_forum_options', type='S', data='".mysql_escape_string('a:24:{s:8:"forum_id";s:1:"0";s:10:"moderation";s:1:"0";s:16:"email_moderators";s:1:"0";s:9:"pub_perms";i:1;s:9:"reg_perms";i:15;s:13:"display_fixed";i:0;s:8:"template";s:7:"default";s:8:"language";s:7:"english";s:13:"threaded_list";s:1:"0";s:13:"threaded_read";s:1:"0";s:17:"reverse_threading";s:1:"0";s:12:"float_to_top";s:1:"1";s:16:"list_length_flat";i:30;s:20:"list_length_threaded";i:30;s:11:"read_length";s:2:"30";s:18:"display_ip_address";s:1:"0";s:18:"allow_email_notify";s:1:"0";s:15:"check_duplicate";s:1:"1";s:11:"count_views";s:1:"2";s:15:"max_attachments";i:0;s:22:"allow_attachment_types";s:0:"";s:19:"max_attachment_size";i:0;s:24:"max_totalattachment_size";i:0;s:5:"vroot";i:0;}')."'";
 
 
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004031201.php
New file
0,0 → 1,7
<?php
if(!defined("PHORUM_ADMIN")) return;
 
// altering the files tables
$upgrade_queries[]="ALTER TABLE {$PHORUM['private_message_table']} add key `read_flag` (`to_user_id`,`read_flag`)";
 
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005120400.php
New file
0,0 → 1,6
<?php
if(!defined("PHORUM_ADMIN")) return;
 
$upgrade_queries[]= "alter table {$PHORUM["user_table"]} add moderation_email tinyint(2) unsigned not null default 1";
 
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004071000.php
New file
0,0 → 1,8
<?php
if(!defined("PHORUM_ADMIN")) return;
 
// altering the message-table with an index for unapproved messages
$upgrade_queries[]="ALTER TABLE {$PHORUM['message_table']} ADD INDEX status_forum ( status , forum_id )";
 
 
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2003112500.php
New file
0,0 → 1,6
<?php
if(!defined("PHORUM_ADMIN")) return;
 
$upgrade_queries[]="alter table {$PHORUM['forums_table']} drop email_outgoing_address, drop email_incoming_address, drop email_subject_tag";
 
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004100700.php
New file
0,0 → 1,6
<?php
if(!defined("PHORUM_ADMIN")) return;
 
$upgrade_queries[]="alter table {$PHORUM['message_table']} drop key post_count, add key post_count (forum_id, status, parent_id)";
 
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005100600.php
New file
0,0 → 1,13
<?php
 
if(!defined("PHORUM_ADMIN")) return;
 
$upgrade_queries[]= "alter table {$PHORUM["user_table"]} add sessid_st_timeout int(10) unsigned not null default 0";
 
$upgrade_queries[]= "insert into {$PHORUM["settings_table"]} set name='short_session_timeout', type='V', data='60'";
 
$upgrade_queries[]= "insert into {$PHORUM["settings_table"]} set name='tight_security', type='V', data='0'";
 
$upgrade_queries[]= "insert into {$PHORUM["settings_table"]} set name='admin_session_salt', type='V', data='".microtime()."'";
 
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004112600.php
New file
0,0 → 1,10
<?php
if(!defined("PHORUM_ADMIN")) return;
 
$upgrade_queries[]="ALTER TABLE {$PHORUM['user_table']} ADD `show_signature` TINYINT( 1 ) DEFAULT '0' NOT NULL ,
ADD `email_notify` TINYINT( 1 ) DEFAULT '0' NOT NULL ,
ADD `tz_offset` TINYINT( 2 ) DEFAULT '-99' NOT NULL,
ADD `is_dst` TINYINT( 1 ) DEFAULT '0' NOT NULL ,
ADD `user_language` VARCHAR( 100 ) NOT NULL ,
ADD `user_template` VARCHAR( 100 ) NOT NULL ";
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005102700.php
New file
0,0 → 1,7
<?php
if(!defined("PHORUM_ADMIN")) return;
 
$upgrade_queries[]="ALTER TABLE {$PHORUM['search_table']} ADD COLUMN forum_id int(10) UNSIGNED NOT NULL DEFAULT '0', ADD KEY forum_id (forum_id)";
$upgrade_queries[]="UPDATE {$PHORUM['search_table']}, {$PHORUM['message_table']} set {$PHORUM['search_table']}.forum_id={$PHORUM['message_table']}.forum_id where {$PHORUM['search_table']}.message_id={$PHORUM['message_table']}.message_id";
 
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004073100.php
New file
0,0 → 1,7
<?php
if(!defined("PHORUM_ADMIN")) return;
 
$upgrade_queries[]="ALTER TABLE {$PHORUM['user_table']} CHANGE email email VARCHAR( 100 ) NOT NULL";
 
$upgrade_queries[]="ALTER TABLE {$PHORUM['message_table']} CHANGE email email VARCHAR( 100 ) NOT NULL";
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004061400.php
New file
0,0 → 1,7
<?php
if(!defined("PHORUM_ADMIN")) return;
 
// altering the user tables for email-changes
$upgrade_queries[]="ALTER TABLE {$PHORUM['user_table']} ADD email_temp VARCHAR( 101 ) NOT NULL AFTER email" ;
$upgrade_queries[]="ALTER TABLE {$PHORUM['user_table']} ADD INDEX ( email_temp ) ";
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004112601.php
New file
0,0 → 1,9
<?php
if(!defined("PHORUM_ADMIN")) return;
 
$upgrade_queries[]="CREATE TABLE {$PHORUM['user_custom_fields_table']} (
user_id INT DEFAULT '0' NOT NULL ,
type INT DEFAULT '0' NOT NULL ,
data TEXT NOT NULL ,
PRIMARY KEY ( user_id , type )) TYPE=MyISAM";
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004112602.php
New file
0,0 → 1,28
<?php
if(!defined("PHORUM_ADMIN")) return;
/*
ALTER TABLE {$PHORUM['user_table']} ADD `show_signature` TINYINT( 1 ) DEFAULT '0' NOT NULL ,
ADD `email_notify` TINYINT( 1 ) DEFAULT '0' NOT NULL ,
ADD `tz_offset` TINYINT( 2 ) DEFAULT NULL ,
ADD `is_dst` TINYINT( 1 ) DEFAULT '0' NOT NULL ,
ADD `user_language` VARCHAR( 100 ) NOT NULL ,
ADD `user_template` VARCHAR( 100 ) NOT NULL ;
 
create additional table for custom-fields
 
*/
 
 
// converting custom-field settings
if(!isset($PHORUM['PROFILE_FIELDS']['num_fields'])) {
$new_profile_fields=array();
foreach($PHORUM['PROFILE_FIELDS'] as $id => $name) {
$new_profile_fields[$id]=array('name'=>$name,'length'=>255,'html_disabled'=>0);
}
$new_profile_fields['num_fields']=count($new_profile_fields);
$PHORUM['PROFILE_FIELDS']=$new_profile_fields;
// saving them
phorum_db_update_settings(array('PROFILE_FIELDS'=>$new_profile_fields));
}
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004112800.php
New file
0,0 → 1,5
<?php
if(!defined("PHORUM_ADMIN")) return;
 
$upgrade_queries[]="ALTER TABLE {$PHORUM['forums_table']} ADD `vroot` INT( 10 ) DEFAULT '0' NOT NULL";
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004112603.php
New file
0,0 → 1,70
<?php
if(!defined("PHORUM_ADMIN")) return;
 
$cid=phorum_db_mysql_connect();
 
// converting the custom-fields
$res=mysql_query("SELECT user_id,user_data FROM {$PHORUM['user_table']}",$cid);
 
while($row=mysql_fetch_assoc($res)) {
$userdata=array('user_id'=>$row['user_id']);
$user_data_new=array();
$user_data_old=unserialize($row['user_data']);
// converting meta-data to fields
if(isset($user_data_old['show_signature']) && !empty($user_data_old['show_signature']))
$userdata['show_signature']=$user_data_old['show_signature'];
if(isset($user_data_old['email_notify']) && !empty($user_data_old['email_notify']))
$userdata['email_notify']=$user_data_old['email_notify'];
if(isset($user_data_old['tz_offset']) && !empty($user_data_old['tz_offset']))
$userdata['tz_offset']=$user_data_old['tz_offset'];
if(isset($user_data_old['is_dst']) && !empty($user_data_old['is_dst']))
$userdata['is_dst']=$user_data_old['is_dst'];
 
if(isset($user_data_old['user_language']) && !empty($user_data_old['user_language']))
$userdata['user_language']=$user_data_old['user_language'];
 
if(isset($user_data_old['user_template']) && !empty($user_data_old['user_template']))
$userdata['user_template']=$user_data_old['user_template'];
unset($user_data_old['user_template']);
unset($user_data_old['user_language']);
unset($user_data_old['is_dst']);
unset($user_data_old['tz_offset']);
unset($user_data_old['email_notify']);
unset($user_data_old['show_signature']);
// converting custom-fields now
if(is_array($user_data_old) && count($user_data_old)) {
foreach($user_data_old as $old_key => $old_val) {
$type=-1;
// find out which ID that custom-field has
foreach($PHORUM['PROFILE_FIELDS'] as $ctype => $cdata) {
if($cdata['name'] == $old_key) {
$type=$ctype;
break;
}
}
 
if($type != -1) { // store it only if we found it
if( $old_val!=="" ) {
if(!is_array($old_val)) {
$user_data_new[$type] = substr($old_val,0,$PHORUM['PROFILE_FIELDS'][$type]['length']);
} else {
$user_data_new[$type] = $old_val;
}
}
}
}
}
$userdata['user_data']=$user_data_new;
phorum_user_save($userdata);
}
// remove old column
//mysql_query("ALTER TABLE {$PHORUM['user_newflags_table']} DROP newflags",$cid);
 
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005031900.php
New file
0,0 → 1,6
<?php
if(!defined("PHORUM_ADMIN")) return;
 
$upgrade_queries[]="ALTER TABLE {$PHORUM['user_table']} ADD `sessid` varchar(50) NOT NULL default '',add key sessid (sessid)";
 
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2003091700.php
New file
0,0 → 1,10
<?php
if(!defined("PHORUM_ADMIN")) return;
 
$upgrade_queries[]="alter table {$PHORUM['message_table']} drop attachments";
$upgrade_queries[]="CREATE TABLE {$PHORUM['files_table']} ( file_id int(11) NOT NULL auto_increment, user_id int(11) NOT NULL default '0', filename varchar(255) NOT NULL default '', filesize int(11) NOT NULL default '0', file_data mediumtext NOT NULL, add_datetime int(10) unsigned NOT NULL default '0', PRIMARY KEY (file_id), KEY add_datetime (add_datetime) ) TYPE=MyISAM";
$upgrade_queries[]="CREATE TABLE {$PHORUM['message_files_xref_table']} ( message_id int(11) NOT NULL default '0', file_id int(11) NOT NULL default '0', PRIMARY KEY (message_id, file_id) ) TYPE=MyISAM";
 
 
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2003103000.php
New file
0,0 → 1,11
<?php
if(!defined("PHORUM_ADMIN")) return;
 
$upgrade_queries[]="ALTER TABLE {$PHORUM['forums_table']} drop allow_html";
 
$upgrade_queries[]="ALTER TABLE {$PHORUM['forums_table']} add registration_control tinyint(1) NOT NULL default '0'";
 
$upgrade_queries[]="ALTER TABLE {$PHORUM['forums_table']} change sec_public pub_perms int(10) unsigned NOT NULL default '0'";
$upgrade_queries[]="ALTER TABLE {$PHORUM['forums_table']} change sec_reg reg_perms int(10) unsigned NOT NULL default '0'";
 
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2003060100.php
New file
0,0 → 1,4
<?php
if(!defined("PHORUM_ADMIN")) return;
$upgrade_queries[]="ALTER TABLE {$PHORUM['user_table']} ADD password_temp varchar(50) NOT NULL default ''";
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2003022400.php
New file
0,0 → 1,4
<?php
if(!defined("PHORUM_ADMIN")) return;
$upgrade_queries[]="ALTER TABLE {$PHORUM['forums_table']} ADD edit_post TINYINT unsigned NOT NULL DEFAULT 1";
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2003072000.php
New file
0,0 → 1,4
<?php
if(!defined("PHORUM_ADMIN")) return;
$upgrade_queries[]="ALTER TABLE {$PHORUM['forums_table']} ADD check_duplicate tinyint(4) NOT NULL default '0'";
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005062000.php
New file
0,0 → 1,6
<?php
if(!defined("PHORUM_ADMIN")) return;
 
$upgrade_queries[]="ALTER TABLE {$PHORUM['forums_table']} ADD `reverse_threading` tinyint(1) NOT NULL default '0'";
 
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005101700.php
New file
0,0 → 1,5
<?php
if(!defined("PHORUM_ADMIN")) return;
 
$upgrade_queries[]="ALTER TABLE {$PHORUM['forums_table']} change column inherit_id inherit_id int(10) unsigned default NULL";
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2003052600.php
New file
0,0 → 1,4
<?php
if(!defined("PHORUM_ADMIN")) return;
$upgrade_queries[]="ALTER TABLE {$PHORUM['forums_table']} ADD template_settings text NOT NULL";
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005022800.php
New file
0,0 → 1,7
<?php
if(!defined("PHORUM_ADMIN")) return;
 
$upgrade_queries[]="CREATE TABLE {$PHORUM['search_table']} ( message_id int(10) unsigned NOT NULL default '0', search_text mediumtext NOT NULL, PRIMARY KEY (message_id), FULLTEXT KEY search_text (search_text) ) TYPE=MyISAM";
$upgrade_queries[]="insert into {$PHORUM['search_table']} select message_id, concat(author, ' | ', subject, ' | ', body) from {$PHORUM['message_table']}";
 
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005070500.php
New file
0,0 → 1,6
<?php
if(!defined("PHORUM_ADMIN")) return;
 
$upgrade_queries[]="alter table {$PHORUM['user_table']} add column moderator_data text not null default '';";
 
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004080600.php
New file
0,0 → 1,7
<?php
if(!defined("PHORUM_ADMIN")) return;
 
$upgrade_queries[]="alter table {$PHORUM['forums_table']} modify description text not null default ''";
$upgrade_queries[]="alter table {$PHORUM['user_newflags_table']} drop newflags";
 
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004032900.php
New file
0,0 → 1,6
<?php
if(!defined("PHORUM_ADMIN")) return;
 
$upgrade_queries[]="alter table {$PHORUM['private_message_table']} drop KEY read_flag";
$upgrade_queries[]="alter table {$PHORUM['private_message_table']} add KEY read_flag (to_user_id,read_flag,to_del_flag)";
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005092200.php
New file
0,0 → 1,35
<?php
if(!defined("PHORUM_ADMIN")) return;
 
// Check if all the tables from version 2005091400 were created,
// before dropping the old private messages table.
 
$old_table = "{$PHORUM['DBCONFIG']['table_prefix']}_private_messages";
 
$cid=phorum_db_mysql_connect();
 
$check_tables = array(
$PHORUM["pm_messages_table"] => 1,
$PHORUM["pm_folders_table"] => 1,
$PHORUM["pm_xref_table"] => 1,
);
 
$res = mysql_query("show tables");
if ($res) {
while (($row = mysql_fetch_array($res))) {
if (isset($check_tables[$row[0]])) {
unset($check_tables[$row[0]]);
}
}
}
 
if (count($check_tables)) { ?>
<br/>
<b>Warning: database upgrade 2005091400 does not seem to have
completed successfully. The old style private messages table
<?php print $old_table ?> will be kept for backup. <?php
} else {
$upgrade_queries[] = "DROP TABLE $old_table";
}
 
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004080601.php
New file
0,0 → 1,6
<?php
if(!defined("PHORUM_ADMIN")) return;
 
$upgrade_queries[]="alter table {$PHORUM['message_table']} add key post_count (forum_id,status,parent_id)";
 
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004032901.php
New file
0,0 → 1,7
<?php
if(!defined("PHORUM_ADMIN")) return;
 
// altering the files tables
$upgrade_queries[]="alter table {$PHORUM['forums_table']} drop registration_control;";
 
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005062600.php
New file
0,0 → 1,6
<?php
if(!defined("PHORUM_ADMIN")) return;
 
$upgrade_queries[]="ALTER TABLE {$PHORUM['forums_table']} ADD `inherit_id` int(10) unsigned default '0' not null";
 
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005092201.php
New file
0,0 → 1,6
<?php
if(!defined("PHORUM_ADMIN")) return;
 
$upgrade_queries[]="alter table {$PHORUM['user_table']} add column pm_email_notify tinyint ( 1 ) default '1' not null";
 
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005092400.php
New file
0,0 → 1,6
<?php
if(!defined("PHORUM_ADMIN")) return;
 
$upgrade_queries[]= "alter table {$PHORUM['user_table']} add column cookie_sessid_lt varchar(50) NOT NULL default '',change column sessid sessid_st varchar(50) NOT NULL default '',add index sessid_st (sessid_st),add index cookie_sessid_lt (cookie_sessid_lt),drop index sessid";
 
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005072600.php
New file
0,0 → 1,6
<?php
if(!defined("PHORUM_ADMIN")) return;
 
$upgrade_queries[]="alter table {$PHORUM['message_table']} CHANGE meta meta mediumtext NOT NULL";
 
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004080800.php
New file
0,0 → 1,17
<?php
if(!defined("PHORUM_ADMIN")) return;
 
$upgrade_queries[]="alter table {$PHORUM['message_table']} add closed tinyint(4) NOT NULL default '0'";
 
$upgrade_queries[]="update {$PHORUM['message_table']} set closed=1, status=2 where status=1";
 
$upgrade_queries[]="alter table {$PHORUM['message_table']} add key dup_check (forum_id,author,subject,datestamp)";
 
$upgrade_queries[]="alter table {$PHORUM['message_table']} drop key message_id";
 
$upgrade_queries[]="alter table {$PHORUM['message_table']} add key forum_max_message (forum_id, message_id)";
 
$upgrade_queries[]="alter table {$PHORUM['message_table']} add key last_post_time (forum_id, status, modifystamp)";
 
 
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004052900.php
New file
0,0 → 1,7
<?php
if(!defined("PHORUM_ADMIN")) return;
 
// altering the files tables
$upgrade_queries[]="alter table {$PHORUM['message_table']} add viewcount int(10) unsigned NOT NULL default '0'";
$upgrade_queries[]="alter table {$PHORUM['forums_table']} add count_views tinyint(1) unsigned NOT NULL default '0'";
?>
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005082800.php
New file
0,0 → 1,6
<?php
if(!defined("PHORUM_ADMIN")) return;
 
$upgrade_queries[]="alter table {$PHORUM['forums_table']} add column max_totalattachment_size int(10) unsigned default 0";
 
?>