CREATE TABLE `tf_relation` ( `relation_id` int(11) NOT NULL AUTO_INCREMENT, `table_name` varchar(23) DEFAULT NULL, `display_column_name` char(1) DEFAULT NULL, `column_name` varchar(27) DEFAULT NULL, `f_table_name` varchar(27) DEFAULT NULL, `f_column_name` varchar(27) DEFAULT NULL, `relation_type_id` int(11) DEFAULT NULL, PRIMARY KEY (`relation_id`) ) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci CHECKSUM=1; INSERT INTO gus_demo.tf_relation(`relation_id`,`table_name`,`display_column_name`,`column_name`,`f_table_name`,`f_column_name`,`relation_type_id`) VALUES('1','tf_relation','','relation_type_id','tf_relation_type','relation_type_id','0'); INSERT INTO gus_demo.tf_relation(`relation_id`,`table_name`,`display_column_name`,`column_name`,`f_table_name`,`f_column_name`,`relation_type_id`) VALUES('2','tf_column_info','','validation_type_id','tf_validation_type','validation_type_id','0'); INSERT INTO gus_demo.tf_relation(`relation_id`,`table_name`,`display_column_name`,`column_name`,`f_table_name`,`f_column_name`,`relation_type_id`) VALUES('3','tf_column_info','','validation_pattern_id','tf_validation_pattern','validation_pattern_id','0'); INSERT INTO gus_demo.tf_relation(`relation_id`,`table_name`,`display_column_name`,`column_name`,`f_table_name`,`f_column_name`,`relation_type_id`) VALUES('4','tf_column_info','','browsetype_id','tf_browsetype','browsetype_id','0'); INSERT INTO gus_demo.tf_relation(`relation_id`,`table_name`,`display_column_name`,`column_name`,`f_table_name`,`f_column_name`,`relation_type_id`) VALUES('5','enemyship_map','','hater_id','critter','critter_id','0'); INSERT INTO gus_demo.tf_relation(`relation_id`,`table_name`,`display_column_name`,`column_name`,`f_table_name`,`f_column_name`,`relation_type_id`) VALUES('6','enemyship_map','','hatee_id','critter','critter_id','0'); INSERT INTO gus_demo.tf_relation(`relation_id`,`table_name`,`display_column_name`,`column_name`,`f_table_name`,`f_column_name`,`relation_type_id`) VALUES('7','friendship_map','','befriender_id','critter','critter_id','0'); INSERT INTO gus_demo.tf_relation(`relation_id`,`table_name`,`display_column_name`,`column_name`,`f_table_name`,`f_column_name`,`relation_type_id`) VALUES('8','friendship_map','','befriendee_id','critter','critter_id','0'); INSERT INTO gus_demo.tf_relation(`relation_id`,`table_name`,`display_column_name`,`column_name`,`f_table_name`,`f_column_name`,`relation_type_id`) VALUES('9','tf_dbdiff_table','','dbdiff_id','tf_dbdiff','dbdiff_id','0'); INSERT INTO gus_demo.tf_relation(`relation_id`,`table_name`,`display_column_name`,`column_name`,`f_table_name`,`f_column_name`,`relation_type_id`) VALUES('10','critter','','lifeform_id','lifeform','lifeform_id','0'); INSERT INTO gus_demo.tf_relation(`relation_id`,`table_name`,`display_column_name`,`column_name`,`f_table_name`,`f_column_name`,`relation_type_id`) VALUES('11','tf_dbmap_table','','dbmap_id','tf_dbmap','dbmap_id','0'); INSERT INTO gus_demo.tf_relation(`relation_id`,`table_name`,`display_column_name`,`column_name`,`f_table_name`,`f_column_name`,`relation_type_id`) VALUES('12','tf_concordance_hit','','concordance_id','tf_concordance','concordance_id','0');