Project

General

Profile

Bug #16961 » sql_0004951.patch

Administrator Admin, 2007-02-10 12:17

View differences:

t3lib/stddb/tables.sql (Arbeitskopie)
#
CREATE TABLE be_groups (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
title varchar(50) DEFAULT '' NOT NULL,
non_exclude_fields text NOT NULL,
......
#
CREATE TABLE be_users (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
username varchar(50) DEFAULT '' NOT NULL,
password varchar(40) DEFAULT '' NOT NULL,
......
#
CREATE TABLE sys_filemounts (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
title varchar(30) DEFAULT '' NOT NULL,
path varchar(120) DEFAULT '' NOT NULL,
......
#
CREATE TABLE sys_language (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
title varchar(80) DEFAULT '' NOT NULL,
typo3/sysext/cms/ext_tables.sql (Arbeitskopie)
#
CREATE TABLE fe_groups (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
title varchar(50) DEFAULT '' NOT NULL,
hidden tinyint(3) unsigned DEFAULT '0' NOT NULL,
......
#
CREATE TABLE fe_users (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
username varchar(50) DEFAULT '' NOT NULL,
password varchar(40) DEFAULT '' NOT NULL,
......
#
CREATE TABLE static_template (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
title tinytext NOT NULL,
......
#
CREATE TABLE sys_domain (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
domainName varchar(80) DEFAULT '' NOT NULL,
typo3/sysext/cms/ext_tables_static+adt.sql (Arbeitskopie)
DROP TABLE IF EXISTS static_template;
CREATE TABLE static_template (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
title tinytext NOT NULL,
typo3/sysext/sys_note/ext_tables.sql (Arbeitskopie)
#
CREATE TABLE sys_note (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
pid int(11) DEFAULT '0' NOT NULL,
deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
typo3/sysext/rtehtmlarea/ext_tables.sql (Arbeitskopie)
CREATE TABLE tx_rtehtmlarea_acronym (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
pid int(11) DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
starttime int(11) unsigned DEFAULT '0' NOT NULL,
typo3/sysext/sys_action/ext_tables.sql (Arbeitskopie)
#
CREATE TABLE sys_action (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
(1-1/2)