knguyen     2005/11/04 14:14:49 CET

  Modified files:
    core/src/java/org/jahia/deprecated/taglibs/util Utils.java 
    core/src/java/org/jahia/hibernate/dao JahiaFieldsDataDAO.java 
    core/src/java/org/jahia/hibernate/manager 
                                              JahiaFieldsDefinitionManager.java 
    core/src/java/org/jahia/hibernate/model JahiaFieldsData.java 
                                            JahiaFieldsDef.java 
    core/src/java/org/jahia/services/metadata/core/listeners 
                                                             
ContentCreationDateListener.java 
    core/src/java/org/jahia/services/search 
                                            JahiaSearchBaseService.java 
    core/src/java/org/jahia/taglibs/util Utils.java 
    core/src/webapp/WEB-INF/var/db 
                                   
default_corporate_portal_templates_postgres.values 
    core/src/webapp/WEB-INF/var/db/sql/schema/postgresql 
                                                         jahia-schema.sql 
  Log:
  - fix posgresql
  
  Revision  Changes    Path
  1.3       +4 -4      
jahia/core/src/java/org/jahia/deprecated/taglibs/util/Utils.java
http://jahia.mine.nu:8080/cgi-bin/cvsweb.cgi/jahia/core/src/java/org/jahia/deprecated/taglibs/util/Utils.java.diff?r1=1.2&r2=1.3&f=h
  1.22      +1 -1      
jahia/core/src/java/org/jahia/hibernate/dao/JahiaFieldsDataDAO.java
http://jahia.mine.nu:8080/cgi-bin/cvsweb.cgi/jahia/core/src/java/org/jahia/hibernate/dao/JahiaFieldsDataDAO.java.diff?r1=1.21&r2=1.22&f=h
  1.6       +7 -3      
jahia/core/src/java/org/jahia/hibernate/manager/JahiaFieldsDefinitionManager.java
http://jahia.mine.nu:8080/cgi-bin/cvsweb.cgi/jahia/core/src/java/org/jahia/hibernate/manager/JahiaFieldsDefinitionManager.java.diff?r1=1.5&r2=1.6&f=h
  1.9       +3 -3      
jahia/core/src/java/org/jahia/hibernate/model/JahiaFieldsData.java
http://jahia.mine.nu:8080/cgi-bin/cvsweb.cgi/jahia/core/src/java/org/jahia/hibernate/model/JahiaFieldsData.java.diff?r1=1.8&r2=1.9&f=h
  1.11      +4 -4      
jahia/core/src/java/org/jahia/hibernate/model/JahiaFieldsDef.java
http://jahia.mine.nu:8080/cgi-bin/cvsweb.cgi/jahia/core/src/java/org/jahia/hibernate/model/JahiaFieldsDef.java.diff?r1=1.10&r2=1.11&f=h
  1.6       +1 -1      
jahia/core/src/java/org/jahia/services/metadata/core/listeners/ContentCreationDateListener.java
http://jahia.mine.nu:8080/cgi-bin/cvsweb.cgi/jahia/core/src/java/org/jahia/services/metadata/core/listeners/ContentCreationDateListener.java.diff?r1=1.5&r2=1.6&f=h
  1.26      +1 -1      
jahia/core/src/java/org/jahia/services/search/JahiaSearchBaseService.java
http://jahia.mine.nu:8080/cgi-bin/cvsweb.cgi/jahia/core/src/java/org/jahia/services/search/JahiaSearchBaseService.java.diff?r1=1.25&r2=1.26&f=h
  1.6       +4 -4      jahia/core/src/java/org/jahia/taglibs/util/Utils.java
http://jahia.mine.nu:8080/cgi-bin/cvsweb.cgi/jahia/core/src/java/org/jahia/taglibs/util/Utils.java.diff?r1=1.5&r2=1.6&f=h
  1.15      +96 -96    
jahia/core/src/webapp/WEB-INF/var/db/default_corporate_portal_templates_postgres.values
http://jahia.mine.nu:8080/cgi-bin/cvsweb.cgi/jahia/core/src/webapp/WEB-INF/var/db/default_corporate_portal_templates_postgres.values.diff?r1=1.14&r2=1.15&f=h
  1.13      +2 -2      
