INSERT INTO cmsSettings (SettingKey, SettingValue, SettingType, SettingIsReadOnly, SettingOptions, SettingComments, SettingGroup) VALUES ('MediaArchivePreviewRoot', 'http://DimacCMSdev/', 'Text', 0, NULL, '= Websiteroot. Localhost or domain', 'System');
INSERT INTO cmsSettings (SettingKey, SettingValue, SettingType, SettingIsReadOnly, SettingOptions, SettingComments, SettingGroup) VALUES ('TrashBinID', '255', 'Text', 0, NULL, 'Used for menus in navigation, 3 is default for the provided MS Access db.', 'System');
INSERT INTO cmsSettings (SettingKey, SettingValue, SettingType, SettingIsReadOnly, SettingOptions, SettingComments, SettingGroup) VALUES ('EditorStylesheet', '/M/SiteResources/CSS/NewSite.css', 'Text', 0, NULL, '[ none | "name.css" ]', 'WYSIWYG');
INSERT INTO cmsSettings (SettingKey, SettingValue, SettingType, SettingIsReadOnly, SettingOptions, SettingComments, SettingGroup) VALUES ('EditorUseBR', '0', 'Select', 0, '1=Use &lt;BR&gt;| 0=Use &lt;P&gt;', NULL, 'WYSIWYG');
INSERT INTO cmsSettings (SettingKey, SettingValue, SettingType, SettingIsReadOnly, SettingOptions, SettingComments, SettingGroup) VALUES ('EditorStyleButtons', '1', 'Select', 0, '1=Use all style buttons | 0=Disable all style buttons', 'Use the WYSIWYG styles (Bold, Italic etc)', 'WYSIWYG');
INSERT INTO cmsSettings (SettingKey, SettingValue, SettingType, SettingIsReadOnly, SettingOptions, SettingComments, SettingGroup) VALUES ('EmailComponent', 'JMail', 'Select', 0, 'JMail | CDONTS', 'Component used for sending e-mails', 'Component');
INSERT INTO cmsSettings (SettingKey, SettingValue, SettingType, SettingIsReadOnly, SettingOptions, SettingComments, SettingGroup) VALUES ('UploadComponent', 'w3Upload', 'Select', 0, 'w3Upload | Script', 'Component used for uploading files', 'Component');
INSERT INTO cmsSettings (SettingKey, SettingValue, SettingType, SettingIsReadOnly, SettingOptions, SettingComments, SettingGroup) VALUES ('Version', '3.0', 'Text', 1, NULL, 'CMS version number', 'Misc');
INSERT INTO cmsSettings (SettingKey, SettingValue, SettingType, SettingIsReadOnly, SettingOptions, SettingComments, SettingGroup) VALUES ('EncryptKey', 'BIKUHJU76GSKI93HNDUE910KLS', 'Text', 0, NULL, 'Encryption Key', 'System');
INSERT INTO cmsSettings (SettingKey, SettingValue, SettingType, SettingIsReadOnly, SettingOptions, SettingComments, SettingGroup) VALUES ('WebSiteRoot', 'http://DimacCMSdev', 'Text', 0, NULL, NULL, 'System');
INSERT INTO cmsSettings (SettingKey, SettingValue, SettingType, SettingIsReadOnly, SettingOptions, SettingComments, SettingGroup) VALUES ('MediaArchiveStartRoot', 'm/SiteResources/data/MediaArchive/', 'Text', 0, NULL, 'Path to images from websiteroot', 'System');
INSERT INTO cmsSettings (SettingKey, SettingValue, SettingType, SettingIsReadOnly, SettingOptions, SettingComments, SettingGroup) VALUES ('SiteRootID', '2', 'Text', 0, NULL, 'Used for menus in navigation, 2 is default for the provided MS Access db.', 'System');
INSERT INTO cmsSettings (SettingKey, SettingValue, SettingType, SettingIsReadOnly, SettingOptions, SettingComments, SettingGroup) VALUES ('SiteUseFrames', '1', 'Select', 0, '1=True | 0=false', NULL, 'System');
INSERT INTO cmsSettings (SettingKey, SettingValue, SettingType, SettingIsReadOnly, SettingOptions, SettingComments, SettingGroup) VALUES ('DatabaseType', 'mySQL', 'Select', 0, 'Access | mySQL | MS-SQL', 'Database type', 'System');
INSERT INTO cmsSettings (SettingKey, SettingValue, SettingType, SettingIsReadOnly, SettingOptions, SettingComments, SettingGroup) VALUES ('MediaArchiveDepth', '../../../../', 'Text', 0, NULL, 'Depth .', 'System');

