BugFix tx_ removed from linkBuilder
[TYPO3CMS/Extensions/typo3wiki.git] / ext_tables.sql
1 #
2 # Table structure for table 'tx_typo3wiki_domain_model_page'
3 #
4 CREATE TABLE tx_typo3wiki_domain_model_page (
5
6 uid int(11) NOT NULL auto_increment,
7 pid int(11) DEFAULT '0' NOT NULL,
8
9 page_title varchar(255) DEFAULT '' NOT NULL,
10 is_category tinyint(4) unsigned DEFAULT '0' NOT NULL,
11 subscriber int(11) unsigned DEFAULT '0' NOT NULL,
12 revisions int(11) unsigned DEFAULT '0' NOT NULL,
13 main_revision int(11) unsigned DEFAULT '0',
14 related_pages int(11) unsigned DEFAULT '0' NOT NULL,
15 category_pages int(11) unsigned DEFAULT '0' NOT NULL,
16 redirection int(11) unsigned DEFAULT '0',
17
18 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
19 crdate int(11) unsigned DEFAULT '0' NOT NULL,
20 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
21 deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
22 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
23 starttime int(11) unsigned DEFAULT '0' NOT NULL,
24 endtime int(11) unsigned DEFAULT '0' NOT NULL,
25
26 t3_origuid int(11) DEFAULT '0' NOT NULL,
27 sys_language_uid int(11) DEFAULT '0' NOT NULL,
28 l10n_parent int(11) DEFAULT '0' NOT NULL,
29 l10n_diffsource mediumblob,
30
31 PRIMARY KEY (uid),
32 KEY parent (pid),
33
34 KEY language (l10n_parent,sys_language_uid)
35
36 );
37
38 #
39 # Table structure for table 'tx_typo3wiki_domain_model_textrevision'
40 #
41 CREATE TABLE tx_typo3wiki_domain_model_textrevision (
42
43 uid int(11) NOT NULL auto_increment,
44 pid int(11) DEFAULT '0' NOT NULL,
45
46 page int(11) unsigned DEFAULT '0' NOT NULL,
47
48 write_date int(11) DEFAULT '0' NOT NULL,
49 unrendered_text text NOT NULL,
50 rendered_text text NOT NULL,
51 changes varchar(255) DEFAULT '' NOT NULL,
52 owner int(11) unsigned DEFAULT '0',
53
54 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
55 crdate int(11) unsigned DEFAULT '0' NOT NULL,
56 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
57 deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
58 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
59 starttime int(11) unsigned DEFAULT '0' NOT NULL,
60 endtime int(11) unsigned DEFAULT '0' NOT NULL,
61
62 sorting int(11) DEFAULT '0' NOT NULL,
63 t3_origuid int(11) DEFAULT '0' NOT NULL,
64 sys_language_uid int(11) DEFAULT '0' NOT NULL,
65 l10n_parent int(11) DEFAULT '0' NOT NULL,
66 l10n_diffsource mediumblob,
67
68 PRIMARY KEY (uid),
69 KEY parent (pid),
70
71 KEY language (l10n_parent,sys_language_uid)
72
73 );
74
75 #
76 # Table structure for table 'fe_users'
77 #
78 CREATE TABLE fe_users (
79
80 tx_extbase_type varchar(255) DEFAULT '' NOT NULL,
81
82 );
83
84 #
85 # Table structure for table 'tx_typo3wiki_domain_model_textrevision'
86 #
87 CREATE TABLE tx_typo3wiki_domain_model_textrevision (
88
89 page int(11) unsigned DEFAULT '0' NOT NULL,
90
91 );
92
93 #
94 # Table structure for table 'tx_typo3wiki_page_user_mm'
95 #
96 CREATE TABLE tx_typo3wiki_page_user_mm (
97 uid_local int(11) unsigned DEFAULT '0' NOT NULL,
98 uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
99 sorting int(11) unsigned DEFAULT '0' NOT NULL,
100 sorting_foreign int(11) unsigned DEFAULT '0' NOT NULL,
101
102 KEY uid_local (uid_local),
103 KEY uid_foreign (uid_foreign)
104 );
105
106 #
107 # Table structure for table 'tx_typo3wiki_page_page_mm'
108 #
109 CREATE TABLE tx_typo3wiki_page_page_mm (
110 uid_local int(11) unsigned DEFAULT '0' NOT NULL,
111 uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
112 sorting int(11) unsigned DEFAULT '0' NOT NULL,
113 sorting_foreign int(11) unsigned DEFAULT '0' NOT NULL,
114
115 KEY uid_local (uid_local),
116 KEY uid_foreign (uid_foreign)
117 );
118
119 #
120 # Table structure for table 'tx_typo3wiki_category_page_mm'
121 #
122 CREATE TABLE tx_typo3wiki_category_page_mm (
123 uid_local int(11) unsigned DEFAULT '0' NOT NULL,
124 uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
125 sorting int(11) unsigned DEFAULT '0' NOT NULL,
126 sorting_foreign int(11) unsigned DEFAULT '0' NOT NULL,
127
128 KEY uid_local (uid_local),
129 KEY uid_foreign (uid_foreign)
130 );