[BASH] ERROR line 1: #!/bin/bash: No existe el fichero o el directorio

Este error aparece cuando se editar el archivo agregando el extra fin de carro es decir "\r\n" o el byte (BOM) en la primera linea del archivo, para descubrir que pasa debemos ejecutar el siguiente comando:
$ head -1 yourscript | od -c

and see how it ends: This is wrong

0000000   ï   »   ¿   #   !   /   b   i   n   /   b   a   s   h  \n
0000017

This is correct:
0000000   #   !   /   b   i   n   /   b   a   s   h  \n

Use dos2unix to fix your script if this is the issue. Esto ocurre por editar los archivos con un editor de texto gráfico como el Kate con la opción activa de Herramientas-> "Añadir marca de orden de byte(BOM)"

[SOA] Oracle JDeveloper install soporte para OSB

Instalando soporte para SOA al Jdeveloper:

Primero descargar la version 11g de :


chmod 775 jdevstudio11116install.bin 
luxo@luxo-Vostro-3460:~/Descargas$ ./jdevstudio11116install.bin 
Extracting 0%....................................................................................................100%

Jdeveloper Downloads

Ir a HELP-> Check for Updates-> next->  next-> Instalar las siguientes versiones extensiones:

  • Oracle SOA Composite Editor
  • Oracle BPM Studio
  • Spring & Oracle Weblogic SCA 


Reiniciar IDE,luego:

Steps in JDeveloper 1. Create DB Connection in JDeveloper. 2. Create a Generic Project. 3. Create Project as SOA project and use Empty Composite.

Steps to create DB Adaptor

Go to Composite Palette and choose AD Adaptor. Drag and drop the DB Adaptor in the External Reference section (right side of Composite view). It will open a wizard for selecting the connection and Other DB related process. Give name to service that you want to create Choose the DB Connection you have created already. Move one with selecting your desired choice of Stored Procedure or Table (insert/Select) functionality that you want your web service to perform. If you choose Table insert/Select then you can also choose the relation between tables as optional step. Try to keep all steps default if you do not want any special features. Once you finish all steps in wizard, then it will generate whole lot of files under your Project. Look for 4 main files .jca, xsd/.xsd, *.mapping.xml, *.wsdl If you see all these files generated well in your project then you are all set and we can move ahead. If not then look for the issue.

Steps in WLS Console Create Data Source

1.Go to Left panel and choose Data Source. 2. Select New -- Generic Data Source 3. Give Name as you wish but for JNDI Name you have to use the connection name from the *.JCA file that you already have. Open the jca file and search for the ‘UIConnectionName’. This value will be used as JNDI name in data source creation. 4. Choose Driver as oracle.jdbc.xa.client.OracleXADataSource 5. Use the host and Port and other details that you had selected during DB Connection (in JDeveloper). This is obvious step. 6. Choose target AdminServer. 7. If you finish everything correctly. You are all set here and you can choose to test the connection and should be Test Success.

Configure the DB Adaptor

Go to Deployment on left hand panel. In Deployed services. Search for DbAdaptor. Click on the name DbAdaptor. Select Configuration tab. And under it choose Outbound Connection Pool. Here you will see (javax.resource.cci.ConnectionFactory) Click on new.

Choose javax.resource.cci.ConnectionFactory Next page will ask for JNDI Name. For this, you have to go to your *.jca file and choose the value which is already there for Connection-factory as Location (like connection-factory location=?). Use the value of Location as JNDI Name. Transaction will be No Transaction. Choose this for now. This is need basis selection. Leave other selection as is and then Finish.

Note : Once you finish. Go to Properties Tab again and look for a property name : xADataSourceName. Its value should be the same as UIConnectionName that you have in *.jca file. It should be populated. If not then you can set now as well. You have to double click on the value section and then write the name and press enter. Then Save it. With above all steps we have set the DbAdaptor to point to same DB where we have our table/store procedure.

[XML]Apache Commons XMLConfiguration fetch Object list?

