text: CREATE TABLE META_Digestion ( id bigint(20) unsigned NOT NULL auto_increment, Enzyme varchar(50) NOT NULL default '', DigestionTime float NOT NULL default '0', Ph float NOT NULL default '0', Temperature float NOT NULL default '0', PRIMARY KEY (id))
  CREATE TABLE DATA_PrecursorAM ( id bigint(20) unsigned NOT NULL auto_increment, fid_Precursor bigint(20) unsigned NOT NULL default '0', ActivationMethods enum('UNKNOWN','CID','PSD','PD','SID','BIRD','ECD','IMD','SORI','HCID','LCID','PHD','ETD','PQD') NOT NULL default 'UNKNOWN', PRIMARY KEY (id), KEY fid_Precursor (fid_Precursor))
  CREATE TABLE META_MSExperiment ( id bigint(20) unsigned NOT NULL auto_increment, fid_MetaInfo bigint(20) unsigned default NULL, `Date` date default NULL, Description text collate latin1_general_ci NOT NULL, FractionIdentifier text collate latin1_general_ci NOT NULL, PRIMARY KEY (id), KEY fid_MetaInfo (fid_MetaInfo))
  CREATE TABLE ID_PeptideHit ( id bigint(20) unsigned NOT NULL auto_increment, fid_Identification bigint(20) unsigned NOT NULL default '0', fid_MetaInfo bigint(20) unsigned default NULL, Score float NOT NULL default '0', Sequence varchar(100) NOT NULL default '', charge tinyint(4) default NULL, AABefore char(1) default NULL, AAAfter char(1) default NULL, PRIMARY KEY (id), KEY db_search (fid_Identification), KEY Score (Score), KEY fid_MetaInfo (fid_MetaInfo))
  CREATE TABLE META_GradientTime ( id bigint(20) unsigned NOT NULL auto_increment, fid_HPLC bigint(20) unsigned NOT NULL default '0', `Time` int(10) unsigned NOT NULL default '0', PRIMARY KEY (id), KEY fid_Gradient (fid_HPLC))
  CREATE TABLE DATA_PeakMetaData ( id bigint(20) unsigned NOT NULL auto_increment, fid_Peak bigint(20) unsigned NOT NULL default '0', fid_MetaInfoDescription bigint(20) unsigned NOT NULL default '0', Value float, PRIMARY KEY (id), KEY fid_Peak (fid_Peak), KEY fid_MetaInfoDescription (fid_MetaInfoDescription))
  CREATE TABLE META_IonDetector ( id bigint(20) unsigned NOT NULL auto_increment, fid_MSInstrument bigint(20) unsigned NOT NULL default '0', fid_MetaInfo bigint(20) unsigned default NULL, AcquisitionMode enum('UNKNOWN','PULSECOUNTING','ADC','TDC','TRANSIENTRECORDER') NOT NULL default 'UNKNOWN', ADCSamplingFrequency float NOT NULL default '0', Resolution float NOT NULL default '0', `Type` enum('UNKNOWN','ELECTRONMULTIPLIER','PHOTOMULTIPLIER','FOCALPLANEARRAY','FARADAYCUP','CONVERSIONDYNODEELECTRONMULTIPLIER','CONVERSIONDYNODEPHOTOMULTIPLIER','MULTICOLLECTOR','CHANNELELECTRONMULTIPLIER') NOT NULL default 'UNKNOWN', InstrumentOrder tinyint default NULL, PRIMARY KEY (id), KEY fid_MSInstrument (fid_MSInstrument), KEY fid_MetaInfo (fid_MetaInfo))
  CREATE TABLE META_SpectrumQuality ( fid_Spectrum bigint(20) unsigned NOT NULL default '0', Score float NOT NULL default '0', `Type` enum('Misc') NOT NULL default 'Misc', PRIMARY KEY (fid_Spectrum))
  CREATE TABLE DATA_Peak ( id bigint(20) unsigned NOT NULL auto_increment, fid_Spectrum bigint(20) unsigned NOT NULL default '0', fid_MetaInfo bigint(20) unsigned default NULL, mz float unsigned NOT NULL default '0', Intensity float unsigned default NULL, PRIMARY KEY (id), KEY peak_peak_list (fid_Spectrum), KEY fid_MetaInfo (fid_MetaInfo))
  CREATE TABLE META_GradientPercentage ( fid_GradientTime bigint(20) unsigned NOT NULL default '0', fid_GradientEluent bigint(20) unsigned NOT NULL default '0', Percentage int(10) unsigned NOT NULL default '0', PRIMARY KEY (fid_GradientTime,fid_GradientEluent), KEY fid_GradientEluent (fid_GradientEluent))
  CREATE TABLE META_Acquisition ( id bigint(20) unsigned NOT NULL auto_increment, fid_AcquisitionInfo bigint(20) unsigned NOT NULL default '0', fid_MetaInfo bigint(20) unsigned default NULL, Number int(11) NOT NULL default '0', PRIMARY KEY (id), KEY fid_AcquisitionInfo (fid_AcquisitionInfo), KEY fid_MetaInfo (fid_MetaInfo))
  CREATE TABLE META_MSInstrument ( id bigint(20) unsigned NOT NULL auto_increment, fid_MSExperiment bigint(20) unsigned NOT NULL default '0', fid_MetaInfo bigint(20) unsigned default NULL, Model varchar(30) collate latin1_general_ci NOT NULL default '', Vendor varchar(30) collate latin1_general_ci NOT NULL default '', Description text collate latin1_general_ci NOT NULL, IonOpticsType enum('UNKNOWN','MAGNETIC_DEFLECTION','DELAYED_EXTRACTION','COLLISION_QUADRUPOLE','SELECTED_ION_FLOW_TUBE','TIME_LAG_FOCUSING','REFLECTRON','EINZEL_LENS','ELECTRIC_FIELD_STRENGTH','FIRST_STABILITY_REGION','FRINGING_FIELD','KINETIC_ENERGY_ANALYZER','SPACE_CHARGE_EFFECT','STATIC_FIELD') collate latin1_general_ci NOT NULL default 'UNKNOWN', PRIMARY KEY (id), KEY fid_MetaInfo (fid_MetaInfo), KEY fid_MSExperiment (fid_MSExperiment))
  CREATE TABLE META_MetaInfoDescription ( id bigint(20) unsigned NOT NULL auto_increment, fid_Spectrum bigint(20) unsigned NOT NULL default '0', fid_MetaInfo bigint(20) unsigned default NULL, Name varchar(30) collate latin1_general_ci NOT NULL default '', PRIMARY KEY (id), KEY fid_Spectrum (fid_Spectrum), KEY fid_MetaInfo (fid_MetaInfo))
  CREATE TABLE ID_ProteinIdentification ( id bigint(20) unsigned NOT NULL auto_increment, fid_MSExperiment bigint(20) unsigned default NULL, fid_File bigint(20) unsigned default NULL, fid_MetaInfo bigint(20) unsigned default NULL, SearchEngine varchar(40) NOT NULL default '', SearchEngineVersion varchar(10) NOT NULL default '', `Date` date default NULL, ScoreType varchar(100) NOT NULL default '', HigherScoreBetter tinyint(1) NOT NULL default '0', SignificanceThreshold float NOT NULL default '0', PRIMARY KEY (id), KEY fid_MSExperiment (fid_MSExperiment), KEY fid_MetaInfo (fid_MetaInfo), KEY fid_File (fid_File))
  CREATE TABLE ID_ProteinHit ( id bigint(20) unsigned NOT NULL auto_increment, fid_ProteinIdentification bigint(20) unsigned NOT NULL default '0', fid_MetaInfo bigint(20) unsigned default NULL, Score float NOT NULL default '0', Accession varchar(20) NOT NULL default '0', Sequence varchar(100) NOT NULL default '', Rank tinyint unsigned default NULL, PRIMARY KEY (id), KEY db_search (fid_ProteinIdentification), KEY Score (Score), KEY fid_MetaInfo (fid_MetaInfo))
  CREATE TABLE META_MetaInfo ( id bigint(20) unsigned NOT NULL auto_increment, PRIMARY KEY (id))
  CREATE TABLE META_ProcessingActions ( id bigint(20) unsigned NOT NULL auto_increment, ProcessingActionType enum('CHARGE_DECONVOLUTION','DEISOTOPING','SMOOTHING','CHARGE_CALCULATION','PRECURSOR_RECALCULATION','BASELINE_REDUCTION','PEAK_PICKING','PEAK_PICKING_SUM','PEAK_PICKING_MAX','FEATURE_FINDING','ALIGNMENT','LOW_INTENSITY_REMOVAL','HIGH_INTENSITY_REMOVAL','CONVERSION_MZDATA','CONVERSION_MZML','CONVERSION_MZXML','CONVERSION_DTA','CONVERSION_FEATUREXML','CONVERSION_CONSENSUSXML') NOT NULL default 'CONVERSION_MZML', fid_DataProcessing bigint(20) unsigned default NULL, PRIMARY KEY (id), KEY fid_DataProcessing (fid_DataProcessing))
  CREATE TABLE META_Sample ( id bigint(20) unsigned NOT NULL auto_increment, fid_MSExperiment bigint(20) unsigned NOT NULL default '0', fid_Sample bigint(20) unsigned default NULL, fid_MetaInfo bigint(20) unsigned default NULL, Name varchar(30) default NULL, SampleID varchar(30) default NULL, Mass float default NULL, Volume float default NULL, Concentration float default NULL, State enum('UNKNOWN','SOLID','LIQUID','GAS','SOLUTION','EULSION','SUSPENSION') NOT NULL default 'UNKNOWN', Organism varchar(40) default NULL, Description text character set latin1 collate latin1_general_ci NOT NULL, PRIMARY KEY (id), KEY fid_MSExperiment (fid_MSExperiment), KEY fid_MetaInfo (fid_MetaInfo), KEY fid_Sample (fid_Sample))
  CREATE TABLE META_InstrumentSettings ( id bigint(20) unsigned NOT NULL auto_increment, fid_Spectrum bigint(20) unsigned NOT NULL default '0', fid_MetaInfo bigint(20) unsigned default NULL, Polarity enum('UNKNOWN','POSITIVE','NEGATIVE') default 'UNKNOWN', ScanMode enum('UNKNOWN','FULL','ZOOM','SELECTEDIONMONITORING','SELECTEDREACTIONMONITORING','CONSECUTIVEREACTIONMONITORING','CONSTANTNEUTRALGAIN','CONSTANTNEUTRALLOSS','PRECURSOR','PHOTODIODEARRAYDETECTOR','ENHANCEDMULTIPLYCHARGED','TIMEDELAYEDFRAGMENTATION') default 'UNKNOWN', ZoomScan tinyint NOT NULL default '0', PRIMARY KEY (id), KEY fid_MetaInfo (fid_MetaInfo), KEY fid_Spectrum (fid_Spectrum))
  CREATE TABLE ID_FixedModifications ( id bigint(20) unsigned NOT NULL auto_increment, fid_SearchParameters bigint(20) unsigned NOT NULL default '0', name varchar(50) NOT NULL default '', PRIMARY KEY (id), KEY fid_SearchParameters (fid_SearchParameters))
  CREATE TABLE META_IonSource ( id bigint(20) unsigned NOT NULL auto_increment, fid_MSInstrument bigint(20) unsigned NOT NULL default '0', fid_MetaInfo bigint(20) unsigned default NULL, InletType enum('UNKNOWN','DIRECT','BATCH','CHROMATOGRAPHY','PARTICLEBEAM','MEMBRANESEPARATOR','OPENSPLIT','JETSEPARATOR','SEPTUM','RESERVOIR','MOVINGBELT','MOVINGWIRE','FLOWINJECTIONANALYSIS','ELECTROSPRAYINLET','THERMOSPRAYINLET','INFUSION','CONTINUOUSFLOWFASTATOMBOMBARDMENT','INDUCTIVELYCOUPLEDPLASMA') collate latin1_general_ci NOT NULL default 'UNKNOWN', IonizationMethod enum('UNKNOWN','ESI','EI','CI','FAB','TSP','LD','FD','FI','PD','SI','TI','API','ISI','CID','CAD','HN','APCI','APPI','ICP') collate latin1_general_ci NOT NULL default 'UNKNOWN', IonizationMode enum('UNKNOWN','POSITIVEIONMODE','NEGATIVEIONMODE') collate latin1_general_ci NOT NULL default 'UNKNOWN', InstrumentOrder tinyint default NULL, PRIMARY KEY (id), KEY fid_MetaInfo (fid_MetaInfo), KEY fid_MSInstrument (fid_MSInstrument))
  CREATE TABLE DATA_PrecursorPCS ( id bigint(20) unsigned NOT NULL auto_increment, fid_Precursor bigint(20) unsigned NOT NULL default '0', PossibleChargeStates smallint(6) default NULL, PRIMARY KEY (id), KEY fid_Precursor (fid_Precursor))
  CREATE TABLE DATA_Precursor ( id bigint(20) unsigned NOT NULL auto_increment, fid_Spectrum bigint(20) unsigned NOT NULL default '0', fid_MetaInfo bigint(20) unsigned default NULL, WindowMz float unsigned NOT NULL default '0', WindowLow float unsigned default NULL, WindowUp float unsigned default NULL, Intensity float unsigned default NULL, Charge smallint(6) default NULL, ActivationEnergy float default NULL, PRIMARY KEY (id), KEY peak_list (fid_Spectrum), KEY fid_MetaInfo (fid_MetaInfo))
  CREATE TABLE META_TypeNameValue ( fid_MetaInfo bigint(20) unsigned NOT NULL default '0', `Type` enum('string','double','int') collate latin1_general_ci NOT NULL default 'string', Name varchar(30) collate latin1_general_ci NOT NULL default '', `Value` text collate latin1_general_ci NOT NULL, PRIMARY KEY (fid_MetaInfo,Name))
  CREATE TABLE META_DataProcessing ( id bigint(20) unsigned NOT NULL auto_increment, fid_Spectrum bigint(20) unsigned NOT NULL default '0', fid_MetaInfo bigint(20) unsigned default NULL, CompletionTime varchar(50) NOT NULL default '0', PRIMARY KEY (id), KEY fid_MetaInfo (fid_MetaInfo), KEY fid_Spectrum (fid_Spectrum))
  CREATE TABLE DATA_Products ( id bigint(20) unsigned NOT NULL auto_increment, fid_Spectrum bigint(20) unsigned NOT NULL default '0', fid_MetaInfo bigint(20) unsigned default NULL, WindowMz float unsigned NOT NULL default '0', WindowLow float unsigned default NULL, WindowUp float unsigned default NULL, PRIMARY KEY (id), KEY fid_Spectrum (fid_Spectrum), KEY fid_MetaInfo (fid_MetaInfo))
  CREATE TABLE META_File ( id bigint(20) unsigned NOT NULL auto_increment, FileName varchar(50) collate latin1_general_ci NOT NULL default '', FilePath varchar(80) collate latin1_general_ci NOT NULL default '', sha1 varchar(40) collate latin1_general_ci NOT NULL default '', Size float unsigned NOT NULL default '0', `Type` text collate latin1_general_ci NOT NULL, ChecksumType enum ('UNKNOWN', 'SHA1', 'MD5') collate latin1_general_ci NOT NULL default 'UNKNOWN', NativeIDType varchar(80) collate latin1_general_ci NOT NULL default '', PRIMARY KEY (id))
  CREATE TABLE META_ScanWindows ( id bigint(20) unsigned NOT NULL auto_increment, fid_Spectrum bigint(20) unsigned NOT NULL default '0', fid_MetaInfo bigint(20) unsigned default NULL, MZRangeBegin float default NULL, MzRangeEnd float default NULL, PRIMARY KEY (id), KEY fid_MetaInfo (fid_MetaInfo), KEY fid_Spectrum (fid_Spectrum))
  CREATE TABLE META_GradientEluent ( id bigint(20) unsigned NOT NULL auto_increment, fid_HPLC bigint(20) unsigned NOT NULL default '0', Name varchar(40) collate latin1_general_ci NOT NULL default '', PRIMARY KEY (id), KEY fid_Gradient (fid_HPLC))
  CREATE TABLE ID_SearchParameters ( id bigint(20) unsigned NOT NULL auto_increment, fid_ProteinIdentification bigint(20) unsigned NOT NULL default '0', fid_MetaInfo bigint(20) unsigned default NULL, DB varchar(40) NOT NULL default '', DBVersion varchar(10) NOT NULL default '', Taxonomy varchar(50) NOT NULL default '', Charges varchar(20) NOT NULL default '', MassType enum('average','monoisotopic') NOT NULL default 'monoisotopic', Enzyme enum('trypsin','pepsin_a','protease_k','chymotrypsin','no_enzyme','unknown_enzyme') NOT NULL default 'unknown_enzyme', MissedCleavages tinyint(4) NOT NULL default '0', PeakMassTolerance float NOT NULL default '0', PrecursorTolerance float NOT NULL default '0', PRIMARY KEY (id), KEY fid_ProteinIdentification (fid_ProteinIdentification), KEY fid_MetaInfo (fid_MetaInfo))
  CREATE TABLE META_HPLC ( id bigint(20) unsigned NOT NULL auto_increment, fid_MSExperiment bigint(20) unsigned NOT NULL default '0', InstrumentName varchar(60) collate latin1_general_ci NOT NULL default '', ColumnName varchar(40) collate latin1_general_ci NOT NULL default '', Description text collate latin1_general_ci NOT NULL, Flux int(11) NOT NULL default '0', Pressure int(11) NOT NULL default '0', Temperature int(11) NOT NULL default '0', PRIMARY KEY (id), KEY fid_MSExperiment (fid_MSExperiment))
  CREATE TABLE DATA_Spectrum ( id bigint(20) unsigned NOT NULL auto_increment, fid_MSExperiment bigint(20) unsigned NOT NULL default '0', fid_File bigint(20) unsigned default NULL, fid_MetaInfo bigint(20) unsigned default NULL, Description text character set latin1 collate latin1_general_ci NOT NULL, NativeID text character set latin1 collate latin1_general_ci NOT NULL, MSLevel smallint(5) unsigned NOT NULL default '0', MassType enum('monoisotopic','average') NOT NULL default 'monoisotopic', RetentionTime double unsigned default NULL, TotalIonCurrent int(11) unsigned default NULL, `Type` enum('Unknown','PeakData','RawData') NOT NULL default 'Unknown', PRIMARY KEY (id), KEY fid_MSExperiment (fid_MSExperiment), KEY fid_MetaInfo (fid_MetaInfo), KEY fid_File (fid_File))
  CREATE TABLE META_AcquisitionInfo ( id bigint(20) unsigned NOT NULL auto_increment, fid_Spectrum bigint(20) unsigned NOT NULL default '0', MethodOfCombination varchar(30) collate latin1_general_ci NOT NULL default '', PRIMARY KEY (id), KEY fid_Spectrum (fid_Spectrum))
  CREATE TABLE ID_PeptideIdentification ( id bigint(20) unsigned NOT NULL auto_increment, fid_Spectrum bigint(20) unsigned default NULL, fid_File bigint(20) unsigned default NULL, fid_MetaInfo bigint(20) unsigned default NULL, SignificanceThreshold float NOT NULL default '0', ScoreType varchar(100) NOT NULL default '', HigherScoreBetter tinyint(1) NOT NULL default '0', PRIMARY KEY (id), KEY fid_Spectrum (fid_Spectrum), KEY fid_MetaInfo (fid_MetaInfo), KEY fid_File (fid_File))
  CREATE TABLE META_ContactPerson ( id bigint(20) unsigned NOT NULL auto_increment, fid_MSExperiment bigint(20) unsigned NOT NULL default '0', fid_MetaInfo bigint(20) unsigned default NULL, PreName varchar(50) collate latin1_general_ci NOT NULL default '', LastName varchar(40) collate latin1_general_ci NOT NULL default '', Affiliation varchar(50) collate latin1_general_ci NOT NULL default '', Email varchar(40) collate latin1_general_ci NOT NULL default '', `Comment` text collate latin1_general_ci NOT NULL, PRIMARY KEY (id), KEY fid_MSExperiment (fid_MSExperiment), KEY fid_MetaInfo (fid_MetaInfo))
  CREATE TABLE META_Software ( id bigint(20) unsigned NOT NULL auto_increment, fid_SoftwareApplicator bigint(20) unsigned NOT NULL default '0', fid_MetaInfo bigint(20) unsigned default NULL, SoftwareApplicator varchar(50) NOT NULL default '0', Name varchar(50) NOT NULL default '0', Version varchar(50) NOT NULL default '0', PRIMARY KEY (id), KEY fid_MetaInfo (fid_MetaInfo), KEY fid_SoftwareApplicator (fid_SoftwareApplicator))
  CREATE TABLE ID_VariableModifications ( id bigint(20) unsigned NOT NULL auto_increment, fid_SearchParameters bigint(20) unsigned NOT NULL default '0', name varchar(50) NOT NULL default '', PRIMARY KEY (id), KEY fid_SearchParameters (fid_SearchParameters))
  CREATE TABLE META_SampleTreatment ( id bigint(20) unsigned NOT NULL auto_increment, fid_Sample bigint(20) unsigned NOT NULL default '0', fid_Digestion bigint(20) unsigned default NULL, fid_Modification bigint(20) unsigned default NULL, fid_MetaInfo bigint(20) unsigned default NULL, Description text collate latin1_general_ci NOT NULL, PRIMARY KEY (id), KEY fid_Sample (fid_Sample), KEY fid_MetaInfo (fid_MetaInfo), KEY fid_Digestion (fid_Digestion), KEY fid_Modification (fid_Modification))
  CREATE TABLE META_Modification ( id bigint(20) unsigned NOT NULL auto_increment, ReagentName varchar(50) NOT NULL default '', AffectedAminoAcids varchar(30) NOT NULL default '', SpecificityType enum('AA','AA_AT_CTERM','AA_AT_NTERM','CTERM','NTERM') NOT NULL default 'AA', Mass float NOT NULL default '0', MassShift float default NULL, Variant enum('LIGHT','HEAVY') default NULL, PRIMARY KEY (id))
  CREATE TABLE ADMIN_Version ( version varchar(50) NOT NULL default '')
  