databases/Metier/wip/jo.sfr_params_10.sql
2016-09-30 14:21:43 +02:00

282 lines
14 KiB
SQL
Executable File

-- phpMyAdmin SQL Dump
-- version 4.0.4.1
-- http://www.phpmyadmin.net
--
-- Client: 192.168.78.230
-- Généré le: Mar 27 Août 2013 à 08:37
-- Version du serveur: 5.5.32-0ubuntu0.12.04.1
-- Version de PHP: 5.3.10-1ubuntu3.7
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 données: `jo`
--
-- --------------------------------------------------------
--
-- Structure de la table `sfr_params_10`
--
CREATE TABLE IF NOT EXISTS `sfr_params_10` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` varchar(5) NOT NULL,
`codif` int(11) NOT NULL,
`ordre` int(11) NOT NULL,
`var` varchar(50) NOT NULL,
`cond` varchar(10) NOT NULL,
`value` varchar(50) NOT NULL,
`define` varchar(50) NOT NULL,
`define_value` varchar(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=485 ;
--
-- Contenu de la table `sfr_params_10`
--
INSERT INTO `sfr_params_10` (`id`, `type`, `codif`, `ordre`, `var`, `cond`, `value`, `define`, `define_value`) VALUES
(1, 'VORP', 1, 1, 'IsCAC', 'EGAL', '1', 'TypeEntrep', 'CAC'),
(2, 'VORP', 1, 2, 'Effectif', 'MIN', '499', 'TypeEntrep', 'GE'),
(3, 'VORP', 1, 3, 'Effectif', 'MIN', '3', 'TypeEntrep', 'PME'),
(4, 'VORP', 1, 4, 'Effectif', 'MIN', '-1', 'TypeEntrep', 'TPE'),
(5, 'VORP', 1, 5, 'Effectif', 'EGAL', 'UNDEFINE', 'TypeEntrep', 'TPE'),
(6, 'VORP', 2, 1, 'NAF', 'LIST', 'TabAdminNaf', 'IsAdmin', '1'),
(7, 'VORP', 3, 1, 'FJ', 'LIST', 'TabAdminFj', 'IsAdmin', '1'),
(8, 'VORP', 4, 1, 'NAF', 'LIST', 'TabEtrangerNaf', 'IsEtranger', '1'),
(9, 'VORP', 5, 1, 'FJ', 'LIST', 'TabEtrangerFj', 'IsEtranger', '1'),
(10, 'VORP', 6, 1, 'Indiscore', 'MAX', '6', '', ''),
(11, 'VORP', 6, 2, 'RJ', 'EGAL', '1', '', ''),
(12, 'VORP', 7, 1, 'Indiscore', 'MAX', '6', '', ''),
(13, 'VORP', 7, 2, 'LJ', 'EGAL', '1', '', ''),
(14, 'VORP', 8, 1, 'Indiscore', 'MAX', '6', '', ''),
(15, 'VORP', 8, 2, 'SV', 'EGAL', '1', '', ''),
(16, 'VORP', 9, 1, 'Indiscore', 'MAX', '6', '', ''),
(17, 'VORP', 9, 2, 'InseeActif', 'EGAL', '0', '', ''),
(18, 'VORP', 10, 1, 'Indiscore', 'MAX', '16', '', ''),
(19, 'VORP', 10, 2, 'Indiscore', 'MIN', '9', '', ''),
(20, 'VORP', 10, 3, 'InseeAge', 'MAX', '37', 'EntrepRecente', '1'),
(21, 'VORP', 10, 4, 'TypeEntrep', 'MIN', 'PME', '', ''),
(22, 'VORP', 11, 1, 'Indiscore', 'MAX', '6', '', ''),
(23, 'VORP', 12, 1, 'Indiscore', 'MAX', '10', '', ''),
(24, 'VORP', 12, 2, 'Indiscore', 'MIN', '5', '', ''),
(25, 'VORP', 13, 1, 'Indiscore', 'MAX', '21', '', ''),
(26, 'VORP', 13, 2, 'Indiscore', 'MIN', '9', '', ''),
(27, 'VORP', 14, 1, 'FEU', 'EGAL', 'ROUGE', '', ''),
(28, 'VORP', 14, 2, 'SV', 'EGAL', '1', '', ''),
(29, 'VORP', 14, 3, 'Indiscore', 'MIN', '4', '', ''),
(30, 'VORP', 15, 1, 'TypeEntrep', 'EGAL', 'GE', '', ''),
(31, 'VORP', 15, 2, 'Indiscore', 'EGAL', '9', '', ''),
(32, 'VORP', 16, 1, 'TypeEntrep', 'EGAL', 'CAC', '', ''),
(33, 'VORP', 16, 2, 'Indiscore', 'MIN', '5', '', ''),
(34, 'VORD', 1, 1, 'ContratAge', 'EGAL', 'UNDEFINE', '', ''),
(35, 'VORD', 1, 2, 'IR', 'EGAL', 'UNDEFINE', '', ''),
(36, 'VORD', 3, 1, 'ContratAge', 'MIN', '-1', '', ''),
(37, 'VORD', 3, 2, 'IR', 'EGAL', 'UNDEFINE', 'IR', '8'),
(38, 'VORD', 4, 1, 'FEU', 'EGAL', 'VERT', '', ''),
(39, 'VORD', 4, 2, 'IR', 'MIN', '4,9', '', ''),
(40, 'VORD', 4, 3, 'IR', 'MAX', '7,1', '', ''),
(41, 'VORD', 4, 4, 'ContratAge', 'MAX', '25', '', ''),
(42, 'VORD', 4, 5, 'Indiscore', 'MIN', '9', '', ''),
(43, 'VORD', 4, 6, 'Indiscore', 'MAX', '12', '', ''),
(44, 'VORD', 5, 1, 'FEU', 'EGAL', 'VERT', '', ''),
(45, 'VORD', 5, 2, 'IR', 'MIN', '4,9', '', ''),
(46, 'VORD', 5, 3, 'IR', 'MAX', '7,1', '', ''),
(47, 'VORD', 5, 4, 'ContratAge', 'MIN', '24', '', ''),
(48, 'VORD', 5, 5, 'ContratAge', 'MAX', '36', '', ''),
(49, 'VORD', 5, 6, 'Indiscore', 'MIN', '9', '', ''),
(50, 'VORD', 5, 7, 'Indiscore', 'MAX', '12', '', ''),
(51, 'VORD', 6, 1, 'FEU', 'EGAL', 'VERT', '', ''),
(52, 'VORD', 6, 2, 'IR', 'MIN', '4,9', '', ''),
(53, 'VORD', 6, 3, 'IR', 'MAX', '7,1', '', ''),
(54, 'VORD', 6, 4, 'ContratAge', 'MIN', '23', '', ''),
(55, 'VORD', 6, 5, 'Indiscore', 'MIN', '11', '', ''),
(56, 'VORD', 6, 6, 'Indiscore', 'MAX', '14', '', ''),
(57, 'VORD', 7, 1, 'FEU', 'EGAL', 'ORANGE', '', ''),
(58, 'VORD', 7, 2, 'IR', 'MAX', '2,1', '', ''),
(59, 'VORD', 7, 3, 'ContratAge', 'MIN', '35', '', ''),
(60, 'VORD', 8, 1, 'FEU', 'EGAL', 'ORANGE', '', ''),
(61, 'VORD', 8, 2, 'IR', 'MIN', '2', '', ''),
(62, 'VORD', 8, 3, 'IR', 'MAX', '5', '', ''),
(63, 'VORD', 8, 4, 'ContratAge', 'MIN', '36', '', ''),
(64, 'VORD', 8, 5, 'Indiscore', 'MAX', '7', '', ''),
(65, 'VORD', 9, 6, 'FEU', 'EGAL', 'ORANGE', '', ''),
(66, 'VORD', 9, 7, 'EntrepRecente', 'EGAL', '1', '', ''),
(67, 'VORD', 9, 8, 'IR', 'MAX', '2,1', '', ''),
(68, 'VORD', 9, 9, 'ContratAge', 'MAX', '36', '', ''),
(69, 'VORD', 10, 1, 'FEU', 'EGAL', 'ORANGE', '', ''),
(70, 'VORD', 10, 2, 'EntrepRecente', 'EGAL', '1', '', ''),
(71, 'VORD', 10, 3, 'ContratAge', 'MAX', '25', '', ''),
(72, 'VORD', 10, 4, 'IR', 'MIN', '4,9', '', ''),
(73, 'VORD', 10, 5, 'IR', 'MAX', '7,1', '', ''),
(74, 'VORD', 10, 6, 'Indiscore', 'MIN', '9', '', ''),
(75, 'VORD', 10, 7, 'Indiscore', 'MAX', '12', '', ''),
(76, 'VORD', 11, 8, 'FEU', 'EGAL', 'ORANGE', '', ''),
(77, 'VORD', 11, 9, 'EntrepRecente', 'EGAL', '1', '', ''),
(78, 'VORD', 11, 10, 'IR', 'MIN', '4,9', '', ''),
(79, 'VORD', 11, 11, 'IR', 'MAX', '7,1', '', ''),
(80, 'VORD', 11, 12, 'ContratAge', 'MIN', '36', '', ''),
(81, 'VORD', 11, 13, 'Indiscore', 'MIN', '11', '', ''),
(82, 'VORD', 12, 14, 'FEU', 'EGAL', 'ORANGE', '', ''),
(83, 'VORD', 12, 15, 'EntrepRecente', 'EGAL', '1', '', ''),
(84, 'VORD', 12, 16, 'IR', 'MIN', '4,9', '', ''),
(85, 'VORD', 12, 17, 'IR', 'MAX', '7,1', '', ''),
(86, 'VORD', 12, 18, 'ContratAge', 'MIN', '24', '', ''),
(87, 'VORD', 12, 19, 'Indiscore', 'MIN', '13', '', ''),
(88, 'VORD', 13, 1, 'FEU', 'EGAL', 'ROUGE', '', ''),
(89, 'VORD', 13, 2, 'IR', 'MIN', '2', '', ''),
(90, 'VORD', 13, 3, 'IR', 'MAX', '5', '', ''),
(91, 'VORD', 13, 4, 'ContratAge', 'MIN', '36', '', ''),
(92, 'VORD', 13, 5, 'Indiscore', 'MIN', '3', '', ''),
(93, 'PO', 1, 1, 'InseeAge', 'MAX', '37', '', ''),
(94, 'PO', 1, 2, 'Indiscore', 'EGAL', '6', '', ''),
(95, 'PO', 1, 3, 'TypeEntrep', 'EGAL', 'GE', '', ''),
(96, 'PO', 2, 1, 'InseeAge', 'MAX', '4', '', ''),
(97, 'PO', 2, 2, 'Indiscore', 'EGAL', '7', '', ''),
(98, 'PO', 2, 3, 'TypeEntrep', 'EGAL', 'GE', '', ''),
(99, 'PO', 3, 1, 'InseeAge', 'MAX', '37', '', ''),
(100, 'PO', 3, 2, 'Indiscore', 'EGAL', '8', '', ''),
(101, 'PO', 3, 3, 'TypeEntrep', 'EGAL', 'GE', '', ''),
(102, 'PO', 4, 1, 'InseeAge', 'MAX', '37', '', ''),
(103, 'PO', 4, 2, 'Indiscore', 'EGAL', '9', '', ''),
(104, 'PO', 4, 3, 'TypeEntrep', 'EGAL', 'GE', '', ''),
(105, 'PO', 5, 1, 'InseeAge', 'MAX', '37', '', ''),
(106, 'PO', 5, 2, 'Indiscore', 'EGAL', '10', '', ''),
(107, 'PO', 5, 3, 'TypeEntrep', 'EGAL', 'GE', '', ''),
(108, 'PO', 6, 1, 'InseeAge', 'MAX', '37', '', ''),
(109, 'PO', 6, 2, 'Indiscore', 'EGAL', '11', '', ''),
(110, 'PO', 6, 3, 'TypeEntrep', 'EGAL', 'GE', '', ''),
(111, 'PO', 7, 1, 'InseeAge', 'MAX', '37', '', ''),
(112, 'PO', 7, 2, 'Indiscore', 'EGAL', '12', '', ''),
(113, 'PO', 7, 3, 'TypeEntrep', 'EGAL', 'GE', '', ''),
(114, 'PO', 8, 1, 'InseeAge', 'MAX', '37', '', ''),
(115, 'PO', 8, 2, 'Indiscore', 'EGAL', '13', '', ''),
(116, 'PO', 8, 3, 'TypeEntrep', 'EGAL', 'GE', '', ''),
(117, 'PO', 9, 1, 'InseeAge', 'MAX', '37', '', ''),
(118, 'PO', 9, 2, 'Indiscore', 'EGAL', '14', '', ''),
(119, 'PO', 9, 3, 'TypeEntrep', 'EGAL', 'GE', '', ''),
(120, 'PO', 10, 1, 'InseeAge', 'MAX', '37', '', ''),
(121, 'PO', 10, 2, 'Indiscore', 'EGAL', '6', '', ''),
(122, 'PO', 10, 3, 'TypeEntrep', 'EGAL', 'PME', '', ''),
(123, 'PO', 11, 1, 'InseeAge', 'MAX', '37', '', ''),
(124, 'PO', 11, 2, 'Indiscore', 'EGAL', '7', '', ''),
(125, 'PO', 11, 3, 'TypeEntrep', 'EGAL', 'PME', '', ''),
(126, 'PO', 12, 1, 'InseeAge', 'MAX', '37', '', ''),
(127, 'PO', 12, 2, 'Indiscore', 'EGAL', '8', '', ''),
(128, 'PO', 12, 3, 'TypeEntrep', 'EGAL', 'PME', '', ''),
(129, 'PO', 13, 1, 'InseeAge', 'MAX', '37', '', ''),
(130, 'PO', 13, 2, 'Indiscore', 'EGAL', '9', '', ''),
(131, 'PO', 13, 3, 'TypeEntrep', 'EGAL', 'PME', '', ''),
(132, 'PO', 14, 1, 'InseeAge', 'MAX', '4', '', ''),
(133, 'PO', 14, 2, 'Indiscore', 'EGAL', '10', '', ''),
(134, 'PO', 14, 3, 'TypeEntrep', 'EGAL', 'PME', '', ''),
(135, 'PO', 15, 1, 'InseeAge', 'MAX', '37', '', ''),
(136, 'PO', 15, 2, 'Indiscore', 'EGAL', '11', '', ''),
(137, 'PO', 15, 3, 'TypeEntrep', 'EGAL', 'PME', '', ''),
(138, 'PO', 16, 1, 'InseeAge', 'MAX', '37', '', ''),
(139, 'PO', 16, 2, 'Indiscore', 'EGAL', '12', '', ''),
(140, 'PO', 16, 3, 'TypeEntrep', 'EGAL', 'PME', '', ''),
(141, 'PO', 17, 1, 'InseeAge', 'MAX', '37', '', ''),
(142, 'PO', 17, 2, 'Indiscore', 'EGAL', '13', '', ''),
(143, 'PO', 17, 3, 'TypeEntrep', 'EGAL', 'PME', '', ''),
(144, 'PO', 18, 1, 'InseeAge', 'MAX', '37', '', ''),
(145, 'PO', 18, 2, 'Indiscore', 'EGAL', '14', '', ''),
(146, 'PO', 18, 3, 'TypeEntrep', 'EGAL', 'PME', '', ''),
(147, 'PO', 19, 1, 'InseeAge', 'MAX', '37', '', ''),
(148, 'PO', 19, 2, 'Indiscore', 'EGAL', '6', '', ''),
(149, 'PO', 19, 3, 'TypeEntrep', 'EGAL', 'TPE', '', ''),
(150, 'PO', 20, 1, 'InseeAge', 'MAX', '37', '', ''),
(151, 'PO', 20, 2, 'Indiscore', 'EGAL', '7', '', ''),
(152, 'PO', 20, 3, 'TypeEntrep', 'EGAL', 'TPE', '', ''),
(153, 'PO', 21, 1, 'InseeAge', 'MAX', '37', '', ''),
(154, 'PO', 21, 2, 'Indiscore', 'EGAL', '8', '', ''),
(155, 'PO', 21, 3, 'TypeEntrep', 'EGAL', 'TPE', '', ''),
(156, 'PO', 22, 1, 'InseeAge', 'MAX', '37', '', ''),
(157, 'PO', 22, 2, 'Indiscore', 'EGAL', '9', '', ''),
(158, 'PO', 22, 3, 'TypeEntrep', 'EGAL', 'TPE', '', ''),
(159, 'PO', 23, 1, 'InseeAge', 'MAX', '4', '', ''),
(160, 'PO', 23, 2, 'Indiscore', 'EGAL', '10', '', ''),
(161, 'PO', 23, 3, 'TypeEntrep', 'EGAL', 'TPE', '', ''),
(162, 'PO', 24, 1, 'InseeAge', 'MAX', '37', '', ''),
(163, 'PO', 24, 2, 'Indiscore', 'EGAL', '11', '', ''),
(164, 'PO', 24, 3, 'TypeEntrep', 'EGAL', 'TPE', '', ''),
(165, 'PO', 25, 1, 'InseeAge', 'MAX', '37', '', ''),
(166, 'PO', 25, 2, 'Indiscore', 'EGAL', '12', '', ''),
(167, 'PO', 25, 3, 'TypeEntrep', 'EGAL', 'TPE', '', ''),
(168, 'PO', 26, 1, 'InseeAge', 'MAX', '37', '', ''),
(169, 'PO', 26, 2, 'Indiscore', 'EGAL', '13', '', ''),
(170, 'PO', 26, 3, 'TypeEntrep', 'EGAL', 'TPE', '', ''),
(171, 'PO', 27, 1, 'InseeAge', 'MAX', '37', '', ''),
(172, 'PO', 27, 2, 'Indiscore', 'EGAL', '14', '', ''),
(173, 'PO', 27, 3, 'TypeEntrep', 'EGAL', 'TPE', '', ''),
(174, 'PO', 28, 1, 'NAF', 'LIST', 'TabNafSFR', '', ''),
(175, 'PO', 28, 2, 'Indiscore', 'EGAL', '6', '', ''),
(176, 'PO', 28, 3, 'TypeEntrep', 'EGAL', 'GE', '', ''),
(177, 'PO', 29, 1, 'NAF', 'LIST', 'TabNafSFR', '', ''),
(178, 'PO', 29, 2, 'Indiscore', 'EGAL', '7', '', ''),
(179, 'PO', 29, 3, 'TypeEntrep', 'EGAL', 'GE', '', ''),
(180, 'PO', 30, 1, 'NAF', 'LIST', 'TabNafSFR', '', ''),
(181, 'PO', 30, 2, 'Indiscore', 'EGAL', '8', '', ''),
(182, 'PO', 30, 3, 'TypeEntrep', 'EGAL', 'GE', '', ''),
(183, 'PO', 31, 1, 'NAF', 'LIST', 'TabNafSFR', '', ''),
(184, 'PO', 31, 2, 'Indiscore', 'EGAL', '9', '', ''),
(185, 'PO', 31, 3, 'TypeEntrep', 'EGAL', 'GE', '', ''),
(186, 'PO', 32, 1, 'NAF', 'LIST', 'TabNafSFR', '', ''),
(187, 'PO', 32, 2, 'Indiscore', 'EGAL', '6', '', ''),
(188, 'PO', 32, 3, 'TypeEntrep', 'EGAL', 'PME', '', ''),
(189, 'PO', 33, 1, 'NAF', 'LIST', 'TabNafSFR', '', ''),
(190, 'PO', 33, 2, 'Indiscore', 'EGAL', '7', '', ''),
(191, 'PO', 33, 3, 'TypeEntrep', 'EGAL', 'PME', '', ''),
(192, 'PO', 34, 1, 'NAF', 'LIST', 'TabNafSFR', '', ''),
(193, 'PO', 34, 2, 'Indiscore', 'EGAL', '8', '', ''),
(194, 'PO', 34, 3, 'TypeEntrep', 'EGAL', 'PME', '', ''),
(195, 'PO', 35, 1, 'NAF', 'LIST', 'TabNafSFR', '', ''),
(196, 'PO', 35, 2, 'Indiscore', 'EGAL', '9', '', ''),
(197, 'PO', 35, 3, 'TypeEntrep', 'EGAL', 'PME', '', ''),
(198, 'PO', 36, 1, 'NAF', 'LIST', 'TabNafSFR', '', ''),
(199, 'PO', 36, 2, 'Indiscore', 'EGAL', '6', '', ''),
(200, 'PO', 36, 3, 'TypeEntrep', 'EGAL', 'TPE', '', ''),
(201, 'PO', 37, 1, 'NAF', 'LIST', 'TabNafSFR', '', ''),
(202, 'PO', 37, 2, 'Indiscore', 'EGAL', '7', '', ''),
(203, 'PO', 37, 3, 'TypeEntrep', 'EGAL', 'TPE', '', ''),
(204, 'PO', 38, 1, 'NAF', 'LIST', 'TabNafSFR', '', ''),
(205, 'PO', 38, 2, 'Indiscore', 'EGAL', '8', '', ''),
(206, 'PO', 38, 3, 'TypeEntrep', 'EGAL', 'TPE', '', ''),
(208, 'PO', 39, 2, 'Indiscore', 'EGAL', '9', '', ''),
(209, 'PO', 39, 3, 'TypeEntrep', 'EGAL', 'TPE', '', ''),
(242, 'PO', 50, 2, 'TypeEntrep', 'EGAL', 'TPE', '', ''),
(211, 'PO', 40, 1, 'Indiscore', 'EGAL', '6', '', ''),
(212, 'PO', 40, 2, 'TypeEntrep', 'EGAL', 'GE', '', ''),
(214, 'PO', 41, 1, 'Indiscore', 'EGAL', '7', '', ''),
(215, 'PO', 41, 2, 'TypeEntrep', 'EGAL', 'GE', '', ''),
(217, 'PO', 42, 1, 'Indiscore', 'EGAL', '8', '', ''),
(218, 'PO', 42, 2, 'TypeEntrep', 'EGAL', 'GE', '', ''),
(220, 'PO', 43, 1, 'Indiscore', 'EGAL', '6', '', ''),
(221, 'PO', 43, 2, 'TypeEntrep', 'EGAL', 'PME', '', ''),
(223, 'PO', 44, 1, 'Indiscore', 'EGAL', '7', '', ''),
(224, 'PO', 44, 2, 'TypeEntrep', 'EGAL', 'PME', '', ''),
(226, 'PO', 45, 1, 'Indiscore', 'EGAL', '8', '', ''),
(227, 'PO', 45, 2, 'TypeEntrep', 'EGAL', 'PME', '', ''),
(229, 'PO', 46, 1, 'Indiscore', 'EGAL', '9', '', ''),
(230, 'PO', 46, 2, 'TypeEntrep', 'EGAL', 'PME', '', ''),
(232, 'PO', 47, 1, 'Indiscore', 'EGAL', '6', '', ''),
(233, 'PO', 47, 2, 'TypeEntrep', 'EGAL', 'TPE', '', ''),
(235, 'PO', 48, 1, 'Indiscore', 'EGAL', '7', '', ''),
(236, 'PO', 48, 2, 'TypeEntrep', 'EGAL', 'TPE', '', ''),
(238, 'PO', 49, 1, 'Indiscore', 'EGAL', '8', '', ''),
(239, 'PO', 49, 2, 'TypeEntrep', 'EGAL', 'TPE', '', ''),
(207, 'PO', 39, 1, 'NAF', 'LIST', 'TabNafSFR', '', ''),
(241, 'PO', 50, 1, 'Indiscore', 'EGAL', '9', '', '');
/*!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 */;