virtual_urls/install.php at main · FriendsOfREDAXO/virtual_urls · 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
<?php

// Tabelle anlegen/aktualisieren via rex_sql_table
rex_sql_table::get(rex::getTable('virtual_urls_profiles'))
    ->ensureColumn(new rex_sql_column('id', 'int(11) unsigned', false, null, 'auto_increment'))
    ->ensureColumn(new rex_sql_column('status', 'tinyint(1)', false, '1'))
    ->ensureColumn(new rex_sql_column('clang_id', 'int(11)', false, '-1'))
    ->ensureColumn(new rex_sql_column('domain', 'varchar(255)', false, ''))
    ->ensureColumn(new rex_sql_column('table_name', 'varchar(255)', false, ''))
    ->ensureColumn(new rex_sql_column('trigger_segment', 'varchar(255)', false, ''))
    ->ensureColumn(new rex_sql_column('url_field', 'varchar(255)', false, ''))
    ->ensureColumn(new rex_sql_column('article_id', 'int(11) unsigned', false, '0'))
    ->ensureColumn(new rex_sql_column('relation_field', 'varchar(255)', true))
    ->ensureColumn(new rex_sql_column('relation_table', 'varchar(255)', true))
    ->ensureColumn(new rex_sql_column('relation_slug_field', 'varchar(255)', true))
    ->ensureColumn(new rex_sql_column('default_category_id', 'int(11) unsigned', true))
    ->ensureColumn(new rex_sql_column('sitemap_filter', 'varchar(255)', true))
    ->ensureColumn(new rex_sql_column('sitemap_changefreq', 'varchar(20)', false, 'weekly'))
    ->ensureColumn(new rex_sql_column('sitemap_priority', 'varchar(5)', false, '0.5'))
    ->ensureColumn(new rex_sql_column('seo_title_field', 'varchar(255)', true))
    ->ensureColumn(new rex_sql_column('seo_description_field', 'varchar(255)', true))
    ->ensureColumn(new rex_sql_column('seo_image_field', 'varchar(255)', true))
    ->setPrimaryKey('id')
    ->ensure();