Sharepoint WTF

ziggyf

I was installing SBS 2003 today for a client of mine, and for some stupid reason to finish the SBS installation you have to install Sharepoint. Anyway the client needed a classic asp app set up (original devs have gone out of business).

Anyway I like knowing how things work, and was looking though the Share Point database structure I found this table that really made me go WTF and I quickly thought of you guys.


CREATE TABLE [dbo].[UserData](
[tp_ID] [int] NOT NULL,
[tp_ListId] [uniqueidentifier] NOT NULL,
[tp_SiteId] [uniqueidentifier] NOT NULL,
[tp_Version] [int] NOT NULL,
[tp_Author] [int] NULL,
[tp_Editor] [int] NULL,
[tp_Modified] [datetime] NULL,
[tp_Created] [datetime] NULL,
[tp_Ordering] [varchar](512) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[tp_HasAttachment] [bit] NOT NULL DEFAULT (0),
[tp_ModerationStatus] [int] NOT NULL DEFAULT (0),
[tp_IsCurrent] [bit] NOT NULL DEFAULT (1),
[tp_ItemOrder] [float] NULL,
[tp_InstanceID] [int] NULL,
[tp_GUID] [uniqueidentifier] NOT NULL DEFAULT (newid()),
[tp_Size] [int] NOT NULL DEFAULT (0),
[nvarchar1] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar2] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar3] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar4] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar5] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar6] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar7] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar8] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar9] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar10] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar11] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar12] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar13] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar14] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar15] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar16] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar17] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar18] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar19] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar20] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar21] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar22] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar23] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar24] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar25] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar26] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar27] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar28] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar29] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar30] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar31] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar32] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar33] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar34] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar35] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar36] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar37] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar38] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar39] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar40] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar41] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar42] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar43] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar44] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar45] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar46] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar47] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar48] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar49] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar50] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar51] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar52] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar53] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar54] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar55] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar56] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar57] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar58] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar59] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar60] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar61] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar62] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar63] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[nvarchar64] [nvarchar](255) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[int1] [int] NULL,
[int2] [int] NULL,
[int3] [int] NULL,
[int4] [int] NULL,
[int5] [int] NULL,
[int6] [int] NULL,
[int7] [int] NULL,
[int8] [int] NULL,
[int9] [int] NULL,
[int10] [int] NULL,
[int11] [int] NULL,
[int12] [int] NULL,
[int13] [int] NULL,
[int14] [int] NULL,
[int15] [int] NULL,
[int16] [int] NULL,
[float1] [float] NULL,
[float2] [float] NULL,
[float3] [float] NULL,
[float4] [float] NULL,
[float5] [float] NULL,
[float6] [float] NULL,
[float7] [float] NULL,
[float8] [float] NULL,
[float9] [float] NULL,
[float10] [float] NULL,
[float11] [float] NULL,
[float12] [float] NULL,
[float13] [float] NULL,
[float14] [float] NULL,
[float15] [float] NULL,
[float16] [float] NULL,
[float17] [float] NULL,
[float18] [float] NULL,
[float19] [float] NULL,
[float20] [float] NULL,
[float21] [float] NULL,
[float22] [float] NULL,
[float23] [float] NULL,
[float24] [float] NULL,
[float25] [float] NULL,
[float26] [float] NULL,
[float27] [float] NULL,
[float28] [float] NULL,
[float29] [float] NULL,
[float30] [float] NULL,
[float31] [float] NULL,
[float32] [float] NULL,
[datetime1] [datetime] NULL,
[datetime2] [datetime] NULL,
[datetime3] [datetime] NULL,
[datetime4] [datetime] NULL,
[datetime5] [datetime] NULL,
[datetime6] [datetime] NULL,
[datetime7] [datetime] NULL,
[datetime8] [datetime] NULL,
[datetime9] [datetime] NULL,
[datetime10] [datetime] NULL,
[datetime11] [datetime] NULL,
[datetime12] [datetime] NULL,
[datetime13] [datetime] NULL,
[datetime14] [datetime] NULL,
[datetime15] [datetime] NULL,
[datetime16] [datetime] NULL,
[bit1] [bit] NULL,
[bit2] [bit] NULL,
[bit3] [bit] NULL,
[bit4] [bit] NULL,
[bit5] [bit] NULL,
[bit6] [bit] NULL,
[bit7] [bit] NULL,
[bit8] [bit] NULL,
[bit9] [bit] NULL,
[bit10] [bit] NULL,
[bit11] [bit] NULL,
[bit12] [bit] NULL,
[bit13] [bit] NULL,
[bit14] [bit] NULL,
[bit15] [bit] NULL,
[bit16] [bit] NULL,
[uniqueidentifier1] [uniqueidentifier] NULL,
[ntext1] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL,
[ntext2] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL,
[ntext3] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL,
[ntext4] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL,
[ntext5] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL,
[ntext6] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL,
[ntext7] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL,
[ntext8] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL,
[ntext9] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL,
[ntext10] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL,
[ntext11] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL,
[ntext12] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL,
[ntext13] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL,
[ntext14] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL,
[ntext15] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL,
[ntext16] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL,
[ntext17] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL,
[ntext18] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL,
[ntext19] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL,
[ntext20] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL,
[ntext21] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL,
[ntext22] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL,
[ntext23] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL,
[ntext24] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL,
[ntext25] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL,
[ntext26] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL,
[ntext27] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL,
[ntext28] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL,
[ntext29] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL,
[ntext30] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL,
[ntext31] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL,
[ntext32] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL,
[sql_variant1] [sql_variant] NULL,
[sql_variant2] [sql_variant] NULL,
[sql_variant3] [sql_variant] NULL,
[sql_variant4] [sql_variant] NULL,
[sql_variant5] [sql_variant] NULL,
[sql_variant6] [sql_variant] NULL,
[sql_variant7] [sql_variant] NULL,
[sql_variant8] [sql_variant] NULL,
CONSTRAINT [UserData_PK] PRIMARY KEY CLUSTERED 
(
[tp_ListId] ASC,
[tp_ID] ASC
) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

