EXEC spInsertMenu 'Home','X','controls/Home.ascx',1;
EXEC spInsertMenu 'Forum','X','controls/Forum.ascx',1;
EXEC spInsertMenu 'Forum View','X','controls/ForumView.ascx',0;
EXEC spInsertMenu 'Forum Topic View','X','controls/ForumTopicView.ascx',0;
EXEC spInsertMenu 'Forum Posting','X','controls/ForumPosting.ascx',0;
EXEC spInsertMenu 'Videos','X','controls/Videos.ascx',1;
EXEC spInsertMenu 'Video Upload','X','controls/VideoUpload.ascx',0;
EXEC spInsertMenu 'Pictures','X','controls/Pictures.ascx',1;
EXEC spInsertMenu 'Picture Upload','X','controls/PictureUpload.ascx',0;
EXEC spInsertMenu 'Registration','X','controls/Registration.ascx',0;
EXEC spInsertMenu 'Profile','X','controls/Profile.ascx',0;
EXEC spInsertMenu 'Private Messages','X','controls/PrivateMessages.ascx',0;
EXEC spInsertMenu 'News','X','controls/News.ascx',1;
EXEC spInsertMenu 'Poll List','X','controls/poll/PollList.ascx',0;
EXEC spInsertMenu 'Chat','X','controls/Chat.ascx',1;
EXEC spInsertMenu 'Avatar Upload','X','controls/ProfileAvatarUpload.ascx',0;
EXEC spInsertMenu 'Members','X','controls/Members.ascx',1;
EXEC spInsertMenu 'Contact Us', 'X', 'controls/ContactUs.ascx',1;
EXEC spInsertMenu 'PictureViewer','X','controls/PictureViewer.ascx',0;
EXEC spInsertMenu 'VideoViewer','X','controls/VideoViewer.ascx',0;
EXEC spInsertMenu 'Web Links', 'X', 'controls/WebLinks.ascx',3;
EXEC spInsertMenu 'Forgot Login', 'X', 'controls/ForgotLogin.ascx',0;
EXEC spInsertMenu 'RSS Feed', 'X', 'controls/RSSFeedList.ascx',3;
EXEC spInsertBoxes 'Main','L',1,'M','',-1;
EXEC spInsertBoxes 'Poll','L',2,'X','controls/poll/Poll.ascx',-1;
EXEC spInsertBoxes 'Other Links','R',3,'M','',-1;
EXEC spInsertBoxes 'Users Online','R',2,'X','controls/UsersOnline.ascx',-1;
EXEC spInsertBoxes 'User CP','R',4,'M','',0;
EXEC spInsertBoxes 'Login','R',1,'X','controls/Login.ascx',-1;
EXEC spInsertMenu 'Edit profile','X','controls/Profile.ascx',5;
EXEC spInsertMenu 'Friends','XE','Profile&tab=1',5;
EXEC spInsertMenu 'My Photos','XE','Profile&tab=2',5;
EXEC spInsertMenu 'My Videos','XE','Profile&tab=3',5;
EXEC spInsertMenu 'My Groups','XE','Profile&tab=4',5;
EXEC spInsertMenu 'My Favorites','XE','Profile&tab=5',5;
EXEC spInsertMenu 'Approvals(X)','XE','Profile&tab=6',5;
EXEC spInsertMenu 'Login','X','controls/Login.ascx',6;

