Return-path: <pullrequests-reply@bitbucket.org>
Envelope-to: javier@ssf.com.mx
Delivery-date: Wed, 06 Jan 2016 11:25:48 -0600
Received: from lb01-ash.bitbucket.org ([131.103.20.165]:46340 helo=lb01.bitbucket.org)
	by vishnu.hosting-mexico.net with esmtps (TLSv1.2:DHE-RSA-AES256-GCM-SHA384:256)
	(Exim 4.86)
	(envelope-from <pullrequests-reply@bitbucket.org>)
	id 1aGrq9-002yoV-Vd
	for javier@ssf.com.mx; Wed, 06 Jan 2016 11:25:45 -0600
Received: from celery-worker-101.ash1.bb-inf.net (node01-c.ash-private.bitbucket.org [172.17.10.43])
	by lb01.bitbucket.org (Postfix) with ESMTP id 8EB50A8346A
	for <javier@ssf.com.mx>; Wed,  6 Jan 2016 17:25:02 +0000 (UTC)
Received: from celery-worker-101.ash1.bb-inf.net (localhost.localdomain [127.0.0.1])
	by celery-worker-101.ash1.bb-inf.net (Postfix) with ESMTP id 90EB8225744
	for <javier@ssf.com.mx>; Wed,  6 Jan 2016 17:25:02 +0000 (UTC)
Content-Type: multipart/alternative;
 boundary="===============6933652854191154279=="
MIME-Version: 1.0
Subject: Re: [Bitbucket] Pull request #11: Serial superv traslado unidad
 unidadequipoelectr servicio servicioelectr vitllanta (globalgassf/globalnet3)
From: "isaiaslee" <pullrequests-reply@bitbucket.org>
To: javier@ssf.com.mx
Date: Wed, 06 Jan 2016 17:25:02 -0000
Auto-Submitted: auto-generated
Message-ID: <pr-globalgassf/globalnet3/11/updated/518f26d330254539b4fcd7b3da8e9bd8@bitbucket.org>
References: <pr-globalgassf/globalnet3/11@bitbucket.org>
Precedence: bulk
In-Reply-To: <pr-globalgassf/globalnet3/11@bitbucket.org>
X-Spam-Status: No, score=-2.3
X-Spam-Score: -22
X-Spam-Bar: --
X-Ham-Report: Spam detection software, running on the system "vishnu.hosting-mexico.net",
 has NOT identified this incoming email as spam.  The original
 message has been attached to this so you can view it or label
 similar future email.  If you have any questions, see
 root\@localhost for details.
 
 Content preview:  --- you can reply above this line --- Pull request #11 has
    been updated by isaiaslee to include new changes. https://bitbucket.org/globalgassf/globalnet3/pull-requests/11/serial-superv-traslado-unidad
    [...] 
 
 Content analysis details:   (-2.3 points, 5.0 required)
 
  pts rule name              description
 ---- ---------------------- --------------------------------------------------
  0.0 URIBL_BLOCKED          ADMINISTRATOR NOTICE: The query to URIBL was blocked.
                             See
                             http://wiki.apache.org/spamassassin/DnsBlocklists#dnsbl-block
                              for more information.
                             [URIs: atlassian.com]
 -2.3 RCVD_IN_DNSWL_MED      RBL: Sender listed at http://www.dnswl.org/, medium
                              trust
                             [131.103.20.165 listed in list.dnswl.org]
 -0.0 RCVD_IN_MSPIKE_H4      RBL: Very Good reputation (+4)
                             [131.103.20.165 listed in wl.mailspike.net]
 -0.0 SPF_PASS               SPF: sender matches SPF record
 -0.0 RP_MATCHES_RCVD        Envelope sender domain matches handover relay domain
  0.0 HTML_MESSAGE           BODY: HTML included in message
 -0.0 RCVD_IN_MSPIKE_WL      Mailspike good senders
X-Spam-Flag: NO

--===============6933652854191154279==
MIME-Version: 1.0
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 8bit

--- you can reply above this line ---

Pull request #11 has been updated by isaiaslee to include new changes.

https://bitbucket.org/globalgassf/globalnet3/pull-requests/11/serial-superv-traslado-unidad

