# MySQL-Front Dump 2.5 # # Host: localhost Database: pasistest # -------------------------------------------------------- # Server version 4.0.18-nt USE pasistest; # # Table structure for table 'tabstractconcreteaction' # CREATE TABLE tabstractconcreteaction ( FID bigint(20) NOT NULL default '0', FORDERINDEX int(11) default NULL, PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tabstractconcreteaction' # # # Table structure for table 'tabstractconventionalaction' # CREATE TABLE tabstractconventionalaction ( FID bigint(20) NOT NULL default '0', PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tabstractconventionalaction' # # # Table structure for table 'tabstractlocation' # CREATE TABLE tabstractlocation ( FID bigint(20) NOT NULL default '0', FTLOCATION_FID bigint(20) default NULL, PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tabstractlocation' # # # Table structure for table 'taction' # CREATE TABLE taction ( FID bigint(20) NOT NULL default '0', FORDERINDEX int(11) default NULL, FTVEHICLETYPELIST_FID bigint(20) default NULL, FTFILTER_FID bigint(20) default NULL, FTVALIDCYCLELIST_FID bigint(20) default NULL, FTSELECTOR_FID bigint(20) default NULL, FTCOURSE_FID bigint(20) default NULL, FTACTIONTYPE_FID bigint(20) default NULL, FTLANGUAGE_FID bigint(20) default NULL, FTABSTRACTCONCRETEACTION_FID bigint(20) default NULL, FTLABELEDENTITY_FID bigint(20) default NULL, FTEVENT_FID bigint(20) default NULL, FTGLOBALSETTINGS_SHUTDOWN_FID bigint(20) default NULL, FTGLOBALSETTINGS_BOOT_FID bigint(20) default NULL, PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'taction' # INSERT INTO taction (FID, FORDERINDEX, FTVEHICLETYPELIST_FID, FTFILTER_FID, FTVALIDCYCLELIST_FID, FTSELECTOR_FID, FTCOURSE_FID, FTACTIONTYPE_FID, FTLANGUAGE_FID, FTABSTRACTCONCRETEACTION_FID, FTLABELEDENTITY_FID, FTEVENT_FID, FTGLOBALSETTINGS_SHUTDOWN_FID, FTGLOBALSETTINGS_BOOT_FID) VALUES("119", "2", NULL, NULL, NULL, NULL, NULL, NULL, "111", NULL, "111", NULL, NULL, NULL); INSERT INTO taction (FID, FORDERINDEX, FTVEHICLETYPELIST_FID, FTFILTER_FID, FTVALIDCYCLELIST_FID, FTSELECTOR_FID, FTCOURSE_FID, FTACTIONTYPE_FID, FTLANGUAGE_FID, FTABSTRACTCONCRETEACTION_FID, FTLABELEDENTITY_FID, FTEVENT_FID, FTGLOBALSETTINGS_SHUTDOWN_FID, FTGLOBALSETTINGS_BOOT_FID) VALUES("115", "1", NULL, NULL, NULL, NULL, NULL, NULL, "104", NULL, "104", NULL, NULL, NULL); INSERT INTO taction (FID, FORDERINDEX, FTVEHICLETYPELIST_FID, FTFILTER_FID, FTVALIDCYCLELIST_FID, FTSELECTOR_FID, FTCOURSE_FID, FTACTIONTYPE_FID, FTLANGUAGE_FID, FTABSTRACTCONCRETEACTION_FID, FTLABELEDENTITY_FID, FTEVENT_FID, FTGLOBALSETTINGS_SHUTDOWN_FID, FTGLOBALSETTINGS_BOOT_FID) VALUES("108", "0", NULL, NULL, NULL, NULL, NULL, NULL, "107", NULL, "107", NULL, NULL, NULL); # # Table structure for table 'tactiontype' # CREATE TABLE tactiontype ( FID bigint(20) NOT NULL default '0', FFLAGSTATIC tinyint(4) default NULL, PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tactiontype' # INSERT INTO tactiontype (FID, FFLAGSTATIC) VALUES("197", "1"); INSERT INTO tactiontype (FID, FFLAGSTATIC) VALUES("102", "1"); # # Table structure for table 'tactiontype_subtypetoindependenteventgroup' # CREATE TABLE tactiontype_subtypetoindependenteventgroup ( FID bigint(20) NOT NULL default '0', FSUBTYPE int(11) default NULL, FFLAGCOMPULSORY tinyint(4) default NULL, FTACTIONTYPE_FID bigint(20) default NULL, FTINDEPENDENTEVENTGROUP_FID bigint(20) default NULL, PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tactiontype_subtypetoindependenteventgroup' # INSERT INTO tactiontype_subtypetoindependenteventgroup (FID, FSUBTYPE, FFLAGCOMPULSORY, FTACTIONTYPE_FID, FTINDEPENDENTEVENTGROUP_FID) VALUES("214", "2", "1", "197", "219"); INSERT INTO tactiontype_subtypetoindependenteventgroup (FID, FSUBTYPE, FFLAGCOMPULSORY, FTACTIONTYPE_FID, FTINDEPENDENTEVENTGROUP_FID) VALUES("101", "1", "1", "102", "205"); # # Table structure for table 'tattributedistance' # CREATE TABLE tattributedistance ( FID bigint(20) NOT NULL default '0', FVALUE int(11) default NULL, FFLAGFROMSTATION tinyint(4) default NULL, PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tattributedistance' # # # Table structure for table 'tattributedoor' # CREATE TABLE tattributedoor ( FID bigint(20) NOT NULL default '0', FFLAGOPEN tinyint(4) default NULL, PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tattributedoor' # # # Table structure for table 'tattributenode' # CREATE TABLE tattributenode ( FID bigint(20) NOT NULL default '0', FTNODE_FID bigint(20) default NULL, PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tattributenode' # # # Table structure for table 'tattributespeed' # CREATE TABLE tattributespeed ( FID bigint(20) NOT NULL default '0', FVALUE int(11) default NULL, FFLAGFASTER tinyint(4) default NULL, PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tattributespeed' # # # Table structure for table 'tattributetimereferevent' # CREATE TABLE tattributetimereferevent ( FID bigint(20) NOT NULL default '0', FDURATION time default NULL, PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tattributetimereferevent' # # # Table structure for table 'tattributetimereferstation' # CREATE TABLE tattributetimereferstation ( FID bigint(20) NOT NULL default '0', FFLAGNOTBEFORE tinyint(4) default NULL, FDURATION time default NULL, PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tattributetimereferstation' # # # Table structure for table 'tcirculation' # CREATE TABLE tcirculation ( FID bigint(20) NOT NULL default '0', FTTIMETABLEPERIOD_FID bigint(20) default NULL, FORDERINDEX int(11) default NULL, FFLAGLOOP tinyint(4) default NULL, FFLAGVIRTUAL tinyint(4) default NULL, FTVALIDCYCLELIST_FID bigint(20) default NULL, PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tcirculation' # # # Table structure for table 'tcourse' # CREATE TABLE tcourse ( FID bigint(20) NOT NULL default '0', FTLINE_FID bigint(20) default NULL, FORDERINDEX int(11) default NULL, FTVALIDCYCLELIST_FID bigint(20) default NULL, FTCOURSECIRCULATION_FID bigint(20) default NULL, FTCIRCULATION_FID bigint(20) default NULL, PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tcourse' # # # Table structure for table 'tcoursecirculation' # CREATE TABLE tcoursecirculation ( FID bigint(20) NOT NULL default '0', PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tcoursecirculation' # INSERT INTO tcoursecirculation (FID) VALUES("211"); INSERT INTO tcoursecirculation (FID) VALUES("213"); # # Table structure for table 'tdescriptable' # CREATE TABLE tdescriptable ( FID bigint(20) NOT NULL default '0', FSHORTDESCRIPTOR varchar(255) default NULL ) TYPE=MyISAM; # # Dumping data for table 'tdescriptable' # INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("190", "eventtypelevel2 [EN]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("171", "Line Section Type 1"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("123", "VehicleTypeList 1 [DE]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("213", "Umlauf 1"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("113", "Französisch"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("159", "Line Section Event 2"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("118", "Francais"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("124", "VehicleTypeList 1 [EN]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("169", "Section 1"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("160", "LineSection Event 2 [FR]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("201", "Announcement Group [EN]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("117", "Allemagne"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("189", "Default LineSectionEventGroup [DE]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("157", "Line 1 [EN]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("122", "Vehicle Type List"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("146", "Hidden Event 1 [FR]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("203", "announcementEvent 1"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("145", "Default HiddenEventGroup [EN]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("194", "Umlauf 2 [FR]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("140", "Valid Cycle List short descriptor"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("172", "LineSection Type 1 [EN]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("181", "Line 1 [DE]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("191", "Default LineSectionEventGroup [FR]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("166", "LineSection Event 2 [EN]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("212", "Umlauf 2 [EN]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("192", "Actiontype 2 [DE]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("121", "Default HiddenEventGroup [DE]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("120", "Deutsch"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("200", "Display Event 1 [FR]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("163", "Line Section Type 2"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("136", "Display Group [EN]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("126", "Vehicletype 1 [EN]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("168", "eventtypelevel2 [DE]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("199", "Actiontype 2 [EN]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("150", "validcyclelist 1 [EN]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("149", "Hidden Event 1 [EN]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("161", "Default LineSectionEventGroup"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("105", "German"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("193", "Announcement Event 1 [FR]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("206", "Announcement Group [DE]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("132", "Vehicletype 2 [EN]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("116", "Actiontype 1 [FR]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("125", "Vehicletype 1"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("196", "Umlauf 1 [EN]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("195", "Announcement Event 1 [EN]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("114", "Englisch"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("154", "Section 1 [FR]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("127", "Vehicletype 1 [FR]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("204", "Announcement Event 1 [DE]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("128", "Vehicletype 1 [DE]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("197", "ActionType 2"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("164", "event Type Level 2"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("153", "eventtypelevel1 [DE]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("202", "Announcement Group [FR]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("107", "Englisch"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("207", "Display Event 1 [DE]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("143", "eventtypelevel1 [EN]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("112", "French"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("198", "Actiontype 2 [FR]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("208", "Umlauf 1 [FR]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("187", "LineSection Event 1 [EN]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("144", "validcyclelist 1 [FR]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("176", "Section 1 [DE]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("129", "Vehicletype 2"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("188", "LineSection Event 1 [FR]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("106", "Actiontype 1 [EN]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("142", "Default HiddenEventGroup [FR]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("131", "Vehicletype 2 [FR]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("210", "Hidden Event 2 [EN]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("186", "LineSection Event 1 [DE]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("175", "Default LineSectionEventGroup [EN]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("209", "Hidden Event 2 [FR]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("162", "Section 2"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("130", "Vehicletype 2 [DE]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("103", "Actiontype 1 [DE]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("155", "LineSection Type 2 [FR]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("205", "Announcement Action"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("141", "validcyclelist 1 [DE]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("156", "Line 1"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("165", "eventtypelevel2 [FR]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("102", "ActionType 1"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("185", "Line Section Event 1"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("215", "Display Group [FR]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("151", "Hidden Event 1 [DE]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("104", "Deutsch"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("177", "Section 2 [EN]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("182", "LineSection Type 1 [DE]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("135", "Umlauf 1 [DE]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("180", "LineSection Type 2 [DE]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("134", "Umlauf 2 [DE]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("137", "Hidden Event 1"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("221", "Hidden Event 2"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("216", "Hidden Event 2 [DE]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("211", "Umlauf 2"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("179", "LineSection Type 2 [EN]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("170", "Section 1 [EN]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("111", "Franzoesisch"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("178", "Section 2 [DE]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("183", "Line 1 [FR]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("139", "Default HiddenEventGroup"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("218", "displayEvent 1"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("219", "Display Action"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("148", "eventtypelevel1 [FR]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("173", "LineSection Type 1 [FR]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("109", "English"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("220", "Display Group [DE]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("133", "VehicleTypeList 1 [FR]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("110", "Anglais"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("184", "Section 2 [FR]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("174", "LineSection Event 2 [DE]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("217", "Display Event 1 [EN]"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("138", "event Type Level 1"); INSERT INTO tdescriptable (FID, FSHORTDESCRIPTOR) VALUES("231", ""); # # Table structure for table 'tedge' # CREATE TABLE tedge ( FID bigint(20) NOT NULL default '0', FTSECTION_FID bigint(20) default NULL, FDISTANCE int(11) default NULL, FTOTNODE_FID bigint(20) default NULL, FFROMTNODE_FID bigint(20) default NULL, PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tedge' # # # Table structure for table 'tevent' # CREATE TABLE tevent ( FID bigint(20) NOT NULL default '0', FTVALIDCYCLELIST_FID bigint(20) default NULL, FTEVENTGROUP_FID bigint(20) default NULL, FTEVENTTYPELEVEL_FID bigint(20) default NULL, PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tevent' # INSERT INTO tevent (FID, FTVALIDCYCLELIST_FID, FTEVENTGROUP_FID, FTEVENTTYPELEVEL_FID) VALUES("159", "140", "161", "164"); INSERT INTO tevent (FID, FTVALIDCYCLELIST_FID, FTEVENTGROUP_FID, FTEVENTTYPELEVEL_FID) VALUES("203", "140", "205", "138"); INSERT INTO tevent (FID, FTVALIDCYCLELIST_FID, FTEVENTGROUP_FID, FTEVENTTYPELEVEL_FID) VALUES("185", "140", "161", "138"); INSERT INTO tevent (FID, FTVALIDCYCLELIST_FID, FTEVENTGROUP_FID, FTEVENTTYPELEVEL_FID) VALUES("137", "140", "139", "138"); INSERT INTO tevent (FID, FTVALIDCYCLELIST_FID, FTEVENTGROUP_FID, FTEVENTTYPELEVEL_FID) VALUES("221", "140", "139", "164"); INSERT INTO tevent (FID, FTVALIDCYCLELIST_FID, FTEVENTGROUP_FID, FTEVENTTYPELEVEL_FID) VALUES("218", "140", "219", "164"); # # Table structure for table 'teventgroup' # CREATE TABLE teventgroup ( FID bigint(20) NOT NULL default '0', FTVALIDCYCLELIST_FID bigint(20) default NULL, FTEVENTTYPELEVEL_FID bigint(20) default NULL, PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'teventgroup' # INSERT INTO teventgroup (FID, FTVALIDCYCLELIST_FID, FTEVENTTYPELEVEL_FID) VALUES("161", "140", "138"); INSERT INTO teventgroup (FID, FTVALIDCYCLELIST_FID, FTEVENTTYPELEVEL_FID) VALUES("205", "140", "138"); INSERT INTO teventgroup (FID, FTVALIDCYCLELIST_FID, FTEVENTTYPELEVEL_FID) VALUES("139", "140", "138"); INSERT INTO teventgroup (FID, FTVALIDCYCLELIST_FID, FTEVENTTYPELEVEL_FID) VALUES("219", "140", "164"); # # Table structure for table 'teventtrigger' # CREATE TABLE teventtrigger ( FID bigint(20) NOT NULL default '0', FTRIGGERLEVEL int(11) default NULL, FTTRIGGERTYPE_FID bigint(20) default NULL, FTTRIGGERATTRIBUTE_FID bigint(20) default NULL, FTEVENTTRIGGERGROUP_FID bigint(20) default NULL, PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'teventtrigger' # # # Table structure for table 'teventtriggergroup' # CREATE TABLE teventtriggergroup ( FID bigint(20) NOT NULL default '0', PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'teventtriggergroup' # # # Table structure for table 'teventtypelevel' # CREATE TABLE teventtypelevel ( FID bigint(20) NOT NULL default '0', FEVENTTYPELEVEL int(11) default NULL, PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'teventtypelevel' # INSERT INTO teventtypelevel (FID, FEVENTTYPELEVEL) VALUES("164", "2"); INSERT INTO teventtypelevel (FID, FEVENTTYPELEVEL) VALUES("138", "1"); # # Table structure for table 'tfilter' # CREATE TABLE tfilter ( FID bigint(20) NOT NULL default '0', FORDERINDEX int(11) default NULL, PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tfilter' # # # Table structure for table 'tglobalsettings' # CREATE TABLE tglobalsettings ( FID bigint(20) NOT NULL default '0', FSTRUCTUREVERSION varchar(255) default NULL, FDATAVERSION varchar(255) default NULL, FGLOBALVALIDCYCLEOFFSET time default NULL, FDATACHKSUM int(11) default NULL, FFAHELNUMBER varchar(255) default NULL, PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tglobalsettings' # # # Table structure for table 'thiddenevent' # CREATE TABLE thiddenevent ( FID bigint(20) NOT NULL default '0', FTVEHICLETYPELIST_FID bigint(20) default NULL, PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'thiddenevent' # INSERT INTO thiddenevent (FID, FTVEHICLETYPELIST_FID) VALUES("137", "122"); INSERT INTO thiddenevent (FID, FTVEHICLETYPELIST_FID) VALUES("221", "122"); # # Table structure for table 'thiddeneventgroup' # CREATE TABLE thiddeneventgroup ( FID bigint(20) NOT NULL default '0', PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'thiddeneventgroup' # INSERT INTO thiddeneventgroup (FID) VALUES("139"); # # Table structure for table 'tindependentevent' # CREATE TABLE tindependentevent ( FID bigint(20) NOT NULL default '0', FORDERINDEX int(11) default NULL, PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tindependentevent' # INSERT INTO tindependentevent (FID, FORDERINDEX) VALUES("203", "1"); INSERT INTO tindependentevent (FID, FORDERINDEX) VALUES("218", "1"); # # Table structure for table 'tindependenteventgroup' # CREATE TABLE tindependenteventgroup ( FID bigint(20) NOT NULL default '0', FORDERINDEX int(11) default NULL, PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tindependenteventgroup' # INSERT INTO tindependenteventgroup (FID, FORDERINDEX) VALUES("205", "1"); INSERT INTO tindependenteventgroup (FID, FORDERINDEX) VALUES("219", "2"); # # Table structure for table 'tlabeledentity' # CREATE TABLE tlabeledentity ( FID bigint(20) NOT NULL default '0', PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tlabeledentity' # INSERT INTO tlabeledentity (FID) VALUES("102"); INSERT INTO tlabeledentity (FID) VALUES("104"); INSERT INTO tlabeledentity (FID) VALUES("107"); INSERT INTO tlabeledentity (FID) VALUES("111"); INSERT INTO tlabeledentity (FID) VALUES("122"); INSERT INTO tlabeledentity (FID) VALUES("125"); INSERT INTO tlabeledentity (FID) VALUES("129"); INSERT INTO tlabeledentity (FID) VALUES("137"); INSERT INTO tlabeledentity (FID) VALUES("138"); INSERT INTO tlabeledentity (FID) VALUES("139"); INSERT INTO tlabeledentity (FID) VALUES("140"); INSERT INTO tlabeledentity (FID) VALUES("156"); INSERT INTO tlabeledentity (FID) VALUES("159"); INSERT INTO tlabeledentity (FID) VALUES("161"); INSERT INTO tlabeledentity (FID) VALUES("162"); INSERT INTO tlabeledentity (FID) VALUES("163"); INSERT INTO tlabeledentity (FID) VALUES("164"); INSERT INTO tlabeledentity (FID) VALUES("169"); INSERT INTO tlabeledentity (FID) VALUES("171"); INSERT INTO tlabeledentity (FID) VALUES("185"); INSERT INTO tlabeledentity (FID) VALUES("197"); INSERT INTO tlabeledentity (FID) VALUES("203"); INSERT INTO tlabeledentity (FID) VALUES("205"); INSERT INTO tlabeledentity (FID) VALUES("211"); INSERT INTO tlabeledentity (FID) VALUES("213"); INSERT INTO tlabeledentity (FID) VALUES("218"); INSERT INTO tlabeledentity (FID) VALUES("219"); INSERT INTO tlabeledentity (FID) VALUES("221"); # # Table structure for table 'tlanguage' # CREATE TABLE tlanguage ( FID bigint(20) NOT NULL default '0', PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tlanguage' # INSERT INTO tlanguage (FID) VALUES("104"); INSERT INTO tlanguage (FID) VALUES("107"); INSERT INTO tlanguage (FID) VALUES("111"); # # Table structure for table 'tline' # CREATE TABLE tline ( FID bigint(20) NOT NULL default '0', FFLAGVIRTUAL tinyint(4) default NULL, PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tline' # INSERT INTO tline (FID, FFLAGVIRTUAL) VALUES("156", "1"); # # Table structure for table 'tlinesection' # CREATE TABLE tlinesection ( FID bigint(20) NOT NULL default '0', FTLINE_FID bigint(20) default NULL, FORDERINDEX int(11) default NULL, FTSECTION_FID bigint(20) default NULL, FTLINESECTIONTYPE_FID bigint(20) default NULL, PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tlinesection' # INSERT INTO tlinesection (FID, FTLINE_FID, FORDERINDEX, FTSECTION_FID, FTLINESECTIONTYPE_FID) VALUES("158", "156", "2", "162", "163"); INSERT INTO tlinesection (FID, FTLINE_FID, FORDERINDEX, FTSECTION_FID, FTLINESECTIONTYPE_FID) VALUES("167", "156", "1", "169", "171"); # # Table structure for table 'tlinesectionevent' # CREATE TABLE tlinesectionevent ( FID bigint(20) NOT NULL default '0', FTLINESECTION_FID bigint(20) default NULL, FFLAGBEFOREEXIT tinyint(4) default NULL, FFLAGMANUALMODE tinyint(4) default NULL, FFLAGAFTERENTRY tinyint(4) default NULL, FFLAGAUTOMATICMODE tinyint(4) default NULL, FORDERINDEX int(11) default NULL, FTEVENTTRIGGER_FID bigint(20) default NULL, PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tlinesectionevent' # INSERT INTO tlinesectionevent (FID, FTLINESECTION_FID, FFLAGBEFOREEXIT, FFLAGMANUALMODE, FFLAGAFTERENTRY, FFLAGAUTOMATICMODE, FORDERINDEX, FTEVENTTRIGGER_FID) VALUES("159", "158", "1", "0", "1", "0", "2", NULL); INSERT INTO tlinesectionevent (FID, FTLINESECTION_FID, FFLAGBEFOREEXIT, FFLAGMANUALMODE, FFLAGAFTERENTRY, FFLAGAUTOMATICMODE, FORDERINDEX, FTEVENTTRIGGER_FID) VALUES("185", "167", "1", "0", "1", "0", "1", NULL); # # Table structure for table 'tlinesectioneventgroup' # CREATE TABLE tlinesectioneventgroup ( FID bigint(20) NOT NULL default '0', PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tlinesectioneventgroup' # INSERT INTO tlinesectioneventgroup (FID) VALUES("161"); # # Table structure for table 'tlinesectiontype' # CREATE TABLE tlinesectiontype ( FID bigint(20) NOT NULL default '0', PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tlinesectiontype' # INSERT INTO tlinesectiontype (FID) VALUES("163"); INSERT INTO tlinesectiontype (FID) VALUES("171"); # # Table structure for table 'tlocation' # CREATE TABLE tlocation ( FID bigint(20) NOT NULL default '0', FLONGITUDE float(10,4) default NULL, FCIRCUMFERENCERADIUS float(10,4) default NULL, FCIRCUMFERENCECENTRELATITUDE float(10,4) default NULL, FLATITUDE float(10,4) default NULL, FCIRCUMFERENCECENTRELONGITUDE float(10,4) default NULL, FALTITUDE float(10,4) default NULL, FTLOCATIONTYPE_FID bigint(20) default NULL, PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tlocation' # # # Table structure for table 'tlocationcircle' # CREATE TABLE tlocationcircle ( FID bigint(20) NOT NULL default '0', FRADIUS float(10,4) default NULL, FLONGITUDE float(10,4) default NULL, FLATITUDE float(10,4) default NULL, PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tlocationcircle' # # # Table structure for table 'tlocationtriangle' # CREATE TABLE tlocationtriangle ( FID bigint(20) NOT NULL default '0', FLATITUDE1 float(10,4) default NULL, FLONGITUDE3 float(10,4) default NULL, FLATITUDE2 float(10,4) default NULL, FLONGITUDE1 float(10,4) default NULL, FLATITUDE3 float(10,4) default NULL, FLONGITUDE2 float(10,4) default NULL, PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tlocationtriangle' # # # Table structure for table 'tlocationtype' # CREATE TABLE tlocationtype ( FID bigint(20) NOT NULL default '0', PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tlocationtype' # # # Table structure for table 'tlocationworm' # CREATE TABLE tlocationworm ( FID bigint(20) NOT NULL default '0', FRADIUS float(10,4) default NULL, FLONGITUDE float(10,4) default NULL, FORDERINDEX int(11) default NULL, FLATITUDE float(10,4) default NULL, PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tlocationworm' # # # Table structure for table 'tnamestring' # CREATE TABLE tnamestring ( FID bigint(20) NOT NULL default '0', FTLABELEDENTITY_FID bigint(20) default NULL, FTLANGUAGE_FID bigint(20) default NULL, PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tnamestring' # INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("190", "164", "107"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("123", "122", "104"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("113", "111", "104"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("118", "111", "111"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("124", "122", "107"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("160", "159", "111"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("201", "205", "107"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("117", "104", "111"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("189", "161", "104"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("157", "156", "107"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("146", "137", "111"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("145", "139", "107"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("194", "211", "111"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("172", "171", "107"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("181", "156", "104"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("191", "161", "111"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("166", "159", "107"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("212", "211", "107"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("192", "197", "104"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("121", "139", "104"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("120", "104", "104"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("200", "218", "111"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("136", "219", "107"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("126", "125", "107"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("168", "164", "104"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("199", "197", "107"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("150", "140", "107"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("149", "137", "107"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("105", "104", "107"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("193", "203", "111"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("206", "205", "104"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("132", "129", "107"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("116", "102", "111"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("196", "213", "107"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("195", "203", "107"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("114", "107", "104"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("154", "169", "111"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("127", "125", "111"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("204", "203", "104"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("128", "125", "104"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("153", "138", "104"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("202", "205", "111"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("207", "218", "104"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("143", "138", "107"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("112", "111", "107"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("198", "197", "111"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("208", "213", "111"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("187", "185", "107"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("144", "140", "111"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("176", "169", "104"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("188", "185", "111"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("106", "102", "107"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("142", "139", "111"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("131", "129", "111"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("210", "221", "107"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("186", "185", "104"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("175", "161", "107"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("209", "221", "111"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("130", "129", "104"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("103", "102", "104"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("155", "163", "111"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("141", "140", "104"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("165", "164", "111"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("215", "219", "111"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("151", "137", "104"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("177", "162", "107"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("182", "171", "104"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("135", "213", "104"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("180", "163", "104"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("134", "211", "104"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("216", "221", "104"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("179", "163", "107"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("170", "169", "107"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("178", "162", "104"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("183", "156", "111"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("148", "138", "111"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("173", "171", "111"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("109", "107", "107"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("220", "219", "104"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("133", "122", "111"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("110", "107", "111"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("184", "162", "111"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("174", "159", "104"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("217", "218", "107"); INSERT INTO tnamestring (FID, FTLABELEDENTITY_FID, FTLANGUAGE_FID) VALUES("231", NULL, "104"); # # Table structure for table 'tnode' # CREATE TABLE tnode ( FID bigint(20) NOT NULL default '0', FTSTATION_FID bigint(20) default NULL, PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tnode' # # # Table structure for table 'toutputtype' # CREATE TABLE toutputtype ( FID bigint(20) NOT NULL default '0', FREMOVEEMPTYELEMENTS tinyint(4) default NULL, FTOUTPUTTYPELIST_FID bigint(20) default NULL, PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'toutputtype' # # # Table structure for table 'toutputtypelist' # CREATE TABLE toutputtypelist ( FID bigint(20) NOT NULL default '0', PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'toutputtypelist' # # # Table structure for table 'tpasisentity' # CREATE TABLE tpasisentity ( FID bigint(20) NOT NULL default '0', IBOXTYPE varchar(255) default NULL, FTCN bigint(20) default NULL, FUSERNAME varchar(255) default NULL, FPROCESSINGDATE timestamp(14) NOT NULL, FTOUTPUTTYPELIST_FID bigint(20) default NULL, PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tpasisentity' # INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("190", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("214", "ch.ascomfahel.pasissuite.common.dto.domain.ActionType_SubTypeToIndependentEventGroup", "4", "Creator", "20040216115628", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("158", "ch.ascomfahel.pasissuite.common.dto.domain.LineSection", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("171", "ch.ascomfahel.pasissuite.common.dto.domain.LineSectionType", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("123", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("213", "ch.ascomfahel.pasissuite.common.dto.domain.CourseCirculation", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("113", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("159", "ch.ascomfahel.pasissuite.common.dto.domain.LineSectionEvent", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("118", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("124", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("169", "ch.ascomfahel.pasissuite.common.dto.domain.Section", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("160", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("201", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("117", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("189", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("157", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("122", "ch.ascomfahel.pasissuite.common.dto.domain.VehicleTypeList", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("146", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("119", "ch.ascomfahel.pasissuite.common.dto.domain.Action", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("203", "ch.ascomfahel.pasissuite.common.dto.domain.IndependentEvent", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("145", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("194", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("140", "ch.ascomfahel.pasissuite.common.dto.domain.ValidCycleList", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("172", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("181", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("191", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("166", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("212", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("192", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("121", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("120", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("200", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("163", "ch.ascomfahel.pasissuite.common.dto.domain.LineSectionType", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("136", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "4", "Creator", "20040216115628", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("126", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("168", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("199", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("150", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("149", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("161", "ch.ascomfahel.pasissuite.common.dto.domain.LineSectionEventGroup", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("105", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("193", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("206", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("132", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("116", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("125", "ch.ascomfahel.pasissuite.common.dto.domain.VehicleType", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("196", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("115", "ch.ascomfahel.pasissuite.common.dto.domain.Action", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("195", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("114", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("154", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("127", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("167", "ch.ascomfahel.pasissuite.common.dto.domain.LineSection", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("108", "ch.ascomfahel.pasissuite.common.dto.domain.Action", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("204", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("128", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("197", "ch.ascomfahel.pasissuite.common.dto.domain.ActionType", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("164", "ch.ascomfahel.pasissuite.common.dto.domain.EventTypeLevel", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("153", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("202", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("107", "ch.ascomfahel.pasissuite.common.dto.domain.Language", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("207", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("143", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("112", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("198", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("208", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("187", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("144", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("176", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("129", "ch.ascomfahel.pasissuite.common.dto.domain.VehicleType", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("188", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("106", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("142", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("131", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("210", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("186", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("175", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("209", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("162", "ch.ascomfahel.pasissuite.common.dto.domain.Section", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("130", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("103", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("155", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("205", "ch.ascomfahel.pasissuite.common.dto.domain.IndependentEventGroup", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("141", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("156", "ch.ascomfahel.pasissuite.common.dto.domain.Line", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("165", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("102", "ch.ascomfahel.pasissuite.common.dto.domain.ActionType", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("185", "ch.ascomfahel.pasissuite.common.dto.domain.LineSectionEvent", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("101", "ch.ascomfahel.pasissuite.common.dto.domain.ActionType_SubTypeToIndependentEventGroup", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("215", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "4", "Creator", "20040216115628", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("151", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("104", "ch.ascomfahel.pasissuite.common.dto.domain.Language", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("177", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("182", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("135", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("180", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("134", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("137", "ch.ascomfahel.pasissuite.common.dto.domain.HiddenEvent", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("221", "ch.ascomfahel.pasissuite.common.dto.domain.HiddenEvent", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("147", "ch.ascomfahel.pasissuite.common.dto.domain.ValidCycle", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("216", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("211", "ch.ascomfahel.pasissuite.common.dto.domain.CourseCirculation", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("179", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("152", "ch.ascomfahel.pasissuite.common.dto.domain.ValidCycle", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("170", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("111", "ch.ascomfahel.pasissuite.common.dto.domain.Language", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("178", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("183", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("139", "ch.ascomfahel.pasissuite.common.dto.domain.HiddenEventGroup", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("218", "ch.ascomfahel.pasissuite.common.dto.domain.IndependentEvent", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("219", "ch.ascomfahel.pasissuite.common.dto.domain.IndependentEventGroup", "4", "", "20040216115627", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("148", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("173", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("109", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("220", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "4", "", "20040216115628", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("133", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("110", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("184", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("174", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("217", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("138", "ch.ascomfahel.pasissuite.common.dto.domain.EventTypeLevel", "0", "Creator", "20040216114621", NULL); INSERT INTO tpasisentity (FID, IBOXTYPE, FTCN, FUSERNAME, FPROCESSINGDATE, FTOUTPUTTYPELIST_FID) VALUES("231", "ch.ascomfahel.pasissuite.common.dto.domain.NameString", "0", "", "20040216115354", NULL); # # Table structure for table 'tsection' # CREATE TABLE tsection ( FID bigint(20) NOT NULL default '0', FDISTANCE int(11) default NULL, FTOTSTATION_FID bigint(20) default NULL, FFROMTSTATION_FID bigint(20) default NULL, PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tsection' # INSERT INTO tsection (FID, FDISTANCE, FTOTSTATION_FID, FFROMTSTATION_FID) VALUES("169", "100", NULL, NULL); INSERT INTO tsection (FID, FDISTANCE, FTOTSTATION_FID, FFROMTSTATION_FID) VALUES("162", "100", NULL, NULL); # # Table structure for table 'tselector' # CREATE TABLE tselector ( FID bigint(20) NOT NULL default '0', PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tselector' # # # Table structure for table 'tsequence' # CREATE TABLE tsequence ( FNAME varchar(255) default NULL, FKEY bigint(20) default NULL ) TYPE=MyISAM; # # Dumping data for table 'tsequence' # INSERT INTO tsequence (FNAME, FKEY) VALUES("default", "240"); # # Table structure for table 'tspecialday' # CREATE TABLE tspecialday ( FID bigint(20) NOT NULL default '0', FVALUE int(11) default NULL, FDATE date default NULL, PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tspecialday' # # # Table structure for table 'tstation' # CREATE TABLE tstation ( FID bigint(20) NOT NULL default '0', FNEGATIVEDEVIATION int(11) default NULL, FPOSITIVEDEVIATION int(11) default NULL, PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tstation' # # # Table structure for table 'ttimetableperiod' # CREATE TABLE ttimetableperiod ( FID bigint(20) NOT NULL default '0', FTVALIDCYCLELIST_FID bigint(20) default NULL, PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'ttimetableperiod' # # # Table structure for table 'ttriggerattribute' # CREATE TABLE ttriggerattribute ( FID bigint(20) NOT NULL default '0', PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'ttriggerattribute' # # # Table structure for table 'ttriggertype' # CREATE TABLE ttriggertype ( FID bigint(20) NOT NULL default '0', FDEFAULTFLAGBEFOREEXIT tinyint(4) default NULL, FDEFAULTFLAGMANUALMODE tinyint(4) default NULL, FDEFAULTFLAGAFTERENTRY tinyint(4) default NULL, FDEFAULTTRIGGERLEVEL int(11) default NULL, FDEFAULTFLAGAUTOMATICMODE tinyint(4) default NULL, PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'ttriggertype' # # # Table structure for table 'tvalidcycle' # CREATE TABLE tvalidcycle ( FID bigint(20) NOT NULL default '0', FFROMTIME time default NULL, FUNTILDATE date default NULL, FUNTILTIME time default NULL, FFROMDATE date default NULL, FOFFSET time default NULL, FWEEKDAYS int(11) default NULL, FTVALIDCYCLELIST_FID bigint(20) default NULL, PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tvalidcycle' # INSERT INTO tvalidcycle (FID, FFROMTIME, FUNTILDATE, FUNTILTIME, FFROMDATE, FOFFSET, FWEEKDAYS, FTVALIDCYCLELIST_FID) VALUES("147", "01:00:00", "1970-01-06", "01:00:00", "1970-01-01", "01:00:00", "1", "140"); INSERT INTO tvalidcycle (FID, FFROMTIME, FUNTILDATE, FUNTILTIME, FFROMDATE, FOFFSET, FWEEKDAYS, FTVALIDCYCLELIST_FID) VALUES("152", "01:00:00", "1970-01-06", "01:00:00", "1970-01-01", "01:00:00", "2", "140"); # # Table structure for table 'tvalidcyclelist' # CREATE TABLE tvalidcyclelist ( FID bigint(20) NOT NULL default '0', PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tvalidcyclelist' # INSERT INTO tvalidcyclelist (FID) VALUES("140"); # # Table structure for table 'tvehicletype' # CREATE TABLE tvehicletype ( FID bigint(20) NOT NULL default '0', FTVEHICLETYPELIST_FID bigint(20) default NULL, PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tvehicletype' # INSERT INTO tvehicletype (FID, FTVEHICLETYPELIST_FID) VALUES("125", "122"); INSERT INTO tvehicletype (FID, FTVEHICLETYPELIST_FID) VALUES("129", "122"); # # Table structure for table 'tvehicletypelist' # CREATE TABLE tvehicletypelist ( FID bigint(20) NOT NULL default '0', PRIMARY KEY (FID) ) TYPE=MyISAM; # # Dumping data for table 'tvehicletypelist' # INSERT INTO tvehicletypelist (FID) VALUES("122");