xima-typo3-content-planner/ext_tables.sql at main · xima-media/xima-typo3-content-planner · 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
72
73
74
75
76
77
78
79
80
81
82
83
CREATE TABLE pages
(
	tx_ximatypo3contentplanner_status   int(11) DEFAULT NULL,
	tx_ximatypo3contentplanner_assignee int(11) DEFAULT NULL,
	tx_ximatypo3contentplanner_comments int(11) unsigned default '0' not null,
);

CREATE TABLE be_users
(
	tx_ximatypo3contentplanner_hide tinyint(4) unsigned DEFAULT 0 NOT NULL,
);

CREATE TABLE be_groups
(
	tx_ximatypo3contentplanner_allowed_statuses text,
	tx_ximatypo3contentplanner_allowed_tables text,
);

CREATE TABLE tx_ximatypo3contentplanner_comment
(
	uid           int(11) NOT NULL auto_increment,
	pid           int(11) DEFAULT '0' NOT NULL,

	foreign_uid   int(11) default '0' not null,
	foreign_table varchar(255) default '' not null,

	content       text,
	author        int(11) DEFAULT NULL,
	edited        tinyint(4) unsigned DEFAULT 0 NOT NULL,
	resolved_user int(11) DEFAULT '0' NOT NULL,
	resolved_date int(11) DEFAULT '0' NOT NULL,
	todo_resolved int(11) unsigned NOT NULL DEFAULT 0,
	todo_total    int(11) unsigned NOT NULL DEFAULT 0,
	PRIMARY KEY (uid)
);

CREATE TABLE tx_ximatypo3contentplanner_domain_model_status
(
	uid       int(11) NOT NULL auto_increment,
	pid       int(11) DEFAULT '0' NOT NULL,

	cruser_id int(11) DEFAULT '0' NOT NULL,
	sorting   int(11) unsigned default '0' not null,

	title     varchar(255) DEFAULT '' NOT NULL,
	icon      varchar(255) DEFAULT '' NOT NULL,
	color     varchar(255) DEFAULT '' NOT NULL,
	PRIMARY KEY (uid)
);

CREATE TABLE tt_content
(
    tx_ximatypo3contentplanner_status   int(11) DEFAULT NULL,
    tx_ximatypo3contentplanner_assignee int(11) DEFAULT NULL,
    tx_ximatypo3contentplanner_comments int(11) unsigned DEFAULT '0' NOT NULL
);

CREATE TABLE sys_file_metadata
(
	tx_ximatypo3contentplanner_status   int(11) DEFAULT NULL,
	tx_ximatypo3contentplanner_assignee int(11) DEFAULT NULL,
	tx_ximatypo3contentplanner_comments int(11) unsigned DEFAULT '0' NOT NULL
);

CREATE TABLE tx_ximatypo3contentplanner_folder
(
	uid               int(11) NOT NULL auto_increment,
	pid               int(11) DEFAULT '0' NOT NULL,

	folder_identifier varchar(255) DEFAULT '' NOT NULL,
	storage_uid       int(11) DEFAULT '0' NOT NULL,

	tx_ximatypo3contentplanner_status   int(11) DEFAULT NULL,
	tx_ximatypo3contentplanner_assignee int(11) DEFAULT NULL,
	tx_ximatypo3contentplanner_comments int(11) unsigned DEFAULT '0' NOT NULL,

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

	PRIMARY KEY (uid),
	UNIQUE KEY folder_lookup (storage_uid, folder_identifier(191))
);