Como se puede cargar un archivo de texto plano a XML, la libreria org.apache.commons.configuration, pero que pasa con los XML que tienen varios niveles dentro del Tag raíz?
EJ:
  
      
 VOZ
 servicio de voz
 OBO,4:OBI,2:OICK,0:OBSSM,0:OSB1,0
 OBO,1:OBI,2:OICK,0:OBSSM,1:OSB1,1
 1
      
      
 Llamadas a Moviles
 Servicio de llamadas a móviles
 OBO,0
 OBO,2
 1
      
      
 700
 Servicio de llamada a 700
 OBOPRE,0
 OBOPRE,1
 1
      
      
   LDI
   Larga distancia Internacional
   OBOPRI,0
   OBOPRI,1
   1
      
      
   300
   Servicio llamadas a 300
   OSB3,0
   OSB3,1
   1
      
  

Para recórrelas solo vasta:

List listaServicios = arch.config.getList("servicios.servicio.codigo");

int nunRowPcsFile = listaServicios.size();
        log.info("Cantidad de servicios Leidos del archivo de configuracion:"+nunRowPcsFile);
        int i = 0;

        registrosTbl = new RequestConsulta[nunRowPcsFile];

        if (nunRowPcsFile != 0) {

            for (String rs : listaServicios) {

                RequestConsulta datosObj = new RequestConsulta();
                String codigo=arch.config.getString("servicios.servicio(" + i + ").codigo");
                datosObj.setCodigo(codigo);
                String on=arch.config.getString("servicios.servicio(" + i + ").servicio_on");
                datosObj.setActivacion(on);
                String off=arch.config.getString("servicios.servicio(" + i + ").servicio_off");
                datosObj.setDesactivacion(off);               
                registrosTbl[i] = datosObj;
                i++;

            }

        }

PD: código funciona para java >= 1.6

INFO:INFO API

Instalar Decompiler Java Ubuntu 14.10


Al ejecutar el decompiler de java JD-GUI da este error:
./jd-gui: error while loading shared libraries: libgtk-x11-2.0.so.0: cannot open shared object file: No such file or directory

Solucion instalar las liberias X11 del GTK:
sudo apt-get install libgtk2.0-0:i386 libxxf86vm1:i386 libsm6:i386 lib32stdc++6

[Weblogic] Respaldar un dominio weblogic

$MW_HOME/wlserver_[version]/common/bin pack -domain =path_of_domain -template=path_of_jara_file_to_create -template_name=”template_name” [-template_author="author"][-template_desc="description"] [-managed=true|false][-log=log_file] [-log_priority=log_priority]






Syntax of the Pack Command
Default value for -managed is false
En el caso de claro estan usando un dominio con un manager de nodos por lo que la opcion managed debe ser true.

Bug Disable Menu Compile en NETBEANS 8.0 en LInux


Product Version: NetBeans IDE 8.0 (Build 201403101706)
Updates: NetBeans IDE is updated to version NetBeans 8.0 Patch 1.1
Java: 1.7.0_51; OpenJDK 64-Bit Server VM 24.45-b08
Runtime: OpenJDK Runtime Environment 1.7.0_51-b00
System: Linux version 3.11.0-19-generic running on amd64; UTF-8; es_CL (nb)
User directory: /home/luxo/.netbeans/8.0
Cache directory: /home/luxo/.cache/netbeans/8.0



The cache is located in /home/luxo/.cache/netbeans/8.0/var/cache. Deleting this directory should clear the cache for you.

how to reset weblogic password

http://www.oracle-base.com/articles/11g/reset-the-adminserver-password-in-weblogic-11g-and-12c.php
En mi caso:
export MW_HOME=/home/luxo/Oracle/Middleware

export DOMAIN_HOME=$MW_HOME/user_projects/domains/berr

$DOMAIN_HOME/bin/stopWebLogic.sh

mv $DOMAIN_HOME/servers/AdminServer/data $DOMAIN_HOME/servers/AdminServer/data-old .

$DOMAIN_HOME/bin/setDomainEnv.sh

cd $DOMAIN_HOME/security

java weblogic.security.utils.AdminAccount weblogic allware123 .

ERROR Readline Java File UTF8

