Bringing the DBAL extension AS OF JULY 2004 into CVS. This is rather for historic...
[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 DEFAULT '0' NOT NULL auto_increment,
7 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
8 beuser_id int(11) unsigned DEFAULT '0' NOT NULL,
9 script tinytext NOT NULL,
10 exec_time int(11) unsigned DEFAULT '0' NOT NULL,
11 table_join tinytext NOT NULL,
12 serdata text NOT NULL,
13 query text NOT NULL,
14 errorFlag int(11) unsigned DEFAULT '0' NOT NULL,
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 DEFAULT '0' NOT NULL auto_increment,
25 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
26 beuser_id int(11) unsigned DEFAULT '0' NOT NULL,
27 script tinytext NOT NULL,
28 tablename tinytext NOT NULL,
29 whereclause text NOT NULL,
30
31 PRIMARY KEY (uid),
32 KEY tstamp (tstamp)
33 );