jahia/core/src/webapp/WEB-INF/var/db/sql/schema/postgresql/jahia-schema.sql
http://jahia.mine.nu:8080/cgi-bin/cvsweb.cgi/jahia/core/src/webapp/WEB-INF/var/db/sql/schema/postgresql/jahia-schema.sql.diff?r1=1.12&r2=1.13&f=h
  
  
  
  Index: Utils.java
  ===================================================================
  RCS file: 
/home/cvs/repository/jahia/core/src/java/org/jahia/deprecated/taglibs/util/Utils.java,v
  retrieving revision 1.2
  retrieving revision 1.3
  diff -u -r1.2 -r1.3
  --- Utils.java        4 Nov 2005 09:58:32 -0000       1.2
  +++ Utils.java        4 Nov 2005 13:14:46 -0000       1.3
  @@ -174,14 +174,14 @@
        /**
        * Method enumSize : returns the size of the given enumeration
        *
  -     * @param   enum   the enumeration
  +     * @param   the enumeration
        * @return  its size
        */
  -    public static int enumSize(final Enumeration enum) {
  +    public static int enumSize(final Enumeration enumeration) {
           int i = 0;
  -        while(enum.hasMoreElements()) {
  +        while(enumeration.hasMoreElements()) {
               i++;
  -            enum.nextElement();
  +            enumeration.nextElement();
           }
           return i;
       }
  
  
  
  Index: JahiaFieldsDataDAO.java
  ===================================================================
  RCS file: 
/home/cvs/repository/jahia/core/src/java/org/jahia/hibernate/dao/JahiaFieldsDataDAO.java,v
  retrieving revision 1.21
  retrieving revision 1.22
  diff -u -r1.21 -r1.22
  --- JahiaFieldsDataDAO.java   3 Nov 2005 13:22:25 -0000       1.21
  +++ JahiaFieldsDataDAO.java   4 Nov 2005 13:14:46 -0000       1.22
  @@ -200,7 +200,7 @@
           final HibernateTemplate template = getHibernateTemplate();
           template.setCacheQueries(true);
           List list = template.find(hql.toString(),
  -                                  new 
Object[]{name,ownerKey.getId(),ownerKey.getType()});
  +                                  new Object[]{name, 
ownerKey.getId(),ownerKey.getType()});
           if ( list.size() > 0 ){
               return (Integer)list.get(0);
           }
  
  
  
  Index: JahiaFieldsDefinitionManager.java
  ===================================================================
  RCS file: 
/home/cvs/repository/jahia/core/src/java/org/jahia/hibernate/manager/JahiaFieldsDefinitionManager.java,v
  retrieving revision 1.5
  retrieving revision 1.6
  diff -u -r1.5 -r1.6
  --- JahiaFieldsDefinitionManager.java 3 Nov 2005 13:22:25 -0000       1.5
  +++ JahiaFieldsDefinitionManager.java 4 Nov 2005 13:14:47 -0000       1.6
  @@ -163,7 +163,11 @@
           }
           jahiaFieldsDef.setJahiaSite(site);
           jahiaFieldsDef.setName(theDef.getName());
  -        jahiaFieldsDef.setIsMetadata(new Boolean(theDef.getIsMetadata()));
  +        if ( theDef.getIsMetadata() ){
  +            jahiaFieldsDef.setIsMetadata(new Integer(1));
  +        } else {
  +            jahiaFieldsDef.setIsMetadata(new Integer(0));
  +        }
           jahiaFieldsDef.setProperties(theDef.getProperties());
           Set set = new HashSet(theDef.getSubDefs().size());
           Iterator iterator = theDef.getSubDefs().entrySet().iterator();
  @@ -230,12 +234,12 @@
                                                   fieldDefID,
                                                   
defProp.getTemplateId().intValue(),
                                                   defProp.getTitle(), 
defProp.getType().intValue(),
  -                                                defaultValue, 
fieldsDef.getIsMetadata().booleanValue()));
  +                                                defaultValue, 
(fieldsDef.getIsMetadata().intValue()==1)));
           }
           JahiaFieldDefinition fieldDefinition = new 
JahiaFieldDefinition(fieldsDef.getId().intValue(),
                                                                           
siteID,
                                                                           
fieldsDef.getName(), map);
  -        
fieldDefinition.setIsMetadata(fieldsDef.getIsMetadata().booleanValue());
  +        fieldDefinition.setIsMetadata(fieldsDef.getIsMetadata().intValue() 
== 1);
           fieldDefinition.setProperties(fieldsDef.getProperties());
           return fieldDefinition;
       }
  
  
  
  Index: JahiaFieldsData.java
  ===================================================================
  RCS file: 
