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