INSERT INTO [tblConfig] ([key_name],[key_value],[removable]) VALUES ('Site Title','DigiOz .NET Portal','N');
INSERT INTO [tblConfig] ([key_name],[key_value],[removable]) VALUES ('Site URL','www.digioz.com','N');
INSERT INTO [tblConfig] ([key_name],[key_value],[removable]) VALUES ('Style Sheet','style.css','N');
INSERT INTO [tblConfig] ([key_name],[key_value],[removable]) VALUES ('Contact Name','Portal Webmaster','N');
INSERT INTO [tblConfig] ([key_name],[key_value],[removable]) VALUES ('Contact Email','webmaster@domain.com','N');
INSERT INTO [tblConfig] ([key_name],[key_value],[removable]) VALUES ('SMTP Server','mail.domain.com','N');
INSERT INTO [tblConfig] ([key_name],[key_value],[removable]) VALUES ('SMTP Username','webmaster@domain.com','N');
INSERT INTO [tblConfig] ([key_name],[key_value],[removable]) VALUES ('SMTP Password','<Password Encrypted>','N');
INSERT INTO [tblConfig] ([key_name],[key_value],[removable]) VALUES ('Portal Version', '1.1.0.0', 'N');
INSERT INTO [tblConfig] ([key_name],[key_value],[removable]) VALUES ('Forum Threads Per Page', '10', 'N');
INSERT INTO [tblUsers] ([username],[password],[permission]) VALUES ('admin','IgTepHWo5DgtPi3U6lyjCw==','3');
EXEC spInsertAdminMenu 'Index','controls/admin/Index.ascx';
EXEC spInsertAdminMenu 'Comment Manager','controls/admin/CommentManager.ascx';
EXEC spInsertAdminMenu 'Database Utilities','controls/admin/DataBaseUtil.ascx';
EXEC spInsertAdminMenu 'File Manager','controls/admin/FileManager.ascx';
EXEC spInsertAdminMenu 'Forum Management','controls/admin/ForumManagement.ascx';
EXEC spInsertAdminMenu 'Module Manager','controls/admin/ModuleManager.ascx';
EXEC spInsertAdminMenu 'Page Manager','controls/admin/PageManager.ascx';
EXEC spInsertAdminMenu 'Poll Manager','controls/admin/PollManager.ascx';
EXEC spInsertAdminMenu 'Statistics','controls/admin/Statistics.ascx';
EXEC spInsertAdminMenu 'Style Sheet Editor','controls/admin/ManageStyleSheet.ascx';
EXEC spInsertAdminMenu 'Top Menu Manager','controls/admin/TopMenuManager.ascx';
EXEC spInsertAdminMenu 'User Management','controls/admin/UserManagement.ascx';
EXEC spInsertAdminMenu 'News Publishing','controls/admin/NewsPublishing.ascx';
EXEC spInsertAdminMenu 'Picture Management','controls/admin/PictureManager.ascx';
EXEC spInsertAdminMenu 'Video Management','controls/admin/VideoManager.ascx';
EXEC spInsertAdminMenu 'WebLinks Manager','controls/admin/WebLinksManager.ascx';
EXEC spInsertAdminMenu 'Category Manager','controls/admin/CategoryManager.ascx';
EXEC spInsertAdminMenu 'RSS Feed Manager','controls/admin/ManageRSSFeeds.ascx';
EXEC spInsertAdminMenu 'Chatroom Manager','controls/admin/ChatroomManager.ascx';
EXEC spInsertForum 'Main Forum','Forum for General Questions','','',1,1,0,0,null,'',null,'';
EXEC spSubmitPollSubject	N'Do you like this Portal?', 1, N'3/6/2100', N'How do you like the Portal?';
EXEC spSubmitPollOption	1, N'I like it very much!';
EXEC spSubmitPollOption	1, N'I like it.';
EXEC spSubmitPollOption	1, N'I don''t like it.';
EXEC spSubmitPollOption	1, N'I hate it!';
EXEC spInsertNews 'admin','Welcome to DigiOz .NET Portal!','%0d%0a%09%09%3cp%3eDigiOz+ASP.NET+Portal+is+a+web+based+portal+system+written+in+C%23+which+uses+Microsoft+SQL+Server%2c+MySQL+Database+and+other+types+of+Database%c2%a0to%c2%a0allow+Webmasters+to+setup+and+customize+an+instant+website+for+either+business+or+personal+use.+%3c%2fp%3e%0d%0a%09%09%3cp%3eIf+you+are+the+webmaster%2c+please+log+into+the+Administrative+Interface+to+Manage+your+site.+%3c%2fp%3e%0d%0a%09%09%3cp%3eThanks%2c%3cbr+%2f%3eThe+DigiOz+.NET+Portal+Team%3c%2fp%3e%0d%0a','2/8/2009 9:10:53 AM';
INSERT INTO tblExtensions (ext_name,ext_type,ext_allowed, ext_mimetype) VALUES ('gif','IMAGE',1,'image/gif');
INSERT INTO tblExtensions (ext_name,ext_type,ext_allowed, ext_mimetype) VALUES ('jpg','IMAGE',1,'image/jpeg');
INSERT INTO tblExtensions (ext_name,ext_type,ext_allowed, ext_mimetype) VALUES ('bmp','IMAGE',1,'image/bmp');
INSERT INTO tblExtensions (ext_name,ext_type,ext_allowed, ext_mimetype) VALUES ('png','IMAGE',0,'image/png');
INSERT INTO tblExtensions (ext_name,ext_type,ext_allowed, ext_mimetype) VALUES ('tif','IMAGE',0,'image/tiff');
INSERT INTO tblExtensions (ext_name,ext_type,ext_allowed, ext_mimetype) VALUES ('tiff','IMAGE',0,'image/tiff');
INSERT INTO tblExtensions (ext_name,ext_type,ext_allowed, ext_mimetype) VALUES ('tga','IMAGE',0,'image/tga');
INSERT INTO tblExtensions (ext_name,ext_type,ext_allowed, ext_mimetype) VALUES ('jpeg','IMAGE',0,'image/jpeg');
INSERT INTO tblExtensions (ext_name,ext_type,ext_allowed, ext_mimetype) VALUES ('avi','VIDEO',1,'video/x-msvideo');
INSERT INTO tblExtensions (ext_name,ext_type,ext_allowed, ext_mimetype) VALUES ('mpg','VIDEO',1,'video/mpeg');
INSERT INTO tblExtensions (ext_name,ext_type,ext_allowed, ext_mimetype) VALUES ('mpeg','VIDEO',1,'video/mpeg');
INSERT INTO tblExtensions (ext_name,ext_type,ext_allowed, ext_mimetype) VALUES ('mov','VIDEO',1,'video/quicktime');
INSERT INTO tblExtensions (ext_name,ext_type,ext_allowed, ext_mimetype) VALUES ('wmv','VIDEO',1,'video/x-ms-wmv');
INSERT INTO tblExtensions (ext_name,ext_type,ext_allowed, ext_mimetype) VALUES ('rm','VIDEO',0,'application/vnd.rn-realmedia');
INSERT INTO tblExtensions (ext_name,ext_type,ext_allowed, ext_mimetype) VALUES ('txt','TEXT',1,'text/plain');
INSERT INTO tblExtensions (ext_name,ext_type,ext_allowed, ext_mimetype) VALUES ('log','TEXT',0,'text/plain');
INSERT INTO tblExtensions (ext_name,ext_type,ext_allowed, ext_mimetype) VALUES ('xml','TEXT',0,'text/xml');
INSERT INTO tblExtensions (ext_name,ext_type,ext_allowed, ext_mimetype) VALUES ('doc','DOCUMENT',1,'application/msword');
INSERT INTO tblExtensions (ext_name,ext_type,ext_allowed, ext_mimetype) VALUES ('pdf','DOCUMENT',1,'application/pdf');
INSERT INTO tblExtensions (ext_name,ext_type,ext_allowed, ext_mimetype) VALUES ('rtf','DOCUMENT',1,'application/rtf');
INSERT INTO tblExtensions (ext_name,ext_type,ext_allowed, ext_mimetype) VALUES ('xls','DOCUMENT',0,'application/vnd.ms-excel');
INSERT INTO tblExtensions (ext_name,ext_type,ext_allowed, ext_mimetype) VALUES ('zip','ARCHIVE',1,'application/x-zip-compressed');
INSERT INTO tblExtensions (ext_name,ext_type,ext_allowed, ext_mimetype) VALUES ('tgz','ARCHIVE',0,'application/x-tar-gz');
INSERT INTO tblExtensions (ext_name,ext_type,ext_allowed, ext_mimetype) VALUES ('tar','ARCHIVE',0,'application/x-tar');
INSERT INTO tblExtensions (ext_name,ext_type,ext_allowed, ext_mimetype) VALUES ('gz','ARCHIVE',0,'application/x-gzip');
INSERT INTO tblExtensions (ext_name,ext_type,ext_allowed, ext_mimetype) VALUES ('rar','ARCHIVE',0,'application/x-rar-compressed');
INSERT INTO tblUserProfile(profile_username,profile_email,profile_birthday,profile_hide_birthday,profile_address,profile_address2,profile_city,profile_state,profile_zip,profile_country,profile_signature)VALUES('admin','webmaster@domain.com',null,1,'','','','','','','');
EXEC spInsertUserPermission '0', 'Regular User';
EXEC spInsertUserPermission '1', 'Moderator';
EXEC spInsertUserPermission '2', 'Administrator';
EXEC spInsertUserPermission '3', 'Super Administrator';
EXEC spInsertTopMenuItem '0', 'Registration','LM', 'Registration', '-1';
EXEC spInsertTopMenuItem '0', 'Login', 'LI', '~/Login.aspx', '-1';
EXEC spInsertTopMenuItem '0', 'Profile', 'LM', 'Profile', '0';
EXEC spInsertTopMenuItem '0', 'Private Messages', 'LM', 'Private Messages', '0';
EXEC spInsertTopMenuItem '0', 'Admin', 'LI', '~/Admin.aspx', '3';
EXEC spInsertTopMenuItem '0', 'Logout', 'LI', '~/Login.aspx?mode=logout', '0';
EXEC spInsertTopMenuItem '0', 'Forgot Login?', 'LM', 'Forgot Login', '-1';
INSERT INTO tblPortalMetadata (portalmetadata_keywords,portalmetadata_description) VALUES ('Portal, ASP.NET, DigiOz','Another ASP.NET Portal Powered by DigiOz .NET Portal');
EXEC spInsertSmiley ':peace:', 'images/chat/peace.png';
EXEC spInsertSmiley ':poop:', 'images/chat/poop.png';
EXEC spInsertSmiley ':pig:', 'images/chat/pig.png';
EXEC spInsertSmiley ':pill:', 'images/chat/pill.png';
EXEC spInsertSmiley '(:o)', 'images/chat/party.png';
EXEC spInsertSmiley '(A)', 'images/chat/angel.png';
EXEC spInsertSmiley '(a)', 'images/chat/angel.png';
EXEC spInsertSmiley ':@', 'images/chat/angry.png';
EXEC spInsertSmiley ';)', 'images/chat/wink.png';
EXEC spInsertSmiley '+o(', 'images/chat/sick.png';
EXEC spInsertSmiley ':^)', 'images/chat/nailbiting.png';
EXEC spInsertSmiley ':(', 'images/chat/sad.png';
EXEC spInsertSmiley ':-#', 'images/chat/quiet.png';
EXEC spInsertSmiley ':o', 'images/chat/shock.png';
EXEC spInsertSmiley ':D', 'images/chat/smile-big.png';
EXEC spInsertSmiley ':-*', 'images/chat/secret.png';
EXEC spInsertSmiley ':cry:', 'images/chat/crying.png';
EXEC spInsertSmiley ':)', 'images/chat/smile.png';
EXEC spInsertSmiley '(ap)', 'images/chat/airplane.png';
EXEC spInsertSmiley ':alien:', 'images/chat/alien.png';
EXEC spInsertSmiley '(N)', 'images/chat/bad.png';
EXEC spInsertSmiley '(n)', 'images/chat/bad.png';
EXEC spInsertSmiley ':$', 'images/chat/shame.png';
EXEC spInsertSmiley ':beauty:', 'images/chat/beauty.png';
EXEC spInsertSmiley '(B)', 'images/chat/beer.png';
EXEC spInsertSmiley ':bomb:', 'images/chat/bomb.png';
EXEC spInsertSmiley ':bowl:', 'images/chat/bowl.png';
EXEC spInsertSmiley '(z)', 'images/chat/boy.png';
EXEC spInsertSmiley ':brb:', 'images/chat/brb.png';
EXEC spInsertSmiley ':bye:', 'images/chat/bye.png';
EXEC spInsertSmiley ':callme:', 'images/chat/call-me.png';
EXEC spInsertSmiley '(P)', 'images/chat/camera.png';
EXEC spInsertSmiley ':can:', 'images/chat/can.png';
EXEC spInsertSmiley '(au)', 'images/chat/car.png';
EXEC spInsertSmiley '(@)', 'images/chat/cat.png';
EXEC spInsertSmiley '(ci)', 'images/chat/cigarette.png';
EXEC spInsertSmiley ':chicken:', 'images/chat/chicken.png';
EXEC spInsertSmiley ':clap:', 'images/chat/clap.png';
EXEC spInsertSmiley '(O)', 'images/chat/clock.png';
EXEC spInsertSmiley '(cl)', 'images/chat/cloudy.png';
EXEC spInsertSmiley ':clover:', 'images/chat/clover.png';
EXEC spInsertSmiley ':clown:', 'images/chat/clown.png';
EXEC spInsertSmiley ':coffee:', 'images/chat/coffee.png';
EXEC spInsertSmiley '(co)', 'images/chat/computer.png';
EXEC spInsertSmiley ':console:', 'images/chat/console.png';
EXEC spInsertSmiley ':cow:', 'images/chat/cow.png';
EXEC spInsertSmiley ':S', 'images/chat/confused.png';
EXEC spInsertSmiley ':s', 'images/chat/confused.png';
EXEC spInsertSmiley ':cowboy:', 'images/chat/cowboy.png';
EXEC spInsertSmiley ':curse:', 'images/chat/curse.png';
EXEC spInsertSmiley ':cute:', 'images/chat/cute.png';
EXEC spInsertSmiley ':dance:', 'images/chat/dance.png';
EXEC spInsertSmiley ':dazed:', 'images/chat/dazed.png';
EXEC spInsertSmiley ':desire:', 'images/chat/desire.png';
EXEC spInsertSmiley '(6)', 'images/chat/devil.png';
EXEC spInsertSmiley ':doctor:', 'images/chat/doctor.png';
EXEC spInsertSmiley '(&)', 'images/chat/dog.png';
EXEC spInsertSmiley '(D)', 'images/chat/drink.png';
EXEC spInsertSmiley ':eat:', 'images/chat/eat.png';
EXEC spInsertSmiley ':$', 'images/chat/embarrassed.png';
EXEC spInsertSmiley '8-)', 'images/chat/eyeroll.png';
EXEC spInsertSmiley '(~)', 'images/chat/film.png';
EXEC spInsertSmiley '(yn)', 'images/chat/fingers-crossed.png';
EXEC spInsertSmiley '(fl)', 'images/chat/flag.png';
EXEC spInsertSmiley ':ghost:', 'images/chat/ghost.png';
EXEC spInsertSmiley '(X)', 'images/chat/girl.png';
EXEC spInsertSmiley '(H)', 'images/chat/glasses-cool.png';
EXEC spInsertSmiley ':nerd:', 'images/chat/glasses-nerdy.png';
EXEC spInsertSmiley '(bah)', 'images/chat/goat.png';
EXEC spInsertSmiley '(Y)', 'images/chat/good.png';
EXEC spInsertSmiley '(%)', 'images/chat/handcuffs.png';
EXEC spInsertSmiley '({)', 'images/chat/hug-left.png';
EXEC spInsertSmiley '(})', 'images/chat/hug-right.png';
EXEC spInsertSmiley '(K)', 'images/chat/kiss.png';
EXEC spInsertSmiley ':knife:', 'images/chat/knife.png';
EXEC spInsertSmiley ':liquor:', 'images/chat/liquor.png';
EXEC spInsertSmiley '(L)', 'images/chat/love.png';
EXEC spInsertSmiley '(l)', 'images/chat/love.png';
EXEC spInsertSmiley '(U)', 'images/chat/love-over.png';
EXEC spInsertSmiley '(u)', 'images/chat/love-over.png';
EXEC spInsertSmiley '(E)', 'images/chat/mail.png';
EXEC spInsertSmiley '(e)', 'images/chat/mail.png';
EXEC spInsertSmiley '(mp)', 'images/chat/mobile.png';
EXEC spInsertSmiley ':monkey:', 'images/chat/monkey.png';
EXEC spInsertSmiley '(S)', 'images/chat/moon.png';
EXEC spInsertSmiley '(8)', 'images/chat/musical-note.png';
EXEC spInsertSmiley ':|', 'images/chat/neutral.png';
EXEC spInsertSmiley '(T)', 'images/chat/phone.png';
EXEC spInsertSmiley '(t)', 'images/chat/phone.png';
EXEC spInsertSmiley '(pi)', 'images/chat/pizza.png';
EXEC spInsertSmiley '(pl)', 'images/chat/plate.png';
EXEC spInsertSmiley '(G)', 'images/chat/present.png';
EXEC spInsertSmiley '(g)', 'images/chat/present.png';
EXEC spInsertSmiley '(?)', 'images/chat/question.png';
EXEC spInsertSmiley '(st)', 'images/chat/rain.png';
EXEC spInsertSmiley '(R)', 'images/chat/rainbow.png';
EXEC spInsertSmiley '(F)', 'images/chat/rose.png';
EXEC spInsertSmiley '(W)', 'images/chat/rose-dead.png';
EXEC spInsertSmiley '(sn)', 'images/chat/snail.png';
EXEC spInsertSmiley '(so)', 'images/chat/soccerball.png';
EXEC spInsertSmiley '(*)', 'images/chat/star.png';
EXEC spInsertSmiley '(#)', 'images/chat/sun.png';
EXEC spInsertSmiley '(li)', 'images/chat/thunder.png';
EXEC spInsertSmiley '(tu)', 'images/chat/turtle.png';
EXEC spInsertSmiley '(tv)', 'images/chat/tv.png';
EXEC spInsertSmiley '(um)', 'images/chat/umbrella.png';
EXEC spInsertSmiley ':vampire:', 'images/chat/vampire.png';
EXEC spInsertSmiley ':yin-yang:', 'images/chat/yin-yang.png';
EXEC spInsertSmiley ':P', 'images/chat/tongue.png';
EXEC spInsertSmiley ':p', 'images/chat/tongue.png';
EXEC spInsertAbbrv 'X','Load Control','Y', 'Y';
EXEC spInsertAbbrv 'F','Read File','Y', 'Y';
EXEC spInsertAbbrv 'W','Read Website','Y', 'Y';
EXEC spInsertAbbrv 'DB','Query Database','Y', 'Y';
EXEC spInsertAbbrv 'LE','Redirect to External Link','Y', '';
EXEC spInsertAbbrv 'LI','Redirect to Internal Link','Y', '';
EXEC spInsertAbbrv 'M','Menu Box','', 'Y';
