-
Member
Cabal tools ep2 sql codes
guys, can you help me on this. how can this code be compatible with our current sql EP8.
i had it running, only this code is not accepting on sql ver 8.
Thanks in advance.
use CabalCash;
CREATE TABLE [dbo].[WebShop](
[int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[Description] [varchar](200) COLLATE Chinese_PRC_CI_AS NOT NULL,
[ItemIdx] [int] NOT NULL,
[Options] [int] NOT NULL,
[Image] [varchar](200) COLLATE Chinese_PRC_CI_AS NOT NULL,
[Cash] [int] NULL,
[Alz] [int] NULL,
[Category] [int] NOT NULL,
[Available] [int] NOT NULL,
[TimeLimit] [int] NOT NULL,
[Total] [int] NOT NULL CONSTRAINT [DF_WebShop_Total] DEFAULT ((0)))
CREATE TABLE [dbo].[WebShop_Category](
[ID] [smallint] IDENTITY(1,1) NOT NULL,
[Category] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[Access] [smallint] NOT NULL)
-