1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
|
<?PHP // $Id: mysql.php,v 1.7.8.2 2004/11/18 19:08:56 stronk7 Exp $
function chat_upgrade($oldversion) {
// This function does anything necessary to upgrade
// older versions to match current functionality
global $CFG;
if ($oldversion < 2003072100) {
modify_database ("", " INSERT INTO prefix_log_display VALUES ('chat', 'report', 'chat', 'name'); ");
}
if ($oldversion < 2003072101) {
table_column("chat", "messages", "keepdays", "integer", "10", "unsigned", "0", "not null");
}
if ($oldversion < 2003072102) {
table_column("chat", "", "studentlogs", "integer", "4", "unsigned", "0", "not null", "keepdays");
}
if ($oldversion < 2003072500) {
table_column("chat", "", "chattime", "integer", "10", "unsigned", "0", "not null", "studentlogs");
table_column("chat", "", "schedule", "integer", "4", "", "0", "not null", "studentlogs");
}
if ($oldversion < 2004022300) {
table_column("chat_messages", "", "groupid", "integer", "10", "unsigned", "0", "not null", "userid");
table_column("chat_users", "", "groupid", "integer", "10", "unsigned", "0", "not null", "userid");
}
if ($oldversion < 2004042500) {
include_once("$CFG->dirroot/mod/chat/lib.php");
chat_refresh_events();
}
if ($oldversion < 2004043000) {
modify_database("", "INSERT INTO prefix_log_display VALUES ('chat', 'talk', 'chat', 'name');");
}
if ($oldversion < 2004060401) {
modify_database('','ALTER TABLE prefix_chat ADD INDEX `course` (`course`);');
modify_database('','ALTER TABLE prefix_chat_messages ADD INDEX `chatid` (`chatid`);');
modify_database('','ALTER TABLE prefix_chat_messages ADD INDEX `userid` (`userid`);');
modify_database('','ALTER TABLE prefix_chat_messages ADD INDEX `groupid` (`groupid`);');
modify_database('','ALTER TABLE prefix_chat_users ADD INDEX `chatid` (`chatid`);');
modify_database('','ALTER TABLE prefix_chat_users ADD INDEX `groupid` (`groupid`);');
}
return true;
}
?>
|
