RSS feed for blog Linkin Skype Mail Me Twitter

Stickfight

Living Document: Connections Db Schema Versions

This page is just a living reference for thoese of us using the connections databases directly who want to make sure our code works by checking the db schemas before performing actions, you can see how to get these values in a previous post

If IBM would like to document this themselves (I know they wont as they dont want us near the dbs directly and want us to go via the APIs) I would be happy to bow out and point to their site :)

Connections App: Files

BD: FILES
Table: PRODUCT
Connections v4.0 BASE: 79
Connections v4.0 CR1: 79
Connections v4.0 CR2: 79
Connections v4.0 CR3: 79
Connections v4.0 CR4: 79
Connections v4.5 BASE: 82
Connections v4.5 CR1: 82
Connections v4.5 CR2: 82
Connections v4.5 CR3: 89
Connections v4.5 CR4: 89


Connections App: Activities

BD: OPNACT
Table: OA_SCHEMA
Connections v4.0 BASE: 53
Connections v4.0 CR1: 53
Connections v4.0 CR2: 53
Connections v4.0 CR3: 53
Connections v4.0 CR4: 53
Connections v4.5 BASE: 56
Connections v4.5 CR1: 56
Connections v4.5 CR2: 56
Connections v4.5 CR3: 56
Connections v4.5 CR4: 56


Connections App: Blogs

BD: BLOGS
Table: ROLLER_PROPERTIES
Connections v4.0 BASE: 43
Connections v4.0 CR1: 43
Connections v4.0 CR2: 43
Connections v4.0 CR3: 43
Connections v4.0 CR4: 43
Connections v4.5 BASE: 51
Connections v4.5 CR1: 51
Connections v4.5 CR2: 51
Connections v4.5 CR3: 51
Connections v4.5 CR4: 51


Connections App: Communities

BD: SNCOMM
Table: SNCOMM_SCHEMA
Connections v4.0 BASE: 76
Connections v4.0 CR1: 76
Connections v4.0 CR2: 76
Connections v4.0 CR3: 76
Connections v4.0 CR4: 76
Connections v4.5 BASE: 77
Connections v4.5 CR1: 77
Connections v4.5 CR2: 77
Connections v4.5 CR3: 77
Connections v4.5 CR4: 77


Connections App: Community Events

BD: SNCOMM
Table: CA_SCHEMA
Connections v4.0 BASE: 10
Connections v4.0 CR1: 10
Connections v4.0 CR2: 10
Connections v4.0 CR3: 10
Connections v4.0 CR4: 10
Connections v4.5 BASE: 15
Connections v4.5 CR1: 15
Connections v4.5 CR2: 15
Connections v4.5 CR3: 15
Connections v4.5 CR4: 15


Connections App: BookMarks

BD: DOGEAR
Table: DOGEAR_SCHEMA
Connections v4.0 BASE: 14
Connections v4.0 CR1: 14
Connections v4.0 CR2: 14
Connections v4.0 CR3: 14
Connections v4.0 CR4: 14
Connections v4.5 BASE: 15
Connections v4.5 CR1: 15
Connections v4.5 CR2: 15
Connections v4.5 CR3: 15
Connections v4.5 CR4: 15


Connections App: Forums

BD: FORUM
Table: DF_SCHEMA
Connections v4.0 BASE: 21
Connections v4.0 CR1: 21
Connections v4.0 CR2: 21
Connections v4.0 CR3: 21
Connections v4.0 CR4: 21
Connections v4.5 BASE: 27
Connections v4.5 CR1: 27
Connections v4.5 CR2: 27
Connections v4.5 CR3: 27
Connections v4.5 CR4: 27


Connections App: HomePage , News, Search

BD: HOMEPAGE
Table: HOMEPAGE_SCHEMA
Connections v4.0 BASE : 110
Connections v4.0 CR1 : 110
Connections v4.0 CR2 : 132
Connections v4.0 CR3 : 132
Connections v4.0 CR4 : 132
Connections v4.5 BASE: 210
Connections v4.5 CR1 : 210
Connections v4.5 CR2 : 210
Connections v4.5 CR3 : 211
Connections v4.5 CR4 : 213


Connections App: Metrics

BD: METRICS
Table: PRODUCT


