Hey Shamil,
I would suggest that you dont directly access the DNN database tables directly. A better approach is to use the DNN API.
http://dotnetnuke.codeplex.com/releas... has the latest api documentation.
However if you do want to get some understanding of the database structure the latest erd documents are here
http://www.dotnetnuke.com/tabid/795/f...
With regard to seo/indexing - assuming you get thru the process of automatically loading the html onto your site.
DNN with reindex the new pages into its indexes for you, and will also generate an updated sitemap for you.
As for worrying about things like menu providers - again - I would look at the DNN api.
DotNetNuke.entities.tabs is the namespace to look into for how to add pages
DotNetNuke.entities.modules is the namespace to look into for how to add modules to a page
The basic steps you would need to follow are:
For each PAGE in you site you need to add a TAB
- the tab is where you define the name of the page, keywords, descriptions, permissions, and also where it sites in the menu tree of your site - basically what TAB is its PARENT and its order in the MENU. - note you dont actually create a MENU - the menu is defined by the information you add to each TAB
On the TAB you then want to add a MODULE - in this case the HTML module
And once the MODULE is added - you want to populate it with your HTML.
Again using the API.
Westa