Title: Serial superv traslado unidad unidadequipoelectr servicio servicioelectr vitllanta

Creator: javierssf

```
#!sql

ALTER TABLE `globalnet`.`traslado` 
DROP FOREIGN KEY `fk_traslado_planta`;
ALTER TABLE `globalnet`.`traslado` 
DROP COLUMN `id_planta`,
DROP INDEX `fk_traslado_planta_idx` ;

ALTER TABLE `globalnet`.`vitalizacion_llanta` 
DROP FOREIGN KEY `fk_vitalizacion_llanta_planta`;
ALTER TABLE `globalnet`.`vitalizacion_llanta` 
DROP COLUMN `id_planta`,
DROP INDEX `fk_vitalizacion_llanta_planta` ;


ALTER TABLE `globalnet`.`supervision` 
DROP FOREIGN KEY `fk_supervision_planta`;
ALTER TABLE `globalnet`.`supervision` 
DROP COLUMN `id_planta`,
DROP INDEX `fk_supervision_planta_idx` ;

ALTER TABLE `globalnet`.`servicio` 
DROP FOREIGN KEY `fk_servicio_planta`;
ALTER TABLE `globalnet`.`servicio` 
DROP COLUMN `id_planta`,
DROP INDEX `fk_servicio_planta_idx` ;

ALTER TABLE `globalnet`.`unidad_equipo_electronico` 
DROP FOREIGN KEY `fk_unidad_equipo_electronico_planta`;
ALTER TABLE `globalnet`.`unidad_equipo_electronico` 
DROP COLUMN `id_planta`,
DROP INDEX `fk_unidad_equipo_electronico_planta_idx` ;


ALTER TABLE `globalnet`.`servicio_electronico` 
DROP FOREIGN KEY `fk_servicio_electronico_planta`;
ALTER TABLE `globalnet`.`servicio_electronico` 
DROP COLUMN `id_planta`,
DROP INDEX `fk_servicio_electronico_planta_idx` ;

ALTER TABLE `globalnet`.`serie` 
DROP FOREIGN KEY `fk_serie_planta`;
ALTER TABLE `globalnet`.`serie` 
DROP COLUMN `id_planta`,
DROP INDEX `fk_serie_planta_idx` ;
```

Quitar factory a : 

35.- serie
Alta
36.- servicio
Baja
37.- sericio_electronico
Alta
38.- supervision
Baja
39.- traslado
Baja
40.- unidad
Alta
41.- unidad_equipo_electronico 
Baja
42.- vitalizacion_llanta
Baja

Updated list of changes:

d213c4635fd2 by isaiaslee: "Merged in changeUuidToBigintSaleAndInvoice (pull request #17)

Se cambia UUID a …"
832c24bb04a0 by hgojim: "Se corrige ServiceDAO"
83179520f853 by hgojim: "Se corrigen congflictos"
f7816e71152d by hgojim: "Se completa el cambio de UUID a Long en Service, Account, y HiddenAccount. Tambi…"
2c3fa60260a7 by hgojim: "Merge branch 'develop' of https://bitbucket.org/globalgassf/globalnet3 into chan…"
... and 3 more.



--

Unwatch this pull request to stop receiving email updates:
https://bitbucket.org/globalgassf/globalnet3/pull-requests/11/unwatch/javierssf/ad2cac00e83be9739703bd241247625da691e0d4/

--===============6933652854191154279==
MIME-Version: 1.0
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: 8bit

