Cabal tools ep2 sql codes

Results 1 to 1 of 1
  1. #1
    Member jcdgreatest is offline
    MemberRank
    Feb 2012 Join Date
    93Posts

    talk 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)




Advertisement