Living Document: Connections Db Schema Versions

Posted on by Mark Myers Leave a comment

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

New Anime Series: Akuma no riddle

Posted on by Mark Myers Leave a comment
First Episode(s) Review for: Akuma no Riddle
Summary:

A gifted and stone cold young female assassin is sent to a new class at school filled with other killers and one as yet unknown but seemingly obvious victim, all the killers imediatly start to size each other up, but the victom takes a shine to our little stone cold killer 🙂

Animation:

Clear cell animation with a slight hazy over tone, Very good human movements, lots of nice details and subtleties including blinking at times when it not needed, which added a lot of depth to the visualisation.

Plot Potential:

Well I don’t know, on the surface this seems to be a dead simple plot with the hardened heroine falling for the Innocent girl with the hard history, but there are so many lead characters and so many plot twist hints that I have no idea whats going to happen next for example Haru’s “dusty smell”: is that a “sunny smell” as one characters thinks or is the the smells of crypts and things brought back to life

Music:

Hard Rock for both beginning and end, good tunes, the opening will I suspect be listened to about 4 times before I start to skip, the ending maybe twice.

Reminds me of:

Aria the Scarlet Ammo with characters from Deadman Wonderland

Overall:

Riveting if slightly dark watching trying to figure out where this is going as well as the shear enjoyment of them trying to pack so many primary characters in to one anime, it is a bit overwhelming in places and I had a couple of WTF! moments and had to flip back the timeline and watch again, but it has the making of a fun anime, let us hope it lives up to its promise.

 

 

 

Disclaimer: These are mini reviews of anime’s that are fresh out in Japan and are not licensed in the UK, buy them once they have been licensed or at the very least buy the merchandise, remember if the anime makers make a loss, THEY WILL STOP MAKING ANIME!!

New Anime Series: Kamigami no Asobi

Posted on by Mark Myers Leave a comment
First Episode(s) Review for: Kamigami no Asobi
Summary:

A young shrine maiden who is following the path of the sword rather than getting ready for her entrance exams, is transported by an ancient sword to some form of Hogwarts’s cross with the playboy mansion but for young girls, in this case she is alone with a wide variety of very hot young men and the odd flying horse, it turns out that they are all young gods here to be taught about humans BY humans what could go wrong

Animation:

This series is filled with the clear bright animation that makes me wish I lived in an anime world, not too shinny but just enough so that you think every day will be a bright new future, detail where it needed but not over done or seemingly trying too hard, A very nice middle ground with good use of light.

Plot Potential:

If it’s got a plot I have not yet found one, that might be because I’m rolling around on the floor at the sheer “teenage girls fantasy” nature of the environment, of particular note was the stunned “it’s so big” line when the flying stallion is standing next to the girl..

Music:

Lots of slow piano tinkles going on in the background (I honestly was expecting to hear Barry White a couple of times)

Reminds me of:

Mostly The Wallflower but with the humour and situations of El-Hazard

Overall:

Anime often makes me chuckle in that it is seen to cater only to a male hetero audience but the number of truly beautiful young males is nearly equal to the number of imposable women, and this is a fun example of the former. easy watching

 

 

 

Disclaimer: These are mini reviews of anime’s that are fresh out in Japan and are not licensed in the UK, buy them once they have been licensed or at the very least buy the merchandise, remember if the anime makers make a loss, THEY WILL STOP MAKING ANIME!!

Connections Db Schema Tip2: Finding the UserID

Posted on by Mark Myers Leave a comment

Anyone who has had a dig around inside the back end SQL databases (or even compared a number of the ATOM feeds) for IBM Connections will have realised that ID’s are not a constant across the whole of Connections i.e. the userID that apparently created a file will not match the user ID that created a community even though you know that it was the same user that performed both actions, the reason for this is simple, IBM Connections was not build from the ground up as a cohesive whole, its a bunch of application and their databases that have been glued together, this makes it a bugger to link things together under the banner of a single user both for the more serious Developer and for Administrators trying restore/fix/edit records.

So I thought a little database relationship diagram would help make life a bit easier, the core of everything is the EMPLOYEE table in the PEOPLEDDB as that is where the global profile ID is generated for each person, you then have to find where that is mentioned in each of the applications individual member tables, from there you can use that to work out actually what that user has done in the system, thankfully most of the individual application database’s use the same sort of text identifier so they don’t cause a problem once you know they exist, the 2 exceptions are the FILES database which uses an IBM binary format (goodness know why, I’m guessing that it makes sense to use one for the files them selves and they were trying to be consistent within the FILES application) and the HOMEPAGE application in which the UNID is hidden inside a text string which you have to parse.

I will keep this diagram up to date, but please yell if you need more.

this diagram works equally well on both v4 and v4.5

 

 

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