FORUMS

Select any forum below to ask question

Home › Forums › Chart Support › Issues retrievng data from MySql › Reply To: Issues retrievng data from MySql

November 3, 2014 at 4:57 pm #7458

andres.chandia

Just in case, i’m adding the table structure

— phpMyAdmin SQL Dump
— version 4.2.6deb1
— http://www.phpmyadmin.net
—
— Servidor: localhost
— Tiempo de generación: 03-11-2014 a las 12:23:46
— Versión del servidor: 5.5.40-0ubuntu1
— Versión de PHP: 5.5.12-2ubuntu4.1

SET SQL_MODE = “NO_AUTO_VALUE_ON_ZERO”;
SET time_zone = “+00:00”;

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

—
— Base de datos: database
—

— ——————————————————–

—
— Estructura de tabla para la tabla values
—

CREATE TABLE IF NOT EXISTS values (
Id int(6) NOT NULL,
Titol varchar(500) DEFAULT NULL,
Autor varchar(200) DEFAULT NULL,
Any_publicacio int(4) NOT NULL,
Pub_prod varchar(200) DEFAULT NULL,
Lloc_publicacio varchar(200) DEFAULT NULL,
Suport varchar(200) DEFAULT NULL,
Consulta_linia varchar(10) NOT NULL,
D_actualitzacio varchar(10) NOT NULL,
Url varchar(500) NOT NULL,
Tipus_1 set(‘lingüístic’,’jurídic’) NOT NULL,
Tipus_2 varchar(1000) NOT NULL,
Tipus_3 varchar(1000) NOT NULL,
P_clau varchar(1000) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=132 ;

—
— Índices para tablas volcadas
—

—
— Indices de la tabla values
—
ALTER TABLE values
ADD PRIMARY KEY (Id), ADD UNIQUE KEY id (Id);

—
— AUTO_INCREMENT de las tablas volcadas
—

—
— AUTO_INCREMENT de la tabla values
—
ALTER TABLE values
MODIFY Id int(6) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=132;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;