erikal

not really a WTF I think, its just an auto-generated table as part of some automation routine. Not for human eyes.

toshir0

@erikal said:

Not for human eyes.

Too late, in fact.

Screw you, OP.

dhromed

@erikal said:

not really a WTF I think

sterf.

boomzilla

Because no thread should be on topic for too long...

@dhromed said:

sterf

When I read that, I googled it to find out WTF it means, and then I found DJ Sterf. Google's blurb: "The life and times of Sterling C. Franklin, ordained minister of the Gospel of Jesus Christ by calling, as well as avid DDR player by hobby."

dhromed

That is one cool Christian.

Also here.

dtech

@dhromed said:

That is one cool Christian.

Also here.

Mensen die Nederlands gebruiken (of elke andere taal) op een internationaal Engels-sprekend forum zouden moeten sterven in een vuur.

boog

@erikal said:

not really a WTF I think, its just an auto-generated table as part of some automation routine. Not for human eyes.

Then again, something about nvarchar1, nvarchar2, nvarchar3, ... nvarchar64, and similarly-named columns still makes me wonder WTF; it may be auto-generated, but someone had to design it to auto-generate that way.

Xyro

@erikal said:

not really a WTF I think, its just an auto-generated table as part of some automation routine. Not for human eyes.

I don't see how that's okay...

@dhromed said:

Also here.

Google suggests "Dying in one o'clock heat" as an alternate translation. What I want to know is, is this AM or PM, and just which kind of "heat" are we talking about?

dhromed

@boog said:

Then again, something about nvarchar1, nvarchar2

It's gotta be compatibility with Oracle.

dhromed

@dtech said:

@dhromed said:
That is one cool Christian.

Also here.

Mensen die Nederlands gebruiken (of elke andere taal) op een internationaal Engels-sprekend forum zouden moeten sterven in een vuur.

bantercookie!

galgorah

@dhromed said:

bantercookie!

De aap van de oorlog zoekt de gouden banaan aan de paradox van hun existentieel probleem verminderen.

Het is liefde. Het Is oorlog. Het is een aardappel.

boog

@dhromed said:

It's gotta be compatibility with Oracle.

Doesn't that pretty much ensure a WTF then?

Kaosadvokit

By the looks of it that is the standard SharePoint table for storing list content. Rather than having multiple tables with descriptive names, they map named columns to columns in this table, which in turn stores all list content for the application.

This is not a WTF, this is SharePoint.

'Sterf' is Dutch for 'Die' (the verb). Inflections sterven, stierf, gestorven. Hope this helps.

dhromed

@galgorah said:

@dhromed said:
bantercookie!
De aap van de oorlog zoekt de gouden banaan aan de paradox van hun existentieel probleem verminderen.

Het is liefde. Het Is oorlog. Het is een aardappel.

I will have your babies.

dhromed

@Kaosadvokit said:

this is SharePoint.

erikal

Holy hell, this forum is infested with Dutch people! I'm finally home *tears of joy*

dhromed

I know, it's crazy shit.

Obfuscator

En ook Zweden, hoor!

Xyro

@dhromed said:

@galgorah said:
@dhromed said:
bantercookie!
De aap van de oorlog zoekt de gouden banaan aan de paradox van hun existentieel probleem verminderen.

Het is liefde. Het Is oorlog. Het is een aardappel.

I will have your babies.

I don't understand... is the paradox diminishing or are the problems diminishing?

dhromed

@Xyro said:

I don't understand... is the paradox diminishing or are the problems diminishing?

I don't know. The Dutch sentence isn't well-formed either. I think it might be a form of "seeks to diminish", where the "verminderen" may legally jump to the end of the sentence, but that would mean the war monkey seeks to diminsh the golden banana, which makes only sense in some loose, ill-defined and barely humorous manner.

galgorah

@dhromed said:

@Xyro said:
I don't understand... is the paradox diminishing or are the problems diminishing?

I don't know. The Dutch sentence isn't well-formed either. I think it might be a form of "seeks to diminish", where the "verminderen" may legally jump to the end of the sentence, but that would mean the war monkey seeks to diminsh the golden banana, which makes only sense in some loose, ill-defined and barely humorous manner.

The original sentence was: "The monkeys of war seek the golden banana to abait the paradox of their existential dilemma." I hope this clears up any misconception caused by having a drunken dutchmen aka google handle the translation.

DaveK1

@galgorah said:

@dhromed said:
@Xyro said:
I don't understand... is the paradox diminishing or are the problems diminishing?

I don't know. The Dutch sentence isn't well-formed either. I think it might be a form of "seeks to diminish", where the "verminderen" may legally jump to the end of the sentence, but that would mean the war monkey seeks to diminsh the golden banana, which makes only sense in some loose, ill-defined and barely humorous manner.
The original sentence was: "The monkeys of war seek the golden banana to abait the paradox of their existential dilemma." I hope this clears up any misconception caused by having a drunken dutchmen aka google handle the translation.

It seems that Google lost (N-1) of your monkeys in translation.