Return-path: <pullrequests-reply@bitbucket.org>
Envelope-to: javier@ssf.com.mx
Delivery-date: Wed, 30 Dec 2015 18:02:35 -0600
Received: from lb01-ash.bitbucket.org ([131.103.20.165]:22361 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 1aEQhN-0014sl-Pr
	for javier@ssf.com.mx; Wed, 30 Dec 2015 18:02:35 -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 C43F8A81412
	for <javier@ssf.com.mx>; Thu, 31 Dec 2015 00:01:54 +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 C4EBD11142F
	for <javier@ssf.com.mx>; Thu, 31 Dec 2015 00:01:54 +0000 (UTC)
Content-Type: multipart/alternative;
 boundary="===============5848361513619502218=="
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: Thu, 31 Dec 2015 00:01:54 -0000
Auto-Submitted: auto-generated
Message-ID: <pr-globalgassf/globalnet3/11/updated/ff1b734d608440529c1ee31c583c6405@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 T_RP_MATCHES_RCVD      Envelope sender domain matches handover relay
                             domain
 -0.0 SPF_PASS               SPF: sender matches SPF record
  0.0 HTML_MESSAGE           BODY: HTML included in message
 -0.0 RCVD_IN_MSPIKE_WL      Mailspike good senders
X-Spam-Flag: NO

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

65764a9dcdbb by isaiaslee: "Merged in uuidToBigint (pull request #16)

uuid to Bigint - Supervision. Esta op…"
c7b1e4b2348d by Othoniel Gutierrez: "uuid to Bigint - Supervision. Esta opcion falta que envie correctamente un email"




--

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

--===============5848361513619502218==
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=1451520072" 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=1451516940" 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/65764a9dcdbb95015c64868d3111ee95db37520c" style="color: #3572b0; text-decoration: none">65764a9</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 #16)
      </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>
          31 Dec 2015
        </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/c7b1e4b2348d6f4cfbee87dc57cb3a56fe349aa9" style="color: #3572b0; text-decoration: none">c7b1e4b</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 - Supervision. Esta opcion falta que envie correctamente un email
      </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>
          30 Dec 2015
        </div>
      </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/246132593/522890fa22cbee1ba5ae02810e5578c918ec2b5a/">


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

--===============5848361513619502218==--
