1915 |
aurelien |
1 |
-- phpMyAdmin SQL Dump
|
|
|
2 |
-- version 4.1.6
|
|
|
3 |
-- http://www.phpmyadmin.net
|
|
|
4 |
--
|
|
|
5 |
-- Client : localhost
|
|
|
6 |
-- Généré le : Mar 28 Juillet 2015 à 16:42
|
|
|
7 |
-- Version du serveur : 5.6.16
|
|
|
8 |
-- Version de PHP : 5.5.9
|
|
|
9 |
|
|
|
10 |
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
|
|
|
11 |
SET time_zone = "+00:00";
|
|
|
12 |
|
|
|
13 |
|
|
|
14 |
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
|
|
15 |
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
|
|
16 |
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
|
|
17 |
/*!40101 SET NAMES utf8 */;
|
|
|
18 |
|
|
|
19 |
--
|
|
|
20 |
-- Base de données : `tb_coel`
|
|
|
21 |
--
|
|
|
22 |
|
|
|
23 |
--
|
|
|
24 |
-- Contenu de la table `coel_meta_liste_valeur`
|
|
|
25 |
--
|
|
|
26 |
|
|
|
27 |
INSERT INTO `coel_meta_liste_valeur` (`cmlv_id_valeur`, `cmlv_ce_parent`, `cmlv_nom`, `cmlv_abreviation`, `cmlv_description`, `cmlv_ce_meta`) VALUES
|
|
|
28 |
(1, 1001, 'Ajouté', 'A', 'NULL', 25),
|
|
|
29 |
(2, 1001, 'Modifié', 'M', 'NULL', 26),
|
|
|
30 |
(3, 1001, 'Supprimé', 'S', 'NULL', 27),
|
|
|
31 |
(11, 1002, 'TINYINT', '1', 'NULL', 28),
|
|
|
32 |
(12, 1002, 'SMALLINT', '2', 'NULL', 29),
|
|
|
33 |
(13, 1002, 'MEDIUMINT', '3', 'NULL', 30),
|
|
|
34 |
(14, 1002, 'INT', '4', 'NULL', 31),
|
|
|
35 |
(15, 1002, 'INTEGER', '5', 'NULL', 32),
|
|
|
36 |
(16, 1002, 'BIGINT', '6', 'NULL', 33),
|
|
|
37 |
(17, 1002, 'FLOAT', '7', 'NULL', 34),
|
|
|
38 |
(18, 1002, 'DOUBLE', '8', 'NULL', 35),
|
|
|
39 |
(19, 1002, 'DOUBLE PRECISION', '9', 'NULL', 36),
|
|
|
40 |
(20, 1002, 'REAL', '10', 'NULL', 37),
|
|
|
41 |
(21, 1002, 'DECIMAL', '11', 'NULL', 38),
|
|
|
42 |
(22, 1002, 'NUMERIC', '12', 'NULL', 39),
|
|
|
43 |
(23, 1002, 'DATE', '13', 'NULL', 40),
|
|
|
44 |
(24, 1002, 'DATETIME', '14', 'NULL', 41),
|
|
|
45 |
(25, 1002, 'TIMESTAMP', '15', 'NULL', 42),
|
|
|
46 |
(26, 1002, 'TIME', '16', 'NULL', 43),
|
|
|
47 |
(27, 1002, 'YEAR', '17', 'NULL', 44),
|
|
|
48 |
(28, 1002, 'CHAR', '18', 'NULL', 45),
|
|
|
49 |
(29, 1002, 'VARCHAR', '19', 'NULL', 46),
|
|
|
50 |
(30, 1002, 'BIT', '20', 'NULL', 47),
|
|
|
51 |
(31, 1002, 'BOOL', '21', 'NULL', 48),
|
|
|
52 |
(32, 1002, 'TINYBLOB', '22', 'NULL', 49);
|
|
|
53 |
|
|
|
54 |
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
|
|
55 |
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
|
|
56 |
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|