OLD

L = Single LIne
M = Multi Select
S = Single Select 
R = DATE
T = Multiline Select
I = INTEGER
L = link

WHEN 'L' THEN 0
WHEN 'T' THEN 1
WHEN 'R' THEN 4
WHEN 'S' THEN 3 - WHEN 'X' THEN 3 (only if source is not null)
WHEN 'I' THEN 10
WHEN 'M' THEN 11




0 - Single Text
1 - MultiText
2 - DateView
3 - Single Select 
4 - Date Field
6 - Time Field
7 - Plugin - Searchable
12 - Unknown

10 - INTEGER
11 - Multiline Select



0 - OK







Deployment
 change web.config
 don't override the data files




Username 
--------
UserData1 -> ClientIPAddress
UserData2 -> ClientMachineName
UserData3 -> Saving confirmation | Global Notification Settings
UserData6 -> Viyo Key
UserData7 -> HTML5 Notes

---------------------------------------------------------------------


select top 1 * from TaskIt
go
select * from TaskItProfile
go
select * from TaskItAttr 
go
select * from TaskItAttrSource
go
select * from TaskItAttrItem
go
select * from TaskItAttrValue

---

select * from TaskItAttr  where AttrProfile = 1



---------------------------------------------------------------------

PROFILE
select * from dbo.MetaProfile 	
select * from MasterProfileUserMap - it is not using an Id
select * from AttributesPowerSearch


FILE EXTENTION
[dbo].[FileFormat]


---------------------------------------------------------------------


PLAYLIB