Hi,

I start to use NopCommerce from V1.0 (or early). And I use V1.4 as a basic platform and keep observing V1.8

My business target is to use it as a real eCommerce platform, not a toy. Now, it is just started.

When I setup the data, I found there are too many columns are set "Not NULL", it caused the implementation is slow. I cannot feel 'EASY' or FAST.

Just take "NOP_Category" and "NOP_Product" as examples.

CREATE TABLE [dbo].[Nop_Category](
  [CategoryID] [int] IDENTITY(1,1) NOT NULL,
  [Name] [nvarchar](400) NOT NULL,
  [Description] [ntext] NOT NULL, --> could be NULL
  [TemplateID] [int] NOT NULL,
  [MetaKeywords] [nvarchar](400) NOT NULL,    --> could be NULL
  [MetaDescription] [nvarchar](4000) NOT NULL,  --> could be NULL
  [MetaTitle] [nvarchar](400) NOT NULL, --> could be NULL
  [SEName] [nvarchar](100) NOT NULL,--> could be NULL
  [ParentCategoryID] [int] NOT NULL,
  [PictureID] [int] NOT NULL,
  [PageSize] [int] NOT NULL,
  [PriceRanges] [nvarchar](400) NOT NULL, --> could be NULL
  [Published] [bit] NOT NULL,
  [Deleted] [bit] NOT NULL,
  [DisplayOrder] [int] NOT NULL,
  [CreatedOn] [datetime] NOT NULL, --> could be NULL
  [UpdatedOn] [datetime] NOT NULL, --> could be NULL
)

ntext, nVarchar, CreatedOn, UpdatedOn, should be able to set NULL.

Thanks,
Frank Zhang@Shanghai