111117 12:40:33 256 Connect spring@localhost on spring
256 Query SHOW VARIABLES
256 Query SHOW COLLATION
256 Query SET character_set_results=NULL
256 Init DB spring
256 Init DB spring
256 Query alter table stations_sta drop foreign key FK910C48B28ED437BA
256 Query alter table l_type_vendor_num_tvn drop foreign key TYP_ID
256 Query alter table l_type_vendor_num_tvn drop foreign key FK2CB54A34AD8C096E
256 Query alter table l_station_serials_numalloc_ssn drop foreign key FK4690B83476ADB8EB
256 Query alter table l_station_serials_numalloc_ssn drop foreign key FK4690B834E708C790
256 Query alter table l_ref_fix_tvn_rft drop foreign key FKDB11D44C6908A64B
111117 12:40:34 256 Query alter table l_ref_fix_tvn_rft drop foreign key FKDB11D44CF3F021C7
256 Query alter table l_ref_fix_tvn_rft drop foreign key FKDB11D44CCCA3CAB9
256 Query alter table l_ref_fix_tvn_rft drop foreign key FKDB11D44C881A653
256 Query alter table l_station_addresses_numalloc_san drop foreign key FKA303BE42E1BB8E6
256 Query alter table l_station_addresses_numalloc_san drop foreign key FKA303BE43F3EC791
111117 12:40:35 256 Query alter table l_factory_id_fid drop foreign key FKE7FDCF9E3BBD7704
256 Query alter table fb_serials_srl drop foreign key FKA4D16D1C259A33A
256 Query alter table fb_serials_srl drop foreign key FKA4D16D1CBEA9264A
256 Query alter table fb_serials_srl drop foreign key FKA4D16D1CCF70C041
256 Query alter table fb_serials_srl drop foreign key FKA4D16D1C725DFA6B
256 Query drop table if exists stations_sta
256 Query drop table if exists l_type_vendor_num_tvn
256 Query drop table if exists l_station_serials_numalloc_ssn
256 Query drop table if exists l_ref_fix_tvn_rft
256 Query drop table if exists fixtures_fix
111117 12:40:36 256 Query drop table if exists types_typ
256 Query drop table if exists vendors_ven
256 Query drop table if exists l_station_addresses_numalloc_san
256 Query drop table if exists factories_fac
256 Query drop table if exists l_factory_id_fid
256 Query drop table if exists fb_serials_srl
256 Query drop table if exists references_ref
256 Query create table stations_sta (STA_ID int(11) NOT NULL AUTO_INCREMENT, STA_NAME varchar(45) not null, STA_FAC int(11) not null, primary key (STA_ID))
256 Query create table l_type_vendor_num_tvn (TVN_ID int(11) NOT NULL AUTO_INCREMENT, TVN_TYP_ID int(11) not null, TVN_VEN_ID int(11) not null, TVN_VENDORID int(11), TVN_SIZE int(11) not null, TVN_DESC varchar(45), primary key (TVN_ID))
256 Query create table l_station_serials_numalloc_ssn (SSN_ID int(11) NOT NULL AUTO_INCREMENT, SSN_TVN_ID int(11) not null, SSN_STA_ID int(11) not null, SSN_NUMALLOC int(11) not null, primary key (SSN_ID))
256 Query create table l_ref_fix_tvn_rft (RFT_ID int(11) NOT NULL AUTO_INCREMENT, RFT_REF int(11) not null, RFT_FIX int(11) not null, RFT_TVN_ID int(11) not null, RFT_FID_ID int(11) not null, RFT_PRIORITY int(11), primary key (RFT_ID))
256 Query create table fixtures_fix (FIX_ID int(11) NOT NULL AUTO_INCREMENT, FIX_NAME varchar(45) not null, primary key (FIX_ID))
256 Query create table types_typ (TYP_ID int(11) NOT NULL AUTO_INCREMENT, TYP_NAME varchar(45) not null, primary key (TYP_ID))
256 Query create table vendors_ven (VEN_ID int(11) NOT NULL AUTO_INCREMENT, VEN_NAME varchar(45) not null, primary key (VEN_ID))
256 Query create table l_station_addresses_numalloc_san (SAN_ID int(11) NOT NULL AUTO_INCREMENT, SAN_TVN_ID int(11) not null, SAN_STA_ID int(11) not null, SAN_NUMALLOC int(11) not null, SAN_SIZE int(11) not null, primary key (SAN_ID))
111117 12:40:37 256 Query create table factories_fac (FAC_ID int(11) NOT NULL AUTO_INCREMENT, FAC_NAME varchar(45) not null, primary key (FAC_ID))
256 Query create table l_factory_id_fid (FID_ID int(11) NOT NULL AUTO_INCREMENT, FID_FAC_ID int(11) not null, FID_FACTORY_ID varchar(25), primary key (FID_ID))
256 Query create table fb_serials_srl (SRL_ID int(11) NOT NULL AUTO_INCREMENT, SRL_DATE datetime not null, SRL_SN varchar(45) not null, SRL_STATION varchar(45) not null, SRL_RFT_ID int(11) not null, SRL_TVN_ID int(11) not null, SRL_FID_ID int(11) not null, primary key (SRL_ID))
256 Query create table references_ref (REF_ID int(11) NOT NULL AUTO_INCREMENT, REF_NAME varchar(45) not null, primary key (REF_ID))
256 Query alter table stations_sta add index (STA_FAC), add constraint FK910C48B28ED437BA foreign key (STA_FAC) references factories_fac (FAC_ID)
256 Query alter table l_type_vendor_num_tvn add index (TVN_TYP_ID), add constraint TYP_ID foreign key (TVN_TYP_ID) references types_typ (TYP_ID)
256 Query alter table l_type_vendor_num_tvn add index (TVN_VEN_ID), add constraint FK2CB54A34AD8C096E foreign key (TVN_VEN_ID) references vendors_ven (VEN_ID)
111117 12:40:38 256 Query alter table l_station_serials_numalloc_ssn add index (SSN_TVN_ID), add constraint FK4690B83476ADB8EB foreign key (SSN_TVN_ID) references l_type_vendor_num_tvn (TVN_ID)
256 Query alter table l_station_serials_numalloc_ssn add index (SSN_STA_ID), add constraint FK4690B834E708C790 foreign key (SSN_STA_ID) references stations_sta (STA_ID)
256 Query alter table l_ref_fix_tvn_rft add index (RFT_REF), add constraint FKDB11D44C6908A64B foreign key (RFT_REF) references references_ref (REF_ID)
256 Query alter table l_ref_fix_tvn_rft add index (RFT_FIX), add constraint FKDB11D44CF3F021C7 foreign key (RFT_FIX) references fixtures_fix (FIX_ID)
256 Query alter table l_ref_fix_tvn_rft add index (RFT_TVN_ID), add constraint FKDB11D44CCCA3CAB9 foreign key (RFT_TVN_ID) references l_type_vendor_num_tvn (TVN_ID)
111117 12:40:39 256 Query alter table l_ref_fix_tvn_rft add index (RFT_FID_ID), add constraint FKDB11D44C881A653 foreign key (RFT_FID_ID) references l_factory_id_fid (FID_ID)
256 Query alter table l_station_addresses_numalloc_san add index (SAN_TVN_ID), add constraint FKA303BE42E1BB8E6 foreign key (SAN_TVN_ID) references l_type_vendor_num_tvn (TVN_ID)
256 Query alter table l_station_addresses_numalloc_san add index (SAN_STA_ID), add constraint FKA303BE43F3EC791 foreign key (SAN_STA_ID) references stations_sta (STA_ID)
256 Query alter table l_factory_id_fid add index (FID_FAC_ID), add constraint FKE7FDCF9E3BBD7704 foreign key (FID_FAC_ID) references factories_fac (FAC_ID)
256 Query alter table fb_serials_srl add index (SRL_STATION), add constraint FKA4D16D1C259A33A foreign key (SRL_STATION) references stations_sta (STA_ID)
Partager