Bug 758531

Summary: CSProcessor SQL Script
Product: [Community] PressGang CCMS Reporter: Joshua Wulf <jwulf>
Component: CSProcessorAssignee: Lee Newson <lnewson>
Status: CLOSED CURRENTRELEASE QA Contact:
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 1.xCC: jwulf, lcarlon
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2012-02-23 14:51:37 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Attachments:
Description Flags
CSProcessor Build 0.19.0 SQL structure script none

Description Joshua Wulf 2011-11-30 00:49:10 UTC
Lee, can you please keep the latest complete SQL script here, so that a new instance of a CSProcessor can be spun up. 

Please specify the version of the .war file that the SQL script is for.

Comment 1 Lee Newson 2011-11-30 00:56:55 UTC
Created attachment 538333 [details]
CSProcessor Build 0.19.0 SQL structure script

Comment 2 Lee Newson 2011-11-30 00:58:20 UTC
Added. The script provided is if you were starting from scratch. It will work for csprocessor-build-19.war and as it stands now should work for build 0.20.0 as well.

Comment 3 Lee Newson 2011-11-30 01:03:05 UTC
I should also mention that there is currently unused tables inside the database from when levels and relationships where saved. I haven't ever had the chance to fully remove the code from the program so they still have to exist to create the Entity Managers.

These tables are:
ContentLevels
ContentLevels_AUD
ContentMapping
ContentMapping_AUD
LevelType
LevelType_AUD
RelationshipType
RelationshipType_AUD
TopicToLevelRelationship
TopicToLevelRelationship_AUD
TopicToTopicRelationship
TopicToTopicRelationship_AUD

The other thing is that the only part that should be required to add, is the User API key fields so that a user can be authenticated.

Comment 4 Joshua Wulf 2012-02-23 14:51:37 UTC
CSProcessor database has now been merged with Skynet mainline.