Este error ocurre cuando se lee un archivo de texto guardado en sistemas operativos UNIX/LINUX en donde se guardan ciertos byte que le dan la codificación UTF-8, lo cual entorpece la comparación del método a byte[] incluya estos caracteres haciendo que una simple comparación de String sea distinta a lo esperado.

    /**
 * 
 * 
 * @param s string a remover caracter UTF8
 * @return 
 */
    private static String removeUTF8BOM(String s) {
        if (s.startsWith("\uFEFF")) {
            s = s.substring(1);
        }
        return s;
    } 

por ejemplo una aplicacion seria:
BufferedReader reader = new BufferedReader(new FileReader(files[i]));
                String header = readLine(reader);
                reader.close();

                String fileRegistroDebloqueo;
                String fileDesbloqueoDebloqueo;
                header = removeUTF8BOM(header);
                header = header.toUpperCase();
                if (header.equals("CUENTA")) {
                    compania = "CLARO";
                } else {
                    compania = extractCompany(files[i]);
                }
 


Oracle Linux BETA

OracleLinux-R7-U0-BETA-Everything-x86_64-dvd.iso (4,785,700,864 bytes)

The early development builds of Oracle Linux 7 are provided for testing purpose only.  The build includes two kernels: 
  • The Unbreakable Enterprise Kernel Release 3 Update 2 (beta release)
  • Red Hat compatible kernel. 
This beta release should not be used in production environments.

Linux Container packages for Unbreakable Enterprise Kernel Release 3 

Download  lxc-1.0.3-2.0.2.el7.x86_64.rpm (200,632 bytes)
Download  lxc-devel-1.0.3-2.0.2.el7.x86_64.rpm (17,452 bytes)
Download  lxc-libs-1.0.3-2.0.2.el7.x86_64.rpm(181,952 bytes)

CVE-2014-0160:  Security Update for openSSL (Heartbleed)

Oracle Linux is an open source operating system available under the GNU General Public License (GPL).  Oracle Linux is optimized for Oracle hardware and software and offers zero-downtime kernel updates with Ksplice and enterprise tracing and diagnostic capabilities with DTrace.  Oracle Linux is free to download, free to distribute and free to use.  All errata is freely available on public-yum.oracle.com


Please review Oracle Linux 7 Beta Release Notes for known issues prior to installation.  To learn more about Oracle Linux, visit www.oracle.com/linux

Documentation

Support

  • Please work with your Oracle team If you have any questions; or send us email at: oraclelinux-beta-info_ww@oracle.com
  • Oracle Bugzilla will be used to file bugs. You will need to request an Oracle Bugzilla account at http://bugzilla.oracle.com. When filing bugs, please choose the release Oracle Linux 7, and select the appropriate components to proceed.

 


nuevo Netbeans 8.0

Nuevo netbeans

Estoy probar las nuevas funcionalidades, en cuanto al soporte de plugins solo probe el plugins de YII, Maven, falta mucho por probar.

https://netbeans.org/downloads/

Error Apache 2 Invalid command '\xef\xbb\xbf

Starting Apache Web Server...
Exit code: 8
Stdout:
apache config test fails, aborting
Stderr:
AH00526: Syntax error on line 1 of /opt/lampp/apache2/conf/httpd.conf:
Invalid command '\xef\xbb\xbfAlias', perhaps misspelled or defined by a module not included in the server configuration

Este error surge porque la codificación utf8 agregar caracteres adicionales que el apache interpreta como parte del comando.

Solución:

Gardar el archivo de texto como: En el menú Herramientas elegimos Codificación y luego ISO 8859-1


[YII] Netbeans 7.4 integracion Yii Framework


Yii plugin adds useful enhancements to NetBeans IDE including the following:
  • Code completion in views (including variables passed to view and $this).
  • Go To Action, Go To View.
  • Go to view via clicking on render or renderPartial argument.
  • Go to file via clicking on path alias (Yii::importwidgetbeginWidget,createWidgetbeginCache).
  • New project wizard.

BAJAR PLUGIN

AGREGAR EL TEMPLATE AL EDITOR DEL NETBEANS O AGREGARLOS MANUALMENTE AL EDITOR:

