Bug 758531 - CSProcessor SQL Script
Summary: CSProcessor SQL Script
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: PressGang CCMS
Classification: Community
Component: CSProcessor
Version: 1.x
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
: ---
Assignee: Lee Newson
QA Contact:
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-11-30 00:49 UTC by Joshua Wulf
Modified: 2014-10-19 22:59 UTC (History)
2 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2012-02-23 14:51:37 UTC

Attachments (Terms of Use)
CSProcessor Build 0.19.0 SQL structure script (17.10 KB, text/x-sql)
2011-11-30 00:56 UTC, Lee Newson 		no flags Details
View All Add an attachment (proposed patch, testcase, etc.)

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.
Note You need to log in before you can comment on or make changes to this bug.