Replace all TINYTEXT columns with VARCHAR(255) and change index "parent" of fe_user...
[Packages/TYPO3.CMS.git] / typo3 / sysext / dbal / ext_tables.sql
1
2 #
3 # Table structure for table 'tx_dbal_debuglog'
4 #
5 CREATE TABLE tx_dbal_debuglog (
6 uid int(11) unsigned NOT NULL auto_increment,
7 tstamp int(11) unsigned DEFAULT '0',
8 beuser_id int(11) unsigned DEFAULT '0',
9 script varchar(255) DEFAULT '' NOT NULL,
10 exec_time int(11) unsigned DEFAULT '0',
11 table_join varchar(255) DEFAULT '' NOT NULL,
12 serdata blob,
13 query text NOT NULL,
14 errorFlag int(11) unsigned DEFAULT '0',
15
16 PRIMARY KEY (uid),
17 KEY tstamp (tstamp)
18 );
19
20 #
21 # Table structure for table 'tx_dbal_debuglog_where'
22 #
23 CREATE TABLE tx_dbal_debuglog_where (
24 uid int(11) unsigned NOT NULL auto_increment,
25 tstamp int(11) unsigned DEFAULT '0',
26 beuser_id int(11) unsigned DEFAULT '0',
27 script varchar(255) DEFAULT '' NOT NULL,
28 tablename varchar(255) DEFAULT '' NOT NULL,
29 whereclause text NOT NULL,
30
31 PRIMARY KEY (uid),
32 KEY tstamp (tstamp)
33 );