Migration tool specifications
Base1 Tables
+----------------+--------------+------+-----+---------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+--------------+------+-----+---------------------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | arrayType | int(11) | | MUL | 0 | | | descr | text | | | | | | printStartDate | datetime | | | 0000-00-00 00:00:00 | | | printEndDate | datetime | | | 0000-00-00 00:00:00 | | | owner | int(11) | | | 0 | | | name | varchar(80) | | MUL | | | | addedDate | date | | | 0000-00-00 | | | surfaceType | varchar(255) | | | | | | protocol | int(11) | | | 0 | | | notes | text | | | | | | removed | tinyint(1) | | | 0 | | | gid | int(11) | | | 0 | | | groupAccess | tinyint(1) | | | 0 | | | worldAccess | tinyint(1) | | | 0 | | +----------------+--------------+------+-----+---------------------+----------------+ArrayBlock
+-----------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+-------------+------+-----+---------+-------+ | arrayType | int(11) | | PRI | 0 | | | blockNum | smallint(6) | | PRI | 0 | | | xOrigin | float | | | 0 | | | yOrigin | float | | | 0 | | | featureDiameter | float | | | 0 | | | xFeatures | float | | | 0 | | | xSpacing | float | | | 0 | | | yFeatures | float | | | 0 | | | ySpacing | float | | | 0 | | | metaRow | smallint(6) | | | 0 | | | metaColumn | smallint(6) | | | 0 | | +-----------------+-------------+------+-----+---------+-------+ArraySlide
+---------------+-------------+------+-----+------------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+-------------+------+-----+------------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | batch | int(11) | | MUL | 0 | | | orderNumber | smallint(6) | | | 0 | | | name | varchar(80) | YES | MUL | NULL | | | destroyed | tinyint(1) | | | 0 | | | hybridization | int(11) | YES | MUL | NULL | | | descr | text | | | | | | owner | int(11) | | | 0 | | | addedDate | date | | | 0000-00-00 | | | removed | tinyint(1) | | | 0 | | | gid | int(11) | | | 0 | | | groupAccess | tinyint(1) | | | 0 | | | worldAccess | tinyint(1) | | | 0 | | +---------------+-------------+------+-----+------------+----------------+ArrayType
+---------------+--------------+------+-----+------------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+--------------+------+-----+------------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | owner | int(11) | | | 0 | | | name | varchar(80) | | MUL | | | | platform | varchar(255) | | | | | | protocol | int(11) | | | 0 | | | descr | text | | | | | | addedDate | date | | | 0000-00-00 | | | printed | tinyint(1) | | | 0 | | | printMapName | varchar(255) | | | | | | removed | tinyint(1) | | | 0 | | | gid | int(11) | | | 0 | | | groupAccess | tinyint(1) | | | 0 | | | worldAccess | tinyint(1) | | | 0 | | | featureLock | smallint(6) | | | 0 | | | featureCount | int(11) | | | 0 | | | blankFeatures | int(11) | | | 0 | | +---------------+--------------+------+-----+------------+----------------+ArrayTypePlate
+-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | arrayType | int(11) | | PRI | 0 | | | plate | int(11) | | | 0 | | | position | smallint(6) | | PRI | 0 | | +-----------+-------------+------+-----+---------+-------+BaseControl
+----------------------+------------+------+-----+---------------------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------------+------------+------+-----+---------------------+-------+ | startTime | datetime | | | 0000-00-00 00:00:00 | | | shutDown | tinyint(4) | | | 0 | | | pendingTransactions | int(11) | | | 0 | | | finishedTransactions | int(11) | | | 0 | | | startedScripts | int(11) | | | 0 | | +----------------------+------------+------+-----+---------------------+-------+BaseFileSection
+-------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+--------------+------+-----+---------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | name | varchar(255) | | UNI | | | +-------+--------------+------+-----+---------+----------------+BioAssay
+-------------+--------------+------+-----+------------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+------------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | name | varchar(80) | | | | | | descr | text | | | | | | owner | int(11) | | | 0 | | | addedDate | date | | | 0000-00-00 | | | bioAssaySet | int(11) | | MUL | 0 | | | experiment | int(11) | | | 0 | | | spots | mediumint(9) | | | 0 | | | removed | tinyint(1) | | | 3 | | | channels | tinyint(4) | | | 2 | | +-------------+--------------+------+-----+------------+----------------+BioAssayOrigin
+-------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+----------------+ | bioAssay | int(11) | | PRI | 0 | | | rawBioAssay | int(11) | | MUL | 0 | | | position | smallint(6) | | PRI | NULL | auto_increment | +-------------+-------------+------+-----+---------+----------------+BioAssayParent
+----------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+---------+----------------+ | bioAssay | int(11) | | PRI | 0 | | | parent | int(11) | | MUL | 0 | | | position | smallint(6) | | PRI | NULL | auto_increment | +----------+-------------+------+-----+---------+----------------+BioAssaySample
+----------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+------------+------+-----+---------+-------+ | bioAssay | int(11) | | PRI | 0 | | | sample | int(11) | | | 0 | | | channel | tinyint(4) | | PRI | 0 | | +----------+------------+------+-----+---------+-------+BioAssaySet
+------------------+--------------+------+-----+------------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+--------------+------+-----+------------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | name | varchar(80) | | MUL | | | | descr | text | | | | | | owner | int(11) | | | 0 | | | addedDate | date | | | 0000-00-00 | | | experiment | int(11) | | MUL | 0 | | | transformation | int(11) | | MUL | 0 | | | assayCount | smallint(6) | | | 0 | | | spotCount | int(11) | | | 0 | | | geneCount | mediumint(9) | | | 0 | | | removed | tinyint(1) | | | 3 | | | intensityMeasure | varchar(80) | YES | | NULL | | | hasExtraColumns | tinyint(1) | | | 0 | | +------------------+--------------+------+-----+------------+----------------+BioAssaySetExplore
+----------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+--------------+------+-----+---------+-------+ | bioAssaySet | int(11) | | PRI | 0 | | | userGroup | int(11) | | PRI | 0 | | | hits | int(11) | | | 0 | | | page | int(11) | | | 0 | | | reporter | mediumint(9) | | | 0 | | | subPage | smallint(6) | | | 1 | | | annotationType | int(11) | | | 0 | | | exploreMode | tinyint(1) | | | 0 | | | showBackend | tinyint(1) | | | 0 | | | spotSize | tinyint(4) | | | 0 | | | rawLevel | tinyint(1) | | | 3 | | +----------------+--------------+------+-----+---------+-------+BioAssaySetExtraColumn
+-----------------+------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------+------------+------+-----+---------+----------------+ | bioAssaySet | int(11) | | PRI | 0 | | | extraDataColumn | int(11) | | | 0 | | | position | tinyint(4) | | PRI | NULL | auto_increment | +-----------------+------------+------+-----+---------+----------------+BioAssaySetSearch
+-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | bioAssaySet | int(11) | | MUL | 0 | | | userGroup | int(11) | | | 0 | | | searchType | varchar(80) | | | | | | search | int(11) | | PRI | 0 | | +-------------+-------------+------+-----+---------+-------+ComputationServer
+---------------+--------------+------+-----+------------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+--------------+------+-----+------------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | name | varchar(80) | | | | | | descr | text | | | | | | owner | int(11) | | | 0 | | | addedDate | date | | | 0000-00-00 | | | removed | tinyint(1) | | | 3 | | | gid | int(11) | | | 0 | | | groupAccess | tinyint(4) | | | 0 | | | worldAccess | tinyint(4) | | | 0 | | | serverType | tinyint(4) | | | 0 | | | userHost | varchar(255) | | | | | | remoteRootDir | varchar(255) | | | | | | remoteDataDir | varchar(255) | | | | | | localUrl | varchar(255) | | | | | | maxJobs | int(11) | | | 0 | | | minTime | int(11) | | | 60 | | | maxTime | int(11) | | | 86400 | | | jobSlots | smallint(6) | | | 3 | | | infSlots | smallint(6) | | | 1 | | | totalRam | double | | | 268435000 | | +---------------+--------------+------+-----+------------+----------------+Cookie
+--------------+-------------+------+-----+---------------------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+-------------+------+-----+---------------------+-------+ | cookie | varchar(40) | | PRI | | | | owner | int(11) | | | 0 | | | lastSeen | datetime | | MUL | 0000-00-00 00:00:00 | | | IP | tinytext | | | | | | loginDate | datetime | | | 0000-00-00 00:00:00 | | | lastActivity | datetime | | | 0000-00-00 00:00:00 | | +--------------+-------------+------+-----+---------------------+-------+EventLog
+-------------+--------------+------+-----+---------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------------------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | name | varchar(255) | | | | | | descr | text | | | | | | owner | int(11) | | | 0 | | | addedDate | datetime | | MUL | 0000-00-00 00:00:00 | | | removed | tinyint(1) | | | 0 | | | gid | int(11) | | | 0 | | | groupAccess | tinyint(1) | | | 0 | | | worldAccess | tinyint(1) | | | 0 | | | eventType | smallint(6) | | | 0 | | | linkInfo | varchar(255) | | | | | +-------------+--------------+------+-----+---------------------+----------------+Experiment
+-------------------+--------------+------+-----+------------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------------+--------------+------+-----+------------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | name | varchar(80) | | | | | | descr | text | | | | | | owner | int(11) | | | 0 | | | addedDate | date | | | 0000-00-00 | | | authors | text | | | | | | affiliations | text | | | | | | experimentType | varchar(255) | | | | | | experimentDesign | text | | | | | | publication | text | | | | | | abstract | text | | | | | | pubMedId | varchar(80) | | | | | | publicationDate | date | | | 0000-00-00 | | | removed | tinyint(1) | | | 3 | | | gid | int(11) | | | 0 | | | groupAccess | tinyint(1) | | | 0 | | | worldAccess | tinyint(1) | | | 0 | | | channels | tinyint(4) | | | 2 | | | hasMageml | smallint(1) | | | 0 | | | extraColumnTables | int(11) | | | 0 | | +-------------------+--------------+------+-----+------------+----------------+ExperimentExplore
+-----------------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------------+------------+------+-----+---------+-------+ | experiment | int(11) | | PRI | 0 | | | userGroup | int(11) | | PRI | 0 | | | shownTab | tinyint(4) | | | 0 | | | currentTransformation | int(11) | | | 0 | | | currentSet | int(11) | | | 0 | | +-----------------------+------------+------+-----+---------+-------+ExperimentRawBioAssay
+-------------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+---------+------+-----+---------+-------+ | experiment | int(11) | | PRI | 0 | | | rawBioAssay | int(11) | | PRI | 0 | | +-------------+---------+------+-----+---------+-------+ExtraDataColumn
+-----------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | name | varchar(80) | | MUL | | | | valueType | tinyint(4) | | | 0 | | +-----------+-------------+------+-----+---------+----------------+Extract
+----------------+-------------+------+-----+------------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------+------+-----+------------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | protocol | int(11) | | | 0 | | | extractionDate | date | | | 0000-00-00 | | | sample | int(11) | | MUL | 0 | | | name | varchar(80) | | MUL | | | | descr | text | | | | | | quantity | float | | | 0 | | | quantityLeft | float | YES | | NULL | | | owner | int(11) | | | 0 | | | addedDate | date | | | 0000-00-00 | | | removed | tinyint(1) | | | 0 | | | gid | int(11) | | | 0 | | | groupAccess | tinyint(1) | | | 0 | | | worldAccess | tinyint(1) | | | 0 | | +----------------+-------------+------+-----+------------+----------------+Feature
+-----------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+--------------+------+-----+---------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | arrayType | int(11) | | MUL | 0 | | | block | smallint(6) | | | 0 | | | x | smallint(6) | | | 0 | | | y | smallint(6) | | | 0 | | | position | mediumint(9) | | | 0 | | | reporter | mediumint(9) | | | 0 | | | well | int(11) | YES | | NULL | | +-----------+--------------+------+-----+---------+----------------+Hardware
+-------------+-------------+------+-----+------------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+------------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | name | varchar(80) | | MUL | | | | descr | text | | | | | | owner | int(11) | | | 0 | | | addedDate | date | | | 0000-00-00 | | | version | varchar(80) | | | | | | removed | tinyint(1) | | | 0 | | | gid | int(11) | | | 0 | | | groupAccess | tinyint(1) | | | 0 | | | worldAccess | tinyint(1) | | | 0 | | +-------------+-------------+------+-----+------------+----------------+Hybridization
+-------------------+-------------+------+-----+------------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------------+-------------+------+-----+------------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | owner | int(11) | | | 0 | | | name | varchar(80) | | MUL | | | | descr | text | | | | | | addedDate | date | | | 0000-00-00 | | | hybridizationDate | date | | | 0000-00-00 | | | protocol | int(11) | | | 0 | | | removed | tinyint(1) | | | 0 | | | gid | int(11) | | | 0 | | | groupAccess | tinyint(1) | | | 0 | | | worldAccess | tinyint(1) | | | 0 | | +-------------------+-------------+------+-----+------------+----------------+HybridizedLabeled
+---------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+------------+------+-----+---------+-------+ | hybridization | int(11) | | PRI | 0 | | | channel | tinyint(4) | | PRI | 0 | | | labeled | int(11) | | MUL | 0 | | | quantity | float | | | 0 | | +---------------+------------+------+-----+---------+-------+Image
+------------------+--------------+------+-----+------------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+--------------+------+-----+------------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | name | varchar(255) | | | | | | descr | text | | | | | | owner | int(11) | | | 0 | | | addedDate | date | | | 0000-00-00 | | | imageAcquisition | int(11) | | MUL | 0 | | | channels | tinyint(4) | | | 0 | | | useForJpeg | tinyint(1) | | | 0 | | | fileSize | int(11) | | | 0 | | | removed | tinyint(1) | | | 0 | | +------------------+--------------+------+-----+------------+----------------+ImageAcquisition
+---------------+-------------+------+-----+------------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+-------------+------+-----+------------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | name | varchar(80) | | | | | | descr | text | | | | | | owner | int(11) | | | 0 | | | addedDate | date | | | 0000-00-00 | | | hybridization | int(11) | | MUL | 0 | | | scanDate | date | | | 0000-00-00 | | | scanner | int(11) | | | 0 | | | removed | tinyint(1) | | | 0 | | | gid | int(11) | | | 0 | | | groupAccess | tinyint(1) | | | 0 | | | worldAccess | tinyint(1) | | | 0 | | +---------------+-------------+------+-----+------------+----------------+Item
+-------------+-------------+------+-----+------------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+------------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | name | varchar(80) | | | | | | descr | text | | | | | | owner | int(11) | | | 0 | | | addedDate | date | | | 0000-00-00 | | | removed | tinyint(1) | | | 0 | | | gid | int(11) | | | 0 | | | groupAccess | tinyint(1) | | | 0 | | | worldAccess | tinyint(1) | | | 0 | | +-------------+-------------+------+-----+------------+----------------+Job
+-------------------+---------------+------+-----+---------------------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+---------------+------+-----+---------------------+-------+ | submitTime | datetime | | | 0000-00-00 00:00:00 | | | handlerTime | datetime | | | 0000-00-00 00:00:00 | | | startTime | datetime | | MUL | 0000-00-00 00:00:00 | | | endTime | datetime | | | 0000-00-00 00:00:00 | | | doneTime | datetime | | | 0000-00-00 00:00:00 | | | program | int(11) | | | 0 | | | resultText | mediumtext | | | | | | transformation | int(11) | | PRI | 0 | | | duration | decimal(10,2) | | | -1.00 | | | cpuTime | decimal(10,2) | | | -1.00 | | | exportCpuTime | decimal(10,2) | | | -1.00 | | | handlerCpuTime | decimal(10,2) | | | -1.00 | | | controlSha1 | varchar(42) | YES | MUL | NULL | | | curStatus | tinyint(4) | | MUL | 0 | | | computationServer | int(11) | YES | | NULL | | | handlerPid | int(11) | YES | | NULL | | | estimatedTime | int(11) | | | 60 | | | maxCpu | int(11) | | | -1 | | | maxRam | double | | | 67108864 | | | matrixSize | double | | | -1 | | | queuePosition | int(11) | YES | MUL | NULL | | +-------------------+---------------+------+-----+---------------------+-------+JobFile
+----------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+--------------+------+-----+---------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | transformation | int(11) | | MUL | 0 | | | name | varchar(255) | | | | | | fileSize | int(11) | | | 0 | | +----------------+--------------+------+-----+---------+----------------+JobFileSection
+--------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+-------------+------+-----+---------+-------+ | jobFile | int(11) | | PRI | 0 | | | fileSection | int(11) | | PRI | 0 | | | sectionCount | smallint(6) | | | 0 | | +--------------+-------------+------+-----+---------+-------+JobSetting
+----------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+------------+------+-----+---------+-------+ | transformation | int(11) | | PRI | 0 | | | position | tinyint(4) | | PRI | 0 | | | setting | text | | | | | +----------------+------------+------+-----+---------+-------+Label
+-------------+-------------+------+-----+------------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+------------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | name | varchar(80) | | MUL | | | | descr | text | | | | | | owner | int(11) | | | 0 | | | addedDate | date | | | 0000-00-00 | | | removed | tinyint(1) | | | 0 | | | gid | int(11) | | | 0 | | | groupAccess | tinyint(1) | | | 0 | | | worldAccess | tinyint(1) | | | 0 | | +-------------+-------------+------+-----+------------+----------------+LabeledExtract
+--------------+-------------+------+-----+------------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+-------------+------+-----+------------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | owner | int(11) | | | 0 | | | name | varchar(80) | | MUL | | | | descr | text | | | | | | addedDate | date | | | 0000-00-00 | | | extract | int(11) | | MUL | 0 | | | protocol | int(11) | | | 0 | | | labelingDate | date | | | 0000-00-00 | | | quantity | float | | | 0 | | | quantityLeft | float | YES | | NULL | | | removed | tinyint(1) | | | 0 | | | gid | int(11) | | | 0 | | | groupAccess | tinyint(1) | | | 0 | | | worldAccess | tinyint(1) | | | 0 | | | label | int(11) | | | 0 | | +--------------+-------------+------+-----+------------+----------------+News
+-----------+--------------+------+-----+---------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+--------------+------+-----+---------------------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | name | varchar(255) | | | | | | descr | text | | | | | | owner | int(11) | | | 0 | | | addedDate | datetime | | MUL | 0000-00-00 00:00:00 | | | removed | tinyint(1) | | | 0 | | +-----------+--------------+------+-----+---------------------+----------------+Plate
+-------------+--------------+------+-----+------------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+------------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | plateType | int(11) | | | 0 | | | name | varchar(255) | YES | MUL | NULL | | | descr | text | | | | | | owner | int(11) | | | 0 | | | addedDate | date | | | 0000-00-00 | | | destroyed | tinyint(1) | | | 0 | | | barcode | varchar(255) | YES | MUL | NULL | | | wizzzard | int(11) | | | 0 | | | removed | tinyint(1) | | | 3 | | | gid | int(11) | | | 0 | | | groupAccess | tinyint(1) | | | 0 | | | worldAccess | tinyint(1) | | | 0 | | +-------------+--------------+------+-----+------------+----------------+PlateEvent
+-----------+---------+------+-----+------------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+---------+------+-----+------------+-------+ | plate | int(11) | | PRI | 0 | | | etype | int(11) | | PRI | 0 | | | eventDate | date | | MUL | 0000-00-00 | | | protocol | int(11) | | | 0 | | +-----------+---------+------+-----+------------+-------+PlateEventType
+--------------+-------------+------+-----+------------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+-------------+------+-----+------------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | name | varchar(80) | | | | | | plateType | int(11) | | MUL | 0 | | | protocolType | int(11) | | | 0 | | | descr | text | | | | | | addedDate | date | | | 0000-00-00 | | | owner | int(11) | | | 0 | | | removed | tinyint(1) | | | 0 | | +--------------+-------------+------+-----+------------+----------------+PlateParent
+----------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+------------+------+-----+---------+-------+ | parent | int(11) | | MUL | 0 | | | plate | int(11) | | MUL | 0 | | | position | tinyint(4) | | | 0 | | +----------+------------+------+-----+---------+-------+PlateType
+----------------+-------------+------+-----+------------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------+------+-----+------------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | name | varchar(80) | | MUL | | | | descr | text | | | | | | owner | int(11) | | | 0 | | | addedDate | date | | | 0000-00-00 | | | wells | smallint(6) | | | 0 | | | hasGrowth | tinyint(1) | | | 0 | | | hasSeqVerified | tinyint(1) | | | 0 | | | hasBands | tinyint(1) | | | 0 | | | hasComment | tinyint(1) | | | 0 | | | namePrefix | varchar(40) | | | | | | parentSuffix | tinyint(1) | | | 0 | | | removed | tinyint(1) | | | 0 | | | gid | int(11) | | | 0 | | | groupAccess | tinyint(1) | | | 0 | | | worldAccess | tinyint(1) | | | 0 | | +----------------+-------------+------+-----+------------+----------------+Preset
+-------------+---------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+---------------+------+-----+---------+-------+ | search | int(11) | | PRI | 0 | | | searchType | varchar(80) | | | | | | owner | int(11) | | MUL | 0 | | | name | varchar(80) | | | | | | lastTouched | timestamp(14) | YES | | NULL | | +-------------+---------------+------+-----+---------+-------+Probe
+----------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+--------------+------+-----+---------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | reporter | mediumint(9) | | | 0 | | +----------+--------------+------+-----+---------+----------------+Program
+---------------+--------------+------+-----+------------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+--------------+------+-----+------------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | execName | varchar(255) | | | | | | descr | text | | | | | | addedDate | date | | | 0000-00-00 | | | owner | int(11) | | | 0 | | | name | varchar(80) | | MUL | | | | usedColumns | text | | | | | | usedFields | text | | | | | | onServer | tinyint(1) | | | 0 | | | geneAverages | tinyint(1) | | | 0 | | | serialFormat | tinyint(1) | | | 0 | | | url | varchar(255) | | | | | | removed | tinyint(1) | | | 0 | | | gid | int(11) | | | 0 | | | groupAccess | tinyint(1) | | | 0 | | | worldAccess | tinyint(1) | | | 0 | | | minChannels | tinyint(4) | | | 2 | | | leaveStdin | tinyint(1) | | | 0 | | | leaveStdout | tinyint(1) | | | 0 | | | maxChannels | smallint(6) | | | 0 | | | uniqueName | varchar(255) | | | | | | versionNumber | varchar(20) | | | | | | estimatedTime | int(11) | | | 3600 | | | defaultMaxRam | double | | | 134218000 | | +---------------+--------------+------+-----+------------+----------------+ProgramParameter
+--------------+-----------------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-----------------------------------+------+-----+---------+----------------+
| program | int(11) | | PRI | 0 | |
| position | smallint(6) | | PRI | NULL | auto_increment |
| name | varchar(80) | | | | |
| commonName | varchar(80) | | | | |
| valueType | enum('i','f','t','a','n','h','e') | | | i | |
| options | text | | | | |
| defaultValue | text | | | | |
| enumOptions | text | | | | |
| removed | smallint(1) | | | 0 | |
+--------------+-----------------------------------+------+-----+---------+----------------+
ProgramServer
+-------------------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+---------+------+-----+---------+-------+ | program | int(11) | | PRI | 0 | | | computationServer | int(11) | | PRI | 0 | | +-------------------+---------+------+-----+---------+-------+Protocol
+--------------+--------------+------+-----+------------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+--------------+------+-----+------------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | protocolType | int(11) | | MUL | 0 | | | name | varchar(80) | | | | | | descr | text | | | | | | owner | int(11) | | | 0 | | | addedDate | date | | | 0000-00-00 | | | removed | tinyint(1) | | | 0 | | | gid | int(11) | | | 0 | | | groupAccess | tinyint(1) | | | 0 | | | worldAccess | tinyint(1) | | | 0 | | | fileSize | int(11) | | | 0 | | | filename | varchar(255) | YES | | NULL | | +--------------+--------------+------+-----+------------+----------------+ProtocolType
+-------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+-------------+------+-----+---------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | name | varchar(80) | | UNI | | | +-------+-------------+------+-----+---------+----------------+RawBioAssay
+------------------+--------------+------+-----+------------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+--------------+------+-----+------------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | name | varchar(80) | | | | | | descr | text | | | | | | owner | int(11) | | | 0 | | | addedDate | date | | | 0000-00-00 | | | imageAcquisition | int(11) | | MUL | 0 | | | featureDate | date | | | 0000-00-00 | | | featureSoftware | int(11) | | | 0 | | | filename | varchar(255) | | | | | | spots | mediumint(9) | | | 0 | | | hasSpotImages | tinyint(1) | | | 0 | | | spotImagePixels | smallint(6) | | | 15 | | | spotImageOffsetX | float | | | 0 | | | spotImageOffsetY | float | | | 0 | | | spotImageScale | float | | | 1 | | | wizzzard | int(11) | | | 0 | | | removed | tinyint(1) | | | 3 | | | gid | int(11) | | | 0 | | | groupAccess | tinyint(1) | | | 0 | | | worldAccess | tinyint(1) | | | 0 | | | arrayType | int(11) | YES | | NULL | | | positionMode | tinyint(4) | | | 0 | | +------------------+--------------+------+-----+------------+----------------+RawBioAssayData
+-------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------+-------+ | rawBioAssay | mediumint(9) | | PRI | 0 | | | position | mediumint(9) | | PRI | 0 | | | element | mediumint(9) | | | 0 | | | reporter | mediumint(9) | | | 0 | | | block | smallint(6) | YES | | NULL | | | numCol | tinyint(4) | YES | | NULL | | | numRow | tinyint(4) | YES | | NULL | | | x | float | | | 0 | | | y | float | | | 0 | | | dia | float | YES | | NULL | | | FCh1Median | float | YES | | NULL | | | FCh1Mean | float | YES | | NULL | | | FCh1SD | float | YES | | NULL | | | BCh1Median | float | YES | | NULL | | | BCh1Mean | float | YES | | NULL | | | BCh1SD | float | YES | | NULL | | | percCh1SD1 | tinyint(4) | YES | | NULL | | | percCh1SD2 | tinyint(4) | YES | | NULL | | | percCh1Sat | tinyint(4) | YES | | NULL | | | FCh2Median | float | YES | | NULL | | | FCh2Mean | float | YES | | NULL | | | FCh2SD | float | YES | | NULL | | | BCh2Median | float | YES | | NULL | | | BCh2Mean | float | YES | | NULL | | | BCh2SD | float | YES | | NULL | | | percCh2SD1 | tinyint(4) | YES | | NULL | | | percCh2SD2 | tinyint(4) | YES | | NULL | | | percCh2Sat | tinyint(4) | YES | | NULL | | | ratiosSD | float | YES | | NULL | | | rgnRatio | float | YES | | NULL | | | rgnR2 | float | YES | | NULL | | | FPixels | smallint(6) | YES | | NULL | | | BPixels | smallint(6) | YES | | NULL | | | flags | tinyint(4) | YES | | NULL | | | MValue | float | YES | | NULL | | | CV | float | YES | | NULL | | +-------------+--------------+------+-----+---------+-------+RawBioAssayHeader
+-------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+------------+------+-----+---------+-------+ | rawBioAssay | int(11) | | PRI | 0 | | | fileHeader | mediumtext | | | | | +-------------+------------+------+-----+---------+-------+Reporter
+---------------+--------------+------+-----+---------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+--------------+------+-----+---------------------+----------------+ | id | mediumint(9) | | PRI | NULL | auto_increment | | reporterId | varchar(255) | | UNI | | | | species | varchar(255) | | | | | | clusterId | int(11) | | | 0 | | | geneName | varchar(255) | | MUL | | | | geneSymbol | varchar(255) | | | | | | lastUpdate | datetime | | | 0000-00-00 00:00:00 | | | length | int(11) | YES | | 0 | | | sequence | text | YES | | NULL | | | vector | text | YES | | NULL | | | tissue | text | YES | | NULL | | | library | text | YES | | NULL | | | accession | varchar(255) | YES | | NULL | | | nid | varchar(255) | YES | | NULL | | | chromosome | varchar(255) | YES | | NULL | | | cytoBand | varchar(255) | YES | | NULL | | | markers | varchar(255) | YES | | NULL | | | antibiotics | varchar(255) | YES | | NULL | | | locusLink | int(11) | YES | | 0 | | | omim | int(11) | YES | | 0 | | | startPosition | int(11) | YES | | 0 | | | endPosition | int(11) | YES | | 0 | | +---------------+--------------+------+-----+---------------------+----------------+ReporterList
+------------+-------------+------+-----+------------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+------------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | name | varchar(80) | | | | | | descr | text | | | | | | owner | int(11) | | | 0 | | | addedDate | date | | | 0000-00-00 | | | experiment | int(11) | | MUL | 0 | | | reporters | int(11) | | | 0 | | | removed | tinyint(1) | | | 3 | | +------------+-------------+------+-----+------------+----------------+Sample
+-------------+-------------+------+-----+------------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+------------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | name | varchar(80) | | MUL | | | | descr | text | | | | | | tissue | int(11) | | | 0 | | | owner | int(11) | | | 0 | | | addedDate | date | | | 0000-00-00 | | | sampleDate | date | | | 0000-00-00 | | | removed | tinyint(1) | | | 0 | | | gid | int(11) | | | 0 | | | groupAccess | tinyint(1) | | | 0 | | | worldAccess | tinyint(1) | | | 0 | | +-------------+-------------+------+-----+------------+----------------+SampleAnnotation
+----------------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------+------+-----+---------+-------+ | sample | int(11) | | PRI | 0 | | | annotationType | int(11) | | PRI | 0 | | | annotation | text | | | | | +----------------+---------+------+-----+---------+-------+SampleAnnotationType
+--------------+-----------------------+------+-----+------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-----------------------+------+-----+------------+----------------+
| id | int(11) | | PRI | NULL | auto_increment |
| name | varchar(80) | | MUL | | |
| valueType | enum('i','f','t','e') | | | i | |
| options | text | | | | |
| defaultValue | text | | | | |
| descr | text | | | | |
| owner | int(11) | | | 0 | |
| addedDate | date | | | 0000-00-00 | |
| removed | tinyint(1) | | | 0 | |
| gid | int(11) | | | 0 | |
| groupAccess | tinyint(1) | | | 0 | |
| worldAccess | tinyint(1) | | | 0 | |
+--------------+-----------------------+------+-----+------------+----------------+
SampleTissue
+-----------+-------------+------+-----+------------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+------------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | parent | int(11) | | MUL | 0 | | | name | varchar(80) | | | | | | descr | text | | | | | | owner | int(11) | | | 0 | | | addedDate | date | | | 0000-00-00 | | | removed | tinyint(1) | | | 0 | | +-----------+-------------+------+-----+------------+----------------+SchemaVersion
+---------------+----------+------+-----+---------------------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+----------+------+-----+---------------------+-------+ | baseVersion | tinytext | | | | | | schemaVersion | tinytext | | | | | | lastChanged | datetime | | | 0000-00-00 00:00:00 | | +---------------+----------+------+-----+---------------------+-------+Search
+-------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | sortField | varchar(80) | | | | | | sortDesc | tinyint(1) | | | 0 | | | currentPage | smallint(6) | | | 0 | | +-------------+-------------+------+-----+---------+----------------+SearchCriterion
+--------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+-------------+------+-----+---------+----------------+ | search | int(11) | | PRI | 0 | | | position | smallint(6) | | PRI | NULL | auto_increment | | field | varchar(80) | | | | | | op | tinyint(4) | | | 0 | | | searchString | text | | | | | +--------------+-------------+------+-----+---------+----------------+Software
+-------------+-------------+------+-----+------------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+------------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | name | varchar(80) | | MUL | | | | descr | text | | | | | | owner | int(11) | | | 0 | | | addedDate | date | | | 0000-00-00 | | | version | varchar(80) | | | | | | removed | tinyint(1) | | | 0 | | | gid | int(11) | | | 0 | | | groupAccess | tinyint(1) | | | 0 | | | worldAccess | tinyint(1) | | | 0 | | +-------------+-------------+------+-----+------------+----------------+TemplateBioAssayData
+------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+--------------+------+-----+---------+-------+ | bioAssay | mediumint(9) | | PRI | 0 | | | position | mediumint(9) | | PRI | 0 | | | reporter | mediumint(9) | | | 0 | | | intensity1 | float | | | 0 | | +------------+--------------+------+-----+---------+-------+TemplateBioAssayExtraFloat
+-----------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+--------------+------+-----+---------+-------+ | bioAssay | mediumint(9) | | PRI | 0 | | | position | mediumint(9) | | PRI | 0 | | | extraDataColumn | smallint(6) | | PRI | 0 | | | extraValue | float | YES | | NULL | | +-----------------+--------------+------+-----+---------+-------+TemplateBioAssayExtraString
+-----------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+--------------+------+-----+---------+-------+ | bioAssay | mediumint(9) | | PRI | 0 | | | position | mediumint(9) | | PRI | 0 | | | extraDataColumn | smallint(6) | | PRI | 0 | | | extraValue | mediumtext | YES | | NULL | | +-----------------+--------------+------+-----+---------+-------+TemplateBioAssaySetGene
+-------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------+-------+ | bioAssaySet | mediumint(9) | | PRI | 0 | | | reporter | mediumint(9) | | PRI | 0 | | | cnt | smallint(11) | | | 0 | | +-------------+--------------+------+-----+---------+-------+TemplateBioAssaySetPosGene
+-------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------+-------+ | bioAssaySet | mediumint(9) | | PRI | 0 | | | reporter | mediumint(9) | | PRI | 0 | | | position | mediumint(9) | | PRI | 0 | | | cnt | smallint(11) | | | 0 | | +-------------+--------------+------+-----+---------+-------+TemplateReporterListRow
+--------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+--------------+------+-----+---------+-------+ | reporterList | mediumint(9) | | PRI | 0 | | | reporter | mediumint(9) | | PRI | 0 | | | score | float | | | 0 | | +--------------+--------------+------+-----+---------+-------+Transformation
+-------------+-------------+------+-----+------------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+------------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | name | varchar(80) | | | | | | descr | text | | | | | | owner | int(11) | | | 0 | | | addedDate | date | | | 0000-00-00 | | | bioAssaySet | int(11) | | MUL | 0 | | | isFilter | tinyint(1) | | | 0 | | | removed | tinyint(1) | | | 3 | | +-------------+-------------+------+-----+------------+----------------+TransformationCollapse
+----------------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------+------+-----+---------+-------+ | owner | int(11) | | PRI | 0 | | | transformation | int(11) | | PRI | 0 | | +----------------+---------+------+-----+---------+-------+TransformationSearch
+------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+---------+-------+ | item | int(11) | | MUL | 0 | | | searchType | varchar(80) | | | | | | search | int(11) | | PRI | 0 | | +------------+-------------+------+-----+---------+-------+Upload
+-------------+--------------+------+-----+---------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------------------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | owner | int(11) | | MUL | 0 | | | name | varchar(255) | YES | | NULL | | | fileSize | int(11) | | | 0 | | | descr | text | | | | | | addedDate | datetime | | | 0000-00-00 00:00:00 | | | mimeType | varchar(100) | | | | | | removed | tinyint(1) | | | 3 | | | gid | int(11) | | | 0 | | | groupAccess | tinyint(1) | | | 0 | | | worldAccess | tinyint(1) | | | 0 | | +-------------+--------------+------+-----+---------------------+----------------+UserAccount
+----------------------+--------------+------+-----+------------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------------+--------------+------+-----+------------+-------+ | userGroup | int(11) | | PRI | 0 | | | email | varchar(255) | | | | | | address | text | | | | | | phone | varchar(60) | | | | | | fax | varchar(60) | | | | | | realName | varchar(80) | | | | | | md5Pass | varchar(40) | | | | | | activeUntil | date | | | 9999-12-31 | | | fileQuota | double | | | -1 | | | lastExperiment | int(11) | | | 0 | | | lastExploredSet | int(11) | | | 0 | | | lastPlateType | int(11) | | | 0 | | | lastPlateTypeCreated | int(11) | | | 0 | | | defaultGid | int(11) | | | 0 | | | defaultGroupAccess | tinyint(1) | | | 0 | | | defaultWorldAccess | tinyint(1) | | | 0 | | +----------------------+--------------+------+-----+------------+-------+UserGroup
Class: MigrateUser
+------------+-------------+------+-----+------------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+------------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | name | varchar(30) | YES | MUL | NULL | | | descr | text | | | | | | owner | int(11) | | | 0 | | | addedDate | date | | | 0000-00-00 | | | removed | tinyint(1) | | | 0 | | | accessMask | int(11) | | | 0 | | | isAccount | tinyint(1) | | | 0 | | +------------+-------------+------+-----+------------+----------------+UserGroupParent
+------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+------------+------+-----+---------+-------+ | child | int(11) | | PRI | 0 | | | parent | int(11) | | PRI | 0 | | | isReviewer | tinyint(1) | | | 0 | | +------------+------------+------+-----+---------+-------+UserSearch
+------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+---------+-------+ | item | int(11) | | MUL | 0 | | | searchType | varchar(80) | | | | | | search | int(11) | | PRI | 0 | | +------------+-------------+------+-----+---------+-------+Well
+-----------------+------------------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+------------------------------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL | auto_increment |
| parent | int(11) | | | 0 | |
| plate | mediumint(9) | | MUL | 0 | |
| x | smallint(6) | | | 0 | |
| y | smallint(6) | | | 0 | |
| probe | int(11) | | MUL | 0 | |
| seqVerified | enum('','good','bad','failed') | | | | |
| bands | enum('','good','missing','double') | | | | |
| bacterialGrowth | enum('','yes','no') | | | | |
| comment | text | | | | |
+-----------------+------------------------------------+------+-----+---------+----------------+
WellAncestor
+----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+---------+-------+ | well | int(11) | | PRI | 0 | | | ancestor | int(11) | | PRI | 0 | | | depth | smallint(6) | | | 0 | | +----------+-------------+------+-----+---------+-------+Wizzzard
+----------------+-------------+------+-----+------------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------+------+-----+------------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | owner | int(11) | | | 0 | | | formatType | varchar(40) | | MUL | | | | name | varchar(80) | | | | | | minCols | smallint(6) | | | 0 | | | maxCols | smallint(6) | | | 0 | | | dataHeader | text | | | | | | typeHeader | text | | | | | | typeHeaderLine | int(11) | | | 0 | | | mapping | mediumtext | | | | | | descr | text | | | | | | addedDate | date | | | 0000-00-00 | | | removed | tinyint(1) | | | 0 | | | gid | int(11) | | | 0 | | | groupAccess | tinyint(1) | | | 0 | | | worldAccess | tinyint(1) | | | 0 | | | dataFooter | text | YES | | NULL | | | fieldSeparator | varchar(10) | | | | | | maxHeaderLine | int(11) | | | 120 | | +----------------+-------------+------+-----+------------+----------------+