ext_tables.sql

#
# Table structure for table 'tx_a21glossary_main'
#
CREATE TABLE tx_a21glossary_main
(
	uid                int(11)             DEFAULT '0' NOT NULL auto_increment,
	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,
	t3ver_oid          int(11) unsigned    DEFAULT '0' NOT NULL,
	t3ver_id           int(11) unsigned    DEFAULT '0' NOT NULL,
	t3ver_label        varchar(30)         DEFAULT ''  NOT NULL,
	sys_language_uid   int(11)             DEFAULT '0' NOT NULL,
	l18n_parent        int(11)             DEFAULT '0' NOT NULL,
	l18n_diffsource    mediumblob                      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,
	fe_group           varchar(200)        DEFAULT '0' NOT NULL,
	short              tinytext                        NOT NULL,
	shortcut           tinytext                        NOT NULL,
	longversion        tinytext                        NOT NULL,
	shorttype          tinytext                        NOT NULL,
	language           char(2)             DEFAULT ''  NOT NULL,
	description        text                            NOT NULL,
	link               tinytext                        NOT NULL,
	exclude            tinyint(3)          DEFAULT '0' NOT NULL,
	force_linking      int(11)             DEFAULT '0' NOT NULL,
	force_case         int(11)             DEFAULT '0' NOT NULL,
	force_preservecase int(11)             DEFAULT '0' NOT NULL,
	force_regexp       int(11)             DEFAULT '0' NOT NULL,
	force_global       int(11)             DEFAULT '0' NOT NULL,

	PRIMARY KEY (uid),
	KEY parent (pid)
);