Bug #57129 » group_db_label_sqlDump.sql

Helge Funk, 2014-03-21 09:31

 
1
# TYPO3 Extension Manager dump 1.1
2
#
3
# Host: localhost    Database: 
4
#--------------------------------------------------------
5

    
6

    
7
#
8
# Table structure for table "tx_groupdblabel_domain_model_parent"
9
#
10
DROP TABLE IF EXISTS tx_groupdblabel_domain_model_parent;
11
CREATE TABLE tx_groupdblabel_domain_model_parent (
12
  uid int(11) NOT NULL auto_increment,
13
  pid int(11) NOT NULL default '0',
14
  title varchar(255) NOT NULL default '',
15
  nodes_with_mm int(11) unsigned NOT NULL default '0',
16
  nodes_without_mm varchar(255) NOT NULL default '',
17
  tstamp int(11) unsigned NOT NULL default '0',
18
  crdate int(11) unsigned NOT NULL default '0',
19
  cruser_id int(11) unsigned NOT NULL default '0',
20
  deleted tinyint(4) unsigned NOT NULL default '0',
21
  hidden tinyint(4) unsigned NOT NULL default '0',
22
  starttime int(11) unsigned NOT NULL default '0',
23
  endtime int(11) unsigned NOT NULL default '0',
24
  t3ver_oid int(11) NOT NULL default '0',
25
  t3ver_id int(11) NOT NULL default '0',
26
  t3ver_wsid int(11) NOT NULL default '0',
27
  t3ver_label varchar(255) NOT NULL default '',
28
  t3ver_state tinyint(4) NOT NULL default '0',
29
  t3ver_stage int(11) NOT NULL default '0',
30
  t3ver_count int(11) NOT NULL default '0',
31
  t3ver_tstamp int(11) NOT NULL default '0',
32
  t3ver_move_id int(11) NOT NULL default '0',
33
  t3_origuid int(11) NOT NULL default '0',
34
  sys_language_uid int(11) NOT NULL default '0',
35
  l10n_parent int(11) NOT NULL default '0',
36
  l10n_diffsource mediumblob,
37
  PRIMARY KEY (uid),
38
  KEY parent (pid),
39
  KEY t3ver_oid (t3ver_oid,t3ver_wsid),
40
  KEY language (l10n_parent,sys_language_uid)
41
);
42

    
43

    
44
INSERT INTO tx_groupdblabel_domain_model_parent VALUES ('1', '0', 'Foooo', '4', '', '1395390501', '1395389843', '1', '0', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', 'a:7:{s:16:"sys_language_uid";N;s:6:"hidden";N;s:5:"title";N;s:13:"nodes_with_mm";N;s:16:"nodes_without_mm";N;s:9:"starttime";N;s:7:"endtime";N;}');
45

    
46

    
47
# TYPO3 Extension Manager dump 1.1
48
#
49
# Host: localhost    Database: 
50
#--------------------------------------------------------
51

    
52

    
53
#
54
# Table structure for table "tx_groupdblabel_domain_model_child"
55
#
56
DROP TABLE IF EXISTS tx_groupdblabel_domain_model_child;
57
CREATE TABLE tx_groupdblabel_domain_model_child (
58
  uid int(11) NOT NULL auto_increment,
59
  pid int(11) NOT NULL default '0',
60
  title varchar(255) NOT NULL default '',
61
  tstamp int(11) unsigned NOT NULL default '0',
62
  crdate int(11) unsigned NOT NULL default '0',
63
  cruser_id int(11) unsigned NOT NULL default '0',
64
  deleted tinyint(4) unsigned NOT NULL default '0',
65
  hidden tinyint(4) unsigned NOT NULL default '0',
66
  starttime int(11) unsigned NOT NULL default '0',
67
  endtime int(11) unsigned NOT NULL default '0',
68
  t3ver_oid int(11) NOT NULL default '0',
69
  t3ver_id int(11) NOT NULL default '0',
70
  t3ver_wsid int(11) NOT NULL default '0',
71
  t3ver_label varchar(255) NOT NULL default '',
72
  t3ver_state tinyint(4) NOT NULL default '0',
73
  t3ver_stage int(11) NOT NULL default '0',
74
  t3ver_count int(11) NOT NULL default '0',
75
  t3ver_tstamp int(11) NOT NULL default '0',
76
  t3ver_move_id int(11) NOT NULL default '0',
77
  t3_origuid int(11) NOT NULL default '0',
78
  sys_language_uid int(11) NOT NULL default '0',
79
  l10n_parent int(11) NOT NULL default '0',
80
  l10n_diffsource mediumblob,
81
  PRIMARY KEY (uid),
82
  KEY parent (pid),
83
  KEY t3ver_oid (t3ver_oid,t3ver_wsid),
84
  KEY language (l10n_parent,sys_language_uid)
85
);
86

    
87

    
88
INSERT INTO tx_groupdblabel_domain_model_child VALUES ('1', '0', 'Bar', '1395389884', '1395389884', '1', '0', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', 'a:5:{s:16:"sys_language_uid";N;s:6:"hidden";N;s:5:"title";N;s:9:"starttime";N;s:7:"endtime";N;}');
89
INSERT INTO tx_groupdblabel_domain_model_child VALUES ('2', '0', 'Baz', '1395389891', '1395389891', '1', '0', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', 'a:5:{s:16:"sys_language_uid";N;s:6:"hidden";N;s:5:"title";N;s:9:"starttime";N;s:7:"endtime";N;}');
90
INSERT INTO tx_groupdblabel_domain_model_child VALUES ('3', '0', 'Bat', '1395389898', '1395389898', '1', '0', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', 'a:5:{s:16:"sys_language_uid";N;s:6:"hidden";N;s:5:"title";N;s:9:"starttime";N;s:7:"endtime";N;}');
91
INSERT INTO tx_groupdblabel_domain_model_child VALUES ('4', '0', 'Man', '1395389906', '1395389906', '1', '0', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', 'a:5:{s:16:"sys_language_uid";N;s:6:"hidden";N;s:5:"title";N;s:9:"starttime";N;s:7:"endtime";N;}');
92

    
93

    
94
# TYPO3 Extension Manager dump 1.1
95
#
96
# Host: localhost    Database: 
97
#--------------------------------------------------------
98

    
99

    
100
#
101
# Table structure for table "tx_groupdblabel_parent_child_mm"
102
#
103
DROP TABLE IF EXISTS tx_groupdblabel_parent_child_mm;
104
CREATE TABLE tx_groupdblabel_parent_child_mm (
105
  uid_local int(11) unsigned NOT NULL default '0',
106
  uid_foreign int(11) unsigned NOT NULL default '0',
107
  sorting int(11) unsigned NOT NULL default '0',
108
  sorting_foreign int(11) unsigned NOT NULL default '0',
109
  tablenames varchar(255) NOT NULL default '',
110
  KEY uid_local (uid_local),
111
  KEY uid_foreign (uid_foreign)
112
);
113

    
114

    
115
INSERT INTO tx_groupdblabel_parent_child_mm VALUES ('1', '1', '1', '0', 'tx_groupdblabel_domain_model_child');
116
INSERT INTO tx_groupdblabel_parent_child_mm VALUES ('1', '4', '3', '0', 'tx_groupdblabel_domain_model_child');
117
INSERT INTO tx_groupdblabel_parent_child_mm VALUES ('1', '1', '2', '0', 'pages');
118
INSERT INTO tx_groupdblabel_parent_child_mm VALUES ('1', '2', '4', '0', 'tx_groupdblabel_domain_model_child');
119

    
120

    
(2-2/2)