Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...customize database installationcustomize database installation
Previous
 
Next
New Post
3/23/2012 5:11 PM
 

Hi all

I want to add multiple INSERTs and UPDATEs in DNN database at installation time. Does anyone know where are the SQL scripts to create and populate the tables at the time of installation?

Thanks for advance


Comunidade BrasilDNN Marcio Maciel, Brasil
 
New Post
3/23/2012 6:36 PM
 

~\Website\Providers\DataProviders\SqlDataProvider




Ken Grierson
DotNetNuke Corporation
Test Lead
 
New Post
3/23/2012 10:48 PM
 
Hi Ken

I find the DotNetNuke.Data.SqlDataProvider file. My goal:
1) translate Brazil to Brasil (very easy, done)
2) add our currency, Real
3) add our states, like California and Florida in USA

I do it:
INSERT INTO ... VALUES (364, N'DataType', N'Multi-line Text', ...)
INSERT INTO ... VALUES (365, N'Currency', N'BRL', N'Reais Brasileiros (BRL)', ...)
INSERT INTO ... VALUES (366, N'Region', N'AC', N'Acre', 29, 1, 0, -1, ...)
INSERT INTO ... VALUES (367, N'Region', N'AL', N'Alagoas', 29, 1, 0, -1, ...)
INSERT INTO ... VALUES (368, N'Region', N'AP', N'Amapá', 29, 1, 0, -1, ...)
INSERT INTO MANY RECORDS! =)
INSERT INTO ... VALUES (392, N'Region', N'TO', N'Tocantins', 29, 1, 0, -1, ...) (last state)

27 states e 1 currency added

My fear: I see the "SET IDENTITY_INSERT ON/OFF" statments, which means that are fixed initials EntryID (why, DNN TEAM, WHY?! =] ). And if in future the DNN move to using IDs 365 to 392 in your installer?!

What do you recommend? I am in right way, or I must use numbers ID 1000 to forward?

Thanks for your support

Comunidade BrasilDNN Marcio Maciel, Brasil
 
New Post
3/23/2012 11:26 PM
 
Fixed id's make for faster installation scripts - with reduced referential integrity issues.

For your own additions however - why not just turn identity back on and let the system work things out for you.
 
New Post
3/25/2012 2:53 AM
 
Tks Wes, I will try.

Comunidade BrasilDNN Marcio Maciel, Brasil
 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...customize database installationcustomize database installation


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out