<!DOCTYPE HTML>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    
  </head>
  <body style="font: 14px/1.4285714 Arial, sans-serif; color: #333;">
    <table style="width: 100%; border-collapse: collapse;">
      <tbody>
        <tr>
          <td style="background: #f5f5f5; padding: 10px 10px 0; font: 14px/1.4285714 Arial, sans-serif;">
            <table style="width: 100%; border-collapse: collapse;">
              <tbody>
                
                
                
                
                  
                     <tr>
  <td id="main" style="font: 14px/1.4285714 Arial, sans-serif; padding: 0; background-color: #ffffff; border-radius: 5px">
    <div style="border: 1px solid #cccccc; border-radius: 5px; padding: 20px">
      <table style="width: 100%; border-collapse: collapse">
        <tbody>
          <tr>
            <td style="font: 14px/1.4285714 Arial, sans-serif; padding: 0">
              <table style="width: 100%; border-collapse: collapse">
                <tbody>
                  <tr>
                    <td id="avatar" style="font: 14px/1.4285714 Arial, sans-serif; padding: 0; width: 32px; vertical-align: top">
                      
                      <img width="32" height="32" alt="isaiaslee" src="https://avatar-cdn.atlassian.com/8c6bab37d1e96040e96aeef13efba83c?s=32&amp;ts=1452100305" style="border-radius: 3px">
                      
                    </td>
                    <td id="content" style="font: 14px/1.4285714 Arial, sans-serif; padding: 0 0 0 10px">
                      
<table style="width: 100%; border-collapse: collapse">
  <tr>
    <td class="user-action" style="font: 14px/1.4285714 Arial, sans-serif; padding: 0; line-height: 1">
      <span>
        
          <strong>isaiaslee</strong> updated pull request #11:
        
      </span>
    </td>
  </tr>
  <tr>
    <td class="title" style="font: 14px/1.4285714 Arial, sans-serif; padding: 5px 0 0; font-weight: bold; line-height: 1.2">
      <a href="https://bitbucket.org/globalgassf/globalnet3/pull-requests/11/serial-superv-traslado-unidad" style="color: #3572b0; text-decoration: none">Serial superv traslado unidad unidadequipoelectr servicio servicioelectr vitllanta</a>
    </td>
  </tr>
  <tr>
    <td class="commit-list-container" style="font: 14px/1.4285714 Arial, sans-serif; padding: 10px 0 20px">
      

