blob: 1f64a32e1b307d52e8fed63c6d3af35dfe91c697 (
plain)
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
|
<?php
class ExtendWikiSize extends Migration
{
public function description()
{
return 'Increase max length of wiki like content (wiki, scm, cv, publications) from 64k to 16M';
}
public function up()
{
$db = DBManager::get();
$db->exec("ALTER TABLE scm CHANGE tab_name tab_name varchar(255) NOT NULL DEFAULT '',
CHANGE content content mediumtext NOT NULL");
$db->exec("ALTER TABLE user_info CHANGE lebenslauf lebenslauf mediumtext NOT NULL,
CHANGE publi publi mediumtext NOT NULL");
$db->exec("ALTER TABLE wiki CHANGE keyword keyword varchar(255) BINARY NOT NULL DEFAULT '',
CHANGE body body mediumtext NOT NULL");
$db->exec("ALTER TABLE wiki_links CHANGE from_keyword from_keyword varchar(255) BINARY NOT NULL DEFAULT '',
CHANGE to_keyword to_keyword varchar(255) BINARY NOT NULL DEFAULT ''");
$db->exec("ALTER TABLE wiki_locks CHANGE keyword keyword varchar(255) BINARY NOT NULL DEFAULT ''");
}
public function down()
{
$db = DBManager::get();
$db->exec("ALTER TABLE scm CHANGE tab_name tab_name varchar(20) NOT NULL DEFAULT 'Info',
CHANGE content content text");
$db->exec("ALTER TABLE user_info CHANGE lebenslauf lebenslauf text,
CHANGE publi publi text NOT NULL");
$db->exec("ALTER TABLE wiki CHANGE keyword keyword varchar(128) BINARY NOT NULL DEFAULT '',
CHANGE body body text");
$db->exec("ALTER TABLE wiki_links CHANGE from_keyword from_keyword char(128) BINARY NOT NULL DEFAULT '',
CHANGE to_keyword to_keyword char(128) BINARY NOT NULL DEFAULT ''");
$db->exec("ALTER TABLE wiki_locks CHANGE keyword keyword varchar(128) BINARY NOT NULL DEFAULT ''");
}
}
|