Connections v4.0 CR2: 29
Connections v4.0 CR1: 29
Connections v4.0 CR2: 29
Connections v4.0 CR3: 30
Connections v4.0 CR4: 30
Connections v4.5 BASE: 34
Connections v4.5 CR1: 34
Connections v4.5 CR2: 37
Connections v4.5 CR3: 37
Connections v4.5 CR4: 37


Connections App: Mobile

BD: MOBILE
Table: ROLLER_PROPERTIES
Connections v4.0 BASE: 1
Connections v4.0 CR1: 1
Connections v4.0 CR2: 1
Connections v4.0 CR3: 1
Connections v4.0 CR4: 1
Connections v4.5 BASE: 1
Connections v4.5 CR1: 1
Connections v4.5 CR2: 1
Connections v4.5 CR3: 1
Connections v4.5 CR4: 2


Connections App: Profiles

BD: PEOPLEDB
Table: SNPROF_SCHEMA
Connections v4.0 BASE: 33
Connections v4.0 CR1: 33
Connections v4.0 CR2: 33
Connections v4.0 CR3: 33
Connections v4.0 CR4: 33
Connections v4.5 BASE: 36
Connections v4.5 CR1: 36
Connections v4.5 CR2: 36
Connections v4.5 CR3: 36
Connections v4.5 CR4: 36


Connections App: Wiki

BD: WIKIS
Table: PRODUCT
Connections v4.0 BASE: 79
Connections v4.0 CR1: 79
Connections v4.0 CR2: 79
Connections v4.0 CR3: 79
Connections v4.0 CR4: 79
Connections v4.5 BASE: 82
Connections v4.5 CR1: 89
Connections v4.5 CR2: 89
Connections v4.5 CR3: 89
Connections v4.5 CR4: 89



NOTE: All these tips are not officaliy sanctioned by IBM as they do not release DB schema info to the public, so you use them at your own risk, Also if IBM are reading this and I either have somthing wrong or you have documented this for the public, then please tell me and I will correct :-)

NOTE: I’m not a proper Connections / Web Sphere admin, If you want proper Web Sphere and Connections admin you want the Turtle Partnership

Leave Your Comments

blog comments powered by Disqus

Related Entries

MWLug 2016 Round-Up

To Find The Perfect Office

A Little Thing Done Right

SalesForce for Domino Dogs 3: Web Query Save Agents

Presenting at MWLUG

SalesForce for Domino Dogs 2: Scheduled Agents

SalesForce for Domino Dogs 1: Profile Documents

Editable salesforce templates

New Platform Type New Client Type

Engage 2016

LDCVia Webinar

Current Android Software 2015

Salesforce read mode hide-when hack

Classic Domino and multi country dates with Bootstrap

C3 charts on Saleforce Winter16

Updating Statamic on AWS

Icon UK 2015

Quiet Isnt it

Engage 2015

Conditional Checking in AngularJs using Restangular

IBM ConnectED2015 All work and no play

Learning A Lesson About Security from other People

2014 A Year In Review

IBM Connections Dev Update to V5

W.T.F. they made me an IBM Champion and a C-API tip

Bloody Android Kit-Kat and SD Cards

LDC Via Cross Post: Why oh why oh why (Part One)

Applet security: a blast from the past

UK ICON 2014

jQuery UK 2014 Day 2

jQuery UK 2014 Day 1

London Node.js User Group April 2014

Listen while you work

SQuirrel SQL For IBM Connections

Connections Db Schema Tip2: Finding the UserID

Working from anywhere

Connections Db Tip1: getting the Connections db Schema version

CSC Event No.1

Engage 2014

IBM Connections Dev Links

Collaboration Stack Community Agenda and Stuff

Connections aide memoire 02: Backing Up Websphere Config

Inserting HTML into word documents

Connections aide memoire 01: Changing XML config

IBM Connect 2014 Slide Decks

IBM Connect 2014 Round up

Finding Me at IBM Connect 2014

Collaboration Stack Event

Commuting tip for Developers

My IBM Connect 2014 Sessions

IBM Connect 2014 session

Best USB Cable

The Perfect Consultant

First Tuesday Club November 2013

Adding a member to IBM Connections communities programmatically

Getting The User ID From IBM Connections - Addendum 1

Getting The User ID From IBM Connections

Latest Blogs