<table class="commit-list" style="width: 100%; border-collapse: collapse">
  <tr>
    <th class="user" style="border-bottom: 1px solid #ccc; text-align: left; font-weight: bold; padding: 5px; width: 132px">Author</th>
    <th class="commit" style="border-bottom: 1px solid #ccc; text-align: left; font-weight: bold; padding: 5px; width: 50px">Commit</th>
    <th class="message" style="border-bottom: 1px solid #ccc; text-align: left; font-weight: bold; padding: 5px">Message</th>
    <th class="date" style="border-bottom: 1px solid #ccc; text-align: left; font-weight: bold; padding: 5px; width: 100px">Date</th>
  </tr>
  
    <tr>
      <td class="user" style="font: 14px/1.4285714 Arial, sans-serif; padding: 5px; border-bottom: 1px solid #ccc; line-height: 24px; color: #707070; width: 132px">
        
          
            
              <img height="24" width="24" alt="isaiaslee" src="https://avatar-cdn.atlassian.com/8c6bab37d1e96040e96aeef13efba83c?s=24&amp;ts=1452038855" style="vertical-align: top; border-radius: 3px">
            
            <span style="padding: 0 0 0 5px">isaiaslee</span>
          
        
      </td>
      <td class="commit" style="font: 14px/1.4285714 Arial, sans-serif; padding: 5px; border-bottom: 1px solid #ccc; line-height: 24px; color: #707070; width: 50px; font-family: Monaco, monospace; font-size: 12px">
        
        <a href="https://bitbucket.org/globalgassf/globalnet3/commits/d213c4635fd2a06cc1bc8cb6098a6171fc246c60" style="color: #3572b0; text-decoration: none">d213c46</a>
      </td>
      <td class="message" style="font: 14px/1.4285714 Arial, sans-serif; padding: 5px; border-bottom: 1px solid #ccc; line-height: 24px; color: #707070">
        Merged in changeUuidToBigintSaleAndInvoice (pull request #17)
      </td>
      <td class="date" style="font: 14px/1.4285714 Arial, sans-serif; padding: 5px; border-bottom: 1px solid #ccc; line-height: 24px; color: #707070; width: 100px">
        <div>
          6 Jan 2016
        </div>
      </td>
    </tr>
  
    <tr>
      <td class="user" style="font: 14px/1.4285714 Arial, sans-serif; padding: 5px; border-bottom: 1px solid #ccc; line-height: 24px; color: #707070; width: 132px">
        
          
            
              <img height="24" width="24" alt="hgojim" src="https://avatar-cdn.atlassian.com/fa5c0a08f4992090fe0bcb2629ccacbb?s=24&amp;ts=1452035133" style="vertical-align: top; border-radius: 3px">
            
            <span style="padding: 0 0 0 5px">hgojim</span>
          
        
      </td>
      <td class="commit" style="font: 14px/1.4285714 Arial, sans-serif; padding: 5px; border-bottom: 1px solid #ccc; line-height: 24px; color: #707070; width: 50px; font-family: Monaco, monospace; font-size: 12px">
        
        <a href="https://bitbucket.org/globalgassf/globalnet3/commits/832c24bb04a093bec97b833c9c9281bca14a2ab8" style="color: #3572b0; text-decoration: none">832c24b</a>
      </td>
      <td class="message" style="font: 14px/1.4285714 Arial, sans-serif; padding: 5px; border-bottom: 1px solid #ccc; line-height: 24px; color: #707070">
        Se corrige ServiceDAO
      </td>
      <td class="date" style="font: 14px/1.4285714 Arial, sans-serif; padding: 5px; border-bottom: 1px solid #ccc; line-height: 24px; color: #707070; width: 100px">
        <div>
          6 Jan 2016
        </div>
      </td>
    </tr>
  
    <tr>
      <td class="user" style="font: 14px/1.4285714 Arial, sans-serif; padding: 5px; border-bottom: 1px solid #ccc; line-height: 24px; color: #707070; width: 132px">
        
          
            
              <img height="24" width="24" alt="hgojim" src="https://avatar-cdn.atlassian.com/fa5c0a08f4992090fe0bcb2629ccacbb?s=24&amp;ts=1452035133" style="vertical-align: top; border-radius: 3px">
            
            <span style="padding: 0 0 0 5px">hgojim</span>
          
        
      </td>
      <td class="commit" style="font: 14px/1.4285714 Arial, sans-serif; padding: 5px; border-bottom: 1px solid #ccc; line-height: 24px; color: #707070; width: 50px; font-family: Monaco, monospace; font-size: 12px">
        
        <a href="https://bitbucket.org/globalgassf/globalnet3/commits/83179520f8535f7038be6b62b47ea1c135cb21ee" style="color: #3572b0; text-decoration: none">8317952</a>
      </td>
      <td class="message" style="font: 14px/1.4285714 Arial, sans-serif; padding: 5px; border-bottom: 1px solid #ccc; line-height: 24px; color: #707070">
        Se corrigen congflictos
      </td>
      <td class="date" style="font: 14px/1.4285714 Arial, sans-serif; padding: 5px; border-bottom: 1px solid #ccc; line-height: 24px; color: #707070; width: 100px">
        <div>
          6 Jan 2016
        </div>
      </td>
    </tr>
  
    <tr>
      <td class="user" style="font: 14px/1.4285714 Arial, sans-serif; padding: 5px; border-bottom: 1px solid #ccc; line-height: 24px; color: #707070; width: 132px">
        
          
            
              <img height="24" width="24" alt="hgojim" src="https://avatar-cdn.atlassian.com/fa5c0a08f4992090fe0bcb2629ccacbb?s=24&amp;ts=1452035133" style="vertical-align: top; border-radius: 3px">
            
            <span style="padding: 0 0 0 5px">hgojim</span>
          
        
      </td>
      <td class="commit" style="font: 14px/1.4285714 Arial, sans-serif; padding: 5px; border-bottom: 1px solid #ccc; line-height: 24px; color: #707070; width: 50px; font-family: Monaco, monospace; font-size: 12px">
        
        <a href="https://bitbucket.org/globalgassf/globalnet3/commits/f7816e71152d41713c6deacf1b6b556e02dd49ab" style="color: #3572b0; text-decoration: none">f7816e7</a>
      </td>
      <td class="message" style="font: 14px/1.4285714 Arial, sans-serif; padding: 5px; border-bottom: 1px solid #ccc; line-height: 24px; color: #707070">
        Se completa el cambio de UUID a Long en Service, Account, y HiddenAccount. También se remueve la pla…
      </td>
      <td class="date" style="font: 14px/1.4285714 Arial, sans-serif; padding: 5px; border-bottom: 1px solid #ccc; line-height: 24px; color: #707070; width: 100px">
        <div>
          6 Jan 2016
        </div>
      </td>
    </tr>
  
    <tr>
      <td class="user" style="font: 14px/1.4285714 Arial, sans-serif; padding: 5px; border-bottom: 1px solid #ccc; line-height: 24px; color: #707070; width: 132px">
        
          
            
              <img height="24" width="24" alt="hgojim" src="https://avatar-cdn.atlassian.com/fa5c0a08f4992090fe0bcb2629ccacbb?s=24&amp;ts=1452035133" style="vertical-align: top; border-radius: 3px">
            
            <span style="padding: 0 0 0 5px">hgojim</span>
          
        
      </td>
      <td class="commit" style="font: 14px/1.4285714 Arial, sans-serif; padding: 5px; border-bottom: 1px solid #ccc; line-height: 24px; color: #707070; width: 50px; font-family: Monaco, monospace; font-size: 12px">
        
        <a href="https://bitbucket.org/globalgassf/globalnet3/commits/2c3fa60260a70df7cacf292ab31de46f37c6ed11" style="color: #3572b0; text-decoration: none">2c3fa60</a>
      </td>
      <td class="message" style="font: 14px/1.4285714 Arial, sans-serif; padding: 5px; border-bottom: 1px solid #ccc; line-height: 24px; color: #707070">
        Merge branch 'develop' of https://bitbucket.org/globalgassf/globalnet3 into changeUuidToBigintSaleAn…
      </td>
      <td class="date" style="font: 14px/1.4285714 Arial, sans-serif; padding: 5px; border-bottom: 1px solid #ccc; line-height: 24px; color: #707070; width: 100px">
        <div>
          4 Jan 2016
        </div>
      </td>
    </tr>
  

  <tr>
    <td colspan="4" style="font: 14px/1.4285714 Arial, sans-serif; padding: 5px; border-bottom: 1px solid #ccc; line-height: 24px; color: #707070">
      
        3 more commits.
      
    </td>
  </tr>

</table>

    </td>
  </tr>
</table>

                    </td>
                  </tr>
                </tbody>
              </table>
            </td>
          </tr>
          
  <tr>
    <td class="actions" colspan="2" style="font: 14px/1.4285714 Arial, sans-serif; padding: 10px 0 0; border-top: 1px solid #cccccc; line-height: 1">
      
      
        
          <a href="https://bitbucket.org/globalgassf/globalnet3/pull-requests/11/serial-superv-traslado-unidad" style="color: #3572b0; text-decoration: none">View this pull request</a> or add a comment by replying to this email.
        
      
    </td>
  </tr>

        </tbody>
      </table>
    </div>
  </td>
</tr>

                  
                
                <tr>
                  

<td style="padding: 20px 0; color: #707070;">
  <table style="width: 100%; border-collapse: collapse;">
    <tbody>
      <tr>
        <td style="padding: 0">
          
            
            
              
              
                
                  <a style="color: #3572b0; text-decoration: none;" href="https://bitbucket.org/globalgassf/globalnet3/pull-requests/11/unwatch/javierssf/ad2cac00e83be9739703bd241247625da691e0d4/">Unwatch this pull request</a> to stop receiving email updates.
                
              
            
          
          
        </td>
        <td style="padding: 0">
          
            

  <img width="1" height="1" src="https://bitbucket.org/account/notifications/mark-read/247870489/89c15c179efedfe4fe4034db844ad436d2d53abd/">


          
        </td>
        <td style="text-align: right; width: 100px; padding: 0">
          <a href="https://bitbucket.org" style="color: #3572b0; text-decoration: none;">
            <img width="100" height="18" src="https://d3oaxc4q5k2d6q.cloudfront.net/m/053380c3a1ac/img/email/logo.gif" alt="Bitbucket" />
          </a>
        </td>
      </tr>
    </tbody>
  </table>
</td>

                </tr>
              </tbody>
            </table>
          </td>
        </tr>
      </tbody>
    </table>
  </body>
</html>

--===============6933652854191154279==--
