ext_tables.sql

#
# Extend table 'sys_file'
#
CREATE TABLE sys_file (
	tx_qbank_id int(11) unsigned DEFAULT 0 NOT NULL,
	tx_qbank_file_timestamp int(11) unsigned DEFAULT 0 NOT NULL,
	tx_qbank_metadata_timestamp int(11) unsigned DEFAULT 0 NOT NULL,
	tx_qbank_remote_change tinyint(3) unsigned DEFAULT 0 NOT NULL,
	tx_qbank_status_updated_timestamp int(11) unsigned DEFAULT 0 NOT NULL,
	tx_qbank_remote_change_timestamp int(11) unsigned DEFAULT 0 NOT NULL,
	tx_qbank_remote_replaced_by int(11) unsigned DEFAULT 0 NOT NULL,
	tx_qbank_remote_is_replaced tinyint(3) unsigned DEFAULT 0 NOT NULL,
	tx_qbank_remote_is_deleted tinyint(3) unsigned DEFAULT 0 NOT NULL,

	KEY qbank (tx_qbank_id),
);

#
# Table structure for table 'tx_qbank_domain_model_mapping'
#
CREATE TABLE tx_qbank_domain_model_mapping (
	source_property varchar(255) DEFAULT '' NOT NULL,
	target_property varchar(255) DEFAULT '' NOT NULL,

	KEY index_property (source_property(80),target_property(80))
);