/home/cvs/repository/jahia/core/src/java/org/jahia/hibernate/model/JahiaFieldsData.java,v
  retrieving revision 1.8
  retrieving revision 1.9
  diff -u -r1.8 -r1.9
  --- JahiaFieldsData.java      3 Nov 2005 17:19:55 -0000       1.8
  +++ JahiaFieldsData.java      4 Nov 2005 13:14:47 -0000       1.9
  @@ -43,7 +43,7 @@
        */
       private JahiaFieldsDef fieldDefinition;
   
  -    private Boolean isMetadata = Boolean.FALSE;
  +    private Integer isMetadata = new Integer(0);
   
       private JahiaObject metadataOwner;
   
  @@ -130,11 +130,11 @@
        * length="11"
        * @return
        */
  -    public Boolean getIsMetadata() {
  +    public Integer getIsMetadata() {
           return isMetadata;
       }
   
  -    public void setIsMetadata(Boolean isMetadata) {
  +    public void setIsMetadata(Integer isMetadata) {
           this.isMetadata = isMetadata;
       }
   
  
  
  
  Index: JahiaFieldsDef.java
  ===================================================================
  RCS file: 
/home/cvs/repository/jahia/core/src/java/org/jahia/hibernate/model/JahiaFieldsDef.java,v
  retrieving revision 1.10
  retrieving revision 1.11
  diff -u -r1.10 -r1.11
  --- JahiaFieldsDef.java       4 Nov 2005 09:57:21 -0000       1.10
  +++ JahiaFieldsDef.java       4 Nov 2005 13:14:47 -0000       1.11
  @@ -19,7 +19,7 @@
        * persistent field
        */
       private Integer id;
  -    private Boolean isMetadata = Boolean.FALSE;
  +    private Integer isMetadata = new Integer(0);
       private Map properties;
   
       /**
  @@ -57,14 +57,14 @@
       }
   
       /**
  -     * @hibernate.property column="ismdata_jahia_fields_def" type="boolean" 
not-null="false"
  +     * @hibernate.property column="ismdata_jahia_fields_def" not-null="false"
        * @return
        */
  -    public Boolean getIsMetadata() {
  +    public Integer getIsMetadata() {
           return isMetadata;
       }
   
  -    public void setIsMetadata(Boolean isMetadata) {
  +    public void setIsMetadata(Integer isMetadata) {
           this.isMetadata = isMetadata;
       }
   
  
  
  
  Index: ContentCreationDateListener.java
  ===================================================================
  RCS file: 
/home/cvs/repository/jahia/core/src/java/org/jahia/services/metadata/core/listeners/ContentCreationDateListener.java,v
  retrieving revision 1.5
  retrieving revision 1.6
  diff -u -r1.5 -r1.6
  --- ContentCreationDateListener.java  3 Nov 2005 13:22:27 -0000       1.5
  +++ ContentCreationDateListener.java  4 Nov 2005 13:14:47 -0000       1.6
  @@ -79,7 +79,7 @@
       }
   
       public void contentObjectCreated(JahiaEvent theEvent){
  -        ProcessingContext jParams = theEvent.getProcessingContext();
  +            ProcessingContext jParams = theEvent.getProcessingContext();
           ContentObject contentObject = (ContentObject)theEvent.getObject();
   
           if ( contentObject == null || jParams==null ){
  
  
  
  Index: JahiaSearchBaseService.java
  ===================================================================
  RCS file: 
/home/cvs/repository/jahia/core/src/java/org/jahia/services/search/JahiaSearchBaseService.java,v
  retrieving revision 1.25
  retrieving revision 1.26
  diff -u -r1.25 -r1.26
  --- JahiaSearchBaseService.java       3 Nov 2005 17:22:09 -0000       1.25
  +++ JahiaSearchBaseService.java       4 Nov 2005 13:14:47 -0000       1.26
  @@ -281,7 +281,7 @@
           JahiaSitesService sitesServ = 
ServicesRegistry.getInstance().getJahiaSitesService();
           while ( !this.disabled && this.localIndexing ){
               try {
  -                Thread.sleep(500);
  +                Thread.sleep(2000);
               } catch ( InterruptedException inte ){
               }
               if ( sitesServ == null || !sitesServ.isStarted() ){
  
  
  
  Index: Utils.java
  ===================================================================
  RCS file: 
/home/cvs/repository/jahia/core/src/java/org/jahia/taglibs/util/Utils.java,v
  retrieving revision 1.5
  retrieving revision 1.6
  diff -u -r1.5 -r1.6
  --- Utils.java        4 Nov 2005 09:58:34 -0000       1.5
  +++ Utils.java        4 Nov 2005 13:14:48 -0000       1.6
  @@ -140,14 +140,14 @@
       /**
        * Method enumSize : returns the size of the given enumeration
        *
  -     * @param   enum   the enumeration
  +     * @param   the enumeration
        * @return  its size
        */
  -    public static int enumSize(final Enumeration enum) {
  +    public static int enumSize(final Enumeration enumeration) {
           int i = 0;
  -        while(enum.hasMoreElements()) {
  +        while(enumeration.hasMoreElements()) {
               i++;
  -            enum.nextElement();
  +            enumeration.nextElement();
           }
           return i;
       }
  
  
  
  Index: default_corporate_portal_templates_postgres.values
  ===================================================================
  RCS file: 
/home/cvs/repository/jahia/core/src/webapp/WEB-INF/var/db/default_corporate_portal_templates_postgres.values,v
  retrieving revision 1.14
  retrieving revision 1.15
  diff -u -r1.14 -r1.15
  --- default_corporate_portal_templates_postgres.values        4 Nov 2005 
09:56:46 -0000       1.14
  +++ default_corporate_portal_templates_postgres.values        4 Nov 2005 
13:14:48 -0000       1.15
  @@ -305,102 +305,102 @@
   INSERT INTO jahia_ctnlists_prop (ctnlistid_ctnlists_prop, 
jahiaid_ctnlists_prop, name_ctnlists_prop, value_ctnlists_prop) VALUES 
(2,1,'view_field_acl_picturemain_1','26');
   INSERT INTO jahia_ctnlists_prop (ctnlistid_ctnlists_prop, 
jahiaid_ctnlists_prop, name_ctnlists_prop, value_ctnlists_prop) VALUES 
(2,1,'view_field_acl_subTitlemain_1','24');
   INSERT INTO jahia_ctnlists_prop (ctnlistid_ctnlists_prop, 
jahiaid_ctnlists_prop, name_ctnlists_prop, value_ctnlists_prop) VALUES 
(2,1,'view_field_acl_pictureAlignmain_1','27');
  -INSERT INTO jahia_fields_data (id_jahia_fields_data, 
jahiaid_jahia_fields_data, pageid_jahia_fields_data, ctnid_jahia_fields_data, 
fielddefid_jahia_fields_data, ismdata_jahia_fields_data, 
type_jahia_fields_data, connecttype_jahia_fields_data, value_jahia_fields_data, 
rank_jahia_fields_data, rights_jahia_fields_data, version_id, workflow_state, 
language_code) VALUES 
(8,1,1,0,59,'0',6,0,'/shared/import/Home/banner_home.gif',0,36,1052504277,1,'@default-site-lang@');
  -INSERT INTO jahia_fields_data (id_jahia_fields_data, 
jahiaid_jahia_fields_data, pageid_jahia_fields_data, ctnid_jahia_fields_data, 
fielddefid_jahia_fields_data, ismdata_jahia_fields_data, 
type_jahia_fields_data, connecttype_jahia_fields_data, value_jahia_fields_data, 
rank_jahia_fields_data, rights_jahia_fields_data, version_id, workflow_state, 
language_code) VALUES 
(7,1,1,2,15,'0',3,0,'<text>',0,32,1052504277,1,'@default-site-lang@');
  -INSERT INTO jahia_fields_data (id_jahia_fields_data, 
jahiaid_jahia_fields_data, pageid_jahia_fields_data, ctnid_jahia_fields_data, 
fielddefid_jahia_fields_data, ismdata_jahia_fields_data, 
type_jahia_fields_data, connecttype_jahia_fields_data, value_jahia_fields_data, 
rank_jahia_fields_data, rights_jahia_fields_data, version_id, workflow_state, 
language_code) VALUES (6,1,1,2,14,'0',2,0,'Welcome to 
Jahia',0,31,1052504277,1,'@default-site-lang@');
  -INSERT INTO jahia_fields_data (id_jahia_fields_data, 
jahiaid_jahia_fields_data, pageid_jahia_fields_data, ctnid_jahia_fields_data, 
fielddefid_jahia_fields_data, ismdata_jahia_fields_data, 
type_jahia_fields_data, connecttype_jahia_fields_data, value_jahia_fields_data, 
rank_jahia_fields_data, rights_jahia_fields_data, version_id, workflow_state, 
language_code) VALUES 
(5,1,1,2,17,'0',20,0,'<empty>',0,30,1052504277,1,'shared');
  -INSERT INTO jahia_fields_data (id_jahia_fields_data, 
jahiaid_jahia_fields_data, pageid_jahia_fields_data, ctnid_jahia_fields_data, 
fielddefid_jahia_fields_data, ismdata_jahia_fields_data, 
type_jahia_fields_data, connecttype_jahia_fields_data, value_jahia_fields_data, 
rank_jahia_fields_data, rights_jahia_fields_data, version_id, workflow_state, 
language_code) VALUES 
(4,1,1,2,16,'0',6,0,'2',0,29,1052504277,1,'@default-site-lang@');
  -INSERT INTO jahia_fields_data (id_jahia_fields_data, 
jahiaid_jahia_fields_data, pageid_jahia_fields_data, ctnid_jahia_fields_data, 
fielddefid_jahia_fields_data, ismdata_jahia_fields_data, 
type_jahia_fields_data, connecttype_jahia_fields_data, value_jahia_fields_data, 
rank_jahia_fields_data, rights_jahia_fields_data, version_id, workflow_state, 
language_code) VALUES 
(4,1,1,2,16,'0',6,0,'/shared/import/Home/portal.gif',0,29,1043264176,0,'@default-site-lang@');
  -INSERT INTO jahia_fields_data (id_jahia_fields_data, 
jahiaid_jahia_fields_data, pageid_jahia_fields_data, ctnid_jahia_fields_data, 
fielddefid_jahia_fields_data, ismdata_jahia_fields_data, 
type_jahia_fields_data, connecttype_jahia_fields_data, value_jahia_fields_data, 
rank_jahia_fields_data, rights_jahia_fields_data, version_id, workflow_state, 
language_code) VALUES 
(5,1,1,2,17,'0',20,0,'<empty>',0,30,1043264176,0,'shared');
  -INSERT INTO jahia_fields_data (id_jahia_fields_data, 
jahiaid_jahia_fields_data, pageid_jahia_fields_data, ctnid_jahia_fields_data, 
fielddefid_jahia_fields_data, ismdata_jahia_fields_data, 
type_jahia_fields_data, connecttype_jahia_fields_data, value_jahia_fields_data, 
rank_jahia_fields_data, rights_jahia_fields_data, version_id, workflow_state, 
language_code) VALUES (6,1,1,2,14,'0',2,0,'Welcome to 
Jahia',0,31,1043264176,0,'@default-site-lang@');
  -INSERT INTO jahia_fields_data (id_jahia_fields_data, 
jahiaid_jahia_fields_data, pageid_jahia_fields_data, ctnid_jahia_fields_data, 
fielddefid_jahia_fields_data, ismdata_jahia_fields_data, 
type_jahia_fields_data, connecttype_jahia_fields_data, value_jahia_fields_data, 
rank_jahia_fields_data, rights_jahia_fields_data, version_id, workflow_state, 
language_code) VALUES 
(7,1,1,2,15,'0',3,0,'<text>',0,32,1043264176,0,'@default-site-lang@');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (2,1,'skillValue','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(3,1,'projectCategoriesValue','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (5,1,'topLink','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (6,1,'file3','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(7,1,'description3','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (8,1,'link3','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (9,1,'linkDesc3','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (10,1,'content3','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (11,1,'webapp3','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (12,1,'boxTitle3','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (13,1,'boxType3','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (14,1,'subTitle','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(15,1,'mainContent','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (16,1,'picture','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(17,1,'pictureAlign','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (18,1,'filemain_1','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(19,1,'descriptionmain_1','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (20,1,'linkmain_1','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(21,1,'linkDescmain_1','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(22,1,'contentmain_1','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(23,1,'webappmain_1','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(24,1,'boxTitlemain_1','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(25,1,'boxTypemain_1','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (26,1,'file2','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(27,1,'description2','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (28,1,'link2','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (29,1,'linkDesc2','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (30,1,'content2','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (31,1,'webapp2','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (32,1,'boxTitle2','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (33,1,'boxType2','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (34,1,'footerLink','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (36,1,'newsTitle1','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (37,1,'newsDesc1','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (38,1,'newsLink1','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(39,1,'newsStartDate1','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(40,1,'newsEndDate1','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(41,1,'newsTitle12','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (42,1,'newsDesc2','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (43,1,'newsLink2','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(44,1,'newsStartDate2','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(45,1,'newsEndDate2','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (46,1,'newsTitle3','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (47,1,'newsDesc3','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (48,1,'newsLink3','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(49,1,'newsStartDate3','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(50,1,'newsEndDate3','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(52,1,'metadataDescription','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(53,1,'metadataKeywords','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(54,1,'splashImage','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(55,1,'splashheight','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(56,1,'splashRepeat','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (57,1,'quickLink','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (58,1,'colorSet','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (59,1,'image','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (60,1,'file1','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(61,1,'description1','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (62,1,'link1','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (63,1,'linkDesc1','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (64,1,'content1','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (65,1,'webapp1','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(66,1,'linkNewsList1','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (67,1,'boxTitle1','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (68,1,'boxType1','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(69,1,'boxTitleLayout1','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(70,1,'boxContentLayout1','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (71,1,'newsTitle2','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(72,1,'linkNewsList2','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(73,1,'boxTitleLayout2','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(74,1,'boxContentLayout2','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(75,1,'linkNewsList3','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(76,1,'boxTitleLayout3','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(77,1,'boxContentLayout3','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (78,1,'pageWidth','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(79,1,'titlePrefix','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(80,1,'defaultMetaDescription','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(81,1,'defaultMetaKeyword','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(82,1,'defaultColorSet','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(83,1,'sitemapDepth','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(84,1,'leftMenuMaxDepth','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(85,1,'displayDropMenu','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (86,1,'footerText','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (87,1,'logo','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(88,1,'alignmain_1','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (89,1,'image1','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (90,1,'image2','0');
  -INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (91,1,'image3','0');
  +INSERT INTO jahia_fields_data (id_jahia_fields_data, 
jahiaid_jahia_fields_data, pageid_jahia_fields_data, ctnid_jahia_fields_data, 
fielddefid_jahia_fields_data, ismdata_jahia_fields_data, 
type_jahia_fields_data, connecttype_jahia_fields_data, value_jahia_fields_data, 
rank_jahia_fields_data, rights_jahia_fields_data, version_id, workflow_state, 
language_code) VALUES 
(8,1,1,0,59,0,6,0,'/shared/import/Home/banner_home.gif',0,36,1052504277,1,'@default-site-lang@');
  +INSERT INTO jahia_fields_data (id_jahia_fields_data, 
jahiaid_jahia_fields_data, pageid_jahia_fields_data, ctnid_jahia_fields_data, 
fielddefid_jahia_fields_data, ismdata_jahia_fields_data, 
type_jahia_fields_data, connecttype_jahia_fields_data, value_jahia_fields_data, 
rank_jahia_fields_data, rights_jahia_fields_data, version_id, workflow_state, 
language_code) VALUES 
(7,1,1,2,15,0,3,0,'<text>',0,32,1052504277,1,'@default-site-lang@');
  +INSERT INTO jahia_fields_data (id_jahia_fields_data, 
jahiaid_jahia_fields_data, pageid_jahia_fields_data, ctnid_jahia_fields_data, 
fielddefid_jahia_fields_data, ismdata_jahia_fields_data, 
type_jahia_fields_data, connecttype_jahia_fields_data, value_jahia_fields_data, 
rank_jahia_fields_data, rights_jahia_fields_data, version_id, workflow_state, 
language_code) VALUES (6,1,1,2,14,0,2,0,'Welcome to 
Jahia',0,31,1052504277,1,'@default-site-lang@');
  +INSERT INTO jahia_fields_data (id_jahia_fields_data, 
jahiaid_jahia_fields_data, pageid_jahia_fields_data, ctnid_jahia_fields_data, 
fielddefid_jahia_fields_data, ismdata_jahia_fields_data, 
type_jahia_fields_data, connecttype_jahia_fields_data, value_jahia_fields_data, 
rank_jahia_fields_data, rights_jahia_fields_data, version_id, workflow_state, 
language_code) VALUES (5,1,1,2,17,0,20,0,'<empty>',0,30,1052504277,1,'shared');
  +INSERT INTO jahia_fields_data (id_jahia_fields_data, 
jahiaid_jahia_fields_data, pageid_jahia_fields_data, ctnid_jahia_fields_data, 
fielddefid_jahia_fields_data, ismdata_jahia_fields_data, 
type_jahia_fields_data, connecttype_jahia_fields_data, value_jahia_fields_data, 
rank_jahia_fields_data, rights_jahia_fields_data, version_id, workflow_state, 
language_code) VALUES 
(4,1,1,2,16,0,6,0,'2',0,29,1052504277,1,'@default-site-lang@');
  +INSERT INTO jahia_fields_data (id_jahia_fields_data, 
jahiaid_jahia_fields_data, pageid_jahia_fields_data, ctnid_jahia_fields_data, 
fielddefid_jahia_fields_data, ismdata_jahia_fields_data, 
type_jahia_fields_data, connecttype_jahia_fields_data, value_jahia_fields_data, 
rank_jahia_fields_data, rights_jahia_fields_data, version_id, workflow_state, 
language_code) VALUES 
(4,1,1,2,16,0,6,0,'/shared/import/Home/portal.gif',0,29,1043264176,0,'@default-site-lang@');
  +INSERT INTO jahia_fields_data (id_jahia_fields_data, 
jahiaid_jahia_fields_data, pageid_jahia_fields_data, ctnid_jahia_fields_data, 
fielddefid_jahia_fields_data, ismdata_jahia_fields_data, 
type_jahia_fields_data, connecttype_jahia_fields_data, value_jahia_fields_data, 
rank_jahia_fields_data, rights_jahia_fields_data, version_id, workflow_state, 
language_code) VALUES (5,1,1,2,17,0,20,0,'<empty>',0,30,1043264176,0,'shared');
  +INSERT INTO jahia_fields_data (id_jahia_fields_data, 
jahiaid_jahia_fields_data, pageid_jahia_fields_data, ctnid_jahia_fields_data, 
fielddefid_jahia_fields_data, ismdata_jahia_fields_data, 
type_jahia_fields_data, connecttype_jahia_fields_data, value_jahia_fields_data, 
rank_jahia_fields_data, rights_jahia_fields_data, version_id, workflow_state, 
language_code) VALUES (6,1,1,2,14,0,2,0,'Welcome to 
Jahia',0,31,1043264176,0,'@default-site-lang@');
  +INSERT INTO jahia_fields_data (id_jahia_fields_data, 
jahiaid_jahia_fields_data, pageid_jahia_fields_data, ctnid_jahia_fields_data, 
fielddefid_jahia_fields_data, ismdata_jahia_fields_data, 
type_jahia_fields_data, connecttype_jahia_fields_data, value_jahia_fields_data, 
rank_jahia_fields_data, rights_jahia_fields_data, version_id, workflow_state, 
language_code) VALUES 
(7,1,1,2,15,0,3,0,'<text>',0,32,1043264176,0,'@default-site-lang@');
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (2,1,'skillValue',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(3,1,'projectCategoriesValue',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (5,1,'topLink',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (6,1,'file3',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (7,1,'description3',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (8,1,'link3',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (9,1,'linkDesc3',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (10,1,'content3',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (11,1,'webapp3',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (12,1,'boxTitle3',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (13,1,'boxType3',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (14,1,'subTitle',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (15,1,'mainContent',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (16,1,'picture',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (17,1,'pictureAlign',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (18,1,'filemain_1',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(19,1,'descriptionmain_1',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (20,1,'linkmain_1',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(21,1,'linkDescmain_1',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(22,1,'contentmain_1',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (23,1,'webappmain_1',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(24,1,'boxTitlemain_1',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(25,1,'boxTypemain_1',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (26,1,'file2',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (27,1,'description2',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (28,1,'link2',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (29,1,'linkDesc2',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (30,1,'content2',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (31,1,'webapp2',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (32,1,'boxTitle2',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (33,1,'boxType2',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (34,1,'footerLink',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (36,1,'newsTitle1',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (37,1,'newsDesc1',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (38,1,'newsLink1',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(39,1,'newsStartDate1',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (40,1,'newsEndDate1',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (41,1,'newsTitle12',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (42,1,'newsDesc2',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (43,1,'newsLink2',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(44,1,'newsStartDate2',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (45,1,'newsEndDate2',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (46,1,'newsTitle3',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (47,1,'newsDesc3',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (48,1,'newsLink3',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(49,1,'newsStartDate3',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (50,1,'newsEndDate3',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(52,1,'metadataDescription',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(53,1,'metadataKeywords',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (54,1,'splashImage',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (55,1,'splashheight',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (56,1,'splashRepeat',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (57,1,'quickLink',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (58,1,'colorSet',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (59,1,'image',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (60,1,'file1',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (61,1,'description1',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (62,1,'link1',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (63,1,'linkDesc1',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (64,1,'content1',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (65,1,'webapp1',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(66,1,'linkNewsList1',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (67,1,'boxTitle1',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (68,1,'boxType1',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(69,1,'boxTitleLayout1',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(70,1,'boxContentLayout1',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (71,1,'newsTitle2',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(72,1,'linkNewsList2',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(73,1,'boxTitleLayout2',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(74,1,'boxContentLayout2',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(75,1,'linkNewsList3',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(76,1,'boxTitleLayout3',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(77,1,'boxContentLayout3',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (78,1,'pageWidth',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (79,1,'titlePrefix',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(80,1,'defaultMetaDescription',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(81,1,'defaultMetaKeyword',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(82,1,'defaultColorSet',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (83,1,'sitemapDepth',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(84,1,'leftMenuMaxDepth',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES 
(85,1,'displayDropMenu',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (86,1,'footerText',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (87,1,'logo',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (88,1,'alignmain_1',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (89,1,'image1',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (90,1,'image2',0);
  +INSERT INTO jahia_fields_def (id_jahia_fields_def, jahiaid_jahia_fields_def, 
name_jahia_fields_def, ismdata_jahia_fields_def) VALUES (91,1,'image3',0);
   INSERT INTO jahia_fields_def_prop (id_jahia_fields_def_prop, 
flddefid_jahia_fields_def_prop, pdefid_jahia_fields_def_prop, 
title_jahia_fields_def_prop, type_jahia_fields_def_prop, 
default_jahia_fields_def_prop) VALUES (2,2,13,'<jahia-resource 
id=\"myjahiasite_CORPORATE_PORTAL_TEMPLATES\" key=\"skill\" 
default-value=\"Skill\"/>',20,'<empty>');
   INSERT INTO jahia_fields_def_prop (id_jahia_fields_def_prop, 
flddefid_jahia_fields_def_prop, pdefid_jahia_fields_def_prop, 
title_jahia_fields_def_prop, type_jahia_fields_def_prop, 
default_jahia_fields_def_prop) VALUES (3,3,13,'<jahia-resource 
id=\"myjahiasite_CORPORATE_PORTAL_TEMPLATES\" key=\"category\" 
default-value=\"Category\"/>',20,'<empty>');
   INSERT INTO jahia_fields_def_prop (id_jahia_fields_def_prop, 
flddefid_jahia_fields_def_prop, pdefid_jahia_fields_def_prop, 
title_jahia_fields_def_prop, type_jahia_fields_def_prop, 
default_jahia_fields_def_prop) VALUES (5,5,13,'<jahia-resource 
id=\"myjahiasite_CORPORATE_PORTAL_TEMPLATES\" key=\"topLink\" 
default-value=\"Top Link\"/>',5,'<empty>');
  
  
  
  Index: jahia-schema.sql
  ===================================================================
  RCS file: 
/home/cvs/repository/jahia/core/src/webapp/WEB-INF/var/db/sql/schema/postgresql/jahia-schema.sql,v
  retrieving revision 1.12
  retrieving revision 1.13
  diff -u -r1.12 -r1.13
  --- jahia-schema.sql  4 Nov 2005 09:56:57 -0000       1.12
  +++ jahia-schema.sql  4 Nov 2005 13:14:48 -0000       1.13
  @@ -358,7 +358,7 @@
                                       pageid_jahia_fields_data integer,
                                       ctnid_jahia_fields_data integer,
                                       fielddefid_jahia_fields_data integer,
  -                                    ismdata_jahia_fields_data bool,
  +                                    ismdata_jahia_fields_data integer,
                                       id_jahia_obj integer,
                                       type_jahia_obj varchar (100),
                                       type_jahia_fields_data integer,
  @@ -391,7 +391,7 @@
                                       id_jahia_fields_def integer NOT NULL,
                                       jahiaid_jahia_fields_def integer,
                                       name_jahia_fields_def varchar (250) NOT 
NULL,
  -                                    ismdata_jahia_fields_def bool,
  +                                    ismdata_jahia_fields_def integer,
       PRIMARY KEY (id_jahia_fields_def)
   );
   
  

Reply via email to