SITools2

-- phpMyAdmin SQL Dump

-- version 2.11.9.5

-- http://www.phpmyadmin.net

--

-- Serveur: odysseus2.silogic.fr

-- G?n?r? le : Lun 12 Septembre 2011 ? 15:56

-- Version du serveur: 5.1.41

-- Version de PHP: 5.1.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--

-- Base de donn?es: `cnes-test`

--

-- --------------------------------------------------------

--

-- Structure de la table `TABLE_TESTS`

--

DROP TABLE IF EXISTS `TABLE_TESTS`;

CREATE TABLE IF NOT EXISTS `TABLE_TESTS` (

  `field_varchar_id` varchar(4) NOT NULL,

  `field_tiny_int` tinyint(2) NOT NULL,

  `field_small_int` smallint(6) NOT NULL,

  `field_medium_int` mediumint(9) NOT NULL,

  `field_int` int(11) NOT NULL,

  `field_big_int` bigint(20) NOT NULL,

  `field_float` float NOT NULL,

  `field_double` double NOT NULL,

  `field_decimal` decimal(10,5) NOT NULL,

  `field_varchar` varchar(200) NOT NULL,

  `field_text` text NOT NULL,

  `field_timestamp` timestamp NULL DEFAULT NULL,

  `field_datetime` datetime NOT NULL,

  `field_date` date NOT NULL,

  `field_year` year(4) NOT NULL,

  `field_time` time NOT NULL,

  `field_char` char(10) NOT NULL,

  `field_bool` tinyint(1) NOT NULL,

  PRIMARY KEY (`field_varchar_id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--

-- Contenu de la table `TABLE_TESTS`

--

INSERT INTO `TABLE_TESTS` (`field_varchar_id`, `field_tiny_int`, `field_small_int`, `field_medium_int`, `field_int`, `field_big_int`, `field_float`, `field_double`, `field_decimal`, `field_varchar`, `field_text`, `field_timestamp`, `field_datetime`, `field_date`, `field_year`, `field_time`, `field_char`, `field_bool`) VALUES

('0', 10, 1, 10, 10, 97, 1.15533, 8.96095939005054, 125.25360, 'varchar', 'Ceci est un enregistrement de test 1', '2011-04-27 11:23:36', '2011-03-11 11:01:50', '2010-04-01', 2011, '14:01:13', 'y', 1),

('1', -10, 0, 101, -10, 22, 1.31612, 5.91603873396269, -250.15200, 'varchar 2', 'Ceci est un enregistrement de test 2', '2011-04-26 16:31:38', '2011-04-11 11:01:50', '2010-05-01', 2010, '14:01:15', 'n', 0);