femanager/ext_tables.sql at main · in2code-de/femanager · 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
#
# Table structure for table 'fe_users'
#
CREATE TABLE fe_users (
  gender int(11) unsigned DEFAULT '0' NOT NULL,
  date_of_birth int(11) DEFAULT '0' NOT NULL,
  tx_femanager_confirmedbyuser tinyint(3) DEFAULT '0' NOT NULL,
  tx_femanager_confirmedbyadmin tinyint(3) DEFAULT '0' NOT NULL,
  tx_femanager_log int(11) DEFAULT '0' NOT NULL,
  tx_femanager_changerequest text,
  tx_femanager_terms tinyint(3) DEFAULT '0' NOT NULL,
  tx_femanager_terms_date_of_acceptance INT(11) DEFAULT '0' NOT NULL,
  state varchar(255) DEFAULT '' NOT NULL
);

#
# Table structure for table 'tx_femanager_domain_model_log'
#
CREATE TABLE tx_femanager_domain_model_log (
  uid int(11) NOT NULL auto_increment,
  pid int(11) DEFAULT '0' NOT NULL,

  user int(11) unsigned DEFAULT '0' NOT NULL,

  title varchar(255) DEFAULT '' NOT NULL,
  state int(11) unsigned DEFAULT '0' NOT NULL,
  additional_properties mediumblob,

  cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
  deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,

  t3ver_oid int(11) DEFAULT '0' NOT NULL,
  t3ver_id int(11) DEFAULT '0' NOT NULL,
  t3ver_wsid int(11) DEFAULT '0' NOT NULL,
  t3ver_label varchar(255) DEFAULT '' NOT NULL,
  t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
  t3ver_stage int(11) DEFAULT '0' NOT NULL,
  t3ver_count int(11) DEFAULT '0' NOT NULL,
  t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
  t3ver_move_id int(11) DEFAULT '0' NOT NULL,

  PRIMARY KEY (uid),
  KEY parent (pid),
  KEY t3ver_oid (t3ver_oid,t3ver_wsid),
  KEY language (l10n_parent,sys_language_uid)
);