-
Notifications
You must be signed in to change notification settings - Fork 2
/
ext_tables.sql
44 lines (35 loc) · 1.25 KB
/
ext_tables.sql
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
CREATE TABLE tx_sudhaus7wizard_domain_model_creator (
uid int(11) NOT NULL auto_increment,
pid int(11) NOT NULL DEFAULT '0',
title varchar(255) NOT NULL DEFAULT '',
category varchar(255) NOT NULL DEFAULT '',
tstamp int(11) unsigned NOT NULL DEFAULT '0',
crdate int(11) unsigned NOT NULL DEFAULT '0',
cruser_id int(11) unsigned NOT NULL DEFAULT '0',
deleted tinyint(4) unsigned NOT NULL DEFAULT '0',
hidden tinyint(4) unsigned NOT NULL DEFAULT '0',
t3_origuid int(11) NOT NULL DEFAULT '0',
sys_language_uid int(11) NOT NULL DEFAULT '0',
l10n_parent int(11) NOT NULL DEFAULT '0',
l10n_diffsource mediumblob,
base varchar(255) NOT NULL DEFAULT '',
projektname text,
longname text,
shortname text,
domainname text,
contact text,
reduser text,
redpass text,
redemail text,
flexinfo text,
email text,
sourceclass varchar(255) NOT NULL DEFAULT '\\SUDHAUS7\\Sudhaus7Wizard\\Sources\\Localdatabase',
valuemapping varchar(255) NOT NULL DEFAULT '',
sourcepid varchar(255) NOT NULL DEFAULT '0',
sourceuser varchar(255) NOT NULL DEFAULT '0',
sourcefilemount varchar(255) NOT NULL DEFAULT '0',
status int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (uid),
KEY parent (pid),
KEY language (l10n_parent,sys_language_uid)
);