http://www.cheatography.com/hoplayann/cheat-sheets/yii-code-templates-for-netbeans/

You can create code templates for commonly used/overridden function in Yii. For example, if you want to add an beforeSave() function in your model, by typing a shortcut you can automatically have the function template in place. There are additional shortcuts for common stuff like Yii::app(), Yii::t(), Yii::app()->user->checkAccess(), and more!
  • Download this template set to get started: http://fbe.am/hly (version 2). View all available commands in this printable cheat sheet.
  • Go to "Tools > Options > Editor > Code Templates"
  • Hit "Import", select the file, and choose "Code Templates"
    • You might get an error message "invalid zip file" if you are importing to a older/newer version of NetBeans. Open up the zip file, edit build.info, and set the correct path to Userdir.

Usage:


o BAJAR Y INSTALAR EN EL DIRECTORIO DEL NETBEANS:

TEMPLATE

Navigation

hyperlink navigation
navigation for i18n file

Run Command

run command

Code Completion

code completion for the path

Usage

Install Plugin

Download a nbm file or create it by yourself. And please, install it.

How to enable

  • Use default directory structure (don't delete yiic* files)
  • project properties > Framework > Yii, check enabled (You don't have to check this if you use plugin with default app)

Existing Source

Source directory : Please, specify the webroot directory
Webroot directory : Please, keep default (Source directory)
e.g.
testdrive (webroot directory)
├── assets
├── css
├── images
├── index-test.php
├── index.php
├── nbproject
├── protected
└── themes

Existing Source (Source Directory has other directories)

Please set webroot directory(yii path alias named "webroot" i.e. webroot is testdrive on the below tree) to webroot of project properties.
Right-click project > properties > Source > Webroot
e.g.
my_source (source directory)
├── testdrive (webroot directory)
│   ├── assets
│   ├── css
│   ├── images
│   ├── index-test.php
│   ├── index.php
│   ├── protected
│   └── themes
│ 
├── ...
├── foo
└── bar

Path settings

You can set the some paths(e.g. path alias) to project properties. If you use defferent path from default, please set relative path there from source directory.

I have added path settings to project properties.
nb-yii-plugin-path-settings-support

Usage

Please set relative path from source directory.
e.g.
Please set protected/myext to ext: if extensions directory is the following:
myproject
├─protected
│  └─myext (extensions directory)
├─...
If you want to use default directory, please set empty.
e.g.
application: myprotected
controllers: (empty)
views: (empty)
controllers directory means myprotected/controllers. views directory means myprotected/views.

Features

  • Badge icon
  • Go To Action
  • Go To View
  • Code Completion on the view file
  • Code Completion for the path
  • Init Action
  • PHPUnit Test Init Action
  • New Yii Project Wizard
  • Run Action Action
  • Navigation for path alias (Hyperlink to file)
  • Run Command Action

Go To Action

You can open the controller file and move action method.
e.g. WebRoot/protected/views/site/index.php -> WebRoot/protected/controllers/SiteController.php::actionIndex()
  1. open a view file
  2. Right-click on Editor
  3. Navigate > Go To Action

Go to View

You can open the view file for action method of the controller.(similar to Go To Action)
  1. open a controller file
  2. move the caret to action method
  3. Right-click on Editor
  4. Navigate > Go To View
If you set the keymap for this action, it's more useful.(Please, search with "php")
If you set the theme on main.php, you will go to there.
// protected/main.php
// e.g. set themes/basic
array(
    // something...
    'theme' => 'basic',
);

Hyper link to view file

You can open the view file from parameter of render and renderPartial methods. This is available on the Controller or View files.
e.g.
public actionIndex() {
    // something ...

    $this->render('foo', array('bar' => $bar));
    $this->renderPartial('bar');
}
When you use the render method like above, if foo.php exists, you do the following.

fallback to default views

You can fallback to default views if view file for your theme doesn't exist when you use the theme. If you would like to this feature, please, check "Fallback to ..." on project properties for Yii.
  1. Hold down Ctrl key on the first parameter (foo)
  2. Wait to be changed string color to blue
  3. Click (foo)
It will go to theme file if you use theme.

Navigation for path alias (Hyperlink to file)

Usage is the same as hyperlink to view file.
This feature is available for the followings:
  • Yii::import()
  • Yii::t()
  • CBaseController::widget()
  • CBaseController::beginWidget()
  • CBaseController::endWidget()
  • CBaseController::createWidget()
  • CBaseController::beginCache()
  • CBaseController::beginContent()
  1. Hold down Ctrl on target path
  2. string color is changed to blue if file exists(file path is displeyed as tooltip)
  3. Click > open file
e.g.
$this->widget('application.components.MyComponent', array());
// Hold down Ctrl on application.components.MyComponent

// support for the path that starts with '/' and '//'
$this->beginContent('//layouts/main');
$this->renderPartial('/users/foo');

// support for the class name
$this->widget('MyWidget');
Furthermore... Class name is also valid at the other places.
e.g.
return array(
    'some'=>array(
        // Hold-down Ctrl key on 'ClassName'
        'class'=>'SomeAction',
    ),
);
i18n
Yii::t('Xyz.categoryName', 'message to be translated');
// on the first parameter : open the message file for LanguageID
// on the second parameter :  open the message file for LanguageID, and caret position is moved to specified message

Notice

  • This feature works with default path alias name.
  • Automatically file creation is valid with only render and renderPartial methods.

Code Completion on the view file

Provide support for code completion on the View file.
e.g. webapp/protected/controllers/SiteController.php
class SiteController extends Controller {
    // something...

    public function actionIndex(){
        // ...
        $this->render('foo', array(
            'var1' => $var,
            'var2' => 'bar',
        ));
    }
}
e.g. webapp/protected/views/site/index.php
$ // [Ctrl + Space] popup $var1, $var2, $this, ...
$this-> // [Ctrl + Space] popup SiteController methods and fields

Code Completion for the path

This is available the following methods:
  • render
  • renderPartial
  • beginContent
  • beginCache
  • import
  • *widget
e.g.
// type character or [Ctrl + Space]
$this->render('i');

// class or path alias
$this->widget('application.[Ctrl + Space]');

Init Action

Run the followings:
  • Set framework directory path to Project Properties.
  • Create a file for code completion.
Project right-click > Yii > Init

 Testing 

To run functional tests and unit tests in Yii, recommended is installing PHPUnit and SeleniumRC.
  • Install PHPUnit
  • Install SeleniumRC by getting the NetBeans plugin
    • Open "Tools > Plugins > Available Plugins"
    • Install "Selenium Module for PHP"
  • Configure project options
    • Open "File > Project properties > Sources" and set "Test Folder" to [PROJECT ROOT]/protected/tests (If the whole project testing doesn't work, try [PROJECT ROOT]/protected/tests/unit)
    • Open "File > Project properties > PHPUnit" and set "Use Bootstrap" to [PROJECT ROOT]/protected/tests/bootstrap.php, and "Use XML Configuration" to [PROJECT ROOT]/protected/tests/phpunit.xml

Usage:

  • Test whole project: Alt+F6
  • Test single file: Shift-F6
  • Check code coverage (right click project > Code Coverage)

4. Debugging 

  • Install Xdebug (usually already available in your installation):
  • Include the Xdebug extension for PHP:
    • In php.ini enable (by removing ; prefix) these settings:
      zend_extension = "C:\xampp\php\ext\php_xdebug.dll"
      xdebug.remote_enable = 1
      xdebug.remote_handler = "dbgp"
      xdebug.remote_host = "localhost"
      xdebug.remote_port = 9000

Usage:

  • Debug project: Ctrl-F5
  • Use breakpoints, walk through running code, and watch variables and objects in real-time. :)
  • If you want to stop the debugger from pausing on the first line for every request, simply turn that "feature" off by clicking: Tools > Options > PHP > Debugging > Stop at First Line (uncheck)

[SHELL]Ver las variables de entorno de Linux/Unix

El compando export, sirve para agregar variables de sistema para distintas aplicaciones por ej: para el caso de java JAVA_HOME, si tenemos shell corriendo etc.
Por ejemplo:

usuario@acura:~$ export
declare -x HOME="/home/usuario"
declare -x LANG="en_GB.UTF-8"
declare -x LANGUAGE="en_GB:en"
declare -x LC_ADDRESS="en_US.UTF-8"
declare -x LC_IDENTIFICATION="en_US.UTF-8"
declare -x LC_MEASUREMENT="en_US.UTF-8"
declare -x LC_MONETARY="en_US.UTF-8"
declare -x LC_NAME="en_US.UTF-8"
declare -x LC_NUMERIC="en_US.UTF-8"
declare -x LC_PAPER="en_US.UTF-8"
declare -x LC_TELEPHONE="en_US.UTF-8"
declare -x LC_TIME="en_US.UTF-8"
declare -x LESSCLOSE="/usr/bin/lesspipe %s %s"
declare -x LESSOPEN="| /usr/bin/lesspipe %s"
declare -x LOGNAME="usuario"
declare -x LS_COLORS="rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01;31:*.lz=01;31:*.xz=01;31:*.bz2=01;31:*.bz=01;31:*.tbz=01;31:*.tbz2=01;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.war=01;31:*.ear=01;31:*.sar=01;31:*.rar=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.webm=01;35:*.ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.cgm=01;35:*.emf=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=00;36:*.au=00;36:*.flac=00;36:*.mid=00;36:*.midi=00;36:*.mka=00;36:*.mp3=00;36:*.mpc=00;36:*.ogg=00;36:*.ra=00;36:*.wav=00;36:*.axa=00;36:*.oga=00;36:*.spx=00;36:*.xspf=00;36:"
declare -x MAIL="/var/mail/usuario"
declare -x OLDPWD
declare -x ORACLE_HOME="/Oracle/app/product/11.2.0/dbhome_1"
declare -x ORACLE_SID="BERR"
declare -x PATH="/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/Oracle/app/product/11.2.0/dbhome_1/bin"
declare -x PWD="/home/usuario"
declare -x SHELL="/bin/bash"
declare -x SHLVL="1"
declare -x SSH_CLIENT="10.10.30.9 50309 22"
declare -x SSH_CONNECTION="10.10.30.9 50309 192.168.40.21 22"
declare -x SSH_TTY="/dev/pts/6"
declare -x TERM="xterm"
declare -x USER="usuario"
declare -x XDG_SESSION_COOKIE="8c19c58df429568648ecf60c00000638-1394136889.281238-1263694637"

[UML] Dicccionario de datos con MYSQL workbench 5.2.33 CE o superior

 Primero tener instalado MYSQL workbench 5.2.33 o superior, no importa el sistema operativo.
Bajar plugin para el WB desde:

wb-datadict/downloads

Seguir los pasos a continuacion:




Debaria aparecer al final de instalar:



Una vez reiniciado el WB ir a un modelo ER y:


Guardar como HTML y el modelo saldra algo como:


sakila Data Dictionary

sakila
Data Dictionay

2014-03-05

Alphabetic Index

actor
Column name DataType PK NN UQ BIN UN ZF AI Default Comment
actor_id SMALLINT      
first_name VARCHAR(45)            
last_name VARCHAR(45)            
last_update TIMESTAMP             CURRENT_TIMESTAMP
address
Column name DataType PK NN UQ BIN UN ZF AI Default Comment
address_id SMALLINT      
address VARCHAR(50)            
address2 VARCHAR(50)               NULL
district VARCHAR(20)            
city_id SMALLINT          
postal_code VARCHAR(10)               NULL
phone VARCHAR(20)            
last_update TIMESTAMP             CURRENT_TIMESTAMP
category
Column name DataType PK NN UQ BIN UN ZF AI Default Comment
category_id TINYINT      
name VARCHAR(25)            
last_update TIMESTAMP             CURRENT_TIMESTAMP
city
Column name DataType PK NN UQ BIN UN ZF AI Default Comment
city_id SMALLINT      
city VARCHAR(50)            
country_id SMALLINT          
last_update TIMESTAMP             CURRENT_TIMESTAMP
country
Column name DataType PK NN UQ BIN UN ZF AI Default Comment
country_id SMALLINT      
country VARCHAR(50)            
last_update TIMESTAMP             CURRENT_TIMESTAMP
customer
Table storing all customers. Holds foreign keys to the address table and the store table where this customer is registered. Basic information about the customer like first and last name are stored in the table itself. Same for the date the record was created and when the information was last updated.
Column name DataType PK NN UQ BIN UN ZF AI Default Comment
customer_id SMALLINT      
store_id TINYINT          
first_name VARCHAR(45)            
last_name VARCHAR(45)            
email VARCHAR(50)               NULL
address_id SMALLINT          
active TINYINT(1)             TRUE
create_date DATETIME            
last_update TIMESTAMP               CURRENT_TIMESTAMP
film
Column name DataType PK NN UQ BIN UN ZF AI Default Comment
film_id SMALLINT      
title VARCHAR(255)            
description TEXT               NULL
release_year YEAR               NULL
language_id TINYINT          
original_language_id TINYINT             NULL
rental_duration TINYINT           3
rental_rate DECIMAL(4,2)             4.99
length SMALLINT             NULL
replacement_cost DECIMAL(5,2)             19.99
rating ENUM('G','PG','PG-13','R','NC-17')               'G'
special_features SET('Trailers','Commentaries','Deleted Scenes','Behind the Scenes')               NULL
last_update TIMESTAMP             CURRENT_TIMESTAMP
film_actor
Column name DataType PK NN UQ BIN UN ZF AI Default Comment
actor_id SMALLINT        
film_id SMALLINT        
last_update TIMESTAMP             CURRENT_TIMESTAMP
film_category
Column name DataType PK NN UQ BIN UN ZF AI Default Comment
film_id SMALLINT        
category_id TINYINT        
last_update TIMESTAMP             CURRENT_TIMESTAMP
film_text
Column name DataType PK NN UQ BIN UN ZF AI Default Comment
film_id SMALLINT        
title VARCHAR(255)            
description TEXT               NULL
inventory
Column name DataType PK NN UQ BIN UN ZF AI Default Comment
inventory_id MEDIUMINT      
film_id SMALLINT          
store_id TINYINT          
last_update TIMESTAMP             CURRENT_TIMESTAMP
language
Column name DataType PK NN UQ BIN UN ZF AI Default Comment
language_id TINYINT      
name CHAR(20)            
last_update TIMESTAMP             CURRENT_TIMESTAMP
payment
Column name DataType PK NN UQ BIN UN ZF AI Default Comment
payment_id SMALLINT      
customer_id SMALLINT          
staff_id TINYINT          
rental_id INT               NULL
amount DECIMAL(5,2)            
payment_date DATETIME            
last_update TIMESTAMP               CURRENT_TIMESTAMP
rental
Column name DataType PK NN UQ BIN UN ZF AI Default Comment
rental_id INT        
rental_date DATETIME            
inventory_id MEDIUMINT          
customer_id SMALLINT          
return_date DATETIME               NULL
staff_id TINYINT          
last_update TIMESTAMP             CURRENT_TIMESTAMP
staff
Column name DataType PK NN UQ BIN UN ZF AI Default Comment
staff_id TINYINT      
first_name VARCHAR(45)            
last_name VARCHAR(45)            
address_id SMALLINT          
picture BLOB               NULL
email VARCHAR(50)               NULL
store_id TINYINT          
active TINYINT(1)             TRUE
username VARCHAR(16)            
password VARCHAR(40)             NULL
last_update TIMESTAMP             CURRENT_TIMESTAMP
store
Column name DataType PK NN UQ BIN UN ZF AI Default Comment
store_id TINYINT      
manager_staff_id TINYINT          
address_id SMALLINT          
last_update TIMESTAMP             CURRENT_TIMESTAMP

Problemas de activación WIFI6 en LG_OLED55CXPSA

  Mi experiencia con este TV  ah sido impecable hasta ahora, llevaba un uso normal y no tenia que usar la conexión por wifi ya que tengo una...