I upgraded my alfresco 4.0 > 4.2 > 5.0 > 5.2. But in my current version (5.2) all working correct but number of tables is 101. But if I install alfresco from box it would be 74 (or 71 don't remember). Is it normal?
I am using alfresco 5.2. And after installing beCPG extention I have a lot of sql-scripts in alfresco\tomcat\temp\Alfresco And in some scrips I see INSERT IGNORE INTO alf_qname (ns_id,version,local_name) SELECT id,0, 'labelingLabelingTemplate' FROM alf_namespace WHERE uri = 'http://www.bcpg.fr/model/quality/1.0' ; And IGNORE is not supported by postgres 9.4 which alfresco is using.
And can you explain me who add scripts to alfresco\tomcat\temp\Alfresco directory and why. Should I execute this scripts on my database?
When you upgrade Alfresco it is normal to have more tables than for a fresh install. You are still carrying around the JBPM tables which will not be created anymore for a new install. The patch to delete those JBPM tables is optional and not enabled by default, so they stick around.
The scripts in the temp directory are generated by Alfresco on-the-fly during the upgrade and already executed - you should do nothing with them.