Add Document Type (ex.”Course Categories”)

1-add 1 record “node” to [umbracoNode] Table “with objectNodeID ending with 0EFB”
2-add 1 record to [cmsContentType] Table
3-add n records to [cmsTab] Table “if you add tabs”
4-add n records to [cmsContentTypeAllowedContentType] Table “if you add structure”"with all nodes under this node id”
5-add n records to [cmsPropertyType] Table”for each property”"if you add properties”
ERD

umbracoNode Table

cmsContentType Table

cmsTab Table

cmsContentTypeAllowedContentType Table

Add Template (ex.”Master”)

1-add 1 record “node” to [umbracoNode] Table “with objectNodeID ending with F07D“
2-add 1 record to [cmsTemplate] Table
3-add 1 record to [cmsDocumentType] Table “to associate content type with template”
ERD

umbracoNode Table


cmsTemplate Table

cmsDocumentType Table

Add Content (ex.”Programming (of type course Categories)”)

1-add 1 record “node” to [umbracoNode] Table “with objectNodeID ending with A972“
2-add 1 record to [cmsContent] Table “to associate new content with document type”
3-add 1 record [cmsDocument] Table “That generate GUID of this version”
4-add 1 record [cmsContentVersion] Table” with the generated GUID and the date
5-add 1 record to [cmsContentXml] Table “with all node information as “XML” if you publish it”
6-add n records to [cmsPropertyData] Table “one record for each data which point to property type id from [cmsPropertyType] Table”"If you add data to its properties”
ERD

umbracoNode Table

cmsContent Table

cmsDocument Table

cmsContentVersionTable

cmsContentXml Table

cmsPropertyData Table

cmsPropertyType Table

Publish content

1-add 1 record to [cmsDocument] Table “That generate GUID of this version” and make newest column = True
2-update 1 record of the previous version and make published =True “1″ and update date very near of the last one, update newest=false
3-add 1 record to [cmsContentVersion] Table” with the generated GUID and the date
4-add 1 record to [cmsContentXml] Table “with all node information as “XML” if you publish it”
5-add n records to [cmsPropertyData] Table “one record for each data “if you change any value otherwise it will not add any “ex. content has 4 properties you change 1 property so it will add 4 records considering none changed value as a new values
ERD

cmsDocument Table
See the previous
cmsContentVersion Table
See the previous
cmsContentXml Table
See the previous
cmsPropertyData Table
See the previous
Add Data Type

1-add 1 record “node” to [umbracoNode] Table “with objectNodeID ending with BA3C“
2-add 1 record to [cmsDataType] Table “with the type of the data “int, date, txt” and the type of the control “dropdown, list“
3-add n records to [cmsDataTypePreValues] Table “which has all entered values like “Egypt, UAE, KSA“
ERD

umbracoNode Table

cmsDataType Table

cmsDataTypePreValues Table

Add Macro that use XSLT

1-add 1 record to [cmsMacro] Table “that associate this macro with the XSLT file name if it use XSLT“
ERD

cmsMacro Table

Add user

1-add record to [umbracoUser] Table
2-add 7 records to [umbracoUser2app] Table “if you select all modules “Content-Developer-Media-Members-Settings-Translation-Users”
ERD

umbracoUser Table

umbracoUser2app Table

Add User Type like administrator, writer, and translator

1-add 1 record to [umbracoUserType] Table “With all permission needed” “one character for each permission” “F:C54ZDMOSRPKAUHI“
ERD

umbracoUserType

Add Specific permission for specific node

1-add n records to [umbracoUser2NodePermission] Table for each node for each permission “ex. Node: 1055 premission: 5 for each node, it will add one record for each character of the following “F:C54ZDMOSRPKAUHI” if needed
ERD

umbracoUser2NodePermission

Add Member Type

1-add 1 record “node” to [umbracoNode] Table “with objectNodeID ending with CE43“
2-add 1 record to [cmsContentType] Table “like adding document type” to be associated with members like content to be associated with document
ERD

umbracoNode Table

cmsContentType Table

Add Member

1-add 1 record “node” to [umbracoNode] Table “with objectNodeID ending with 7560“
2-add 1 record to [cmsContent] Table “to associate new content (member) with member type (like document type)”
3-add 1 record to [cmsContentVersion] Table” with the generated GUID and the date
4-add 1 record to [cmsContentXml] Table “with all node information as xml”
5-add n record [cmsMember2MemberGroup] Table “if we add it to group” “1 record for each group to this member with member nodeid and group nodeid”
ERD

umbracoNode

cmsContent
See the previous
cmsContentVersion
See the previous
cmsContentXml
See the previous
cmsMember2MemberGroup

Add Group

1-add 1 record “node” to [umbracoNode] Table “with objectNodeID ending with 9728“
umbracoNode Table
