JMDCMS.Data

Table of contents


Data Tables

  • JmdSite
FieldName DataType Required Description
ID UniqueIdentifier Y Primary Key
ParentSiteID UniqueIdentifier N Site ID of Parent site
AliasSiteID UniqueIdentifier N If provided, then this site will acts as an alias for other existing site.
SiteURL Nvarchar(100) Y URL for this site
SiteFolder Nvarchar(100) Y Base folder for this site. This site will only have access to the folders under SiteFolder.
LastChanged timestamp Y Auto generated by sql server.

Views

  • JmdSiteInfo: Site, ParentSite and AliasSite consolidated information view.

Stored Procedures

  • JmdSiteSave: Performs insert/update on JmdSite table.
  • JmdSiteDelete: Performs delete on JmdSite table.


Last edited Jan 26, 2008 at 7:10 PM by handaajay15, version 11

Comments

No comments yet.