Return-path: <pullrequests-reply@bitbucket.org>
Envelope-to: javier@ssf.com.mx
Delivery-date: Tue, 05 Jan 2016 11:12:35 -0600
Received: from lb01-ash.bitbucket.org ([131.103.20.165]:21264 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 1aGV9r-000pSq-8v
	for javier@ssf.com.mx; Tue, 05 Jan 2016 11:12:35 -0600
Received: from celery-worker-102.ash1.bb-inf.net (db04.ash-private.bitbucket.org [172.17.10.20])
	by lb01.bitbucket.org (Postfix) with ESMTP id 9D558A82822
	for <javier@ssf.com.mx>; Tue,  5 Jan 2016 17:11:54 +0000 (UTC)
Received: from celery-worker-102.ash1.bb-inf.net (localhost.localdomain [127.0.0.1])
	by celery-worker-102.ash1.bb-inf.net (Postfix) with ESMTP id 9C274247AE1
	for <javier@ssf.com.mx>; Tue,  5 Jan 2016 17:11:54 +0000 (UTC)
Content-Type: multipart/alternative;
 boundary="===============1620353827388658530=="
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: Tue, 05 Jan 2016 17:11:54 -0000
Auto-Submitted: auto-generated
Message-ID: <pr-globalgassf/globalnet3/11/updated/d40583c3760d4460869e1e5c2eae62eb@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

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

--- 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:

095f1f034471 by isaiaslee: "Merged in uuidToBigint (pull request #18)

uuid to Bigint - piso comision"
bb60deb3b04b by Othoniel Gutierrez: "uuid to Bigint - postventa y preventa"
82edda713ec9 by Othoniel Gutierrez: "uuid to Bigint - comodante"
edeb36e232dc by Othoniel Gutierrez: "uuid to Bigint - comodatario"
12bc79646c3e by Othoniel Gutierrez: "uuid to Bigint - piso comision - se eliminan referencias"
... and 2 more.



--

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

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

<!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=1452013850" 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=1452013850" 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/095f1f0344710972fff8d4b3be2600fac1d7da99" style="color: #3572b0; text-decoration: none">095f1f0</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 uuidToBigint (pull request #18)
      </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>
          5 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="ogutierrezssg" src="https://bitbucket-assetroot.s3.amazonaws.com/c/photos/2015/Nov/10/3831478476-8-ogutierrezssg-avatar_avatar.png" style="vertical-align: top; border-radius: 3px">
            
            <span style="padding: 0 0 0 5px">Othoniel Gutierrez</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/bb60deb3b04be3c52843025dea5e7ca9d897cb30" style="color: #3572b0; text-decoration: none">bb60deb</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">
        uuid to Bigint - postventa y preventa
      </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>
          5 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="ogutierrezssg" src="https://bitbucket-assetroot.s3.amazonaws.com/c/photos/2015/Nov/10/3831478476-8-ogutierrezssg-avatar_avatar.png" style="vertical-align: top; border-radius: 3px">
            
            <span style="padding: 0 0 0 5px">Othoniel Gutierrez</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/82edda713ec9af24191e7f5aeeb0114ddb83dee0" style="color: #3572b0; text-decoration: none">82edda7</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">
        uuid to Bigint - comodante
      </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 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="ogutierrezssg" src="https://bitbucket-assetroot.s3.amazonaws.com/c/photos/2015/Nov/10/3831478476-8-ogutierrezssg-avatar_avatar.png" style="vertical-align: top; border-radius: 3px">
            
            <span style="padding: 0 0 0 5px">Othoniel Gutierrez</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/edeb36e232dccf655832f73f186aeecd418cb06f" style="color: #3572b0; text-decoration: none">edeb36e</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">
        uuid to Bigint - comodatario
      </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 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="ogutierrezssg" src="https://bitbucket-assetroot.s3.amazonaws.com/c/photos/2015/Nov/10/3831478476-8-ogutierrezssg-avatar_avatar.png" style="vertical-align: top; border-radius: 3px">
            
            <span style="padding: 0 0 0 5px">Othoniel Gutierrez</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/12bc79646c3ef4ce42471b4ea4a1ae54df5ca5dc" style="color: #3572b0; text-decoration: none">12bc796</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">
        uuid to Bigint - piso comision - se eliminan referencias
      </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">
      
        2 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/247340134/2c800917bcd3d2988ac674f39a84622c133ebdac/">


          
        </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/bc3111412fb8/img/email/logo.gif" alt="Bitbucket" />
          </a>
        </td>
      </tr>
    </tbody>
  </table>
</td>

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

--===============1620353827388658530==--
