1 |
d2a8c3fd
|
Marc NICOLAS
|
|
2 |
|
|
|
3 |
|
|
|
4 |
|
|
|
5 |
|
|
|
6 |
|
|
|
7 |
|
|
|
8 |
|
|
|
9 |
|
|
|
10 |
|
|
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
|
11 |
|
|
|
12 |
|
|
|
13 |
|
|
|
14 |
|
|
|
15 |
|
|
|
16 |
|
|
|
17 |
|
|
|
18 |
|
|
|
19 |
|
|
|
20 |
|
|
|
21 |
|
|
|
22 |
|
|
DROP TABLE IF EXISTS `TABLE_TESTS`;
|
23 |
|
|
CREATE TABLE IF NOT EXISTS `TABLE_TESTS` (
|
24 |
|
|
`field_varchar_id` varchar(4) NOT NULL,
|
25 |
|
|
`field_tiny_int` tinyint(2) NOT NULL,
|
26 |
|
|
`field_small_int` smallint(6) NOT NULL,
|
27 |
|
|
`field_medium_int` mediumint(9) NOT NULL,
|
28 |
|
|
`field_int` int(11) NOT NULL,
|
29 |
|
|
`field_big_int` bigint(20) NOT NULL,
|
30 |
|
|
`field_float` float NOT NULL,
|
31 |
|
|
`field_double` double NOT NULL,
|
32 |
|
|
`field_decimal` decimal(10,5) NOT NULL,
|
33 |
|
|
`field_varchar` varchar(200) NOT NULL,
|
34 |
|
|
`field_text` text NOT NULL,
|
35 |
|
|
`field_timestamp` timestamp NULL DEFAULT NULL,
|
36 |
|
|
`field_datetime` datetime NOT NULL,
|
37 |
|
|
`field_date` date NOT NULL,
|
38 |
|
|
`field_year` year(4) NOT NULL,
|
39 |
|
|
`field_time` time NOT NULL,
|
40 |
|
|
`field_char` char(10) NOT NULL,
|
41 |
|
|
`field_bool` tinyint(1) NOT NULL,
|
42 |
|
|
PRIMARY KEY (`field_varchar_id`)
|
43 |
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
44 |
|
|
|
45 |
|
|
|
46 |
|
|
|
47 |
|
|
|
48 |
|
|
|
49 |
|
|
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
|
50 |
|
|
('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),
|
51 |
|
|
('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); |