From 00b60f8dd21989728e2c6cc3fc27e2cd1e102ddc Mon Sep 17 00:00:00 2001 From: rkv Date: Mon, 21 Jan 2013 05:09:22 +0000 Subject: [PATCH] *** empty log message *** --- Workspace/Siman-Common/ testng_util.xml | 20 - Workspace/Siman-Common/.checkstyle | 6 - Workspace/Siman-Common/.classpath | 36 - Workspace/Siman-Common/.cvsignore | 16 - Workspace/Siman/.checkstyle | 6 - Workspace/Siman/.classpath | 17 - Workspace/Siman/.cvsignore | 15 - .../Ant_Siman_Dev_Config_Builder.launch | 25 - .../Ant_Siman_War_Builder.launch | 26 - Workspace/Siman/.pmd | 7 - Workspace/Siman/.project | 71 -- Workspace/Siman/.ruleset | 235 ------ .../.settings/org.eclipse.jdt.apt.core.prefs | 4 - .../.settings/org.eclipse.jdt.core.prefs | 8 - ...clipse.jst.common.project.facet.core.prefs | 4 - .../org.eclipse.ltk.core.refactoring.prefs | 3 - .../org.eclipse.wst.common.component | 151 ---- ....eclipse.wst.common.project.facet.core.xml | 9 - .../org.eclipse.wst.validation.prefs | 6 - Workspace/Siman/.springBeans | 22 - Workspace/Siman/applet_howto.txt | 90 -- Workspace/Siman/siman-pmd.ruleset | 773 ------------------ Workspace/Siman/sql/drop_simer_tables.sql | 33 - Workspace/Siman/sql/pg_simer_ini_data.sql | 75 -- Workspace/Siman/sql/pgsql.inidata.sql | 104 --- Workspace/Siman/sql/simer_ini_data.sql | 88 -- 26 files changed, 1850 deletions(-) delete mode 100644 Workspace/Siman-Common/ testng_util.xml delete mode 100644 Workspace/Siman-Common/.checkstyle delete mode 100644 Workspace/Siman-Common/.classpath delete mode 100644 Workspace/Siman-Common/.cvsignore delete mode 100644 Workspace/Siman/.checkstyle delete mode 100644 Workspace/Siman/.classpath delete mode 100644 Workspace/Siman/.cvsignore delete mode 100644 Workspace/Siman/.externalToolBuilders/Ant_Siman_Dev_Config_Builder.launch delete mode 100644 Workspace/Siman/.externalToolBuilders/Ant_Siman_War_Builder.launch delete mode 100644 Workspace/Siman/.pmd delete mode 100644 Workspace/Siman/.project delete mode 100644 Workspace/Siman/.ruleset delete mode 100644 Workspace/Siman/.settings/org.eclipse.jdt.apt.core.prefs delete mode 100644 Workspace/Siman/.settings/org.eclipse.jdt.core.prefs delete mode 100644 Workspace/Siman/.settings/org.eclipse.jst.common.project.facet.core.prefs delete mode 100644 Workspace/Siman/.settings/org.eclipse.ltk.core.refactoring.prefs delete mode 100644 Workspace/Siman/.settings/org.eclipse.wst.common.component delete mode 100644 Workspace/Siman/.settings/org.eclipse.wst.common.project.facet.core.xml delete mode 100644 Workspace/Siman/.settings/org.eclipse.wst.validation.prefs delete mode 100644 Workspace/Siman/.springBeans delete mode 100644 Workspace/Siman/applet_howto.txt delete mode 100644 Workspace/Siman/siman-pmd.ruleset delete mode 100644 Workspace/Siman/sql/drop_simer_tables.sql delete mode 100644 Workspace/Siman/sql/pg_simer_ini_data.sql delete mode 100644 Workspace/Siman/sql/pgsql.inidata.sql delete mode 100644 Workspace/Siman/sql/simer_ini_data.sql diff --git a/Workspace/Siman-Common/ testng_util.xml b/Workspace/Siman-Common/ testng_util.xml deleted file mode 100644 index 9c58f73..0000000 --- a/Workspace/Siman-Common/ testng_util.xml +++ /dev/null @@ -1,20 +0,0 @@ - - - - - - - - - - - - - - - - diff --git a/Workspace/Siman-Common/.checkstyle b/Workspace/Siman-Common/.checkstyle deleted file mode 100644 index c606f32..0000000 --- a/Workspace/Siman-Common/.checkstyle +++ /dev/null @@ -1,6 +0,0 @@ - - - - - - diff --git a/Workspace/Siman-Common/.classpath b/Workspace/Siman-Common/.classpath deleted file mode 100644 index 20999c6..0000000 --- a/Workspace/Siman-Common/.classpath +++ /dev/null @@ -1,36 +0,0 @@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - diff --git a/Workspace/Siman-Common/.cvsignore b/Workspace/Siman-Common/.cvsignore deleted file mode 100644 index 54d2c55..0000000 --- a/Workspace/Siman-Common/.cvsignore +++ /dev/null @@ -1,16 +0,0 @@ -build -dist -bin -build/* -dist/* -bin/* -*.class -*.war -test-output -test-output/* -test-output/*.* -reports -reports/* -temp -temp/* -temp/*.* diff --git a/Workspace/Siman/.checkstyle b/Workspace/Siman/.checkstyle deleted file mode 100644 index c606f32..0000000 --- a/Workspace/Siman/.checkstyle +++ /dev/null @@ -1,6 +0,0 @@ - - - - - - diff --git a/Workspace/Siman/.classpath b/Workspace/Siman/.classpath deleted file mode 100644 index 1c4a2bf..0000000 --- a/Workspace/Siman/.classpath +++ /dev/null @@ -1,17 +0,0 @@ - - - - - - - - - - - - - - - - - diff --git a/Workspace/Siman/.cvsignore b/Workspace/Siman/.cvsignore deleted file mode 100644 index af5d841..0000000 --- a/Workspace/Siman/.cvsignore +++ /dev/null @@ -1,15 +0,0 @@ -Thumbs.db -build -dist -bin -generated -build/* -dist/* -bin/* -*.class -*.war -reports -reports/* -temp -temp/* -temp/*.* diff --git a/Workspace/Siman/.externalToolBuilders/Ant_Siman_Dev_Config_Builder.launch b/Workspace/Siman/.externalToolBuilders/Ant_Siman_Dev_Config_Builder.launch deleted file mode 100644 index e8fb2f2..0000000 --- a/Workspace/Siman/.externalToolBuilders/Ant_Siman_Dev_Config_Builder.launch +++ /dev/null @@ -1,25 +0,0 @@ - - - - - - - - - - - - - - - - - - - - - - - - - diff --git a/Workspace/Siman/.externalToolBuilders/Ant_Siman_War_Builder.launch b/Workspace/Siman/.externalToolBuilders/Ant_Siman_War_Builder.launch deleted file mode 100644 index 2bf33ed..0000000 --- a/Workspace/Siman/.externalToolBuilders/Ant_Siman_War_Builder.launch +++ /dev/null @@ -1,26 +0,0 @@ - - - - - - - - - - - - - - - - - - - - - - - - - - diff --git a/Workspace/Siman/.pmd b/Workspace/Siman/.pmd deleted file mode 100644 index dc7a2c1..0000000 --- a/Workspace/Siman/.pmd +++ /dev/null @@ -1,7 +0,0 @@ - - - true - siman-pmd.ruleset - false - true - diff --git a/Workspace/Siman/.project b/Workspace/Siman/.project deleted file mode 100644 index f333516..0000000 --- a/Workspace/Siman/.project +++ /dev/null @@ -1,71 +0,0 @@ - - - Siman - - - Siman-Common - SPlat - - - - org.eclipse.ui.externaltools.ExternalToolBuilder - auto,full,incremental, - - - LaunchConfigHandle - <project>/.externalToolBuilders/Ant_Siman_Dev_Config_Builder.launch - - - - - org.eclipse.jdt.core.javabuilder - - - - - org.eclipse.wst.common.project.facet.core.builder - - - - - org.eclipse.wst.validation.validationbuilder - - - - - org.eclipse.ui.externaltools.ExternalToolBuilder - clean,full,incremental, - - - LaunchConfigHandle - <project>/.externalToolBuilders/Ant_Siman_War_Builder.launch - - - - - com.atlassw.tools.eclipse.checkstyle.CheckstyleBuilder - - - - - org.springframework.ide.eclipse.core.springbuilder - - - - - net.sourceforge.pmd.eclipse.plugin.pmdBuilder - - - - - - org.springframework.ide.eclipse.core.springnature - org.eclipse.wst.common.project.facet.core.nature - org.eclipse.jdt.core.javanature - org.eclipse.wst.common.modulecore.ModuleCoreNature - org.eclipse.jem.workbench.JavaEMFNature - com.atlassw.tools.eclipse.checkstyle.CheckstyleNature - net.sourceforge.pmd.runtime.pmdNature - net.sourceforge.pmd.eclipse.plugin.pmdNature - - diff --git a/Workspace/Siman/.ruleset b/Workspace/Siman/.ruleset deleted file mode 100644 index d9cce2c..0000000 --- a/Workspace/Siman/.ruleset +++ /dev/null @@ -1,235 +0,0 @@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - diff --git a/Workspace/Siman/.settings/org.eclipse.jdt.apt.core.prefs b/Workspace/Siman/.settings/org.eclipse.jdt.apt.core.prefs deleted file mode 100644 index 743a614..0000000 --- a/Workspace/Siman/.settings/org.eclipse.jdt.apt.core.prefs +++ /dev/null @@ -1,4 +0,0 @@ -#Wed Sep 19 19:21:52 MSD 2012 -eclipse.preferences.version=1 -org.eclipse.jdt.apt.aptEnabled=true -org.eclipse.jdt.apt.genSrcDir=.apt_src diff --git a/Workspace/Siman/.settings/org.eclipse.jdt.core.prefs b/Workspace/Siman/.settings/org.eclipse.jdt.core.prefs deleted file mode 100644 index 6eaba40..0000000 --- a/Workspace/Siman/.settings/org.eclipse.jdt.core.prefs +++ /dev/null @@ -1,8 +0,0 @@ -#Wed Sep 19 19:21:52 MSD 2012 -eclipse.preferences.version=1 -org.eclipse.jdt.core.compiler.codegen.targetPlatform=1.6 -org.eclipse.jdt.core.compiler.compliance=1.6 -org.eclipse.jdt.core.compiler.problem.assertIdentifier=error -org.eclipse.jdt.core.compiler.problem.enumIdentifier=error -org.eclipse.jdt.core.compiler.processAnnotations=enabled -org.eclipse.jdt.core.compiler.source=1.6 diff --git a/Workspace/Siman/.settings/org.eclipse.jst.common.project.facet.core.prefs b/Workspace/Siman/.settings/org.eclipse.jst.common.project.facet.core.prefs deleted file mode 100644 index 358b769..0000000 --- a/Workspace/Siman/.settings/org.eclipse.jst.common.project.facet.core.prefs +++ /dev/null @@ -1,4 +0,0 @@ -#Wed Sep 19 19:21:52 MSD 2012 -classpath.helper/org.eclipse.jdt.launching.JRE_CONTAINER/owners=jst.java\:6.0 -classpath.helper/org.eclipse.jst.server.core.container\:\:org.eclipse.jst.server.tomcat.runtimeTarget\:\:Apache\ Tomcat\ v6.0/owners=jst.web\:2.5 -eclipse.preferences.version=1 diff --git a/Workspace/Siman/.settings/org.eclipse.ltk.core.refactoring.prefs b/Workspace/Siman/.settings/org.eclipse.ltk.core.refactoring.prefs deleted file mode 100644 index 981fe80..0000000 --- a/Workspace/Siman/.settings/org.eclipse.ltk.core.refactoring.prefs +++ /dev/null @@ -1,3 +0,0 @@ -#Thu Sep 20 12:53:11 MSD 2012 -eclipse.preferences.version=1 -org.eclipse.ltk.core.refactoring.enable.project.refactoring.history=false diff --git a/Workspace/Siman/.settings/org.eclipse.wst.common.component b/Workspace/Siman/.settings/org.eclipse.wst.common.component deleted file mode 100644 index 20caf89..0000000 --- a/Workspace/Siman/.settings/org.eclipse.wst.common.component +++ /dev/null @@ -1,151 +0,0 @@ - - - - - - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - uses - - - - - diff --git a/Workspace/Siman/.settings/org.eclipse.wst.common.project.facet.core.xml b/Workspace/Siman/.settings/org.eclipse.wst.common.project.facet.core.xml deleted file mode 100644 index c0a8123..0000000 --- a/Workspace/Siman/.settings/org.eclipse.wst.common.project.facet.core.xml +++ /dev/null @@ -1,9 +0,0 @@ - - - - - - - - - diff --git a/Workspace/Siman/.settings/org.eclipse.wst.validation.prefs b/Workspace/Siman/.settings/org.eclipse.wst.validation.prefs deleted file mode 100644 index 0963748..0000000 --- a/Workspace/Siman/.settings/org.eclipse.wst.validation.prefs +++ /dev/null @@ -1,6 +0,0 @@ -#Thu Sep 20 12:53:11 MSD 2012 -DELEGATES_PREFERENCE=delegateValidatorListorg.eclipse.wst.wsdl.validation.internal.eclipse.WSDLDelegatingValidator\=org.eclipse.wst.wsdl.validation.internal.eclipse.Validator;org.eclipse.wst.xsd.core.internal.validation.eclipse.XSDDelegatingValidator\=org.eclipse.wst.xsd.core.internal.validation.eclipse.Validator; -USER_BUILD_PREFERENCE=enabledBuildValidatorListorg.eclipse.wst.wsdl.validation.internal.eclipse.WSDLDelegatingValidator;org.eclipse.wst.xsd.core.internal.validation.eclipse.XSDDelegatingValidator;org.eclipse.wst.dtd.core.internal.validation.eclipse.Validator;org.eclipse.jst.jsp.core.internal.validation.JSPContentValidator;org.eclipse.wst.common.componentcore.internal.ModuleCoreValidator;org.eclipse.jst.j2ee.internal.classpathdep.ClasspathDependencyValidator;org.eclipse.jst.jsf.validation.internal.JSPSemanticsValidator;org.eclipse.jst.jsp.core.internal.validation.JSPBatchValidator;org.eclipse.wst.wsi.ui.internal.WSIMessageValidator;org.eclipse.wst.html.internal.validation.HTMLValidator;org.eclipse.jst.jsf.validation.internal.appconfig.AppConfigValidator;org.eclipse.wst.xml.core.internal.validation.eclipse.Validator; -USER_MANUAL_PREFERENCE=enabledManualValidatorListorg.eclipse.wst.wsdl.validation.internal.eclipse.WSDLDelegatingValidator;org.eclipse.wst.xsd.core.internal.validation.eclipse.XSDDelegatingValidator;org.eclipse.wst.dtd.core.internal.validation.eclipse.Validator;org.eclipse.jst.jsp.core.internal.validation.JSPContentValidator;org.eclipse.wst.common.componentcore.internal.ModuleCoreValidator;org.eclipse.jst.j2ee.internal.classpathdep.ClasspathDependencyValidator;org.eclipse.jst.jsf.validation.internal.JSPSemanticsValidator;org.eclipse.jst.jsp.core.internal.validation.JSPBatchValidator;org.eclipse.wst.wsi.ui.internal.WSIMessageValidator;org.eclipse.wst.html.internal.validation.HTMLValidator;org.eclipse.jst.jsf.validation.internal.appconfig.AppConfigValidator;org.eclipse.wst.xml.core.internal.validation.eclipse.Validator; -USER_PREFERENCE=overrideGlobalPreferencesfalse -eclipse.preferences.version=1 diff --git a/Workspace/Siman/.springBeans b/Workspace/Siman/.springBeans deleted file mode 100644 index 9cb669e..0000000 --- a/Workspace/Siman/.springBeans +++ /dev/null @@ -1,22 +0,0 @@ - - - - xml - - - src/spring/applicationContext.xml - - - - - true - false - - /Siman-Common/src/spring/businessServiceContext.xml - /Siman-Common/src/spring/globalContext.xml - /Siman-Common/src/spring/technicalServiceContext.xml - src/spring/applicationContext.xml - - - - diff --git a/Workspace/Siman/applet_howto.txt b/Workspace/Siman/applet_howto.txt deleted file mode 100644 index 0c0a694..0000000 --- a/Workspace/Siman/applet_howto.txt +++ /dev/null @@ -1,90 +0,0 @@ -set path=%path%;C:\Program Files\Java\jdk1.6.0_03\bin - - -D:\users\rkv\SIMAN\SIMAN_SRC\Workspace\Siman\build\classes> -set path=%path%;"C:\Program Files\Java\jdk1.6.0_20\bin" - -C:\work\Siman\SIMAN_SRC\Workspace\Siman\build\classes> -jar cvf splat-launcher.jar org\splat\launcher\*.class - - -cd ..\..\WebContent\jap - -jarsigner -verbose -keystore launcherkeystore -signedjar splat-signedlauncher.jar splat-launcher.jar launcheralias - - - -For creation the applet please use the following java methods : - - //To get the SALOME_HOME environment variable - String SALOME_HOME = System.getenv("SALOME_ROOT_DIR"); - - If SALOME_ROOT_DIR does not exist the SALOME_HOME equals to _null_. - - //To execute the RunSalome script - Runtime runtime = Runtime.getRuntime(); - String pathToScript = SALOME_HOME+"\\runSalome" or pathToScript = SALOME_HOME+"runSalome" - - if (new File(pathToScript).exists()) { - Process process = runtime.exec(pathToScript); - } - - - - - - - - - - - -Dear Colleagues, - - - - Some more details about current procedure of SALOME running - - It probably will be updated in accordance with changes of SALOME directories - organizarion - - - - To check availability of SALOME environment, the applet should : - - - check existence of environment variable $SALOME_ROOT_DIR - - - check existence of environment file $SALOME_ROOT_DIR/env_build.sh - - - existence of run bash script $SALOME_ROOT_DIR/KERNEL/bin/salome/runSalome - - - - To run SALOME-SIMAN : - - - open bash shell - - bash - - - export SALOME environment variables - - . $SALOME_ROOT_DIR/env_build.sh - - - run bash shell script - - runSalome --siman --siman-study=s --siman-scenario=sc --siman-user=u -k - - - where : - - the SIMAN parameters are displayed as Title of the SALOME GUI Window - - "-k" is to kill previously run runSalome and all SALOME processes - - - - -- - - Best Regards, - - Alexander \ No newline at end of file diff --git a/Workspace/Siman/siman-pmd.ruleset b/Workspace/Siman/siman-pmd.ruleset deleted file mode 100644 index e610618..0000000 --- a/Workspace/Siman/siman-pmd.ruleset +++ /dev/null @@ -1,773 +0,0 @@ - - - PMD Plugin preferences rule set Hewis - level 1 : not to be violated AREVA requirements - level 2 : not to be violated EURIWARE requirements - level 3 :should not be violated AREVA requirements - level 4 :should not be violated EURIWARE requirements - level 5 : good practices - - - .*/test/.* - - - 5 - - - 5 - - - 2 - - - 5 - - - 4 - - - 5 - - - 5 - - - 5 - - - 5 - - - 5 - - - 4 - - - 5 - - - 5 - - - 5 - - - 5 - - - 5 - - - 5 - - - 4 - - - 4 - - - 4 - - - 5 - - - 5 - - - 5 - - - 5 - - - 5 - - - 5 - - - 5 - - - 5 - - - 2 - - - 2 - - - 5 - - - 5 - - - 5 - - - 3 - - - 5 - - - 5 - - - 5 - - - 2 - - - 5 - - - 5 - - - 2 - - - 2 - - - 2 - - - 5 - - - 5 - - - 3 - - - 3 - - - 1 - - - 5 - - - 3 - - - 2 - - - 5 - - - 5 - - - 5 - - - 3 - - - 2 - - - 2 - - - 5 - - - 5 - - - 2 - - - 5 - - - 1 - - - 4 - - - 2 - - - 2 - - - 2 - - - 5 - - - 2 - - - 2 - - - 4 - - - 4 - - - 2 - - - 2 - - - 4 - - - 2 - - - 4 - - - 3 - - - 3 - - - 3 - - - 3 - - - 5 - - - 5 - - - 4 - - - 2 - - - 2 - - - 2 - - - 2 - - - 2 - - - 2 - - - 2 - - - 5 - - - 5 - - - 4 - - - 5 - - - 4 - - - 2 - - - 2 - - - 2 - - - 2 - - - 2 - - - 3 - - - 5 - - - 5 - - - 2 - - - 3 - - - 4 - - - 2 - - - 2 - - - 2 - - - 4 - - - 2 - - - 3 - - - 4 - - - 2 - - - 2 - - - 2 - - - 4 - - - 5 - - - 3 - - - 5 - - - 2 - - - 2 - - - 4 - - - 4 - - - 5 - - - 2 - - - 3 - - - 5 - - - 2 - - - 5 - - - 2 - - - 2 - - - 2 - - - 1 - - - 3 - - - 3 - - - 1 - - - 1 - - - - 2 - - - 2 - - - - 3 - - - 2 - - - 2 - - - 4 - - - 4 - - - 4 - - - 3 - - - 3 - - - 3 - - - 3 - - - 5 - - - 5 - - - 5 - - - 2 - - - 3 - - - 4 - - - 3 - - - 3 - - - 3 - - - 5 - - - 2 - - - 2 - - - 4 - - - 4 - - - - - - 4 - - - 4 - - - 4 - - - 4 - - - 2 - - - 4 - - - 4 - - - 2 - - - 4 - - - 4 - - - 4 - - - 4 - - - 4 - - - 4 - - - 2 - - - 4 - - - 2 - - - - - - - - - 1 - - - 1 - - - 1 - - - 2 - - - 1 - - - 2 - - - 2 - - - 2 - - - 2 - - - 2 - - - 2 - - - 2 - - - 1 - - - 1 - - - 1 - - - 5 - - - 3 - - - - - - 3 - - - - - - 4 - - - - - - - 3 - - - - - - 3 - - - 4 - - - - - - 4 - - - 4 - - - 4 - - - 4 - - - - - - 4 - - - 2 - - - 2 - - - 2 - - - 5 - - - - Detects when a field has not a name starting with '_'. - - - 1 - - - - - - - - - - Detects when a parameter has a name starting with '_'. - - - 1 - - - - - - - - - - Detect using of condition?statement:statement; - - 1 - - - - - - - - 3 - - - - - - - diff --git a/Workspace/Siman/sql/drop_simer_tables.sql b/Workspace/Siman/sql/drop_simer_tables.sql deleted file mode 100644 index fbf6597..0000000 --- a/Workspace/Siman/sql/drop_simer_tables.sql +++ /dev/null @@ -1,33 +0,0 @@ -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 deleted file mode 100644 index fe331b1..0000000 --- a/Workspace/Siman/sql/pg_simer_ini_data.sql +++ /dev/null @@ -1,75 +0,0 @@ --- -------------------------------------------------------- --- 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 deleted file mode 100644 index f43f7d2..0000000 --- a/Workspace/Siman/sql/pgsql.inidata.sql +++ /dev/null @@ -1,104 +0,0 @@ -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/simer_ini_data.sql b/Workspace/Siman/sql/simer_ini_data.sql deleted file mode 100644 index 3cb3aaa..0000000 --- a/Workspace/Siman/sql/simer_ini_data.sql +++ /dev/null @@ -1,88 +0,0 @@ -# -------------------------------------------------------- -# 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`; -/*!40000 ALTER TABLE `contelm` DISABLE KEYS */; -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); -/*!40000 ALTER TABLE `contelm` ENABLE KEYS */; - -# Dumping data for table simer1.contype: 16 rows -DELETE FROM `contype`; -/*!40000 ALTER TABLE `contype` DISABLE KEYS */; -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); -/*!40000 ALTER TABLE `contype` ENABLE KEYS */; - -# Dumping data for table simer1.cycle: 4 rows -DELETE FROM `cycle`; -/*!40000 ALTER TABLE `cycle` DISABLE KEYS */; -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); -/*!40000 ALTER TABLE `cycle` ENABLE KEYS */; - -# Dumping data for table simer1.doctag: 30 rows -DELETE FROM `doctag`; - -# Dumping data for table simer1.doctype: 12 rows -DELETE FROM `doctype`; -/*!40000 ALTER TABLE `doctype` DISABLE KEYS */; -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); -/*!40000 ALTER TABLE `doctype` ENABLE KEYS */; - -# 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`; -/*!40000 ALTER TABLE `knowtype` DISABLE KEYS */; -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'); -/*!40000 ALTER TABLE `knowtype` ENABLE KEYS */; - -# 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`; -/*!40000 ALTER TABLE `role` DISABLE KEYS */; -INSERT INTO `role` (`username`, `role`) VALUES ('simer', 'sysadmin'), ('jbt', 'manager'), ('hl', 'manager'), ('pdd', 'studengineer'), ('sdd', 'manager'), ('mko', 'manager'), ('pjt', 'manager'), ('rkv', 'manager'), ('xyz', 'user'); -/*!40000 ALTER TABLE `role` ENABLE KEYS */; - -# 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`; -/*!40000 ALTER TABLE `users` DISABLE KEYS */; -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); -/*!40000 ALTER TABLE `users` ENABLE KEYS */; -/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; -/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; -/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; -- 2.39.2