From 52443417ef588b03a925da6db6c2e795b815902a Mon Sep 17 00:00:00 2001 From: rkv Date: Mon, 26 Nov 2012 08:44:14 +0000 Subject: [PATCH] DB init scripts are added for Postgres. Users.xml is added. --- Workspace/Siman/sql/drop_simer_tables.sql | 73 +++++++-------- Workspace/Siman/sql/pg_simer_ini_data.sql | 75 ++++++++++++++++ Workspace/Siman/sql/pgsql.inidata.sql | 104 ++++++++++++++++++++++ Workspace/Siman/sql/users.xml | 33 +++++++ 4 files changed, 245 insertions(+), 40 deletions(-) create mode 100644 Workspace/Siman/sql/pg_simer_ini_data.sql create mode 100644 Workspace/Siman/sql/pgsql.inidata.sql create mode 100644 Workspace/Siman/sql/users.xml diff --git a/Workspace/Siman/sql/drop_simer_tables.sql b/Workspace/Siman/sql/drop_simer_tables.sql index 786492f..fbf6597 100644 --- a/Workspace/Siman/sql/drop_simer_tables.sql +++ b/Workspace/Siman/sql/drop_simer_tables.sql @@ -1,40 +1,33 @@ -drop table if exists `refid`; -drop table if exists `comment_attr`; -drop table if exists `descr_attr`; -drop table if exists `text_attr`; -drop table if exists `text_attr`; -drop table if exists `attribute`; -drop table if exists `doctag`; -drop table if exists `docuse`; -drop table if exists `knowelm`; -drop table if exists `knowtype`; -drop table if exists `contributor_rel`; -drop table if exists `converts_rel`; -drop table if exists `cycle_rel`; -drop table if exists `stamp_rel`; -drop table if exists `usedby_rel`; -drop table if exists `uses_rel`; -drop table if exists `versions_rel`; -drop table if exists `relation`; -drop table if exists `cycle`; -drop table if exists `document`; -drop table if exists `entity`; -drop table if exists `projext`; -drop table if exists `stamp`; -drop table if exists `file`; -drop table if exists `doctype`; -drop table if exists `scenario`; -drop table if exists `study`; -drop table if exists `any`; -drop table if exists `contelm`; -drop table if exists `contype`; -drop table if exists `user`; -drop table if exists `users`; -drop table if exists `role`; -drop table if exists `relation_id`; -drop table if exists `persistent_id`; -drop table if exists `text`; -SHOW TABLE STATUS FROM `simer`; -SHOW FUNCTION STATUS WHERE `Db`='simer'; -SHOW PROCEDURE STATUS WHERE `Db`='simer'; -SHOW TRIGGERS FROM `simer`; \ No newline at end of file +drop table if exists refid; +drop table if exists comment_attr; +drop table if exists descr_attr; +drop table if exists text_attr; +drop table if exists text_attr; +drop table if exists attribute; +drop table if exists doctag; +drop table if exists docuse; +drop table if exists knowelm; +drop table if exists knowtype; +drop table if exists contributor_rel; +drop table if exists converts_rel; +drop table if exists cycle_rel; +drop table if exists stamp_rel; +drop table if exists usedby_rel; +drop table if exists uses_rel; +drop table if exists versions_rel; +drop table if exists relation; +drop table if exists cycle; +drop table if exists document; +drop table if exists entity; +drop table if exists projext; +drop table if exists stamp; +drop table if exists file; +drop table if exists doctype; +drop table if exists scenario; +drop table if exists study; +drop table if exists contelm; +drop table if exists contype; +drop table if exists users; +drop table if exists role; +--drop table if exists persistent_id; +drop table if exists text; diff --git a/Workspace/Siman/sql/pg_simer_ini_data.sql b/Workspace/Siman/sql/pg_simer_ini_data.sql new file mode 100644 index 0000000..fe331b1 --- /dev/null +++ b/Workspace/Siman/sql/pg_simer_ini_data.sql @@ -0,0 +1,75 @@ +-- -------------------------------------------------------- +-- Host: 172.22.0.166 +-- Database: simer1 +-- Server version: 5.0.45-community-nt +-- Server OS: Win32 +-- HeidiSQL version: 5.0.0.3272 +-- Date/time: 2012-09-27 14:29:24 +-- -------------------------------------------------------- + +/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; +/*!40101 SET NAMES utf8 */; +/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; +/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; + +-- Dumping data for table simer1.contelm: 31 rows +DELETE FROM contelm; + +-- Dumping data for table simer1.contype: 16 rows +DELETE FROM contype; +INSERT INTO contype (rid, name, state, step) VALUES (31, 'customer', 'APPROVED', 1), (32, 'product', 'APPROVED', 1), (33, 'phase', 'APPROVED', 1), (34, 'need', 'APPROVED', 1), (35, 'purpose', 'APPROVED', 1), (36, 'physic', 'APPROVED', 1), (37, 'object', 'APPROVED', 3), (38, 'part', 'APPROVED', 3), (39, 'model', 'APPROVED', 4), (310, 'element', 'APPROVED', 4), (311, 'shape', 'APPROVED', 4), (312, 'order', 'APPROVED', 4), (313, 'analysis', 'APPROVED', 5), (314, 'platform', 'APPROVED', 6), (315, 'module', 'APPROVED', 6), (316, 'component', 'APPROVED', 6); + +INSERT INTO contelm (rid, type, step, state, value, counter) VALUES (41, 31, 1, 'APPROVED', 'CEA Cadarache', 1), (42, 32, 1, 'APPROVED', 'Réacteur RAPSODIE', 3), (43, 33, 1, 'APPROVED', 'Démantèlement', 1), (44, 34, 1, 'APPROVED', 'Caractérisation du béton SERCOTER', 1), (45, 35, 1, 'APPROVED', 'Valider les résultats d''une précédente étude', 1), (46, 36, 1, 'APPROVED', 'Transport de particules', 2), (47, 37, 3, 'APPROVED', 'Réacteur nucléaire', 1), (48, 38, 3, 'APPROVED', 'Ensemble Bloc réacteur et Enceinte en béton', 1), (49, 39, 4, 'APPROVED', 'Éléments finis', 1), (410, 310, 4, 'APPROVED', 'Surfacique', 1), (411, 311, 4, 'APPROVED', 'Triangles', 1), (412, 314, 6, 'APPROVED', 'NARVEOS V3', 1), (413, 315, 6, 'APPROVED', 'NARMER V2', 1), (414, 316, 6, 'APPROVED', 'VIRTOOLS V5', 1), (415, 31, 1, 'APPROVED', 'Fonction transverse sûreté', 1), (416, 32, 1, 'APPROVED', 'Laser Mégajoule (LMJ)', 3), (417, 33, 1, 'APPROVED', 'Dossier de Validation DSGA/SSPP', 1), (418, 34, 1, 'APPROVED', 'Validation du calcul TRIPOLI4.5 via le PlugIn Pro/E', 1), (419, 35, 1, 'APPROVED', 'Cartographie neutronique', 1), (420, 37, 3, 'APPROVED', 'Bâtiment LMJ', 1), (421, 38, 3, 'APPROVED', 'Bât. Nord, Sud, Hall d''expériences, Hall lasers', 1), (422, 39, 4, 'APPROVED', 'CSG', 1), (423, 310, 4, 'APPROVED', 'Monte Carlo ', 1), (424, 311, 4, 'APPROVED', 'Combinatoire volumique', 1), (425, 314, 6, 'APPROVED', 'SALOME-TRIPOLI V2.04', 1), (426, 315, 6, 'APPROVED', 'TRIPOLI4.5', 1), (427, 32, 1, 'inCHECK', '_A380', 1), (428, 31, 1, 'inCHECK', '_Airbus', 1), (429, 35, 1, 'inCHECK', 'Analyse de l''impact foudre', 1), (430, 36, 1, 'inCHECK', 'Équation de Maxwell', 1), (431, 37, 3, 'inCHECK', '_Avion', 4); + +-- Dumping data for table simer1.cycle: 4 rows +DELETE FROM cycle; + +-- Dumping data for table simer1.doctag: 30 rows +DELETE FROM doctag; + +-- Dumping data for table simer1.doctype: 12 rows +DELETE FROM doctype; +INSERT INTO doctype (rid, name, state, step, result) VALUES (21, 'requirements', 'APPROVED', '-1-', NULL), (22, 'specification', 'APPROVED', '-1-', '1'), (23, 'design', 'APPROVED', '-2-', '2'), (24, 'geometry', 'APPROVED', '-3-', '3'), (25, 'model', 'APPROVED', '-4-', '4'), (26, 'loads', 'APPROVED', '-5-', '5'), (27, 'script', 'APPROVED', '-5-', NULL), (28, 'log', 'APPROVED', '-6-', NULL), (29, 'results', 'APPROVED', '-6-', '6'), (210, 'report', 'APPROVED', '-9-', '9'), (211, 'memorandum', 'APPROVED', '-2-3-4-7-', NULL), (212, 'minutes', 'APPROVED', '-1-2-3-4-5-6-7-9-', NULL); + +-- Dumping data for table simer1.document: 33 rows +DELETE FROM document; + +-- Dumping data for table simer1.docuse: 9 rows +DELETE FROM docuse; + +-- Dumping data for table simer1.file: 42 rows +DELETE FROM file; + +-- Dumping data for table simer1.knowelm: 23 rows +DELETE FROM knowelm; + +-- Dumping data for table simer1.knowtype: 6 rows +DELETE FROM knowtype; +INSERT INTO knowtype (rid, name, state) VALUES (11, 'usecase', 'inWORK'), (12, 'bestpractice', 'APPROVED'), (13, 'limitation', 'APPROVED'), (14, 'inconsistency', 'APPROVED'), (15, 'metrics', 'APPROVED'), (16, 'improvement', 'APPROVED'); + +-- Dumping data for table simer1.projext: 39 rows +DELETE FROM projext; + +-- Dumping data for table simer1.refid: 3 rows +DELETE FROM refid; + +-- Dumping data for table simer1.role: 9 rows +DELETE FROM role; +INSERT INTO role (username, role) VALUES ('simer', 'sysadmin'), ('jbt', 'manager'), ('hl', 'manager'), ('pdd', 'studengineer'), ('sdd', 'manager'), ('mko', 'manager'), ('pjt', 'manager'), ('rkv', 'manager'), ('xyz', 'user'); + +-- Dumping data for table simer1.scenario: 11 rows +DELETE FROM scenario; + +-- Dumping data for table simer1.stamp: 23 rows +DELETE FROM stamp; + +-- Dumping data for table simer1.study: 7 rows +DELETE FROM study; + +-- Dumping data for table simer1.users: 9 rows +DELETE FROM users; +INSERT INTO users (rid, username, password, first, last, display, email, organid) VALUES (1, 'simer', '92668751', 'Manager', 'Simulation', 'label.sysadmin', 'noreply@salome-platform.org', NULL), (2, 'jbt', NULL, 'Jean-Bernard', 'Trépon', 'Jean-Bernard Trépon', 'jean-bernard.trepon@euriware.fr', 'Euriware'), (3, 'hl', NULL, 'Hervé', 'Lexpert', 'Hervé', 'herve.lexpert@opencascade.com', 'OC-F'), (4, 'pdd', NULL, 'Paul', 'Durand', NULL, 'paul.durand@euriware.fr', 'Euriware'), (5, 'sdd', NULL, 'Sylvie', 'Dupond', NULL, 'sylvie.dupond@cea.fr', 'CEA'), (6, 'mko', NULL, 'Michel', 'Karyo', NULL, 'michel.karyo@opencascade.com', 'Nx1'), (7, 'pjt', NULL, 'Pierre', 'Jarnet', NULL, 'pierre.jarnet@euriware.fr', 'Nx2'), (8, 'rkv', NULL, 'Roman', 'Kozlov', 'Roman Kozlov', 'roman.kozlov@opencascade.com', 'OC-N'), (9, 'xyz', NULL, 'My surname', 'My name', 'Any string', 'me@provider.fr', NULL); + +INSERT INTO cycle (rid, type, publisher, reviewer, approver, signatory) VALUES (51, 24, NULL, 3, 2, NULL), (52, 210, 8, 6, 7, NULL), (53, 24, NULL, 3, 8, NULL), (54, 22, NULL, 7, 7, NULL); + + diff --git a/Workspace/Siman/sql/pgsql.inidata.sql b/Workspace/Siman/sql/pgsql.inidata.sql new file mode 100644 index 0000000..f43f7d2 --- /dev/null +++ b/Workspace/Siman/sql/pgsql.inidata.sql @@ -0,0 +1,104 @@ +LOCK TABLE descr_attr IN EXCLUSIVE MODE; +/*!40000 ALTER TABLE descr_attr DISABLE KEYS */; +INSERT INTO descr_attr VALUES (1,1,'Cette étude est livrée avec l''application comme exemple pour tester les fonctions de recherche et de navigation.'),(2,10,'Ajout de la description du scénario de calcul'),(3,24,'Prise en compte des retours internes'),(5,70,'sans void space'),(6,71,'avec void space'); +/*!40000 ALTER TABLE descr_attr ENABLE KEYS */; + +LOCK TABLE comment_attr IN EXCLUSIVE MODE; +/*!40000 ALTER TABLE comment_attr DISABLE KEYS */; +INSERT INTO comment_attr VALUES (4,33,'Le document peut être envoyé au client.'); +/*!40000 ALTER TABLE comment_attr ENABLE KEYS */; + +LOCK TABLE contype IN EXCLUSIVE MODE; +/*!40000 ALTER TABLE contype DISABLE KEYS */; +INSERT INTO contype VALUES (1,'customer','APPROVED',1),(2,'product','APPROVED',1),(3,'phase','APPROVED',1),(4,'need','APPROVED',1),(5,'purpose','APPROVED',1),(6,'physic','APPROVED',1),(7,'object','APPROVED',3),(8,'part','APPROVED',3),(9,'model','APPROVED',4),(10,'element','APPROVED',4),(11,'shape','APPROVED',4),(12,'order','APPROVED',4),(13,'analysis','APPROVED',5),(14,'platform','APPROVED',6),(15,'module','APPROVED',6),(16,'component','APPROVED',6); +/*!40000 ALTER TABLE contype ENABLE KEYS */; + +LOCK TABLE contelm IN EXCLUSIVE MODE; +/*!40000 ALTER TABLE contelm DISABLE KEYS */; +INSERT INTO contelm VALUES (1,1,1,'APPROVED','CEA Cadarache',1),(2,2,1,'APPROVED','Réacteur RAPSODIE',1),(3,3,1,'APPROVED','Démantèlement',1),(4,4,1,'APPROVED','Caractérisation du béton SERCOTER',1),(5,5,1,'APPROVED','Valider les résultats d''une précédente étude',1),(6,6,1,'APPROVED','Transport de particules',2),(7,7,3,'APPROVED','Réacteur nucléaire',1),(8,8,3,'APPROVED','Ensemble Bloc réacteur et Enceinte en béton',1),(9,9,4,'APPROVED','Éléments finis',1),(10,10,4,'APPROVED','Surfacique',1),(11,11,4,'APPROVED','Triangles',1),(12,14,6,'APPROVED','NARVEOS V3',1),(13,15,6,'APPROVED','NARMER V2',1),(14,16,6,'APPROVED','VIRTOOLS V5',1),(15,1,1,'APPROVED','Fonction transverse sûreté',1),(16,2,1,'APPROVED','Laser Mégajoule (LMJ)',1),(17,3,1,'APPROVED','Dossier de Validation DSGA/SSPP',1),(18,4,1,'APPROVED','Validation du calcul TRIPOLI4.5 via le PlugIn Pro/E',1),(19,5,1,'APPROVED','Cartographie neutronique',1),(20,7,3,'APPROVED','Bâtiment LMJ',1),(21,8,3,'APPROVED','Bât. Nord, Sud, Hall d''expériences, Hall lasers',1),(22,9,4,'APPROVED','CSG',1),(23,10,4,'APPROVED','Monte Carlo ',1),(24,11,4,'APPROVED','Combinatoire volumique',1),(25,14,6,'APPROVED','SALOME-TRIPOLI V2.04',1),(26,15,6,'APPROVED','TRIPOLI4.5',1); +/*!40000 ALTER TABLE contelm ENABLE KEYS */; + +LOCK TABLE doctype IN EXCLUSIVE MODE; +/*!40000 ALTER TABLE doctype DISABLE KEYS */; +INSERT INTO doctype VALUES (1,'requirements','APPROVED','-1-',NULL),(2,'specification','APPROVED','-1-','1'),(3,'design','APPROVED','-2-','2'),(4,'geometry','APPROVED','-3-','3'),(5,'model','APPROVED','-4-','4'),(6,'loads','APPROVED','-5-','5'),(7,'script','APPROVED','-5-',NULL),(8,'log','APPROVED','-6-',NULL),(9,'results','APPROVED','-6-','6'),(10,'report','APPROVED','-9-','9'),(11,'memorandum','APPROVED','-2-3-4-7-',NULL),(12,'minutes','APPROVED','-1-2-3-4-5-6-7-9-',NULL); +/*!40000 ALTER TABLE doctype ENABLE KEYS */; + +LOCK TABLE role IN EXCLUSIVE MODE; +/*!40000 ALTER TABLE role DISABLE KEYS */; +INSERT INTO role VALUES ('simer','sysadmin'),('jbt','manager'),('hl','manager'),('pdd','studengineer'),('sdd','manager'),('mko','manager'),('pjt','manager'); +/*!40000 ALTER TABLE role ENABLE KEYS */; + +LOCK TABLE "users" IN EXCLUSIVE MODE; +/*!40000 ALTER TABLE users DISABLE KEYS */; +INSERT INTO "users" VALUES (1,'simer','92668751','Manager','Simulation','label.sysadmin','noreply@salome-platform.org',NULL),(2,'jbt',NULL,'Jean-Bernard','Trépon','Jean-Bernard Trépon','jean-bernard.trepon@euriware.fr','Euriware'),(3,'hl',NULL,'Hervé','Lexpert','Hervé','herve.lexpert@opencascade.com','OC-F'),(4,'pdd',NULL,'Paul','Durand',NULL,'paul.durand@euriware.fr','Euriware'),(5,'sdd',NULL,'Sylvie','Dupond',NULL,'sylvie.dupond@cea.fr','CEA'),(6,'mko','108177','Michel','Karyo',NULL,'michel.karyo@opencascade.com','Nx1'),(7,'pjt','111034','Pierre','Jarnet',NULL,'pierre.jarnet@euriware.fr','Nx2'); +/*!40000 ALTER TABLE users ENABLE KEYS */; + +LOCK TABLE cycle IN EXCLUSIVE MODE; +/*!40000 ALTER TABLE cycle DISABLE KEYS */; +INSERT INTO cycle VALUES (1,4,NULL,3,2,NULL); +/*!40000 ALTER TABLE cycle ENABLE KEYS */; + +LOCK TABLE doctag IN EXCLUSIVE MODE; +/*!40000 ALTER TABLE doctag DISABLE KEYS */; +INSERT INTO doctag VALUES (1,5,1,'Y'),(9,45,41,'Y'),(8,44,41,'Y'),(4,13,2,'Y'),(5,16,2,'Y'),(6,23,1,'Y'),(7,34,1,'Y'),(10,50,42,'Y'),(11,51,42,'Y'),(12,65,42,'Y'),(13,73,41,'Y'); +/*!40000 ALTER TABLE doctag ENABLE KEYS */; + +LOCK TABLE document IN EXCLUSIVE MODE; +/*!40000 ALTER TABLE document DISABLE KEYS */; +INSERT INTO document VALUES (5,'DER100001.01',1,1,'EXTERN','Proposition technique',5,'GCVP-P/09-1629/V1',1,0,1,'2010-02-08'),(6,'DER100001.02',2,1,'inWORK','Spécifications générales',4,'0.1.0',0,1,2,'2010-03-05'),(9,'DER100001.02',2,1,'inWORK','Spécifications générales',4,'0.2.0',0,1,3,'2010-03-12'),(13,'DER100001.04',4,3,'inWORK','Assemblage SERCOTER',2,'0.1.0',1,0,4,'2010-03-26'),(16,'DER100001.05',11,3,'inCHECK','Modifications et simplifications retenues',2,'1.0.0',1,0,5,'2010-03-26'),(23,'DER100001.02',2,1,'APPROVED','Spécifications générales',4,'1.0.0',1,0,6,'2010-03-24'),(34,'DER100001.07',10,9,'inCHECK','Comparaison des résultats',2,'1.0.0',1,0,8,'2010-04-16'),(44,'DER110001.01',1,1,'EXTERN','Cahier des charges',5,NULL,1,0,9,'2011-05-03'),(45,'DER110001.02',2,1,'inDRAFT','Spécifications générales',5,'0.1.0',1,0,10,'2010-05-03'),(50,'DER110001.03',4,3,'inCHECK','Assemblage PCC',5,'1.0.0',1,0,11,'2011-05-03'),(51,'DER110001.04',11,3,'inCHECK','Description de l''assemblage',5,'1.0.0',1,0,12,'2011-05-03'),(65,'DER110001.05',5,4,'inDRAFT','PCC',5,'0.1.0',1,0,14,'2011-05-03'),(73,'DER110001.06',10,9,'inDRAFT','Comparaison des résultats',5,'0.1.0',1,0,18,'2011-05-17'); +/*!40000 ALTER TABLE document ENABLE KEYS */; + +LOCK TABLE docuse IN EXCLUSIVE MODE; +/*!40000 ALTER TABLE docuse DISABLE KEYS */; +INSERT INTO docuse VALUES (2,1),(3,2),(4,3),(5,4),(6,5),(7,6),(8,7),(9,7),(10,9); +/*!40000 ALTER TABLE docuse ENABLE KEYS */; + +LOCK TABLE file IN EXCLUSIVE MODE; +/*!40000 ALTER TABLE file DISABLE KEYS */; +INSERT INTO file VALUES (1,'pdf','2010/DER100001/1.Study/DER100001.01.pdf','2010-02-08'),(2,'xml','2010/DER100001/1.Study/DER100001.02.xml','2010-03-05'),(3,'xml','2010/DER100001/1.Study/DER100001.03.xml','2010-03-12'),(4,'sldasm','2010/DER100001/2.Geometry/DER100001.04.sldasm','2010-03-26'),(5,'doc','2010/DER100001/2.Geometry/DER100001.05.doc','2010-03-26'),(6,'xml','2010/DER100001/1.Study/DER100001.06.xml','2010-03-24'),(7,'pdf','2010/DER100001/1.Study/DER100001.06.pdf','2012-07-05'),(8,'xml','2010/DER100001/1.Study/DER100001.07.xml','2010-04-16'),(9,'pdf','2011/DER110001/1.Study/DER110001.01.pdf','2011-05-03'),(10,'xml','2011/DER110001/1.Study/DER110001.02.xml','2010-05-03'),(11,'ProE','2011/DER110001/2.Geometry/DER110001.03.ProE','2011-05-03'),(12,'doc','2011/DER110001/2.Geometry/DER110001.04.doc','2011-05-03'),(13,'gdml','2011/DER110001/2.Geometry/DER110001.03.gdml','2012-07-05'),(14,'hdf','2011/DER110001/3.Mesh/DER110001.05.hdf','2011-05-03'),(15,'gdml','2011/DER110001/3.Mesh/DER110001.05.gdml','2012-07-05'),(16,'tri','2011/DER110001/3.Mesh/DER110001.05.tri','2012-07-05'),(17,'pdf','2011/DER110001/3.Mesh/DER110001.05.pdf','2012-07-05'),(18,'xml','2011/DER110001/1.Study/DER110001.06.xml','2011-05-17'); +/*!40000 ALTER TABLE file ENABLE KEYS */; + +LOCK TABLE knowelm IN EXCLUSIVE MODE; +/*!40000 ALTER TABLE knowelm DISABLE KEYS */; +INSERT INTO knowelm VALUES (1,1,2,'inWORK','Caractérisation du béton SERCOTER','

Scénario 1

',1,'2012-07-05'),(2,3,2,'inDRAFT','Format du modèle géométrique','

Seul le format 3DXML V5 ou antérieur est supporté.

',2,'2012-07-05'),(3,2,2,'APPROVED','Compréhension de l''environnement','

Avoir une compréhension globale du débit de dose en commençant par effectuer une cartographie.

',2,'2012-07-05'),(4,2,2,'APPROVED','Calage du modèle radiologique','

A partir de sources à 1 Bq/m3, faire évoluer une source à la fois et vérifier l''impact sur les points de calcul pour connaitre l''influence relative des sources.

',2,'2012-07-05'),(5,2,2,'APPROVED','Calage du modèle radiologique','

Toujours faire le premier calcul sans built-up.

',2,'2012-07-05'),(6,3,2,'APPROVED','Effets diffusés indirects','

L''outil ne tenant pas compte des effets diffusés indirects, faire attention à la géométrie autour des points de calcul.

',2,'2012-07-05'),(7,6,2,'APPROVED','Gestion des écrans','

Mieux gérer les multi-écrans à géométrie cylindrique.

',2,'2012-07-05'),(8,1,42,'inWORK','Validation des voies de production de la plate-forme Radioprotection','

Scénario Tripoli

',1,'2012-07-05'),(9,1,43,'inWORK','Validation des voies de production de la plate-forme Radioprotection','

Scénario MCNP

',1,'2012-07-05'),(10,2,42,'APPROVED','Compréhension des modèles CAO','

Convertir le modèle CAO par élément (part) et constituer les assemblages sous GDML en vérifiant à chaque étape qu''il n''existe pas d''intersection entre les éléments.

',5,'2012-07-05'),(11,2,42,'APPROVED','Génération du volume complémentaire','

Appliquer la génération du volume complémentaire au modèle GDML global de l''installation en sauvegardant le découpage de l''espace complémentaire en tant que volume.

',5,'2012-07-05'),(12,3,42,'APPROVED','Découpage du volume complémentaire','

Inutile de découper le complémentaire pour le code TRIPOLI4.5. Les performances calculs ne sont pas meilleures.

',5,'2012-07-05'),(13,3,42,'APPROVED','Option de pondération','

impossible de visualiser sous le viewer OCC les grilles de pondération dans la géométrie (temps d''affichage prohibitif).

',5,'2012-07-05'),(14,6,42,'APPROVED','Grille de pondération TRIPOLI4.5','

Faire évoluer le viewer Ray tracing pour qu''il puisse afficher les grilles de pondération et de maillage.

',5,'2012-07-05'); +/*!40000 ALTER TABLE knowelm ENABLE KEYS */; + +LOCK TABLE knowtype IN EXCLUSIVE MODE; +/*!40000 ALTER TABLE knowtype DISABLE KEYS */; +INSERT INTO knowtype VALUES (1,'usecase','inWORK'),(2,'bestpractice','APPROVED'),(3,'limitation','APPROVED'),(4,'inconsistency','APPROVED'),(5,'metrics','APPROVED'),(6,'improvement','APPROVED'); +/*!40000 ALTER TABLE knowtype ENABLE KEYS */; + +LOCK TABLE projext IN EXCLUSIVE MODE; +/*!40000 ALTER TABLE projext DISABLE KEYS */; +INSERT INTO projext VALUES (1,0,1),(1,1,2),(1,2,3),(1,3,4),(1,4,5),(1,5,6),(2,0,7),(2,1,8),(2,2,9),(2,3,10),(2,4,11),(2,5,12),(2,6,13),(2,7,14),(41,0,15),(41,1,16),(41,2,17),(41,3,18),(41,4,19),(41,5,6),(42,0,20),(42,1,21),(42,2,22),(42,3,23),(42,4,24),(42,5,25),(42,6,26); +/*!40000 ALTER TABLE projext ENABLE KEYS */; + +LOCK TABLE refid IN EXCLUSIVE MODE; +/*!40000 ALTER TABLE refid DISABLE KEYS */; +INSERT INTO refid VALUES (2010,1),(2011,1); +/*!40000 ALTER TABLE refid ENABLE KEYS */; + +LOCK TABLE relation IN EXCLUSIVE MODE; +/*!40000 ALTER TABLE relation DISABLE KEYS */; +INSERT INTO relation VALUES (3,'contributor',1,4),(4,'cycle',1,1),(7,'uses',6,5),(8,'usedby',5,6),(10,'versions',9,6),(11,'uses',9,5),(12,'usedby',5,9),(14,'uses',13,23),(15,'usedby',23,13),(17,'uses',16,23),(18,'usedby',23,16),(19,'uses',16,13),(20,'usedby',13,16),(21,'stamp',16,22),(24,'versions',23,9),(25,'stamp',23,26),(27,'uses',23,5),(28,'usedby',5,23),(29,'stamp',23,30),(31,'converts',23,7),(32,'stamp',23,33),(35,'stamp',34,36),(37,'stamp',34,38),(46,'stamp',45,47),(48,'uses',45,44),(49,'usedby',44,45),(52,'stamp',50,53),(54,'stamp',51,55),(56,'stamp',50,57),(58,'uses',50,45),(59,'usedby',45,50),(60,'uses',51,45),(61,'usedby',45,51),(62,'uses',51,50),(63,'usedby',50,51),(64,'converts',50,13),(66,'stamp',65,67),(68,'uses',65,50),(69,'usedby',50,65),(70,'converts',65,15),(71,'converts',65,16),(72,'converts',65,17),(74,'stamp',73,75); +/*!40000 ALTER TABLE relation ENABLE KEYS */; + +LOCK TABLE scenario IN EXCLUSIVE MODE; +/*!40000 ALTER TABLE scenario DISABLE KEYS */; +INSERT INTO scenario VALUES (2,1,1,0,'Scénario 1',2,NULL,'2010-01-25','2010-01-25'),(42,1,41,0,'Scénario Tripoli',5,NULL,'2011-05-03','2011-05-03'),(43,2,41,1,'Scénario MCNP',5,NULL,'2011-05-03','2011-05-03'); +/*!40000 ALTER TABLE scenario ENABLE KEYS */; + +LOCK TABLE stamp IN EXCLUSIVE MODE; +/*!40000 ALTER TABLE stamp DISABLE KEYS */; +INSERT INTO stamp VALUES (22,'PROMOTION',2,'2010-03-26 00:00:00'),(26,'PROMOTION',2,'2010-03-24 00:00:00'),(30,'REVIEW',6,'2010-03-26 10:15:00'),(33,'APPROVAL',7,'2010-03-26 16:30:00'),(36,'PROMOTION',2,'2010-04-16 00:00:00'),(38,'REVIEW',6,'2010-04-19 10:15:00'),(47,'PROMOTION',5,'2010-05-03 00:00:00'),(53,'PROMOTION',5,'2011-05-03 00:00:00'),(55,'PROMOTION',5,'2011-05-03 00:00:00'),(57,'REVIEW',5,'2011-05-08 00:00:00'),(67,'PROMOTION',5,'2011-05-03 00:00:00'),(75,'PROMOTION',5,'2011-05-18 00:00:00'); +/*!40000 ALTER TABLE stamp ENABLE KEYS */; + +LOCK TABLE study IN EXCLUSIVE MODE; +/*!40000 ALTER TABLE study DISABLE KEYS */; +INSERT INTO study VALUES (1,'DER100001','Caractérisation du béton SERCOTER','inCHECK','PUBLIC',2,'1.0.0',7,0,'2010-01-25','2010-01-25'),(41,'DER110001','Validation des voies de production de la plate-forme Radioprotection','inDRAFT','PUBLIC',5,'0.1.0',6,0,'2011-05-03','2011-05-03'); +/*!40000 ALTER TABLE study ENABLE KEYS */; + +LOCK TABLE text IN EXCLUSIVE MODE; +/*!40000 ALTER TABLE text DISABLE KEYS */; +INSERT INTO text VALUES (1,'Cette étude est livrée avec l''application comme exemple pour tester les fonctions de recherche et de navigation.'),(2,'Ajout de la description du scénario de calcul'),(3,'Prise en compte des retours internes'),(4,'Le document peut être envoyé au client.'),(5,'sans void space'),(6,'avec void space'); +/*!40000 ALTER TABLE text ENABLE KEYS */; diff --git a/Workspace/Siman/sql/users.xml b/Workspace/Siman/sql/users.xml new file mode 100644 index 0000000..f8ddbd5 --- /dev/null +++ b/Workspace/Siman/sql/users.xml @@ -0,0 +1,33 @@ + + + + + Roman + Kozlov + Roman KOZLOV + rkv + manager + roman.kozlov@opencascade.com + OC-N + + + + Daniel + Brunier-Coulin + Daniel Brunier-Coulin + dbc + manager,knowledgineer + daniel.brunier-coulin@opencascade.com + OC-F + + + + Alexander + Brivin + bri + manager + alexander.brivin@opencascade.com + OC-N + + + \ No newline at end of file -- 2.39.2