loaddata.sql

Portal Starter Kit提供了在线管理工具

-- point to proper DB 
use [~~##PRTLStarterKitDB##~~]
GO


SET DATEFORMAT mdy
GO

-- insert templated records for each module type
INSERT INTO Portal_Links (ModuleID) VALUES (0)
INSERT INTO Portal_Events (ModuleID) VALUES (0)
INSERT INTO Portal_Announcements (ModuleID) VALUES (0)
INSERT INTO Portal_Contacts (ModuleID) VALUES (0)
INSERT INTO Portal_Documents (ModuleID) VALUES (0)
INSERT INTO Portal_Discussion (ModuleID, Title, Body, DisplayOrder, CreatedByUser) VALUES (0,'','','','')

-- insert default Portal data
INSERT INTO Portal_Roles (PortalID,RoleName) VALUES (0,'Admins')
INSERT INTO Portal_Users (Name, Password, Email) VALUES ('Guest','D0-09-1A-0F-E2-B2-09-34-D8-8B-46-06-84-F5-97-89','guest')
INSERT INTO Portal_UserRoles (UserID,RoleID) VALUES (1,0)

INSERT INTO Portal_Links (ModuleID,CreatedByUser,CreatedDate,Title,Url,MobileUrl,ViewOrder,Description) VALUES (1,'[e-mail]','2001-12-20 14:41:40.840','ASP.NET Site','http://www.asp.net','',1,'')
INSERT INTO Portal_Links (ModuleID,CreatedByUser,CreatedDate,Title,Url,MobileUrl,ViewOrder,Description) VALUES (1,'[e-mail]','2001-12-20 14:41:40.840','GotDotNet.com','http://www.gotdotnet.com','',3,'')
INSERT INTO Portal_Links (ModuleID,CreatedByUser,CreatedDate,Title,Url,MobileUrl,ViewOrder,Description) VALUES (1,'[e-mail]','2001-12-20 14:41:40.840','ASP.NET on MSDN','http://msdn.microsoft.com/net/aspnet','',5,'')
INSERT INTO Portal_Links (ModuleID,CreatedByUser,CreatedDate,Title,Url,MobileUrl,ViewOrder,Description) VALUES (1,'[e-mail]','2001-12-20 14:41:40.840','QuickStart Samples','http://www.gotdotnet.com/quickstart/aspplus','',7,'')
INSERT INTO Portal_Links (ModuleID,CreatedByUser,CreatedDate,Title,Url,MobileUrl,ViewOrder,Description) VALUES (16,'[e-mail]','2001-12-20 14:41:40.840','SpyWorld','http://www.SpyWorld.com','',1,'')
INSERT INTO Portal_Links (ModuleID,CreatedByUser,CreatedDate,Title,Url,MobileUrl,ViewOrder,Description) VALUES (16,'[e-mail]','2001-12-20 14:41:40.840','SpyGear4U','http://www.SpyGear4U.com','',3,'')
INSERT INTO Portal_Links (ModuleID,CreatedByUser,CreatedDate,Title,Url,MobileUrl,ViewOrder,Description) VALUES (16,'[e-mail]','2001-12-20 14:41:40.840','GlobalSpy','http://www.GlobalSpy.com','',5,'')
INSERT INTO Portal_Links (ModuleID,CreatedByUser,CreatedDate,Title,Url,MobileUrl,ViewOrder,Description) VALUES (16,'[e-mail]','2001-12-20 14:41:40.840','SpyProducts','http://www.SpyProducts.com','',7,'')
INSERT INTO Portal_Links (ModuleID,CreatedByUser,CreatedDate,Title,Url,MobileUrl,ViewOrder,Description) VALUES (21,'[e-mail]','2001-12-20 14:41:40.840','ASP.NET Site','http://www.asp.net','',1,'')
INSERT INTO Portal_Links (ModuleID,CreatedByUser,CreatedDate,Title,Url,MobileUrl,ViewOrder,Description) VALUES (21,'[e-mail]','2001-12-20 14:41:40.840','GotDotNet.com','http://www.gotdotnet.com','',3,'')
INSERT INTO Portal_Links (ModuleID,CreatedByUser,CreatedDate,Title,Url,MobileUrl,ViewOrder,Description) VALUES (21,'[e-mail]','2001-12-20 14:41:40.840','ASP.NET on MSDN','http://msdn.microsoft.com/net/aspnet','',5,'')
INSERT INTO Portal_Links (ModuleID,CreatedByUser,CreatedDate,Title,Url,MobileUrl,ViewOrder,Description) VALUES (21,'[e-mail]','2001-12-20 14:41:40.840','QuickStart Samples','http://www.gotdotnet.com/quickstart/aspplus','',7,'')

INSERT INTO Portal_Events (ModuleID,CreatedByUser,CreatedDate,Title,ExpireDate,Description,WhereWhen) VALUES (4,'[e-mail]','2001-12-19 15:46:25.053','Spy-o-Rama','2005-12-31 00:00:00','It''s back!  The premier regional swap meet for spy paraphernalia of every description.  Shop early for some amazing bargins.', 'This Saturday, usual secret time and place...')
INSERT INTO Portal_Events (ModuleID,CreatedByUser,CreatedDate,Title,ExpireDate,Description,WhereWhen) VALUES (4,'[e-mail]','2001-12-19 15:48:22.813','Dark Ops Sock Hop','2005-12-31 00:00:00','Back by popular demand!  Practice your surveillance of the opposite sex, and dance some too.  Great opportunity for a brush pass!', 'Saturday, 8pm to ?, Dark Ops Cafe')

INSERT INTO Portal_Announcements (ModuleID,CreatedByUser,CreatedDate,Title,MoreLink,MobileMoreLink,ExpireDate,Description) VALUES (8,'[e-mail]','2001-12-19 15:46:25.053','Open Enrollment and Payroll Checklist','~/admin/notimplemented.aspx?title=Open%20Enrollment%20and%20Payroll%20Checklist','','2005-12-31 00:00:00','Please take a few moments to review this year-end checklist that will guide you through the Benefits Open Enrollment process and instruct you on how to ensure your payroll information is accurate for 2001.')
INSERT INTO Portal_Announcements (ModuleID,CreatedByUser,CreatedDate,Title,MoreLink,MobileMoreLink,ExpireDate,Description) VALUES (8,'[e-mail]','2001-12-19 15:49:05.603','Selecting Your Primary Care Provider','~/admin/notimplemented.aspx?title=Selecting%20Your%20Primary%20Care%20Provider','','2005-12-31 00:00:00','Learn how to find the Primary Care Provider (PCP) that best suits your needs with this list of things to think about and questions to ask yourself and your potential PCP.')
INSERT INTO Portal_Announcements (ModuleID,CreatedByUser,CreatedDate,Title,MoreLink,MobileMoreLink,ExpireDate,Description) VALUES (3,'[e-mail]','2002-01-10 11:17:52.903','Q4 Sales Rise 200% Over Last Year','~/admin/notimplemented.aspx?title=Q4%20Sales%20Rise%20200%%20Over%20Last%20Year','','2005-12-31 00:00:00','IBuySpy.com online sales for the crucial fourth quarter of last year rose nearly 200% over the previous year, despite a lackluster holiday sales overall. ')
INSERT INTO Portal_Announcements (ModuleID,CreatedByUser,CreatedDate,Title,MoreLink,MobileMoreLink,ExpireDate,Description) VALUES (13,'[e-mail]','2002-01-10 06:09:11.117','Envelope X-Ray Spray','http://www.spyworld.net/Surveil3.htm','','2005-12-31 00:00:00','Envelope X-RAY Spray turns opaque paper temporarily translucent, allowing the user to view the contents of an envelope without ever opening it. SpyWorld, $42.95.')
INSERT INTO Portal_Announcements (ModuleID,CreatedByUser,CreatedDate,Title,MoreLink,MobileMoreLink,ExpireDate,Description) VALUES (13,'[e-mail]','2002-01-10 06:19:35.883','Wrist Watch Video Camera','http://www.spyworld.net/Surveil1.htm','','2005-12-31 00:00:00','This is not a device from a James bond movie, but a real, sophisticated video camera disguised as a watch.  SpyWorld, $489.95.')
INSERT INTO Portal_Announcements (ModuleID,CreatedByUser,CreatedDate,Title,MoreLink,MobileMoreLink,ExpireDate,Description) VALUES (13,'[e-mail]','2002-01-10 10:43:59.150','Bionic Ear','http://www.spyworld.net/Surveil3.htm','','2005-12-31 00:00:00','Zoom in on a whisper at up to 100 yards away, door shutting at 4 blocks, dog barking up to 2 miles away.  SpyWorld, $198.95.')
INSERT INTO Portal_Announcements (ModuleID,CreatedByUser,CreatedDate,Title,MoreLink,MobileMoreLink,ExpireDate,Description) VALUES (13,'[e-mail]','2002-01-10 10:44:18.217','CAMCopter','http://www.spyworld.com/camcopter.htm','','2005-12-31 00:00:00','The CAMCopter is a remotely controlled, autonomous Aerial Vehicle System developed under military specifications design to carry various sensors that transmit data and live video.  SpyWorld, $490,000.00.')
INSERT INTO Portal_Announcements (ModuleID,CreatedByUser,CreatedDate,Title,MoreLink,MobileMoreLink,ExpireDate,Description) VALUES (12,'[e-mail]','2002-01-10 07:01:58.280','Ultraviolet Pen','http://www.spyproducts.com/Theftpowders1.html','','2005-12-31 00:00:00','This felt-tipped pen is an inexpensive and convenient ultraviolet writing instrument.  SpyProducts, $6.95.')
INSERT INTO Portal_Announcements (ModuleID,CreatedByUser,CreatedDate,Title,MoreLink,MobileMoreLink,ExpireDate,Description) VALUES (12,'[e-mail]','2002-01-10 07:06:09.160','Micro Bug Detector ','http://www.spygear4u.com/hi_tech.htm','','2005-12-31 00:00:00','Covert bug detection probe for room sweeping include a vibration mode.  SpyGear4U, $399.00.')
INSERT INTO Portal_Announcements (ModuleID,CreatedByUser,CreatedDate,Title,MoreLink,MobileMoreLink,ExpireDate,Description) VALUES (12,'[e-mail]','2002-01-10 07:09:51.920','Telephone Voice Changer','http://www.firstlineindustries.com/telvoicchani.html','','2005-12-31 00:00:00','Answer the telephone without anyone recognizing your voice.  FirstLine, $42.95.')
INSERT INTO Portal_Announcements (ModuleID,CreatedByUser,CreatedDate,Title,MoreLink,MobileMoreLink,ExpireDate,Description) VALUES (14,'[e-mail]','2002-01-10 06:57:28.190','Air Taser','http://www.spyworld.com/3005.htm','','2005-12-31 00:00:00','Uses compressed air to shoot two small probes up to 15 feet.  These probes are connected by wire to the launcher, which sends a powerful electric signal into the nervous system of an assailant.  SpyWorld, $285.95.')

INSERT INTO Portal_Contacts (ModuleID,CreatedByUser,CreatedDate,Name,Role,Email,Contact1,Contact2) VALUES (9,'[e-mail]','2001-12-20 12:58:58.250','JennaJ','Program Lead','[e-mail]','home: 206-555-4434','mobile: [phone]')
INSERT INTO Portal_Contacts (ModuleID,CreatedByUser,CreatedDate,Name,Role,Email,Contact1,Contact2) VALUES (9,'[e-mail]','2001-12-20 13:00:19.057','ManishG','Technical Lead','[e-mail]','home: 425-555-9008','mobile: [phone]')
INSERT INTO Portal_Contacts (ModuleID,CreatedByUser,CreatedDate,Name,Role,Email,Contact1,Contact2) VALUES (9,'[e-mail]','2001-12-20 13:03:55.657','BrettH','Development Lead','[e-mail]','home: 206-555-5580','mobile: [phone]')
INSERT INTO Portal_Contacts (ModuleID,CreatedByUser,CreatedDate,Name,Role,Email,Contact1,Contact2) VALUES (9,'[e-mail]','2001-12-20 14:07:31.290','MaryK','Test Lead','[e-mail]','home: 206-555-7729','mobile: [phone]')
INSERT INTO Portal_Contacts (ModuleID,CreatedByUser,CreatedDate,Name,Role,Email,Contact1,Contact2) VALUES (9,'[e-mail]','2001-12-20 14:07:44.470','RajivP','Fullfillment Lead','[e-mail]','home: 425-555-7787','mobile: [phone]')
INSERT INTO Portal_Contacts (ModuleID,CreatedByUser,CreatedDate,Name,Role,Email,Contact1,Contact2) VALUES (9,'[e-mail]','2001-12-20 13:02:54.730','TomVZ','Secret Agent','[e-mail]','shoe phone: [phone]','fountain pen: 206-555-9985')

INSERT INTO Portal_Discussion (ModuleID,Title,CreatedDate,Body,DisplayOrder,CreatedByUser) VALUES (19,'Edible Tape Puttanesca','2001-12-20 14:10:36','Had this last night in the Dark Ops Cafe and -- WOW -- is it good!  Red sauce with olives, capers and anchovies.','2001-12-20 14:10:36.317','[e-mail]')
INSERT INTO Portal_Discussion (ModuleID,Title,CreatedDate,Body,DisplayOrder,CreatedByUser) VALUES (19,'Re: Edible Tape Puttanesca','2001-12-20 14:11:59','Their Edible Tape Carbonara is terrific too.  I think they add number two pencil shavings.','2001-12-20 14:10:36.3172001-12-20 14:11:59.090','[e-mail]')
INSERT INTO Portal_Discussion (ModuleID,Title,CreatedDate,Body,DisplayOrder,CreatedByUser) VALUES (19,'Help - need a Survival Bar recipe','2001-12-20 14:25:41','My wife''s boss is coming for dinner this week and we wanted to serve survival bar.  Anybody have a favorite recipe?','2001-12-20 14:25:41.333','[e-mail]')
INSERT INTO Portal_Discussion (ModuleID,Title,CreatedDate,Body,DisplayOrder,CreatedByUser) VALUES (19,'Re: Help - need a Survival Bar recipe','2001-12-20 14:26:53','I saute it with some garlic and onions in butter and white wine.  When it softens up (about an hour), I finish the dish with a little lemon and pine nuts, and serve over edible tape.  Yum!','2001-12-20 14:25:41.3332001-12-20 14:26:53.180','[e-mail]')
INSERT INTO Portal_Discussion (ModuleID,Title,CreatedDate,Body,DisplayOrder,CreatedByUser) VALUES (19,'Re: Help - need a Survival Bar recipe','2001-12-20 14:28:18','Survival bar can be pretty chewy, so I throw it in the pressure cooker for about a half hour with onions, carrots, celery and a bay leaf.','2001-12-20 14:25:41.3332001-12-20 14:28:18.367','[e-mail]')
INSERT INTO Portal_Discussion (ModuleID,Title,CreatedDate,Body,DisplayOrder,CreatedByUser) VALUES (19,'Re: Help - need a Survival Bar recipe','2001-12-20 14:29:25','There''s just one thing that can improve a survival bar: Ketchup ;)','2001-12-20 14:25:41.3332001-12-20 14:28:18.3672001-12-20 14:29:25.987','[e-mail]')
INSERT INTO Portal_Discussion (ModuleID,Title,CreatedDate,Body,DisplayOrder,CreatedByUser) VALUES (19,'Eat my shoelaces','2001-12-20 14:30:44','I just tried the new Glow in the Dark Shoelaces and they are *yummy*!  Even better with ketchup...','2001-12-20 14:30:44.013','[e-mail]')
INSERT INTO Portal_Discussion (ModuleID,Title,CreatedDate,Body,DisplayOrder,CreatedByUser) VALUES (18,'What''s the best dead drop mark?','2001-01-08 08:06:52','I know this is a total newbie question, but how do I mark a dead drop?  What''s the best mark?','2001-01-08 08:06:51.607','[e-mail]')
INSERT INTO Portal_Discussion (ModuleID,Title,CreatedDate,Body,DisplayOrder,CreatedByUser) VALUES (18,'Re: What''s the best dead drop mark?','2001-01-08 08:07:59','I just use chalk.  It''s fast, writes on just about anything, and doesn''t stick around long enough to get noticed.','2001-01-08 08:06:51.6072001-01-08 08:07:59.177','[e-mail]')
INSERT INTO Portal_Discussion (ModuleID,Title,CreatedDate,Body,DisplayOrder,CreatedByUser) VALUES (18,'Re: What''s the best dead drop mark?','2001-01-09 08:15:33','I use chalk too -- it''s really easy to erase.','2001-01-08 08:06:51.6072001-01-08 08:07:59.1772001-01-09 08:15:32.970','[e-mail]')
INSERT INTO Portal_Discussion (ModuleID,Title,CreatedDate,Body,DisplayOrder,CreatedByUser) VALUES (18,'Re: What''s the best dead drop mark?','2001-01-09 08:14:57','There are several things to consider in making your mark: it has to made (and later erased) quickly and discretely, durable enough to stick around until it''s read, easily ignored by passers by, and not missed when it''s gone.  Lots of folks like chalk, but I find it washes away too easily in rainy weather.  Chewing gum (already chewed) works great, but you''ll want to place it well below eye level lest some zealous maintenance worker cleans it off before it has done the job.','2001-01-08 08:06:51.6072001-01-09 08:14:57.357','[e-mail]')
INSERT INTO Portal_Discussion (ModuleID,Title,CreatedDate,Body,DisplayOrder,CreatedByUser) VALUES (18,'Best night vision gear for nocturnal paint ball?','2001-01-10 08:27:17','We''re going to start playing paint ball at night, and I''m looking for recommendations.  What night vision gear is best for this?','2001-01-10 08:27:17.640','[e-mail]')
INSERT INTO Portal_Discussion (ModuleID,Title,CreatedDate,Body,DisplayOrder,CreatedByUser) VALUES (18,'Re: Best night vision gear for nocturnal paint ball?','2001-01-10 08:34:34','Well, you definitely want to use the goggle type since you''ll want your hands free (btw, I think you are crazy to play paintball at night).  The Viper 2 (<a href=''http://www.spyworld.com/Viper2.htm''>http://www.spyworld.com/Viper2.htm</a>) is pretty comfortable and not too pricey ($550, vs the thousands you pay for the military versions).  It has a built-in IR illuminator, which is a ''must have'' in your application.  Best of all, it will make you look just like a Borg... :)','2001-01-10 08:27:17.6402001-01-10 08:34:34.810','[e-mail]')
INSERT INTO Portal_Discussion (ModuleID,Title,CreatedDate,Body,DisplayOrder,CreatedByUser) VALUES (18,'Foreign language terms for ''mole''?','2001-01-11 08:49:58','Anyone know where I can find this?','2001-01-10 08:49:57.503','[e-mail]')
INSERT INTO Portal_Discussion (ModuleID,Title,CreatedDate,Body,DisplayOrder,CreatedByUser) VALUES (18,'Re: Foreign language terms for ''mole''?','2001-01-11 08:53:56','There''s a great dictionary for intelligence terms both in English and the languages of the other major intelligence agencies: <i>The CIA Insider''s Dictionary of US and Foreign Intelligence, Counterintelligence & Tradecraft</i>.  Last time I looked Amazon offered it, but was out of stock.  Let me know if you want to borrow my copy.','2001-01-10 08:49:57.5032001-01-10 08:53:55.600','[e-mail]')
INSERT INTO Portal_Discussion (ModuleID,Title,CreatedDate,Body,DisplayOrder,CreatedByUser) VALUES (18,'AMT Mini Night Vision Monocular','2001-01-12 09:16:00','Has anyone tried this yet?  It looks really good: tiny (9.5 oz), built-in IR illumination.  The only downside I see is that it seems to be limited to 1.5x magnification.','2001-01-12 09:15:59.640','[e-mail]')

INSERT INTO Portal_Documents (ModuleID,CreatedByUser,CreatedDate,FileNameUrl,FileFriendlyName,Category) VALUES (10,'[e-mail]','2001-12-20 12:35:01.883','~/uploads/sample.doc','Employee Handbook','New Employee Info')
INSERT INTO Portal_Documents (ModuleID,CreatedByUser,CreatedDate,FileNameUrl,FileFriendlyName,Category) VALUES (10,'[e-mail]','2001-12-20 12:37:54.503','~/uploads/sample.doc','Annual Reviews','New Employee Info')
INSERT INTO Portal_Documents (ModuleID,CreatedByUser,CreatedDate,FileNameUrl,FileFriendlyName,Category) VALUES (10,'[e-mail]','2001-12-20 12:39:09.890','~/uploads/sample.doc','Vacation Policy','New Employee Info')
INSERT INTO Portal_Documents (ModuleID,CreatedByUser,CreatedDate,FileNameUrl,FileFriendlyName,Category) VALUES (20,'[e-mail]','2001-12-20 12:35:01.883','~/uploads/sample.doc','Secret Diary of a Field Operative','Dossiers')
INSERT INTO Portal_Documents (ModuleID,CreatedByUser,CreatedDate,FileNameUrl,FileFriendlyName,Category) VALUES (20,'[e-mail]','2001-12-20 12:37:54.503','~/uploads/sample.doc','Toaster Boat Users Guide','Documentation')
INSERT INTO Portal_Documents (ModuleID,CreatedByUser,CreatedDate,FileNameUrl,FileFriendlyName,Category) VALUES (20,'[e-mail]','2001-12-20 12:39:09.890','~/uploads/sample.doc','Mistranslated: Translator Moustache Meets Interpreter Earrings','Spy Humor')
INSERT INTO Portal_Documents (ModuleID,CreatedByUser,CreatedDate,FileNameUrl,FileFriendlyName,Category) VALUES (20,'[e-mail]','2001-12-20 12:35:01.883','~/uploads/sample.doc','The Edible Tape Recipe Book','Documentation')

INSERT INTO Portal_HtmlText (ModuleID,DesktopHtml,MobileSummary,MobileDetails) VALUES (2,'&lt;table cellSpacing=&quot;0&quot; cellPadding=&quot;5&quot; border=&quot;0&quot;&gt;
    &lt;tr valign=&quot;top&quot;&gt;
        &lt;td&gt;
            &lt;a target=&quot;_blank&quot; href=&quot;http://www.ibuyspy.com&quot;&gt;
                &lt;img src=&quot;data/logoneg.gif&quot; border=&quot;0&quot; align=&quot;left&quot; hspace=&quot;10&quot;&gt;
            &lt;/a&gt;
        &lt;/td&gt;
        &lt;td class=&quot;Normal&quot; width=&quot;100%&quot;&gt;
            The &lt;b&gt;Portal Starter Kit&lt;/b&gt; has everything you need and is flexible enough to serve as the hub application for an enterprises internal operations or as an internet portal. It provides online news and information sharing, event and sales information, interactive discussion forums and employee contact information. In a nutshell, the Portal Starter Kit has everything needed to maintain and run a fast-growing commercial enterprise.
            &lt;br&gt;
            &lt;br&gt;
            Feel free to browse the site and explore. Sign in to obtain access to different modules within the framework, as well as view the restricted sections of the site.
        &lt;/td&gt;
    &lt;/tr&gt;
&lt;/table&gt;','Welcome to the &lt;b&gt;Portal Starter Kit&lt;/b&gt;, the Intranet Home for corporate employees or as your personal portal.','This site can serve as the hub application for an enterprises internal operations.  It provides online news, event and sales information, along with interactive discussion forums and employee contact information.  In a nutshell, everything needed to maintain and run a fast-growing commercial enterprise.  Feel free to browse the site and explore.  

&lt;br&gt;&lt;br&gt;Sign in with a desktop browser to obtain edit access to different modules within the framework, as well as view the restricted sections of the site.
')
INSERT INTO Portal_HtmlText (ModuleID,DesktopHtml,MobileSummary,MobileDetails) VALUES (5,'&lt;span class=&quot;Normal&quot;&gt;
The QLT2112 &lt;a href=&quot;http://www.ibuyspy.com/store/ProductDetails.aspx?productID=399&quot;&gt;&lt;b&gt;Document Transportation System&lt;/b&gt;&lt;/a&gt; is on special this week to clear an overstock.  Purchasers of the P38 &lt;a href=&quot;http://www.ibuyspy.com/store/ProductDetails.aspx?productID=357&quot;&gt;Escape Vehicle (Air)&lt;/a&gt; receive one free.
&lt;p&gt;
&lt;img align=&quot;left&quot; src=&quot;data/qlt2112.gif&quot;&gt;
&lt;/p&gt;
&lt;/span&gt;
','The QLT2112 &lt;a href=&quot;http://www.ibuyspy.com/store&quot;&gt;&lt;b&gt;Document Transportation System&lt;/b&gt;&lt;/a&gt; is on special this week to clear an overstock.','The QLT2112 &lt;a href=&quot;http://www.ibuyspy.com/store/ProductDetails.aspx?productID=399&quot;&gt;&lt;b&gt;Document Transportation System&lt;/b&gt;&lt;/a&gt; is on special this week to clear an overstock.  Purchasers of the P38 &lt;a href=&quot;http://www.ibuyspy.com/store/ProductDetails.aspx?productID=357&quot;&gt;Escape Vehicle (Air)&lt;/a&gt; receive one free.')
INSERT INTO Portal_HtmlText (ModuleID,DesktopHtml,MobileSummary,MobileDetails) VALUES (7,'&lt;span class=&quot;Normal&quot;&gt;
&lt;img align=&quot;right&quot; hspace=&quot;0&quot; src=&quot;data/hart.gif&quot;&gt;
&lt;p&gt;&lt;b&gt;Nancy Hart&lt;/b&gt; served as a scout, guide and spy for the Confederate army, carrying messages between the Southern Armies. She hung around isolated Federal outposts, acting as a peddlar, to report their strength, population and vulnerability to General Jackson. Nancy was twenty years old when she was captured by the Yankees and jailed in a dilapidated house with guards constantly patrolling the building. Nancy gained the trust of one of her guards, got his weapon from him, shot him and escaped.&lt;/p&gt;
&lt;/span&gt;
','','')
INSERT INTO Portal_HtmlText (ModuleID,DesktopHtml,MobileSummary,MobileDetails) VALUES (11,'&lt;table cellspacing=&quot;0&quot; cellpadding=&quot;0&quot; border=&quot;0&quot;&gt;
    &lt;tr&gt;
        &lt;td class=&quot;Normal&quot;&gt;
            &lt;img src=&quot;data/enigma.gif&quot;&gt;
        &lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
        &lt;td class=&quot;Normal&quot;&gt;
            &lt;br&gt;The WWII &lt;b&gt;Enigma&lt;/b&gt; cypher was based on a system of three rotors that substituted cipher text letters for plain text letters. The innovation that made Enigma machine so powerful was the spinning of its rotors. As the plain text letter passed through the first rotor, the first rotor would rotate one position. The other two rotors would remain stationary until the first rotor had rotated 26 times. Then the second rotor would rotate one position. After the second rotor had rotated 26 times, the third rotor would rotate one position.  As a result, an ''s'' could be encoded as a ''b'' in the first part of the message, and then as an ''m'' later in the same message.  
        &lt;/td&gt;
    &lt;/tr&gt;
&lt;/table&gt;
','','')
INSERT INTO Portal_HtmlText (ModuleID,DesktopHtml,MobileSummary,MobileDetails) VALUES (17,'&lt;span class=&quot;Normal&quot;&gt;
    &lt;img align=&quot;right&quot; hspace=&quot;0&quot; src=&quot;data/vanlew.gif&quot;&gt;
    &lt;p&gt;
        &lt;b&gt;Elizabeth Van Lew&lt;/b&gt; asked to be allowed to visit Union prisoners held by the Confederates in Richmond and began taking them food and medicines. She realized that many of the prisoners had been marched through Confederate lines on their way to Richmond and were full of useful information about Confederate movements. She became a spy for the North for the next four years, setting up a network of couriers, and devising a code. For her efforts during the Civil War, Elizabeth Van Lew was made Postmaster of Richmond by General Grant. 
    &lt;/p&gt;
&lt;/span&gt;
','','')
INSERT INTO Portal_HtmlText (ModuleID,DesktopHtml,MobileSummary,MobileDetails) VALUES (22,'&lt;table cellspacing=0 cellpadding=0 border=0&gt;
    &lt;tr&gt;
        &lt;td class=Normal width=&quot;100%&quot;&gt;
            The &lt;b&gt;ASP.NET Portal Starter Kit&lt;/b&gt; demonstrates how you can use ASP.NET and the .NET Framework to build either an intranet or Internet portal application. The &lt;b&gt;Portal Starter Kit&lt;/b&gt; offers all the functionality of typical portal applications, including:&lt;br&gt;&lt;br&gt;

            &lt;table cellspacing=0 cellpadding=0 border=0&gt;
                &lt;tr valign=&quot;top&quot;&gt;
                    &lt;td width=&quot;140&quot;&gt;
                        &lt;image src=&quot;data/sample.gif&quot;&gt;
                    &lt;/td&gt;
                    &lt;td&gt;&amp;nbsp;&lt;/td&gt;
                    &lt;td class=&quot;Normal&quot; width=&quot;*&quot;&gt;

                        &lt;ul&gt;
                            &lt;li&gt;
                            &lt;a href=&quot;#basicmod&quot;&gt;10 basic portal modules&lt;/a&gt; for common types of content
                            &lt;li&gt;
                            &lt;a href=&quot;#custommod&quot;&gt;Custom portal modules&lt;/a&gt; based on a &quot;pluggable&quot; framework that is simple to extend
                            &lt;li&gt;
                            &lt;a href=&quot;#admintool&quot;&gt;Online administration&lt;/a&gt; of portal layout, content and security
                            &lt;li&gt;
                            &lt;a href=&quot;#security&quot;&gt;Roles-based security&lt;/a&gt; for viewing content, editing content, and administering 
                            the portal
                            &lt;/li&gt;
                        &lt;/ul&gt;


                        All code contained in the Portal Starter Kit download package is free for use
                in your own applications.  But if you prefer, you may customize the portal for your own use without writing a line of code.  The portal includes built-in Administration pages for setting up your portal, adding content, and setting security options.&lt;br&gt;
                    &lt;/td&gt;
                &lt;/tr&gt;
                &lt;tr valign=&quot;top&quot;&gt;