search_it/install.php at main · FriendsOfREDAXO/search_it · GitHub

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
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
<?php

rex_sql_table::get(rex::getTable(rex::getTempPrefix() . 'search_it_index'))
    ->ensureColumn(new rex_sql_column('id', 'int(11)', false, null, 'auto_increment'))
    ->ensureColumn(new rex_sql_column('fid', 'varchar(191)', true))
    ->ensureColumn(new rex_sql_column('catid', 'int(11)', true))
    ->ensureColumn(new rex_sql_column('ftable', 'varchar(255)', true))
    ->ensureColumn(new rex_sql_column('fcolumn', 'varchar(255)', true))
    ->ensureColumn(new rex_sql_column('texttype', 'varchar(255)'))
    ->ensureColumn(new rex_sql_column('clang', 'int(11)', true))
    ->ensureColumn(new rex_sql_column('filename', 'varchar(255)', true))
    ->ensureColumn(new rex_sql_column('fileext', 'varchar(255)', true))
    ->ensureColumn(new rex_sql_column('plaintext', 'longtext'))
    ->ensureColumn(new rex_sql_column('unchangedtext', 'longtext'))
    ->ensureColumn(new rex_sql_column('teaser', 'longtext'))
    ->ensureColumn(new rex_sql_column('values', 'longtext'))
    ->ensureColumn(new rex_sql_column('lastindexed', 'VARCHAR(255)'))
    ->setPrimaryKey('id')
    ->ensureIndex(new rex_sql_index('fid', ['fid']))
    ->ensureIndex(new rex_sql_index('plaintext', ['plaintext'], rex_sql_index::FULLTEXT))
    ->ensureIndex(new rex_sql_index('unchangedtext', ['unchangedtext'], rex_sql_index::FULLTEXT))
    ->ensureIndex(new rex_sql_index('plaintext_2', ['plaintext', 'unchangedtext'], rex_sql_index::FULLTEXT))
    ->ensure();


rex_sql_table::get(rex::getTable(rex::getTempPrefix() . 'search_it_cache'))
    ->ensureColumn(new rex_sql_column('id', 'int(11)', false, null, 'auto_increment'))
    ->ensureColumn(new rex_sql_column('hash', 'char(32)'))
    ->ensureColumn(new rex_sql_column('returnarray', 'longtext', true))
    ->setPrimaryKey('id')
    ->ensureIndex(new rex_sql_index('hash', ['hash']))
    ->ensure();

rex_sql_table::get(rex::getTable(rex::getTempPrefix() . 'search_it_cacheindex_ids'))
    ->ensureColumn(new rex_sql_column('id', 'int(11)', false, null, 'auto_increment'))
    ->ensureColumn(new rex_sql_column('index_id', 'int(11)', true))
    ->ensureColumn(new rex_sql_column('cache_id', 'varchar(255)', true))
    ->setPrimaryKey('id')
    ->ensure();

rex_sql_table::get(rex::getTable(rex::getTempPrefix() . 'search_it_keywords'))
    ->ensureColumn(new rex_sql_column('keyword', 'varchar(191)'))
    ->ensureColumn(new rex_sql_column('soundex', 'varchar(255)'))
    ->ensureColumn(new rex_sql_column('metaphone', 'varchar(255)'))
    ->ensureColumn(new rex_sql_column('colognephone', 'varchar(255)'))
    ->ensureColumn(new rex_sql_column('clang', 'int(11)', false, '-1'))
    ->ensureColumn(new rex_sql_column('count', 'int(11)', false, '1'))
    ->removeColumn('id')
    ->setPrimaryKey(['keyword', 'clang'])
    ->ensure();

rex_sql_table::get(rex::getTablePrefix() . 'search_it_stats_searchterms')
    ->ensureColumn(new rex_sql_column('id', 'int(11)', false, null, 'auto_increment'))
    ->ensureColumn(new rex_sql_column('term', 'varchar(255)'))
    ->ensureColumn(new rex_sql_column('time', 'datetime'))
    ->ensureColumn(new rex_sql_column('resultcount', 'int(11)', false, '0'))
    ->setPrimaryKey('id')
    ->ensure();

// v7 Migration: Cronjob-Typen auf Namespace-Klassen umstellen
if (rex_sql::factory()->setQuery('SHOW TABLES LIKE :table', ['table' => rex::getTable('cronjob')])->getRows() > 0) {
    $sql = rex_sql::factory();
    $sql->setQuery('UPDATE ' . rex::getTable('cronjob') . ' SET type = :new WHERE type = :old', [
        'old' => 'rex_cronjob_reindex',
        'new' => FriendsOfRedaxo\SearchIt\Cronjob\Reindex::class,
    ]);
    $sql->setQuery('UPDATE ' . rex::getTable('cronjob') . ' SET type = :new WHERE type = :old', [
        'old' => 'rex_cronjob_clearcache',
        'new' => FriendsOfRedaxo\SearchIt\Cronjob\ClearCache::class,
    ]);
}