be_packages

Jan 10, 2012 at 10:08 PM

I'm getting an error with the latest update blogengine_de25cddc85cc using sql storage due to missing tables; be_packages and be_packagefiles.   Is a script availables for these tables? 

 

Thanks

Coordinator
Jan 11, 2012 at 1:28 AM

setup/sqlserver/MSSQLUpgradeFrom2.5to2.6.sql

--
-- Create table "dbo.be_Packages"
--
CREATE TABLE dbo.be_Packages (
  [PackageId] nvarchar(128) NOT NULL,
  [Version] nvarchar(128) NOT NULL
)
GO

--
-- Create table "dbo.be_PackageFiles"
--
CREATE TABLE dbo.be_PackageFiles (
  [PackageId] nvarchar(128) NOT NULL,
  [FileOrder] int NOT NULL,
  [FilePath] nvarchar(255) NOT NULL,
  [IsDirectory] bit NOT NULL
)
GO

--
-- QuickNotes
--

CREATE TABLE [dbo].[be_QuickNotes](
	[NoteID] [uniqueidentifier] NOT NULL,
	[BlogID] [uniqueidentifier] NOT NULL,
	[UserName] [nvarchar](100) NOT NULL,
	[Note] [nvarchar](max) NOT NULL,
	[Updated] [datetime] NULL
)
GO

CREATE TABLE [dbo].[be_QuickSettings](
	[BlogID] [uniqueidentifier] NOT NULL,
	[UserName] [nvarchar](100) NOT NULL,
	[SettingName] [nvarchar](255) NOT NULL,
	[SettingValue] [nvarchar](255) NOT NULL
)
GO

CREATE NONCLUSTERED INDEX [idx_be_NoteId_BlogId_UserName] ON [dbo].[be_QuickNotes] 
(
	[NoteID] ASC,
	[BlogID] ASC,
	[UserName] ASC
)
GO