INSERT INTO ContentScripts (Name, Code) VALUES ('Copyright', '<b>Copyright 2004,Ourcompany</b>');

INSERT INTO DocumentFields (DocID, Name, LangId, FieldValue) VALUES (3, 'Info', 1, '<P>Level 2 test</P>');
INSERT INTO DocumentFields (DocID, Name, LangId, FieldValue) VALUES (4, 'Info', 1, '<DIV><FONT face=Georgia>This is our new website 231.</FONT><FONT face=Georgia><SPAN class=plate><FONT face=Georgia><SPAN class=plate></DIV></SPAN></FONT></SPAN></FONT>');
INSERT INTO DocumentFields (DocID, Name, LangId, FieldValue) VALUES (6, 'Info', 1, '<P>Our great products:</P>');
INSERT INTO DocumentFields (DocID, Name, LangId, FieldValue) VALUES (7, 'Info', 1, '<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD>
<P align=center><STRONG><FONT size=5>Blanket.</FONT></STRONG></P></TD></TR>
<TR>
<TD>
<P align=center>&nbsp;</P></TD></TR>
<TR>
<TD>&nbsp;<STRONG>For some of you, it''s starting to cool down. Warm back up with our fuzzy cool blanket.</STRONG></TD></TR>
<TR>
<TD><BR>&nbsp;<STRONG>Price: $ 15.00</STRONG></TD></TR></TBODY></TABLE>');
INSERT INTO DocumentFields (DocID, Name, LangId, FieldValue) VALUES (9, 'Info', 1, '<P>This is the TrashBin</P>');
INSERT INTO DocumentFields (DocID, Name, LangId, FieldValue) VALUES (10, 'Info', 1, '55555');
INSERT INTO DocumentFields (DocID, Name, LangId, FieldValue) VALUES (10, 'Label', 1, 'eryeyeyer');
INSERT INTO DocumentFields (DocID, Name, LangId, FieldValue) VALUES (4, 'Bengt', 1, 'hej');
INSERT INTO DocumentFields (DocID, Name, LangId, FieldValue) VALUES (4, 'Info', 2, '<FONT face=Georgia>231 la zuezia.</FONT>');
INSERT INTO DocumentFields (DocID, Name, LangId, FieldValue) VALUES (6, 'Info', 2, 'V&aring;ra fina produkter:');
INSERT INTO DocumentFields (DocID, Name, LangId, FieldValue) VALUES (10, 'Label', 2, '');
INSERT INTO DocumentFields (DocID, Name, LangId, FieldValue) VALUES (10, 'Info', 2, '');
INSERT INTO DocumentFields (DocID, Name, LangId, FieldValue) VALUES (11, 'Info', 1, 'Just a drill');
INSERT INTO DocumentFields (DocID, Name, LangId, FieldValue) VALUES (11, 'Info', 2, '');
INSERT INTO DocumentFields (DocID, Name, LangId, FieldValue) VALUES (12, 'Info', 1, '<H1><FONT face=Georgia>Raml&ouml;sa</FONT></H1>
<DIV><FONT face=Georgia>There is a little place called Raml&ouml;sa, south of Helsingborg.</FONT></DIV>');
INSERT INTO DocumentFields (DocID, Name, LangId, FieldValue) VALUES (12, 'Info', 2, '<H1><FONT face=Georgia>Raml&ouml;sa</FONT></H1>
<DIV><FONT face=Georgia>Det finns ett litet st&auml;lle s&ouml;der om Helsingborg som heter Raml&ouml;sa.</FONT></DIV>');
INSERT INTO DocumentFields (DocID, Name, LangId, FieldValue) VALUES (5, 'Info', 1, '<FONT face=Georgia>This is our new web site.</FONT>');
INSERT INTO DocumentFields (DocID, Name, LangId, FieldValue) VALUES (5, 'Info', 2, '<FONT face=Georgia>Detta &auml;r v&aring;r nya hemsida.</FONT>');

INSERT INTO DocumentLanguages (DocId, LangId, DocName, LangStatus, LangModuleURL) VALUES (6, 3, 'sadf', 5, NULL);
INSERT INTO DocumentLanguages (DocId, LangId, DocName, LangStatus, LangModuleURL) VALUES (10, 1, 'Aftonbladet', 5, NULL);
INSERT INTO DocumentLanguages (DocId, LangId, DocName, LangStatus, LangModuleURL) VALUES (10, 2, 'Aftonbladet', 5, NULL);
INSERT INTO DocumentLanguages (DocId, LangId, DocName, LangStatus, LangModuleURL) VALUES (11, 1, 'This is a drill', 1, NULL);
INSERT INTO DocumentLanguages (DocId, LangId, DocName, LangStatus, LangModuleURL) VALUES (11, 2, 'Detta &auml;r en borr', 1, NULL);
INSERT INTO DocumentLanguages (DocId, LangId, DocName, LangStatus, LangModuleURL) VALUES (8, 1, 'Contact Us', 5, '');
INSERT INTO DocumentLanguages (DocId, LangId, DocName, LangStatus, LangModuleURL) VALUES (8, 2, 'Kontakta Oss', 5, NULL);
INSERT INTO DocumentLanguages (DocId, LangId, DocName, LangStatus, LangModuleURL) VALUES (12, 1, 'Raml&ouml;sa', 1, NULL);
INSERT INTO DocumentLanguages (DocId, LangId, DocName, LangStatus, LangModuleURL) VALUES (12, 2, 'Raml&ouml;sa', 1, NULL);
INSERT INTO DocumentLanguages (DocId, LangId, DocName, LangStatus, LangModuleURL) VALUES (4, 1, 'New Site!', 5, NULL);
INSERT INTO DocumentLanguages (DocId, LangId, DocName, LangStatus, LangModuleURL) VALUES (4, 2, 'Ny Sajt!', 5, NULL);
INSERT INTO DocumentLanguages (DocId, LangId, DocName, LangStatus, LangModuleURL) VALUES (5, 2, 'Om Oss', 1, NULL);
INSERT INTO DocumentLanguages (DocId, LangId, DocName, LangStatus, LangModuleURL) VALUES (5, 1, 'About Us', 3, NULL);
INSERT INTO DocumentLanguages (DocId, LangId, DocName, LangStatus, LangModuleURL) VALUES (6, 2, 'Produkter', 5, NULL);
INSERT INTO DocumentLanguages (DocId, LangId, DocName, LangStatus, LangModuleURL) VALUES (6, 1, 'Products', 5, NULL);

INSERT INTO Documents (ParentID, prevDocumentID, prevParentID, SortOrder, isFolder, DocName, ModuleID, ModuleFrame, TemplateURL, CreatedBy, CreatedDate, ModifiedBy, ModifiedDate, SentForApprovalDate, PublishDate, ExpiresDate, Active, ApprovalID, DocumentStatus, SecLevel, ExternalPage, ExternalPageURL, ExternalPageFrame, Extra1, Extra2, Extra3, MultiPageStartYN, MultiPagePrevPage, MultiPageNextPage, TreeIcon) VALUES (0, NULL, NULL, 999, 1, 'DevRoot', 0, NULL, '0DevRoot.asp', 1, '2002-05-25', 1, '2002-06-08', NULL, '2002-05-24', '2004-01-01', 1, 0, 0, 1, 0, NULL, NULL, NULL, NULL, NULL, '0', 0, 0, 'Systemfolder.gif');
INSERT INTO Documents (ParentID, prevDocumentID, prevParentID, SortOrder, isFolder, DocName, ModuleID, ModuleFrame, TemplateURL, CreatedBy, CreatedDate, ModifiedBy, ModifiedDate, SentForApprovalDate, PublishDate, ExpiresDate, Active, ApprovalID, DocumentStatus, SecLevel, ExternalPage, ExternalPageURL, ExternalPageFrame, Extra1, Extra2, Extra3, MultiPageStartYN, MultiPagePrevPage, MultiPageNextPage, TreeIcon) VALUES (0, NULL, NULL, 0, 1, 'SiteRoot', 0, NULL, '0SiteRoot.asp', 1, '2002-05-25', 1, '2002-06-08', NULL, '2002-05-25', '2002-05-25', 1, 0, 0, 1, 0, NULL, NULL, NULL, NULL, NULL, '0', 0, 0, 'Systemfolder.gif');
INSERT INTO Documents (ParentID, prevDocumentID, prevParentID, SortOrder, isFolder, DocName, ModuleID, ModuleFrame, TemplateURL, CreatedBy, CreatedDate, ModifiedBy, ModifiedDate, SentForApprovalDate, PublishDate, ExpiresDate, Active, ApprovalID, DocumentStatus, SecLevel, ExternalPage, ExternalPageURL, ExternalPageFrame, Extra1, Extra2, Extra3, MultiPageStartYN, MultiPagePrevPage, MultiPageNextPage, TreeIcon) VALUES (6, NULL, NULL, 0, 0, 'Level 2 test', 0, NULL, '1Template3.asp', 1, '2003-04-09', 1, '2003-04-12', NULL, '2003-04-09', '2005-04-09', 0, 0, 0, 1, 0, '', '', '', '', '', NULL, 0, 0, NULL);
INSERT INTO Documents (ParentID, prevDocumentID, prevParentID, SortOrder, isFolder, DocName, ModuleID, ModuleFrame, TemplateURL, CreatedBy, CreatedDate, ModifiedBy, ModifiedDate, SentForApprovalDate, PublishDate, ExpiresDate, Active, ApprovalID, DocumentStatus, SecLevel, ExternalPage, ExternalPageURL, ExternalPageFrame, Extra1, Extra2, Extra3, MultiPageStartYN, MultiPagePrevPage, MultiPageNextPage, TreeIcon) VALUES (1, NULL, NULL, 0, 0, 'Ny Sajt!', 0, NULL, '1Template3.asp', 1, '2003-09-24', 1, '2005-01-13', NULL, '2004-12-30', '2004-12-30', 0, 0, 5, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL);
INSERT INTO Documents (ParentID, prevDocumentID, prevParentID, SortOrder, isFolder, DocName, ModuleID, ModuleFrame, TemplateURL, CreatedBy, CreatedDate, ModifiedBy, ModifiedDate, SentForApprovalDate, PublishDate, ExpiresDate, Active, ApprovalID, DocumentStatus, SecLevel, ExternalPage, ExternalPageURL, ExternalPageFrame, Extra1, Extra2, Extra3, MultiPageStartYN, MultiPagePrevPage, MultiPageNextPage, TreeIcon) VALUES (2, NULL, NULL, 0, 0, 'About Us', 0, NULL, '1Template3.asp', 1, '2003-10-22', 1, '2005-01-17', '2005-01-13', '2004-12-30', '2004-12-30', 0, 1, 2, 1, 0, '', '', '', '', '', NULL, 0, 0, NULL);
INSERT INTO Documents (ParentID, prevDocumentID, prevParentID, SortOrder, isFolder, DocName, ModuleID, ModuleFrame, TemplateURL, CreatedBy, CreatedDate, ModifiedBy, ModifiedDate, SentForApprovalDate, PublishDate, ExpiresDate, Active, ApprovalID, DocumentStatus, SecLevel, ExternalPage, ExternalPageURL, ExternalPageFrame, Extra1, Extra2, Extra3, MultiPageStartYN, MultiPagePrevPage, MultiPageNextPage, TreeIcon) VALUES (2, NULL, NULL, 0, 1, 'Products', 0, '', '1Template3.asp', 1, '2003-10-22', 1, '2005-01-10', NULL, '2003-10-22', '2005-10-22', 0, 0, 0, 0, 0, '', '', '', '', '', '', 0, 0, NULL);
INSERT INTO Documents (ParentID, prevDocumentID, prevParentID, SortOrder, isFolder, DocName, ModuleID, ModuleFrame, TemplateURL, CreatedBy, CreatedDate, ModifiedBy, ModifiedDate, SentForApprovalDate, PublishDate, ExpiresDate, Active, ApprovalID, DocumentStatus, SecLevel, ExternalPage, ExternalPageURL, ExternalPageFrame, Extra1, Extra2, Extra3, MultiPageStartYN, MultiPagePrevPage, MultiPageNextPage, TreeIcon) VALUES (6, NULL, NULL, 0, 0, 'Blanket', 0, NULL, '1Template3.asp', 1, '2003-10-22', 1, '2004-06-02', NULL, '2003-10-22', '2005-10-22', 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL);
INSERT INTO Documents (ParentID, prevDocumentID, prevParentID, SortOrder, isFolder, DocName, ModuleID, ModuleFrame, TemplateURL, CreatedBy, CreatedDate, ModifiedBy, ModifiedDate, SentForApprovalDate, PublishDate, ExpiresDate, Active, ApprovalID, DocumentStatus, SecLevel, ExternalPage, ExternalPageURL, ExternalPageFrame, Extra1, Extra2, Extra3, MultiPageStartYN, MultiPagePrevPage, MultiPageNextPage, TreeIcon) VALUES (2, NULL, NULL, 400, 0, 'Contact Us', 7, 'main', 'modules/Contactus/contactus.asp', 1, '2004-05-07', 1, '2005-01-17', NULL, '2004-05-07', '2006-05-07', 1, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL);
INSERT INTO Documents (ParentID, prevDocumentID, prevParentID, SortOrder, isFolder, DocName, ModuleID, ModuleFrame, TemplateURL, CreatedBy, CreatedDate, ModifiedBy, ModifiedDate, SentForApprovalDate, PublishDate, ExpiresDate, Active, ApprovalID, DocumentStatus, SecLevel, ExternalPage, ExternalPageURL, ExternalPageFrame, Extra1, Extra2, Extra3, MultiPageStartYN, MultiPagePrevPage, MultiPageNextPage, TreeIcon) VALUES (0, NULL, NULL, 9999, 1, 'TrashBin', 0, NULL, '0TrashBin.asp', 1, '2004-11-29', 1, '2004-11-29', NULL, '2004-11-29', '2006-11-29', 0, 0, 0, 0, 0, '', '', '', '', '', NULL, 0, 0, 'TrashBin.gif');
INSERT INTO Documents (ParentID, prevDocumentID, prevParentID, SortOrder, isFolder, DocName, ModuleID, ModuleFrame, TemplateURL, CreatedBy, CreatedDate, ModifiedBy, ModifiedDate, SentForApprovalDate, PublishDate, ExpiresDate, Active, ApprovalID, DocumentStatus, SecLevel, ExternalPage, ExternalPageURL, ExternalPageFrame, Extra1, Extra2, Extra3, MultiPageStartYN, MultiPagePrevPage, MultiPageNextPage, TreeIcon) VALUES (2, NULL, NULL, 0, 0, 'Aftonbladet', 0, NULL, '1Template2.asp', 1, '2004-12-07', 1, '2005-01-13', '2004-12-07', '2004-12-07', '2006-12-07', 0, 1, 5, 0, 0, 'http://www.aftonbladet.se', '', '', '', '', NULL, 0, 0, NULL);
INSERT INTO Documents (ParentID, prevDocumentID, prevParentID, SortOrder, isFolder, DocName, ModuleID, ModuleFrame, TemplateURL, CreatedBy, CreatedDate, ModifiedBy, ModifiedDate, SentForApprovalDate, PublishDate, ExpiresDate, Active, ApprovalID, DocumentStatus, SecLevel, ExternalPage, ExternalPageURL, ExternalPageFrame, Extra1, Extra2, Extra3, MultiPageStartYN, MultiPagePrevPage, MultiPageNextPage, TreeIcon) VALUES (9, 0, 2, 0, 0, 'Detta &auml;r en borr', 0, NULL, '1Template3.asp', 1, '2005-01-13', 1, '2005-01-13', NULL, '2005-01-13', '2007-01-13', 0, 0, 1, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL);
INSERT INTO Documents (ParentID, prevDocumentID, prevParentID, SortOrder, isFolder, DocName, ModuleID, ModuleFrame, TemplateURL, CreatedBy, CreatedDate, ModifiedBy, ModifiedDate, SentForApprovalDate, PublishDate, ExpiresDate, Active, ApprovalID, DocumentStatus, SecLevel, ExternalPage, ExternalPageURL, ExternalPageFrame, Extra1, Extra2, Extra3, MultiPageStartYN, MultiPagePrevPage, MultiPageNextPage, TreeIcon) VALUES (2, 0, 0, 0, 0, 'Raml&ouml;sa', 0, NULL, '1Template3.asp', 1, '2005-01-13', 1, '2005-01-13', NULL, '2005-01-13', '2007-01-13', 0, 0, 1, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL);

INSERT INTO FunctionScripts (Name, Code) VALUES ('FixNumber', 'Function FixNumber( x )

  If x < 10 Then
    FixNumber = "0" & x
  Else
    FixNumber = "" & x
  End If

End Function');
INSERT INTO FunctionScripts (Name, Code) VALUES ('OurOwnTrimAll', 'Function OurOwnTrimAll( s )

  Dim x

  x = Trim( s )
  While (Left(x,1) = vbTab)
    x = Right(x,Len(x)-1)
  Wend
	
  While (Right(x,1) = vbTab)
    x = Left(x,Len(x)-1)
  Wend

  TrimAll = x
	
End Function');

INSERT INTO Languages (Code, Description, MasterLanguage, LCID, Charset, LanguageImage, IsMenuDirty) VALUES ('EN', 'English', 1, 0, 'iso-8859-1', 'us.gif', 1);
INSERT INTO Languages (Code, Description, MasterLanguage, LCID, Charset, LanguageImage, IsMenuDirty) VALUES ('SV', 'Swedish', 0, 0, 'iso-8859-1', 'se.gif', 0);

INSERT INTO Modules (ModuleName, ModuleVersion, StartURL, StartFrame, AdminURL, Active) VALUES ('Contact Us', '1', 'modules/Contactus/contactus.asp', 'main', 'modules/Contactus/admin.htm', 1);

INSERT INTO Tasks (OwnerID, OwnerGroupID, CreatedByID, DocumentID, RevisionID, Prio, Status, Subject, DueDate, Description) VALUES (1, 2, 1, 0, 0, 3, 1, 'test ', '2004-12-12', 'ertertv re retcer');
INSERT INTO Tasks (OwnerID, OwnerGroupID, CreatedByID, DocumentID, RevisionID, Prio, Status, Subject, DueDate, Description) VALUES (1, 0, 1, 0, 0, 3, 1, 'ertertet', '2004-12-15', 'fghfhfhfghfg');
INSERT INTO Tasks (OwnerID, OwnerGroupID, CreatedByID, DocumentID, RevisionID, Prio, Status, Subject, DueDate, Description) VALUES (1, 2, 1, 0, 0, 3, 1, 'ert', '2005-01-01', 'dfgdfdffd');

INSERT INTO UserGroups (Description, vRead, vCreate, vEdit, vDelete) VALUES ('Administrators', 1, 1, 0, 1);
INSERT INTO UserGroups (Description, vRead, vCreate, vEdit, vDelete) VALUES ('Publishers', 1, 1, 1, 1);
INSERT INTO UserGroups (Description, vRead, vCreate, vEdit, vDelete) VALUES ('Editors', 1, 1, 0, 0);

INSERT INTO WorkFlowInfo (DocID, UserID, LangID, ApprovalUserID, Status, Info) VALUES (10, 1, 1, 1, 0, 'g&ouml;r om......');
INSERT INTO WorkFlowInfo (DocID, UserID, LangID, ApprovalUserID, Status, Info) VALUES (5, 1, 1, 1, 0, '3wrte');

