Changeset 2992 for trunk/config


Ignore:
Timestamp:
Dec 1, 2006, 3:00:14 PM (15 years ago)
Author:
Johan Enell
Message:

Merged log:branches/2.1#2846:2990 trunk.

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/config/dist/mysql-migration-queries.sql

    r2959 r2992  
    11/*
    2    $Id: mysql-migration-queries.sql 2693 2006-10-03 11:44:54Z nicklas $
     2   $Id: mysql-migration-queries.sql 2973 2006-11-29 09:24:26Z nicklas $
    33
    44  Copyright (C) Authors contributing to this file.
     
    971971  `flags`
    972972FROM  `RawBioAssayData`
    973 WHERE   `rawBioAssay` = ?
    974 ORDER BY `position`
    975 LIMIT   ?,?;
     973WHERE   `rawBioAssay` = ?;
    976974
    977975
     
    979977SELECT `element`, `reporter`, `block`, `numCol`, `numRow`, `x`, `y`
    980978FROM  `RawBioAssayData`
    981 WHERE   `rawBioAssay` = ?
    982 ORDER BY `position`
    983 LIMIT   ?,?;
     979WHERE   `rawBioAssay` = ?;
    984980
    985981
     
    10371033LIMIT   ?, ?;
    10381034
     1035/* getCh1SampleForRawBioAssay */
     1036SELECT s.`id` FROM `Sample` s
     1037INNER JOIN `Extract` e ON e.`sample` = s.`id`
     1038INNER JOIN `LabeledExtract` le ON le.`extract` = e.`id`
     1039INNER JOIN `HybridizedLabeled` hl ON hl.`labeled` = le.`id` AND hl.`channel` = 1
     1040INNER JOIN `ImageAcquisition` ia ON ia.`hybridization` =  hl.`hybridization`
     1041INNER JOIN `RawBioAssay` rba ON rba.`imageAcquisition` = ia.`id`
     1042WHERE rba.`id` = ?;
    10391043
    10401044/* selectRawBioAssaysWithSpotData */
Note: See TracChangeset for help on using the changeset viewer.