ext_tables.sql

Typo3, 开源里边最强大的

#
# Table structure for extension 'rtehtmlarea'
#

CREATE TABLE tx_rtehtmlarea_acronym (
	uid int(11) unsigned NOT NULL auto_increment,
	pid int(11) unsigned 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,
	endtime int(11) unsigned DEFAULT '0' NOT NULL,
	sorting int(11) unsigned DEFAULT '0' NOT NULL,
	sys_language_uid int(11) DEFAULT '0' NOT NULL,
	type tinyint(3) unsigned DEFAULT '1' NOT NULL,
	term tinytext NOT NULL,
	acronym tinytext NOT NULL,
	
	PRIMARY KEY (uid),
	KEY parent (pid)
);