Sharepoint2007核心表结构
来源:互联网 发布:java权限管理实现原理 编辑:程序博客网 时间:2024/05/01 20:16
SharePoint 2007 Databases (Core Content Tables)
The classic naming convention of SharePoint 2003 (PortalName_Prof, PortalName_Serv and PortalName_Site) is no longer applicable to SharePoint 2007. What used to reside under “_PROF” and “_SERV” databases now resides under Shared Services Database in SharePoint 2007. All content of “_Site” database is moved to content database in SharePoint 2007.
In my test install of MOSS, I found out that MOSS install actually created 6 databases altogether (including all content, configuration and shared services databases).
Here is the Mapping of SharePoint 2003 Core Content Tables to SharePoint 2007 Core Content Tables.
SharePoint 2003 (SPS) SharePoint 2007 (MOSS)
Sites Sites
Webs Webs
Lists AllLists
UserData AllUserData
Site:
The Site table contains information about SharePoint site collections. Information such as Site Collection Owner, Full URL, Site Collection ID, and 2nd contact information is stored in this table.
Webs:
Webs table contains information on SharePoint Web Sites.
AllLists:
AllLists table contains information of SharePoint lists such as list’s name, list’s description and list’s item count.
AllUserData:
AllUserData contains information on Built-in fields (version, author, editor, etc…) and custom fields. AllUserData is a very wide table with almost 200 columns.
Note: Direct database access and modification is not supported by Microsoft, so use the SharePoint Object Model whenever possible.
Some Examples:
SELECT
Id, -- Site Collection ID
OwnerId, -- relates to tp_ID in UserInfo table
TimeCreated, -- Time this Site Collection was created.
RootWebId -- WebId of top level site in Site Collection
FROM
Sites
SELECT
Id, -- Web Site's WebID
SiteId, -- Site Collection's ID
FullUrl, -- relative url of site from main SharePoint site.
ParentWebID, -- Web Site's Parent's WebID
Title, -- Title of Web Site
TimeCreated, -- Time this Web Site was created.
Description, -- Description
MasterUrl -- Master Page Url.
FROM
Webs
SELECT
tp_WebId, -- Web Site's ID
tp_ID, -- List ID
tp_Title, -- Title
tp_Created, -- Time list created.
tp_ItemCount -- Count of items in List
From
AllLists
- Sharepoint2007核心表结构
- 工作流--JBPM核心服务及表结构
- C#核心编程结构
- SpringMVC结构---核心组件
- Redis核心结构字典
- OGRE核心结构指南
- 核心动画的结构
- nmap核心结构概述
- 图解Sharepoint2007部署(下):安装sharepoint2007、创建sharepoint2007站点
- C#核心编程结构二
- Tomcat6核心类结构分析
- Tomcat6核心类结构分析
- 安卓源代码核心结构
- obs 核心结构体(一)
- obs 核心结构体(二)
- obs 核心结构体(三)
- obs 核心结构体(四)
- obs 核心结构体(五)
- Spring开发基础之Spring事务管理
- div和img标签之间存在空的解决办法
- 使用 sed 编辑器
- 同济大学软件学院院长谈嵌入式方向选择
- 什么是RIA,他的优势?
- Sharepoint2007核心表结构
- .net中dataset的保存回数据库的操作指南
- 算法导论习题1.2的一些思考。
- 开篇
- 生成按某个字段排序后的序号
- Bindows
- 我的一个高手同事离职了,缅怀一小下
- 用游标解决纪录合并的问题
- FTP再学习 (二)