/BlogEngine/BlogEngine.NET/setup/SQLite/SQLiteUpgradeFrom1.4.5.0To1.4.0.0.txt

# · Plain Text · 10 lines · 9 code · 1 blank · 0 comment · 0 complexity · 4f35ec5c697d6320800d281079a8593c MD5 · raw file 

    

  1. ALTER TABLE [be_Categories]

    2. 

  2. ADD [ParentID] VARCHAR(36)  NULL

    3. 

  3. 

    4. 

  4. UPDATE be_DataStoreSettings

    5. 

  5. SET Settings =

    6. 

  6. '<?xml version="1.0" encoding="utf-16"?>

    7. 

  7. <WidgetData xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

    8. 

  8.   <Settings>&lt;widgets&gt;&lt;widget id="b5310024-0259-46dc-ae5e-8514c4d0428c" title="Administration" showTitle="True"&gt;Administration&lt;/widget&gt;&lt;widget id="bc71fece-380e-4937-93cf-14b01d53d03a" title="Search" showTitle="True"&gt;Search&lt;/widget&gt;&lt;widget id="fb84735a-bff6-4670-a249-427720a58c70" title="Tag cloud" showTitle="True"&gt;Tag cloud&lt;/widget&gt;&lt;widget id="2b92a42c-90d4-4752-9eba-932b0c0bd387" title="RecentPosts" showTitle="True"&gt;RecentPosts&lt;/widget&gt;&lt;/widgets&gt;</Settings>

    9. 

  9. </WidgetData>'

    10. 

  10. WHERE ExtensionID = 'be_WIDGET_ZONE'
    11.