USE [master]
GO
/****** Object:  Database [Database_ECOM1]    Script Date: 1/28/2014 9:59:36 AM ******/
CREATE DATABASE [Database_ECOM1]
 CONTAINMENT = NONE
 ON  PRIMARY 
( NAME = N'Database_ECOM1_Data', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\Database_ECOM1_Data.mdf' , SIZE = 2376256KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
 LOG ON 
( NAME = N'Database_ECOM1_Log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\Database_ECOM1_Log.ldf' , SIZE = 6144KB , MAXSIZE = 2048GB , FILEGROWTH = 1024KB )
GO
ALTER DATABASE [Database_ECOM1] SET COMPATIBILITY_LEVEL = 110
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [Database_ECOM1].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [Database_ECOM1] SET ANSI_NULL_DEFAULT OFF 
GO
ALTER DATABASE [Database_ECOM1] SET ANSI_NULLS OFF 
GO
ALTER DATABASE [Database_ECOM1] SET ANSI_PADDING OFF 
GO
ALTER DATABASE [Database_ECOM1] SET ANSI_WARNINGS OFF 
GO
ALTER DATABASE [Database_ECOM1] SET ARITHABORT OFF 
GO
ALTER DATABASE [Database_ECOM1] SET AUTO_CLOSE ON 
GO
ALTER DATABASE [Database_ECOM1] SET AUTO_CREATE_STATISTICS ON 
GO
ALTER DATABASE [Database_ECOM1] SET AUTO_SHRINK OFF 
GO
ALTER DATABASE [Database_ECOM1] SET AUTO_UPDATE_STATISTICS ON 
GO
ALTER DATABASE [Database_ECOM1] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO
ALTER DATABASE [Database_ECOM1] SET CURSOR_DEFAULT  GLOBAL 
GO
ALTER DATABASE [Database_ECOM1] SET CONCAT_NULL_YIELDS_NULL OFF 
GO
ALTER DATABASE [Database_ECOM1] SET NUMERIC_ROUNDABORT OFF 
GO
ALTER DATABASE [Database_ECOM1] SET QUOTED_IDENTIFIER OFF 
GO
ALTER DATABASE [Database_ECOM1] SET RECURSIVE_TRIGGERS OFF 
GO
ALTER DATABASE [Database_ECOM1] SET  ENABLE_BROKER 
GO
ALTER DATABASE [Database_ECOM1] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO
ALTER DATABASE [Database_ECOM1] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO
ALTER DATABASE [Database_ECOM1] SET TRUSTWORTHY OFF 
GO
ALTER DATABASE [Database_ECOM1] SET ALLOW_SNAPSHOT_ISOLATION OFF 
GO
ALTER DATABASE [Database_ECOM1] SET PARAMETERIZATION SIMPLE 
GO
ALTER DATABASE [Database_ECOM1] SET READ_COMMITTED_SNAPSHOT OFF 
GO
ALTER DATABASE [Database_ECOM1] SET HONOR_BROKER_PRIORITY OFF 
GO
ALTER DATABASE [Database_ECOM1] SET RECOVERY SIMPLE 
GO
ALTER DATABASE [Database_ECOM1] SET  MULTI_USER 
GO
ALTER DATABASE [Database_ECOM1] SET PAGE_VERIFY CHECKSUM  
GO
ALTER DATABASE [Database_ECOM1] SET DB_CHAINING OFF 
GO
ALTER DATABASE [Database_ECOM1] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) 
GO
ALTER DATABASE [Database_ECOM1] SET TARGET_RECOVERY_TIME = 0 SECONDS 
GO
USE [Database_ECOM1]
GO
/****** Object:  Table [dbo].[JPA_GENERATED_KEYS]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[JPA_GENERATED_KEYS](
	[ID] [nvarchar](30) NOT NULL,
	[LAST_VALUE] [bigint] NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sysdiagrams]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[sysdiagrams](
	[name] [nvarchar](128) NOT NULL,
	[principal_id] [int] NOT NULL,
	[diagram_id] [int] NOT NULL,
	[version] [int] NULL,
	[definition] [varbinary](max) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[TADDRESS]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TADDRESS](
	[UIDPK] [bigint] NOT NULL,
	[LAST_NAME] [nvarchar](100) NULL,
	[FIRST_NAME] [nvarchar](100) NULL,
	[PHONE_NUMBER] [nvarchar](50) NULL,
	[FAX_NUMBER] [nvarchar](50) NULL,
	[STREET_1] [nvarchar](200) NULL,
	[STREET_2] [nvarchar](200) NULL,
	[CITY] [nvarchar](200) NULL,
	[SUB_COUNTRY] [nvarchar](200) NULL,
	[ZIP_POSTAL_CODE] [nvarchar](50) NULL,
	[COUNTRY] [nvarchar](200) NULL,
	[COMMERCIAL] [int] NULL,
	[GUID] [nvarchar](64) NOT NULL,
	[CUSTOMER_UID] [bigint] NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TADVANCEDSEARCHQUERY]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TADVANCEDSEARCHQUERY](
	[UIDPK] [bigint] NOT NULL,
	[QUERY_ID] [bigint] NOT NULL,
	[NAME] [nvarchar](255) NOT NULL,
	[DESCRIPTION] [ntext] NULL,
	[QUERY_VISIBILITY] [nvarchar](20) NOT NULL,
	[OWNER_ID] [bigint] NULL,
	[QUERY_TYPE] [nvarchar](20) NOT NULL,
	[QUERY_CONTENT] [ntext] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TAPPLIEDRULE]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TAPPLIEDRULE](
	[UIDPK] [bigint] NOT NULL,
	[ORDER_UID] [bigint] NOT NULL,
	[RULE_UID] [bigint] NOT NULL,
	[RULE_NAME] [nvarchar](255) NOT NULL,
	[RULE_CODE] [ntext] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TAPPLIEDRULECOUPONCODE]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TAPPLIEDRULECOUPONCODE](
	[UIDPK] [bigint] NOT NULL,
	[APPLIED_RULE_UID] [bigint] NOT NULL,
	[COUPONCODE] [nvarchar](255) NOT NULL,
	[USECOUNT] [int] NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TATTRIBUTE]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TATTRIBUTE](
	[UIDPK] [bigint] NOT NULL,
	[ATTRIBUTE_KEY] [nvarchar](255) NOT NULL,
	[LOCALE_DEPENDANT] [int] NOT NULL,
	[ATTRIBUTE_TYPE] [int] NOT NULL,
	[NAME] [nvarchar](255) NOT NULL,
	[REQUIRED] [int] NULL,
	[VALUE_LOOKUP_ENABLED] [int] NULL,
	[MULTI_VALUE_ENABLED] [int] NULL,
	[ATTRIBUTE_USAGE] [int] NOT NULL,
	[SYSTEM] [int] NULL,
	[CATALOG_UID] [bigint] NULL,
	[ATTR_GLOBAL] [int] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TBASEAMOUNT]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TBASEAMOUNT](
	[UIDPK] [bigint] NOT NULL,
	[GUID] [nvarchar](64) NOT NULL,
	[OBJECT_GUID] [nvarchar](64) NOT NULL,
	[OBJECT_TYPE] [nvarchar](100) NOT NULL,
	[QUANTITY] [decimal](19, 2) NOT NULL,
	[LIST] [decimal](19, 2) NULL,
	[SALE] [decimal](19, 2) NULL,
	[PRICE_LIST_GUID] [nvarchar](64) NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TBRAND]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TBRAND](
	[UIDPK] [bigint] NOT NULL,
	[CODE] [nvarchar](255) NOT NULL,
	[IMAGE_URL] [nvarchar](255) NULL,
	[CATALOG_UID] [bigint] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TBUNDLECONSTITUENTX]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TBUNDLECONSTITUENTX](
	[UIDPK] [bigint] NOT NULL,
	[GUID] [nvarchar](64) NOT NULL,
	[BUNDLE_UID] [bigint] NOT NULL,
	[CONSTITUENT_UID] [bigint] NOT NULL,
	[QUANTITY] [int] NOT NULL,
	[ORDERING] [int] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TBUNDLESELECTIONRULE]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TBUNDLESELECTIONRULE](
	[UIDPK] [bigint] NOT NULL,
	[GUID] [nvarchar](64) NOT NULL,
	[PARAMETER] [int] NOT NULL,
	[BUNDLE_UID] [bigint] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TCARTITEM]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCARTITEM](
	[UIDPK] [bigint] NOT NULL,
	[GUID] [nvarchar](64) NOT NULL,
	[SKU_UID] [bigint] NOT NULL,
	[QUANTITY] [int] NOT NULL,
	[CURRENCY] [nvarchar](3) NULL,
	[LIST_UNIT_PRICE] [decimal](19, 2) NULL,
	[SALE_UNIT_PRICE] [decimal](19, 2) NULL,
	[PROMO_UNIT_PRICE] [decimal](19, 2) NULL,
	[DISCOUNT_AMOUNT] [decimal](19, 2) NULL,
	[TAX_AMOUNT] [decimal](19, 2) NULL,
	[SHOPPING_CART_UID] [bigint] NULL,
	[PARENT_ITEM_UID] [bigint] NULL,
	[LAST_MODIFIED_DATE] [datetime] NOT NULL,
	[ORDERING] [int] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TCATALOG]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCATALOG](
	[UIDPK] [bigint] NOT NULL,
	[MASTER] [int] NOT NULL,
	[NAME] [nvarchar](255) NOT NULL,
	[DEFAULT_LOCALE] [nvarchar](20) NOT NULL,
	[CATALOG_CODE] [nvarchar](64) NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TCATALOGSUPPORTEDLOCALE]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCATALOGSUPPORTEDLOCALE](
	[UIDPK] [bigint] NOT NULL,
	[LOCALE] [nvarchar](255) NOT NULL,
	[CATALOG_UID] [bigint] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TCATEGORY]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCATEGORY](
	[UIDPK] [bigint] NOT NULL,
	[TYPE] [nvarchar](255) NOT NULL,
	[LAST_MODIFIED_DATE] [datetime] NOT NULL,
	[PARENT_CATEGORY_UID] [bigint] NULL,
	[ORDERING] [int] NULL,
	[CATALOG_UID] [bigint] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TCATEGORYATTRIBUTEVALUE]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCATEGORYATTRIBUTEVALUE](
	[UIDPK] [bigint] NOT NULL,
	[ATTRIBUTE_UID] [bigint] NOT NULL,
	[ATTRIBUTE_TYPE] [int] NOT NULL,
	[LOCALIZED_ATTRIBUTE_KEY] [nvarchar](255) NOT NULL,
	[SHORT_TEXT_VALUE] [nvarchar](255) NULL,
	[LONG_TEXT_VALUE] [ntext] NULL,
	[INTEGER_VALUE] [int] NULL,
	[DECIMAL_VALUE] [decimal](19, 2) NULL,
	[BOOLEAN_VALUE] [int] NULL,
	[DATE_VALUE] [datetime] NULL,
	[CATEGORY_UID] [bigint] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TCATEGORYDELETED]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCATEGORYDELETED](
	[UIDPK] [bigint] NOT NULL,
	[CATEGORY_UID] [bigint] NOT NULL,
	[DELETED_DATE] [datetime] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TCATEGORYLDF]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCATEGORYLDF](
	[UIDPK] [bigint] NOT NULL,
	[CATEGORY_UID] [bigint] NOT NULL,
	[URL] [nvarchar](255) NULL,
	[KEY_WORDS] [nvarchar](255) NULL,
	[DESCRIPTION] [nvarchar](255) NULL,
	[TITLE] [nvarchar](255) NULL,
	[DISPLAY_NAME] [nvarchar](255) NULL,
	[LOCALE] [nvarchar](20) NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TCATEGORYTYPE]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCATEGORYTYPE](
	[UIDPK] [bigint] NOT NULL,
	[NAME] [nvarchar](255) NOT NULL,
	[TEMPLATE] [nvarchar](255) NOT NULL,
	[GUID] [nvarchar](64) NOT NULL,
	[CATALOG_UID] [bigint] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TCATEGORYTYPEATTRIBUTE]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCATEGORYTYPEATTRIBUTE](
	[UIDPK] [bigint] NOT NULL,
	[ORDERING] [int] NULL,
	[ATTRIBUTE_UID] [bigint] NOT NULL,
	[CATEGORY_TYPE_UID] [bigint] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TCHANGEOPERATION]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCHANGEOPERATION](
	[UIDPK] [bigint] NOT NULL,
	[OPERATION_ORDER] [int] NOT NULL,
	[ROOT_OBJECT_NAME] [nvarchar](255) NULL,
	[ROOT_OBJECT_UID] [bigint] NULL,
	[ROOT_OBJECT_GUID] [nvarchar](255) NULL,
	[CHANGE_TYPE] [nvarchar](255) NOT NULL,
	[CHANGE_TRANSACTION_UID] [bigint] NOT NULL,
	[QUERY_STRING] [nvarchar](255) NULL,
	[QUERY_PARAMETERS] [nvarchar](255) NULL,
	[TYPE] [nvarchar](20) NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TCHANGESET]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCHANGESET](
	[UIDPK] [bigint] NOT NULL,
	[NAME] [nvarchar](255) NOT NULL,
	[DESCRIPTION] [nvarchar](255) NULL,
	[OBJECT_GROUP_ID] [nvarchar](64) NOT NULL,
	[CREATED_DATE] [datetime] NOT NULL,
	[CREATED_BY_USER_GUID] [nvarchar](64) NOT NULL,
	[STATE_CODE] [nvarchar](64) NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TCHANGESETUSER]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCHANGESETUSER](
	[UIDPK] [bigint] NOT NULL,
	[USER_GUID] [nvarchar](255) NOT NULL,
	[CHANGESET_UID] [bigint] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TCHANGETRANSACTION]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCHANGETRANSACTION](
	[UIDPK] [bigint] NOT NULL,
	[TRANSACTION_ID] [nvarchar](255) NOT NULL,
	[CHANGE_DATE] [datetime] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TCHANGETRANSACTIONMETADATA]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCHANGETRANSACTIONMETADATA](
	[UIDPK] [bigint] NOT NULL,
	[CHANGE_TRANSACTION_UID] [bigint] NOT NULL,
	[METADATA_KEY] [nvarchar](255) NOT NULL,
	[METADATA_VALUE] [nvarchar](255) NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TCMUSER]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCMUSER](
	[UIDPK] [bigint] NOT NULL,
	[USER_NAME] [nvarchar](255) NOT NULL,
	[EMAIL] [nvarchar](255) NOT NULL,
	[FIRST_NAME] [nvarchar](100) NULL,
	[LAST_NAME] [nvarchar](100) NULL,
	[PASSWORD] [nvarchar](255) NOT NULL,
	[CREATION_DATE] [datetime] NOT NULL,
	[LAST_LOGIN_DATE] [datetime] NULL,
	[LAST_CHANGED_PASSWORD_DATE] [datetime] NULL,
	[FAILED_LOGIN_ATTEMPTS] [int] NOT NULL,
	[GUID] [nvarchar](64) NOT NULL,
	[STATUS] [int] NOT NULL,
	[ALL_WAREHOUSE_ACCESS] [int] NOT NULL,
	[ALL_CATALOG_ACCESS] [int] NOT NULL,
	[ALL_STORE_ACCESS] [int] NOT NULL,
	[ALL_PRICELIST_ACCESS] [int] NOT NULL,
	[LAST_MODIFIED_DATE] [datetime] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TCMUSERCATALOG]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCMUSERCATALOG](
	[USER_UID] [bigint] NOT NULL,
	[CATALOG_UID] [bigint] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TCMUSERPRICELIST]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCMUSERPRICELIST](
	[USER_UID] [bigint] NOT NULL,
	[PRICELIST_GUID] [nvarchar](64) NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TCMUSERROLEX]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCMUSERROLEX](
	[CM_USER_UID] [bigint] NOT NULL,
	[USER_ROLE_UID] [bigint] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TCMUSERSTORE]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCMUSERSTORE](
	[USER_UID] [bigint] NOT NULL,
	[STORE_UID] [bigint] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TCMUSERWAREHOUSE]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCMUSERWAREHOUSE](
	[USER_UID] [bigint] NOT NULL,
	[WAREHOUSE_UID] [bigint] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TCOUPON]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCOUPON](
	[UIDPK] [bigint] NOT NULL,
	[COUPONCODE] [nvarchar](255) NOT NULL,
	[COUPON_CONFIG_UID] [bigint] NOT NULL,
	[SUSPENDED] [int] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TCOUPON_old]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCOUPON_old](
	[UIDPK] [bigint] NOT NULL,
	[COUPONCODE] [nvarchar](255) NOT NULL,
	[COUPON_CONFIG_UID] [bigint] NOT NULL,
	[SUSPENDED] [int] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TCOUPONCONFIG]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCOUPONCONFIG](
	[UIDPK] [bigint] NOT NULL,
	[RULECODE] [nvarchar](64) NOT NULL,
	[USAGE_LIMIT] [int] NOT NULL,
	[USAGE_TYPE] [nvarchar](255) NOT NULL,
	[GUID] [nvarchar](64) NOT NULL,
	[LIMITED_DURATION] [int] NOT NULL,
	[DURATION_DAYS] [int] NULL,
	[MULTI_USE_PER_ORDER] [int] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TCOUPONCONFIG_old]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCOUPONCONFIG_old](
	[UIDPK] [bigint] NOT NULL,
	[RULECODE] [nvarchar](64) NOT NULL,
	[USAGE_LIMIT] [int] NOT NULL,
	[USAGE_TYPE] [nvarchar](255) NOT NULL,
	[GUID] [nvarchar](64) NOT NULL,
	[LIMITED_DURATION] [int] NOT NULL,
	[DURATION_DAYS] [int] NULL,
	[MULTI_USE_PER_ORDER] [int] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TCOUPONUSAGE]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCOUPONUSAGE](
	[UIDPK] [bigint] NOT NULL,
	[COUPON_UID] [bigint] NOT NULL,
	[USECOUNT] [int] NOT NULL,
	[ACTIVE_IN_CART] [int] NOT NULL,
	[CUSTOMER_EMAIL_ADDRESS] [nvarchar](255) NOT NULL,
	[LIMITED_DURATION_END_DATE] [datetime] NULL,
	[SUSPENDED] [int] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TCOUPONUSAGE_old]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCOUPONUSAGE_old](
	[UIDPK] [bigint] NOT NULL,
	[COUPON_UID] [bigint] NOT NULL,
	[USECOUNT] [int] NOT NULL,
	[ACTIVE_IN_CART] [int] NOT NULL,
	[CUSTOMER_EMAIL_ADDRESS] [nvarchar](255) NOT NULL,
	[LIMITED_DURATION_END_DATE] [datetime] NULL,
	[SUSPENDED] [int] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TCSCONTENTSPACE]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCSCONTENTSPACE](
	[UIDPK] [bigint] NOT NULL,
	[GUID] [nvarchar](64) NOT NULL,
	[TARGET_ID] [nvarchar](255) NOT NULL,
	[DESCRIPTION] [nvarchar](255) NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TCSDYNAMICCONTENT]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCSDYNAMICCONTENT](
	[UIDPK] [bigint] NOT NULL,
	[GUID] [nvarchar](64) NOT NULL,
	[CONTENT_WRAPPER_ID] [nvarchar](255) NOT NULL,
	[NAME] [nvarchar](255) NOT NULL,
	[DESCRIPTION] [nvarchar](4000) NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TCSDYNAMICCONTENTDELIVERY]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCSDYNAMICCONTENTDELIVERY](
	[UIDPK] [bigint] NOT NULL,
	[GUID] [nvarchar](64) NOT NULL,
	[NAME] [nvarchar](255) NOT NULL,
	[DESCRIPTION] [nvarchar](255) NULL,
	[PRIORITY] [int] NOT NULL,
	[CSDC_CONTENT_UID] [bigint] NOT NULL,
	[SELLING_CONTEXT_GUID] [nvarchar](64) NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TCSDYNAMICCONTENTSPACE]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCSDYNAMICCONTENTSPACE](
	[DC_DELIVERY_UID] [bigint] NOT NULL,
	[DC_CONTENTSPACE_UID] [bigint] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TCSPARAMETERVALUE]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCSPARAMETERVALUE](
	[UIDPK] [bigint] NOT NULL,
	[GUID] [nvarchar](64) NOT NULL,
	[CSDYNAMICCONTENT_UID] [bigint] NOT NULL,
	[PARAMETER_NAME] [nvarchar](255) NOT NULL,
	[LOCALIZABLE] [int] NOT NULL,
	[DESCRIPTION] [nvarchar](4000) NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TCSPARAMETERVALUELDF]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCSPARAMETERVALUELDF](
	[UIDPK] [bigint] NOT NULL,
	[GUID] [nvarchar](64) NOT NULL,
	[LOCALE] [nvarchar](20) NOT NULL,
	[LDVALUE] [nvarchar](4000) NOT NULL,
	[CSPARAMETERVALUE_UID] [bigint] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TCUSTOMER]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCUSTOMER](
	[UIDPK] [bigint] NOT NULL,
	[USER_ID] [nvarchar](255) NOT NULL,
	[PREF_BILL_ADDRESS_UID] [bigint] NULL,
	[PREF_SHIP_ADDRESS_UID] [bigint] NULL,
	[CREATION_DATE] [datetime] NOT NULL,
	[LAST_EDIT_DATE] [datetime] NOT NULL,
	[GUID] [nvarchar](64) NOT NULL,
	[STATUS] [int] NOT NULL,
	[AUTHENTICATION_UID] [bigint] NULL,
	[STORE_UID] [bigint] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TCUSTOMERAUTHENTICATION]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCUSTOMERAUTHENTICATION](
	[UIDPK] [bigint] NOT NULL,
	[PASSWORD] [nvarchar](255) NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TCUSTOMERCREDITCARD]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCUSTOMERCREDITCARD](
	[UIDPK] [bigint] NOT NULL,
	[CARD_TYPE] [nvarchar](50) NOT NULL,
	[CARD_HOLDER_NAME] [nvarchar](100) NOT NULL,
	[CARD_NUMBER] [nvarchar](255) NOT NULL,
	[EXPIRY_YEAR] [nvarchar](4) NOT NULL,
	[EXPIRY_MONTH] [nvarchar](2) NOT NULL,
	[START_YEAR] [nvarchar](4) NULL,
	[START_MONTH] [nvarchar](2) NULL,
	[ISSUE_NUMBER] [int] NULL,
	[DEFAULT_CARD] [int] NULL,
	[CUSTOMER_UID] [bigint] NOT NULL,
	[BILLING_ADDRESS_UID] [bigint] NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TCUSTOMERDELETED]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCUSTOMERDELETED](
	[UIDPK] [bigint] NOT NULL,
	[CUSTOMER_UID] [bigint] NOT NULL,
	[DELETED_DATE] [datetime] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TCUSTOMERGROUP]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCUSTOMERGROUP](
	[UIDPK] [bigint] NOT NULL,
	[NAME] [nvarchar](255) NOT NULL,
	[GUID] [nvarchar](64) NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TCUSTOMERGROUPROLEX]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCUSTOMERGROUPROLEX](
	[UIDPK] [bigint] NOT NULL,
	[CUSTOMER_GROUP_UID] [bigint] NOT NULL,
	[CUSTOMER_ROLE] [nvarchar](255) NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TCUSTOMERGROUPX]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCUSTOMERGROUPX](
	[CUSTOMER_UID] [bigint] NOT NULL,
	[CUSTOMERGROUP_UID] [bigint] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TCUSTOMERPROFILEVALUE]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCUSTOMERPROFILEVALUE](
	[UIDPK] [bigint] NOT NULL,
	[ATTRIBUTE_UID] [bigint] NOT NULL,
	[ATTRIBUTE_TYPE] [int] NOT NULL,
	[LOCALIZED_ATTRIBUTE_KEY] [nvarchar](255) NOT NULL,
	[SHORT_TEXT_VALUE] [nvarchar](255) NULL,
	[LONG_TEXT_VALUE] [ntext] NULL,
	[INTEGER_VALUE] [int] NULL,
	[DECIMAL_VALUE] [decimal](19, 2) NULL,
	[BOOLEAN_VALUE] [int] NULL,
	[DATE_VALUE] [datetime] NULL,
	[CUSTOMER_UID] [bigint] NULL,
	[LAST_MODIFIED_DATE] [datetime] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TCUSTOMERSESSION]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCUSTOMERSESSION](
	[UIDPK] [bigint] NOT NULL,
	[CREATION_DATE] [datetime] NOT NULL,
	[LAST_ACCESSED_DATE] [datetime] NOT NULL,
	[CUSTOMER_UID] [bigint] NULL,
	[EMAIL] [nvarchar](255) NULL,
	[LOCALE] [nvarchar](255) NULL,
	[CURRENCY] [nvarchar](3) NULL,
	[GUID] [nvarchar](64) NOT NULL,
	[IP_ADDRESS] [nvarchar](255) NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TDATACHANGED]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TDATACHANGED](
	[UIDPK] [bigint] NOT NULL,
	[CHANGE_TYPE] [nvarchar](255) NOT NULL,
	[FIELD_NAME] [nvarchar](255) NULL,
	[FIELD_OLD_VALUE] [ntext] NULL,
	[FIELD_NEW_VALUE] [ntext] NULL,
	[OBJECT_NAME] [nvarchar](255) NULL,
	[OBJECT_UID] [bigint] NULL,
	[OBJECT_GUID] [nvarchar](255) NULL,
	[CHANGE_OPERATION_UID] [bigint] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TDIGITALASSETAUDIT]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TDIGITALASSETAUDIT](
	[UIDPK] [bigint] NOT NULL,
	[ORDERSKU_UID] [bigint] NOT NULL,
	[DIGITALASSET_UID] [bigint] NOT NULL,
	[DOWNLOAD_TIME] [datetime] NOT NULL,
	[IP_ADDRESS] [nvarchar](255) NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TDIGITALASSETS]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TDIGITALASSETS](
	[UIDPK] [bigint] NOT NULL,
	[FILE_NAME] [nvarchar](255) NOT NULL,
	[EXPIRY_DAYS] [int] NULL,
	[MAX_DOWNLOAD_TIMES] [int] NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TGIFTCERTIFICATE]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TGIFTCERTIFICATE](
	[UIDPK] [bigint] NOT NULL,
	[GUID] [nvarchar](64) NOT NULL,
	[GIFT_CERTIFICATE_CODE] [nvarchar](64) NULL,
	[CREATED_DATE] [datetime] NOT NULL,
	[LAST_MODIFIED_DATE] [datetime] NOT NULL,
	[RECIPIENT_NAME] [nvarchar](255) NULL,
	[SENDER_NAME] [nvarchar](255) NULL,
	[MESSAGE] [nvarchar](255) NULL,
	[THEME] [nvarchar](255) NULL,
	[PURCHASE_AMOUNT] [decimal](19, 2) NULL,
	[CURRENCY] [nvarchar](255) NULL,
	[RECEPIENT_EMAIL] [nvarchar](255) NULL,
	[CUSTOMER_UID] [bigint] NULL,
	[STORE_UID] [bigint] NOT NULL,
	[ORDER_GUID] [nvarchar](64) NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TGIFTCERTIFICATETRANSACTION]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TGIFTCERTIFICATETRANSACTION](
	[UIDPK] [bigint] NOT NULL,
	[CREATED_DATE] [datetime] NOT NULL,
	[AMOUNT] [decimal](19, 2) NULL,
	[AUTHORIZATION_CODE] [nvarchar](50) NULL,
	[TRANSACTION_TYPE] [nvarchar](25) NULL,
	[GIFTCERTIFICATE_UID] [bigint] NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TIMPORTBADROW]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TIMPORTBADROW](
	[UIDPK] [bigint] NOT NULL,
	[IMPORT_JOB_STATUS_UID] [bigint] NOT NULL,
	[ROW_NUMBER] [int] NOT NULL,
	[ROW_DATA] [ntext] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TIMPORTFAULT]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TIMPORTFAULT](
	[UIDPK] [bigint] NOT NULL,
	[IMPORT_BAD_ROW_UID] [bigint] NOT NULL,
	[LEVEL_NUMBER] [int] NULL,
	[CODE] [nvarchar](255) NULL,
	[SOURCE_MESSAGE] [ntext] NULL,
	[ARGS] [nvarchar](255) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TIMPORTJOB]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[TIMPORTJOB](
	[UIDPK] [bigint] NOT NULL,
	[NAME] [nvarchar](255) NOT NULL,
	[CSV_FILE_NAME] [nvarchar](255) NOT NULL,
	[COL_DELIMETER] [char](1) NULL,
	[TEXT_QUALIFIER] [char](1) NULL,
	[DATA_TYPE_NAME] [nvarchar](255) NOT NULL,
	[IMPORT_TYPE] [int] NOT NULL,
	[MAX_ALLOW_ERRORS] [int] NOT NULL,
	[CATALOG_UID] [bigint] NULL,
	[STORE_UID] [bigint] NULL,
	[WAREHOUSE_UID] [bigint] NULL,
	[DEPENDENT_OBJ_GUID] [nvarchar](64) NULL,
	[GUID] [nvarchar](64) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[TIMPORTJOBSTATUS]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TIMPORTJOBSTATUS](
	[UIDPK] [bigint] NOT NULL,
	[PROCESS_ID] [nvarchar](64) NOT NULL,
	[IMPORT_JOB_UID] [bigint] NOT NULL,
	[CMUSER_UID] [bigint] NOT NULL,
	[START_DATE] [datetime] NULL,
	[END_DATE] [datetime] NULL,
	[TOTAL_ROWS] [int] NULL,
	[FAILED_ROWS] [int] NULL,
	[CURRENT_ROW] [int] NULL,
	[STATE] [nvarchar](64) NOT NULL,
	[LAST_MODIFIED_DATE] [datetime] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TIMPORTMAPPINGS]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TIMPORTMAPPINGS](
	[UIDPK] [bigint] NOT NULL,
	[IMPORT_JOB_UID] [bigint] NOT NULL,
	[COL_NUMBER] [int] NOT NULL,
	[IMPORT_FIELD_NAME] [nvarchar](255) NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TIMPORTNOTIFICATION]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TIMPORTNOTIFICATION](
	[UIDPK] [bigint] NOT NULL,
	[REQUEST_ID] [nvarchar](64) NOT NULL,
	[ACTION] [nvarchar](64) NOT NULL,
	[IMPORT_JOB_UID] [bigint] NOT NULL,
	[DATE_CREATED] [datetime] NOT NULL,
	[CMUSER_UID] [bigint] NOT NULL,
	[NOTIFICATION_STATE] [nvarchar](64) NOT NULL,
	[CHANGESET_GUID] [nvarchar](64) NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TIMPORTNOTIFICATIONMETADATA]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TIMPORTNOTIFICATIONMETADATA](
	[UIDPK] [bigint] NOT NULL,
	[METADATA_KEY] [nvarchar](255) NULL,
	[METADATA_VALUE] [nvarchar](255) NULL,
	[IMPORT_NOTIFICATION_UID] [bigint] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TINDEXBUILDSTATUS]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TINDEXBUILDSTATUS](
	[UIDPK] [bigint] NOT NULL,
	[INDEX_TYPE] [nvarchar](100) NOT NULL,
	[LAST_BUILD_DATE] [datetime] NULL,
	[INDEX_STATUS] [nvarchar](100) NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TINDEXNOTIFY]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TINDEXNOTIFY](
	[UIDPK] [bigint] NOT NULL,
	[INDEX_TYPE] [nvarchar](100) NOT NULL,
	[UPDATE_TYPE] [nvarchar](64) NOT NULL,
	[AFFECTED_UID] [bigint] NULL,
	[ENTITY_TYPE] [nvarchar](64) NULL,
	[QUERY_STRING] [ntext] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TINVENTORY]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TINVENTORY](
	[UIDPK] [bigint] NOT NULL,
	[QUANTITY_ON_HAND] [int] NULL,
	[RESERVED_QUANTITY] [int] NULL,
	[REORDER_MINIMUM] [int] NULL,
	[REORDER_QUANTITY] [int] NULL,
	[RESTOCK_DATE] [datetime] NULL,
	[ALLOCATED_QUANTITY] [int] NULL,
	[WAREHOUSE_UID] [bigint] NOT NULL,
	[PRODUCTSKU_SKUCODE] [nvarchar](255) NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TINVENTORYALLOCATION]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TINVENTORYALLOCATION](
	[UIDPK] [bigint] NOT NULL,
	[ORDERSKU_UID] [bigint] NOT NULL,
	[QUANTITY] [bigint] NOT NULL,
	[STATUS] [nvarchar](25) NOT NULL,
	[WAREHOUSE_CODE] [nvarchar](64) NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TINVENTORYAUDIT]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TINVENTORYAUDIT](
	[UIDPK] [bigint] NOT NULL,
	[INVENTORY_UID] [bigint] NOT NULL,
	[QUANTITY] [int] NULL,
	[LOG_COMMENT] [ntext] NULL,
	[EVENT_ORIGINATOR] [nvarchar](255) NOT NULL,
	[LOG_DATE] [datetime] NOT NULL,
	[ORDER_UID] [bigint] NULL,
	[EVENT_TYPE] [nvarchar](30) NOT NULL,
	[REASON] [nvarchar](255) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TLINKEDCATEGORY]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TLINKEDCATEGORY](
	[UIDPK] [bigint] NOT NULL,
	[MASTER_CATEGORY_UID] [bigint] NULL,
	[INCLUDE] [int] NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TLOCALIZEDPROPERTIES]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TLOCALIZEDPROPERTIES](
	[UIDPK] [bigint] NOT NULL,
	[OBJECT_UID] [bigint] NULL,
	[LOCALIZED_PROPERTY_KEY] [nvarchar](255) NOT NULL,
	[VALUE] [nvarchar](255) NOT NULL,
	[TYPE] [nvarchar](31) NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TMASTERCATEGORY]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TMASTERCATEGORY](
	[UIDPK] [bigint] NOT NULL,
	[START_DATE] [datetime] NOT NULL,
	[END_DATE] [datetime] NULL,
	[HIDDEN] [int] NULL,
	[CATEGORY_TYPE_UID] [bigint] NOT NULL,
	[CODE] [nvarchar](64) NOT NULL,
	[VIRTUAL] [int] NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TOBJECTDELETED]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TOBJECTDELETED](
	[UIDPK] [bigint] NOT NULL,
	[OBJECT_TYPE] [nvarchar](255) NOT NULL,
	[OBJECT_UID] [bigint] NOT NULL,
	[DELETED_DATE] [datetime] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TOBJECTGROUPMEMBER]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TOBJECTGROUPMEMBER](
	[UIDPK] [bigint] NOT NULL,
	[GUID] [nvarchar](64) NOT NULL,
	[OBJECT_GROUP_ID] [nvarchar](64) NOT NULL,
	[OBJECT_TYPE] [nvarchar](100) NOT NULL,
	[OBJECT_IDENTIFIER] [nvarchar](100) NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TOBJECTMETADATA]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TOBJECTMETADATA](
	[UIDPK] [bigint] NOT NULL,
	[OBJECT_GROUP_MEMBER_UID] [bigint] NOT NULL,
	[METADATA_KEY] [nvarchar](255) NOT NULL,
	[METADATA_VALUE] [nvarchar](255) NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TORDER]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TORDER](
	[UIDPK] [bigint] NOT NULL,
	[LAST_MODIFIED_DATE] [datetime] NOT NULL,
	[CREATED_DATE] [datetime] NOT NULL,
	[IP_ADDRESS] [nvarchar](255) NULL,
	[ORDER_BILLING_ADDRESS_UID] [bigint] NULL,
	[TOTAL] [decimal](19, 2) NULL,
	[STATUS] [nvarchar](20) NULL,
	[ORDER_NUMBER] [nvarchar](64) NOT NULL,
	[EXTERNAL_ORDER_NUMBER] [nvarchar](64) NULL,
	[CUSTOMER_UID] [bigint] NULL,
	[LOCALE] [nvarchar](5) NOT NULL,
	[CURRENCY] [nvarchar](3) NULL,
	[STORE_UID] [bigint] NULL,
	[CREATED_BY] [bigint] NULL,
	[ORDER_SOURCE] [nvarchar](100) NULL,
	[EXCHANGE_ORDER] [int] NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TORDERADDRESS]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TORDERADDRESS](
	[UIDPK] [bigint] NOT NULL,
	[LAST_NAME] [nvarchar](100) NULL,
	[FIRST_NAME] [nvarchar](100) NULL,
	[PHONE_NUMBER] [nvarchar](50) NULL,
	[FAX_NUMBER] [nvarchar](50) NULL,
	[STREET_1] [nvarchar](200) NULL,
	[STREET_2] [nvarchar](200) NULL,
	[CITY] [nvarchar](200) NULL,
	[SUB_COUNTRY] [nvarchar](200) NULL,
	[ZIP_POSTAL_CODE] [nvarchar](50) NULL,
	[COUNTRY] [nvarchar](200) NULL,
	[COMMERCIAL] [int] NULL,
	[GUID] [nvarchar](64) NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TORDERAUDIT]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TORDERAUDIT](
	[UIDPK] [bigint] NOT NULL,
	[CREATED_DATE] [datetime] NOT NULL,
	[CREATED_BY] [bigint] NULL,
	[DETAIL] [ntext] NULL,
	[ORDER_UID] [bigint] NULL,
	[ORIGINATOR_TYPE] [nvarchar](30) NOT NULL,
	[TITLE] [nvarchar](255) NOT NULL,
	[LAST_MODIFIED_DATE] [datetime] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TORDERITEMDATA]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TORDERITEMDATA](
	[UIDPK] [bigint] NOT NULL,
	[ITEM_KEY] [ntext] NOT NULL,
	[ITEM_VALUE] [ntext] NULL,
	[ORDERSKU_UID] [bigint] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TORDERLOCK]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TORDERLOCK](
	[UIDPK] [bigint] NOT NULL,
	[ORDER_UID] [bigint] NOT NULL,
	[USER_UID] [bigint] NOT NULL,
	[CREATED_DATE] [bigint] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TORDERNUMBERGENERATOR]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TORDERNUMBERGENERATOR](
	[UIDPK] [bigint] NOT NULL,
	[NEXT_ORDER_NUMBER] [nvarchar](100) NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TORDERPAYMENT]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TORDERPAYMENT](
	[UIDPK] [bigint] NOT NULL,
	[CREATED_DATE] [datetime] NOT NULL,
	[CARD_TYPE] [nvarchar](50) NULL,
	[CARD_HOLDER_NAME] [nvarchar](100) NULL,
	[CARD_NUMBER] [nvarchar](255) NULL,
	[MASKED_CARD_NUMBER] [nvarchar](255) NULL,
	[EXPIRY_YEAR] [nvarchar](4) NULL,
	[EXPIRY_MONTH] [nvarchar](2) NULL,
	[START_DATE] [datetime] NULL,
	[ISSUE_NUMBER] [nvarchar](100) NULL,
	[PAYMENT_GATEWAY] [nvarchar](100) NULL,
	[AMOUNT] [decimal](19, 2) NULL,
	[REFERENCE_ID] [nvarchar](50) NULL,
	[REQUEST_TOKEN] [nvarchar](255) NULL,
	[AUTHORIZATION_CODE] [nvarchar](50) NULL,
	[TRANSACTION_TYPE] [nvarchar](25) NULL,
	[CURRENCY] [nvarchar](10) NULL,
	[EMAIL] [nvarchar](100) NULL,
	[STATUS] [nvarchar](20) NULL,
	[ORDER_UID] [bigint] NULL,
	[GIFTCERTIFICATE_UID] [bigint] NULL,
	[ORDERSHIPMENT_UID] [bigint] NULL,
	[LAST_MODIFIED_DATE] [datetime] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TORDERRETURN]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TORDERRETURN](
	[UIDPK] [bigint] NOT NULL,
	[CREATED_DATE] [datetime] NOT NULL,
	[RMA_CODE] [nvarchar](255) NULL,
	[RETURN_COMMENT] [nvarchar](2000) NULL,
	[ORDER_UID] [bigint] NULL,
	[CREATED_BY] [bigint] NULL,
	[STATUS] [nvarchar](50) NULL,
	[RETURN_TYPE] [nvarchar](255) NULL,
	[PHYSICAL_RETURN] [int] NULL,
	[EXCHANGE_ORDER_UID] [bigint] NULL,
	[ORDER_PAYMENT_UID] [bigint] NULL,
	[LESS_RESTOCK_AMOUNT] [decimal](19, 2) NULL,
	[SHIPPING_COST] [decimal](19, 2) NOT NULL,
	[LAST_MODIFIED_DATE] [datetime] NOT NULL,
	[RECEIVED_BY] [bigint] NULL,
	[VERSION] [int] NULL,
	[ORDER_RETURN_ADDRESS_UID] [bigint] NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TORDERRETURNSKU]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TORDERRETURNSKU](
	[UIDPK] [bigint] NOT NULL,
	[GUID] [nvarchar](64) NOT NULL,
	[ORDER_SKU_UID] [bigint] NULL,
	[ORDER_RETURN_UID] [bigint] NULL,
	[QUANTITY] [int] NULL,
	[RETURN_AMOUNT] [decimal](19, 2) NULL,
	[RECEIVED_QUANTITY] [int] NULL,
	[RECEIVED_STATE] [nvarchar](255) NULL,
	[RETURN_REASON] [nvarchar](255) NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TORDERSHIPMENT]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TORDERSHIPMENT](
	[UIDPK] [bigint] NOT NULL,
	[TYPE] [nvarchar](255) NOT NULL,
	[STATUS] [nvarchar](20) NULL,
	[LAST_MODIFIED_DATE] [datetime] NOT NULL,
	[CREATED_DATE] [datetime] NOT NULL,
	[SHIPMENT_DATE] [datetime] NULL,
	[CARRIER] [nvarchar](255) NULL,
	[SERVICE_LEVEL] [nvarchar](255) NULL,
	[TRACKING_CODE] [nvarchar](255) NULL,
	[ITEM_SUBTOTAL] [decimal](19, 2) NULL,
	[BEFORE_TAX_SHIPPING_COST] [decimal](19, 2) NULL,
	[ITEM_TAX] [decimal](19, 2) NULL,
	[SUBTOTAL_DISCOUNT] [decimal](19, 2) NULL,
	[SHIPPING_COST] [decimal](19, 2) NULL,
	[SHIPPING_TAX] [decimal](19, 2) NULL,
	[SHIPPING_SUBTOTAL] [decimal](19, 2) NULL,
	[INCLUSIVE_TAX] [int] NULL,
	[ORDER_ADDRESS_UID] [bigint] NULL,
	[ORDER_UID] [bigint] NULL,
	[SERVICE_LEVEL_UID] [bigint] NULL,
	[PICKLIST_UID] [bigint] NULL,
	[SHIPMENT_NUMBER] [nvarchar](64) NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TORDERSKU]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TORDERSKU](
	[UIDPK] [bigint] NOT NULL,
	[GUID] [nvarchar](64) NOT NULL,
	[PARENT_ITEM_UID] [bigint] NULL,
	[LAST_MODIFIED_DATE] [datetime] NOT NULL,
	[CREATED_DATE] [datetime] NOT NULL,
	[SKUCODE] [nvarchar](255) NOT NULL,
	[TAXCODE] [nvarchar](255) NOT NULL,
	[PRODUCT_SKU_UID] [bigint] NULL,
	[ORDER_SHIPMENT_UID] [bigint] NULL,
	[QUANTITY] [int] NULL,
	[DISPLAY_NAME] [nvarchar](255) NOT NULL,
	[AMOUNT] [decimal](19, 5) NULL,
	[TAX_AMOUNT] [decimal](19, 5) NULL,
	[LIST_UNIT_PRICE] [decimal](19, 5) NULL,
	[SALE_UNIT_PRICE] [decimal](19, 5) NULL,
	[PROMO_UNIT_PRICE] [decimal](19, 5) NULL,
	[UNIT_PRICE] [decimal](19, 5) NULL,
	[DISCOUNT_AMOUNT] [decimal](19, 5) NULL,
	[DISPLAY_SKU_OPTIONS] [nvarchar](255) NULL,
	[IMAGE] [nvarchar](255) NULL,
	[WEIGHT] [int] NULL,
	[DIGITAL_ASSET_UID] [bigint] NULL,
	[ALLOCATED_QUANTITY] [bigint] NULL,
	[CURRENCY] [nvarchar](3) NULL,
	[ORDERING] [int] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TPASSWORDHISTORY]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TPASSWORDHISTORY](
	[UIDPK] [bigint] NOT NULL,
	[OLD_PASSWORD] [nvarchar](255) NOT NULL,
	[EXPIRATION_DATE] [datetime] NOT NULL,
	[CM_USER_UID] [bigint] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TPAYMENTGATEWAY]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TPAYMENTGATEWAY](
	[UIDPK] [bigint] NOT NULL,
	[NAME] [nvarchar](255) NOT NULL,
	[TYPE] [nvarchar](255) NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TPAYMENTGATEWAYPROPERTIES]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TPAYMENTGATEWAYPROPERTIES](
	[UIDPK] [bigint] NOT NULL,
	[PROPKEY] [nvarchar](255) NOT NULL,
	[PROPVALUE] [nvarchar](255) NULL,
	[PAYMENTGATEWAY_UID] [bigint] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TPICKLIST]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TPICKLIST](
	[UIDPK] [bigint] NOT NULL,
	[CREATED_DATE] [datetime] NOT NULL,
	[WAREHOUSE_UID] [bigint] NULL,
	[CREATED_BY] [bigint] NULL,
	[ACTIVE] [int] NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TPRICEADJUSTMENT]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TPRICEADJUSTMENT](
	[UIDPK] [bigint] NOT NULL,
	[GUID] [nvarchar](64) NOT NULL,
	[CONSTITUENT_GUID] [nvarchar](64) NOT NULL,
	[AMOUNT] [decimal](19, 2) NULL,
	[PRICE_LIST_GUID] [nvarchar](64) NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TPRICELIST]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TPRICELIST](
	[UIDPK] [bigint] NOT NULL,
	[GUID] [nvarchar](64) NOT NULL,
	[NAME] [nvarchar](255) NOT NULL,
	[CURRENCY] [nvarchar](255) NOT NULL,
	[DESCRIPTION] [ntext] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TPRICELISTASSIGNMENT]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TPRICELISTASSIGNMENT](
	[UIDPK] [bigint] NOT NULL,
	[GUID] [nvarchar](64) NOT NULL,
	[NAME] [nvarchar](255) NOT NULL,
	[DESCRIPTION] [nvarchar](4000) NULL,
	[PRIORITY] [int] NOT NULL,
	[CATALOG_UID] [bigint] NOT NULL,
	[PRLISTDSCR_UID] [bigint] NOT NULL,
	[SELLING_CTX_UID] [bigint] NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TPRODUCT]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TPRODUCT](
	[UIDPK] [bigint] NOT NULL,
	[LAST_MODIFIED_DATE] [datetime] NOT NULL,
	[START_DATE] [datetime] NOT NULL,
	[END_DATE] [datetime] NULL,
	[IMAGE] [nvarchar](255) NULL,
	[PRODUCT_TYPE_UID] [bigint] NOT NULL,
	[BRAND_UID] [bigint] NULL,
	[DEFAULT_SKU_UID] [bigint] NULL,
	[CODE] [nvarchar](64) NOT NULL,
	[MIN_QUANTITY] [int] NOT NULL,
	[EXPECTED_RELEASE_DATE] [datetime] NULL,
	[HIDDEN] [int] NULL,
	[SALES_COUNT] [int] NULL,
	[TAX_CODE_UID] [bigint] NULL,
	[PRE_OR_BACK_ORDER_LIMIT] [int] NULL,
	[AVAILABILITY_CRITERIA] [nvarchar](30) NULL,
	[TYPE] [nvarchar](255) NULL,
	[NOT_SOLD_SEPARATELY] [int] NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TPRODUCTASSOCIATION]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TPRODUCTASSOCIATION](
	[UIDPK] [bigint] NOT NULL,
	[GUID] [nvarchar](64) NOT NULL,
	[ASSOCIATION_TYPE] [int] NOT NULL,
	[SOURCE_PRODUCT_UID] [bigint] NOT NULL,
	[TARGET_PRODUCT_UID] [bigint] NOT NULL,
	[CATALOG_UID] [bigint] NULL,
	[START_DATE] [datetime] NOT NULL,
	[END_DATE] [datetime] NULL,
	[DEFAULT_QUANTITY] [int] NOT NULL,
	[SOURCE_PRODUCT_DEPENDENT] [int] NULL,
	[ORDERING] [int] NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TPRODUCTATTRIBUTEVALUE]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TPRODUCTATTRIBUTEVALUE](
	[UIDPK] [bigint] NOT NULL,
	[ATTRIBUTE_UID] [bigint] NOT NULL,
	[ATTRIBUTE_TYPE] [int] NOT NULL,
	[LOCALIZED_ATTRIBUTE_KEY] [nvarchar](255) NOT NULL,
	[SHORT_TEXT_VALUE] [nvarchar](255) NULL,
	[LONG_TEXT_VALUE] [ntext] NULL,
	[INTEGER_VALUE] [int] NULL,
	[DECIMAL_VALUE] [decimal](19, 2) NULL,
	[BOOLEAN_VALUE] [int] NULL,
	[DATE_VALUE] [datetime] NULL,
	[PRODUCT_UID] [bigint] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TPRODUCTCATEGORY]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TPRODUCTCATEGORY](
	[UIDPK] [bigint] NOT NULL,
	[PRODUCT_UID] [bigint] NOT NULL,
	[CATEGORY_UID] [bigint] NOT NULL,
	[FEAT_PRODUCT_ORDER] [int] NULL,
	[DEFAULT_CATEGORY] [int] NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TPRODUCTDELETED]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TPRODUCTDELETED](
	[UIDPK] [bigint] NOT NULL,
	[PRODUCT_UID] [bigint] NOT NULL,
	[DELETED_DATE] [datetime] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TPRODUCTLDF]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TPRODUCTLDF](
	[UIDPK] [bigint] NOT NULL,
	[PRODUCT_UID] [bigint] NOT NULL,
	[URL] [nvarchar](255) NULL,
	[KEY_WORDS] [nvarchar](255) NULL,
	[DESCRIPTION] [nvarchar](255) NULL,
	[TITLE] [nvarchar](255) NULL,
	[DISPLAY_NAME] [nvarchar](255) NULL,
	[LOCALE] [nvarchar](20) NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TPRODUCTSKU]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TPRODUCTSKU](
	[UIDPK] [bigint] NOT NULL,
	[START_DATE] [datetime] NOT NULL,
	[END_DATE] [datetime] NULL,
	[SKUCODE] [nvarchar](255) NOT NULL,
	[IMAGE] [nvarchar](255) NULL,
	[PRODUCT_UID] [bigint] NOT NULL,
	[SHIPPABLE] [int] NULL,
	[WEIGHT] [decimal](19, 2) NULL,
	[HEIGHT] [decimal](19, 2) NULL,
	[WIDTH] [decimal](19, 2) NULL,
	[LENGTH] [decimal](19, 2) NULL,
	[PRE_OR_BACK_ORDERED_QUANTITY] [int] NULL,
	[DIGITAL] [int] NULL,
	[DIGITAL_ASSET_UID] [bigint] NULL,
	[LAST_MODIFIED_DATE] [datetime] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TPRODUCTSKUATTRIBUTEVALUE]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TPRODUCTSKUATTRIBUTEVALUE](
	[UIDPK] [bigint] NOT NULL,
	[ATTRIBUTE_UID] [bigint] NOT NULL,
	[ATTRIBUTE_TYPE] [int] NOT NULL,
	[LOCALIZED_ATTRIBUTE_KEY] [nvarchar](255) NOT NULL,
	[SHORT_TEXT_VALUE] [nvarchar](255) NULL,
	[LONG_TEXT_VALUE] [ntext] NULL,
	[INTEGER_VALUE] [int] NULL,
	[DECIMAL_VALUE] [decimal](19, 2) NULL,
	[BOOLEAN_VALUE] [int] NULL,
	[DATE_VALUE] [datetime] NULL,
	[PRODUCT_SKU_UID] [bigint] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TPRODUCTSKUOPTIONVALUE]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TPRODUCTSKUOPTIONVALUE](
	[UIDPK] [bigint] NOT NULL,
	[PRODUCT_SKU_UID] [bigint] NOT NULL,
	[OPTION_KEY] [nvarchar](100) NOT NULL,
	[OPTION_VALUE_UID] [bigint] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TPRODUCTTYPE]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TPRODUCTTYPE](
	[UIDPK] [bigint] NOT NULL,
	[WITH_MULTIPLE_SKUS] [int] NOT NULL,
	[NAME] [nvarchar](255) NOT NULL,
	[TEMPLATE] [nvarchar](255) NOT NULL,
	[GUID] [nvarchar](64) NOT NULL,
	[TAX_CODE_UID] [bigint] NOT NULL,
	[CATALOG_UID] [bigint] NOT NULL,
	[EXCLUDE_FROM_DISCOUNT] [int] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TPRODUCTTYPEATTRIBUTE]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TPRODUCTTYPEATTRIBUTE](
	[UIDPK] [bigint] NOT NULL,
	[ORDERING] [int] NULL,
	[ATTRIBUTE_UID] [bigint] NOT NULL,
	[PRODUCT_TYPE_UID] [bigint] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TPRODUCTTYPESKUATTRIBUTE]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TPRODUCTTYPESKUATTRIBUTE](
	[UIDPK] [bigint] NOT NULL,
	[ORDERING] [int] NULL,
	[ATTRIBUTE_UID] [bigint] NOT NULL,
	[PRODUCT_TYPE_UID] [bigint] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TPRODUCTTYPESKUOPTION]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TPRODUCTTYPESKUOPTION](
	[PRODUCT_TYPE_UID] [bigint] NOT NULL,
	[SKU_OPTION_UID] [bigint] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TRMAGENERATOR]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TRMAGENERATOR](
	[UIDPK] [bigint] NOT NULL,
	[NEXT_RMA] [nvarchar](100) NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TRULE]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TRULE](
	[UIDPK] [bigint] NOT NULL,
	[LAST_MODIFIED_DATE] [datetime] NOT NULL,
	[RULECODE] [nvarchar](64) NOT NULL,
	[START_DATE] [datetime] NULL,
	[END_DATE] [datetime] NULL,
	[ELIGIBILITY_OPERATOR] [int] NULL,
	[CONDITION_OPERATOR] [int] NULL,
	[NAME] [nvarchar](255) NOT NULL,
	[DESCRIPTION] [nvarchar](255) NULL,
	[RULE_SET_UID] [bigint] NULL,
	[STORE_UID] [bigint] NULL,
	[CATALOG_UID] [bigint] NULL,
	[CM_USER_UID] [bigint] NULL,
	[ENABLED] [int] NOT NULL,
	[CURRENT_LUP_NUMBER] [bigint] NULL,
	[SELLING_CTX_UID] [bigint] NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TRULE_old]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TRULE_old](
	[UIDPK] [bigint] NOT NULL,
	[LAST_MODIFIED_DATE] [datetime] NOT NULL,
	[RULECODE] [nvarchar](64) NOT NULL,
	[START_DATE] [datetime] NULL,
	[END_DATE] [datetime] NULL,
	[ELIGIBILITY_OPERATOR] [int] NULL,
	[CONDITION_OPERATOR] [int] NULL,
	[NAME] [nvarchar](255) NOT NULL,
	[DESCRIPTION] [nvarchar](255) NULL,
	[RULE_SET_UID] [bigint] NULL,
	[STORE_UID] [bigint] NULL,
	[CATALOG_UID] [bigint] NULL,
	[CM_USER_UID] [bigint] NULL,
	[ENABLED] [int] NOT NULL,
	[CURRENT_LUP_NUMBER] [bigint] NULL,
	[SELLING_CTX_UID] [bigint] NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TRULEELEMENT]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TRULEELEMENT](
	[UIDPK] [bigint] NOT NULL,
	[TYPE] [nvarchar](255) NOT NULL,
	[KIND] [nvarchar](255) NOT NULL,
	[RULE_UID] [bigint] NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TRULEELEMENT_old]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TRULEELEMENT_old](
	[UIDPK] [bigint] NOT NULL,
	[TYPE] [nvarchar](255) NOT NULL,
	[KIND] [nvarchar](255) NOT NULL,
	[RULE_UID] [bigint] NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TRULEEXCEPTION]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TRULEEXCEPTION](
	[UIDPK] [bigint] NOT NULL,
	[TYPE] [nvarchar](255) NOT NULL,
	[RULE_ELEMENT_UID] [bigint] NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TRULEEXCEPTION_old]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TRULEEXCEPTION_old](
	[UIDPK] [bigint] NOT NULL,
	[TYPE] [nvarchar](255) NOT NULL,
	[RULE_ELEMENT_UID] [bigint] NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TRULEPARAMETER]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TRULEPARAMETER](
	[UIDPK] [bigint] NOT NULL,
	[PARAM_KEY] [nvarchar](255) NOT NULL,
	[PARAM_VALUE] [nvarchar](255) NOT NULL,
	[DISPLAY_TEXT] [nvarchar](255) NULL,
	[RULE_ELEMENT_UID] [bigint] NULL,
	[RULE_EXCEPTION_UID] [bigint] NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TRULEPARAMETER_old]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TRULEPARAMETER_old](
	[UIDPK] [bigint] NOT NULL,
	[PARAM_KEY] [nvarchar](255) NOT NULL,
	[PARAM_VALUE] [nvarchar](255) NOT NULL,
	[DISPLAY_TEXT] [nvarchar](255) NULL,
	[RULE_ELEMENT_UID] [bigint] NULL,
	[RULE_EXCEPTION_UID] [bigint] NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TRULESET]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TRULESET](
	[UIDPK] [bigint] NOT NULL,
	[LAST_MODIFIED_DATE] [datetime] NOT NULL,
	[NAME] [nvarchar](255) NOT NULL,
	[SCENARIO] [int] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TRULESTORAGE]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TRULESTORAGE](
	[UIDPK] [bigint] NOT NULL,
	[STORE_UID] [bigint] NULL,
	[CATALOG_UID] [bigint] NULL,
	[SCENARIO] [int] NOT NULL,
	[LAST_MODIFIED_DATE] [datetime] NOT NULL,
	[RULEBASE] [image] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TSELLINGCONTEXT]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TSELLINGCONTEXT](
	[UIDPK] [bigint] NOT NULL,
	[GUID] [nvarchar](64) NOT NULL,
	[NAME] [nvarchar](255) NOT NULL,
	[DESCRIPTION] [nvarchar](255) NULL,
	[PRIORITY] [int] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TSELLINGCONTEXT_old]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TSELLINGCONTEXT_old](
	[UIDPK] [bigint] NOT NULL,
	[GUID] [nvarchar](64) NOT NULL,
	[NAME] [nvarchar](255) NOT NULL,
	[DESCRIPTION] [nvarchar](255) NULL,
	[PRIORITY] [int] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TSELLINGCONTEXTCONDITION]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TSELLINGCONTEXTCONDITION](
	[SELLING_CONTEXT_UID] [bigint] NOT NULL,
	[CONDITION_GUID] [nvarchar](64) NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TSELLINGCONTEXTCONDITION_old]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TSELLINGCONTEXTCONDITION_old](
	[SELLING_CONTEXT_UID] [bigint] NOT NULL,
	[CONDITION_GUID] [nvarchar](64) NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TSETTINGDEFINITION]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TSETTINGDEFINITION](
	[UIDPK] [bigint] NOT NULL,
	[PATH] [nvarchar](255) NOT NULL,
	[DEFAULT_VALUE] [ntext] NULL,
	[VALUE_TYPE] [nvarchar](255) NOT NULL,
	[DESCRIPTION] [ntext] NULL,
	[LAST_MODIFIED_DATE] [datetime] NOT NULL,
	[MAX_OVERRIDE_VALUES] [bigint] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TSETTINGMETADATA]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TSETTINGMETADATA](
	[UIDPK] [bigint] NOT NULL,
	[SETTING_DEFINITION_UID] [bigint] NULL,
	[METADATA_KEY] [nvarchar](255) NOT NULL,
	[VALUE] [nvarchar](2000) NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TSETTINGVALUE]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TSETTINGVALUE](
	[UIDPK] [bigint] NOT NULL,
	[SETTING_DEFINITION_UID] [bigint] NULL,
	[CONTEXT] [nvarchar](255) NULL,
	[LAST_MODIFIED_DATE] [datetime] NOT NULL,
	[CONTEXT_VALUE] [ntext] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TSFSEARCHLOG]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TSFSEARCHLOG](
	[UIDPK] [bigint] NOT NULL,
	[SEARCH_TIME] [datetime] NOT NULL,
	[KEYWORDS] [nvarchar](255) NULL,
	[RESULT_COUNT] [int] NOT NULL,
	[SUGGESTIONS_GENERATED] [int] NULL,
	[CATEGORY_RESTRICTION] [bigint] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TSHIPMENTTAX]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TSHIPMENTTAX](
	[UIDPK] [bigint] NOT NULL,
	[TAX_CATEGORY_NAME] [nvarchar](255) NOT NULL,
	[TAX_CATEGORY_DISPLAY_NAME] [nvarchar](255) NOT NULL,
	[VALUE] [decimal](19, 2) NULL,
	[ORDER_SHIPMENT_UID] [bigint] NULL,
	[ORDER_RETURN_UID] [bigint] NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TSHIPPINGCOSTCALCULATIONMETHOD]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TSHIPPINGCOSTCALCULATIONMETHOD](
	[UIDPK] [bigint] NOT NULL,
	[TYPE] [nvarchar](255) NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TSHIPPINGCOSTCALCULATIONPARAM]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[TSHIPPINGCOSTCALCULATIONPARAM](
	[UIDPK] [bigint] NOT NULL,
	[PARAM_KEY] [nvarchar](255) NOT NULL,
	[VALUE] [nvarchar](255) NOT NULL,
	[DISPLAY_TEXT] [nvarchar](255) NOT NULL,
	[SCCM_UID] [bigint] NULL,
	[CURRENCY] [char](3) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[TSHIPPINGREGION]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TSHIPPINGREGION](
	[UIDPK] [bigint] NOT NULL,
	[NAME] [nvarchar](255) NOT NULL,
	[REGION_STR] [nvarchar](2000) NULL,
	[GUID] [nvarchar](64) NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TSHIPPINGSERVICELEVEL]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TSHIPPINGSERVICELEVEL](
	[UIDPK] [bigint] NOT NULL,
	[GUID] [nvarchar](64) NOT NULL,
	[SHIPPING_REGION_UID] [bigint] NOT NULL,
	[STORE_UID] [bigint] NOT NULL,
	[SCCM_UID] [bigint] NOT NULL,
	[CARRIER] [nvarchar](255) NULL,
	[CODE] [nvarchar](64) NOT NULL,
	[DEFAULT_COST] [decimal](19, 2) NULL,
	[ENABLED] [int] NOT NULL,
	[LAST_MODIFIED_DATE] [datetime] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TSHOPPINGCART]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TSHOPPINGCART](
	[UIDPK] [bigint] NOT NULL,
	[GUID] [nvarchar](100) NOT NULL,
	[STORE_UID] [bigint] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TSHOPPINGITEMDATA]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TSHOPPINGITEMDATA](
	[UIDPK] [bigint] NOT NULL,
	[ITEM_KEY] [ntext] NOT NULL,
	[ITEM_VALUE] [ntext] NULL,
	[CARTITEM_UID] [bigint] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TSKUOPTION]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TSKUOPTION](
	[UIDPK] [bigint] NOT NULL,
	[OPTION_KEY] [nvarchar](100) NOT NULL,
	[CATALOG_UID] [bigint] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TSKUOPTIONVALUE]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TSKUOPTIONVALUE](
	[UIDPK] [bigint] NOT NULL,
	[OPTION_VALUE_KEY] [nvarchar](255) NOT NULL,
	[ORDERING] [int] NULL,
	[SKU_OPTION_UID] [bigint] NOT NULL,
	[IMAGE] [nvarchar](255) NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TSTORE]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[TSTORE](
	[UIDPK] [bigint] NOT NULL,
	[NAME] [nvarchar](255) NOT NULL,
	[STORECODE] [nvarchar](64) NOT NULL,
	[DESCRIPTION] [ntext] NULL,
	[URL] [nvarchar](255) NULL,
	[ENABLED] [int] NOT NULL,
	[DEFAULT_LOCALE] [nvarchar](20) NULL,
	[DEFAULT_CURRENCY] [char](3) NULL,
	[SUB_COUNTRY] [nvarchar](200) NULL,
	[COUNTRY] [nvarchar](200) NOT NULL,
	[TIMEZONE] [nvarchar](50) NOT NULL,
	[STORE_TYPE] [char](3) NOT NULL,
	[CONTENT_ENCODING] [nvarchar](20) NULL,
	[CREDIT_CARD_CVV2_ENABLED] [int] NOT NULL,
	[CC_PAYER_AUTH_ENABLED] [int] NOT NULL,
	[DISPLAY_OUT_OF_STOCK] [int] NOT NULL,
	[STORE_FULL_CREDIT_CARDS] [int] NOT NULL,
	[EMAIL_SENDER_NAME] [nvarchar](255) NULL,
	[EMAIL_SENDER_ADDRESS] [nvarchar](255) NULL,
	[STORE_ADMIN_EMAIL] [nvarchar](255) NULL,
	[CATALOG_UID] [bigint] NULL,
	[STORE_STATE] [int] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[TSTOREASSOCIATION]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TSTOREASSOCIATION](
	[STORE_UID] [bigint] NOT NULL,
	[ASSOCIATED_STORE_UID] [bigint] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TSTORECATALOG]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TSTORECATALOG](
	[UIDPK] [bigint] NOT NULL,
	[STORE_UID] [bigint] NOT NULL,
	[CATALOG_UID] [bigint] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TSTORECREDITCARDTYPE]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TSTORECREDITCARDTYPE](
	[UIDPK] [bigint] NOT NULL,
	[TYPE] [nvarchar](255) NULL,
	[STORE_UID] [bigint] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TSTOREPAYMENTGATEWAY]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TSTOREPAYMENTGATEWAY](
	[STORE_UID] [bigint] NOT NULL,
	[GATEWAY_UID] [bigint] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TSTORESUPPORTEDCURRENCY]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TSTORESUPPORTEDCURRENCY](
	[UIDPK] [bigint] NOT NULL,
	[CURRENCY] [nvarchar](255) NOT NULL,
	[STORE_UID] [bigint] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TSTORESUPPORTEDLOCALE]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TSTORESUPPORTEDLOCALE](
	[UIDPK] [bigint] NOT NULL,
	[LOCALE] [nvarchar](255) NOT NULL,
	[STORE_UID] [bigint] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TSTORETAXCODE]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TSTORETAXCODE](
	[STORE_UID] [bigint] NOT NULL,
	[TAXCODE_UID] [bigint] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TSTORETAXJURISDICTION]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TSTORETAXJURISDICTION](
	[STORE_UID] [bigint] NOT NULL,
	[TAXJURISDICTION_UID] [bigint] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TSTOREWAREHOUSE]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TSTOREWAREHOUSE](
	[STORE_UID] [bigint] NOT NULL,
	[WAREHOUSE_UID] [bigint] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TSYNONYM]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TSYNONYM](
	[UIDPK] [bigint] NOT NULL,
	[SYNONYM_UID] [bigint] NOT NULL,
	[SYNONYM_WORD] [nvarchar](255) NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TSYNONYMGROUPS]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TSYNONYMGROUPS](
	[UIDPK] [bigint] NOT NULL,
	[CONCEPT_TERM] [nvarchar](255) NOT NULL,
	[LOCALE] [nvarchar](20) NOT NULL,
	[CATALOG_UID] [bigint] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TTAGALLOWEDVALUE]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TTAGALLOWEDVALUE](
	[UIDPK] [bigint] NOT NULL,
	[VALUE] [nvarchar](255) NOT NULL,
	[TAGVALUETYPE_GUID] [nvarchar](64) NOT NULL,
	[DESCRIPTION] [nvarchar](4000) NULL,
	[ORDERING] [int] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TTAGCONDITION]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TTAGCONDITION](
	[UIDPK] [bigint] NOT NULL,
	[GUID] [nvarchar](64) NOT NULL,
	[NAME] [nvarchar](255) NOT NULL,
	[DESCRIPTION] [nvarchar](4000) NULL,
	[CONDITION_STRING] [nvarchar](4000) NOT NULL,
	[TAGDICTIONARY_GUID] [nvarchar](64) NULL,
	[NAMED] [int] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TTAGCONDITION_old]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TTAGCONDITION_old](
	[UIDPK] [bigint] NOT NULL,
	[GUID] [nvarchar](64) NOT NULL,
	[NAME] [nvarchar](255) NOT NULL,
	[DESCRIPTION] [nvarchar](4000) NULL,
	[CONDITION_STRING] [nvarchar](4000) NOT NULL,
	[TAGDICTIONARY_GUID] [nvarchar](64) NULL,
	[NAMED] [int] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TTAGDEFINITION]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TTAGDEFINITION](
	[UIDPK] [bigint] NOT NULL,
	[GUID] [nvarchar](64) NOT NULL,
	[NAME] [nvarchar](255) NOT NULL,
	[DESCRIPTION] [nvarchar](255) NULL,
	[TAGVALUETYPE_GUID] [nvarchar](64) NOT NULL,
	[TAGGROUP_UID] [bigint] NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TTAGDICTIONARY]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TTAGDICTIONARY](
	[UIDPK] [bigint] NOT NULL,
	[GUID] [nvarchar](64) NOT NULL,
	[NAME] [nvarchar](255) NOT NULL,
	[PURPOSE] [nvarchar](255) NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TTAGDICTIONARYTAGDEFINITION]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TTAGDICTIONARYTAGDEFINITION](
	[TAGDICTIONARY_GUID] [nvarchar](64) NOT NULL,
	[TAGDEFINITION_GUID] [nvarchar](64) NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TTAGGROUP]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TTAGGROUP](
	[UIDPK] [bigint] NOT NULL,
	[GUID] [nvarchar](64) NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TTAGOPERATOR]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TTAGOPERATOR](
	[UIDPK] [bigint] NOT NULL,
	[GUID] [nvarchar](64) NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TTAGVALUETYPE]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TTAGVALUETYPE](
	[UIDPK] [bigint] NOT NULL,
	[GUID] [nvarchar](64) NOT NULL,
	[JAVA_TYPE] [nvarchar](50) NULL,
	[UI_PICKER_KEY] [nvarchar](50) NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TTAGVALUETYPEOPERATOR]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TTAGVALUETYPEOPERATOR](
	[TAGVALUETYPE_GUID] [nvarchar](64) NOT NULL,
	[TAGOPERATOR_GUID] [nvarchar](64) NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TTAXCATEGORY]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TTAXCATEGORY](
	[UIDPK] [bigint] NOT NULL,
	[GUID] [nvarchar](64) NOT NULL,
	[NAME] [nvarchar](255) NOT NULL,
	[FIELD_MATCH_TYPE] [int] NULL,
	[TAX_JURISDICTION_UID] [bigint] NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TTAXCODE]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TTAXCODE](
	[UIDPK] [bigint] NOT NULL,
	[GUID] [nvarchar](64) NOT NULL,
	[CODE] [nvarchar](255) NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TTAXJURISDICTION]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TTAXJURISDICTION](
	[UIDPK] [bigint] NOT NULL,
	[GUID] [nvarchar](64) NOT NULL,
	[REGION_CODE] [nvarchar](255) NOT NULL,
	[PRICE_CALCULATION_METH] [int] NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TTAXREGION]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TTAXREGION](
	[UIDPK] [bigint] NOT NULL,
	[REGION_NAME] [nvarchar](255) NOT NULL,
	[TAX_CATEGORY_UID] [bigint] NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TTAXVALUE]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TTAXVALUE](
	[UIDPK] [bigint] NOT NULL,
	[TAX_REGION_UID] [bigint] NULL,
	[TAX_CODE_UID] [bigint] NULL,
	[VALUE] [decimal](19, 4) NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TTOPSELLER]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TTOPSELLER](
	[UIDPK] [bigint] NOT NULL,
	[CATEGORY_UID] [bigint] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TTOPSELLERPRODUCTS]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TTOPSELLERPRODUCTS](
	[UIDPK] [bigint] NOT NULL,
	[TOP_SELLER_UID] [bigint] NOT NULL,
	[PRODUCT_UID] [bigint] NOT NULL,
	[SALES_COUNT] [int] NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TUSERROLE]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TUSERROLE](
	[UIDPK] [bigint] NOT NULL,
	[NAME] [nvarchar](255) NOT NULL,
	[DESCRIPTION] [nvarchar](255) NULL,
	[GUID] [nvarchar](64) NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TUSERROLEPERMISSIONX]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TUSERROLEPERMISSIONX](
	[UIDPK] [bigint] NOT NULL,
	[ROLE_UID] [bigint] NOT NULL,
	[USER_PERMISSION] [nvarchar](255) NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TVALIDATIONCONSTRAINTS]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TVALIDATIONCONSTRAINTS](
	[UIDPK] [bigint] NOT NULL,
	[OBJECT_UID] [bigint] NULL,
	[ERROR_MESSAGE_KEY] [nvarchar](255) NOT NULL,
	[VALIDATION_CONSTRAINT] [nvarchar](4000) NOT NULL,
	[TYPE] [nvarchar](31) NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TWAREHOUSE]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TWAREHOUSE](
	[UIDPK] [bigint] NOT NULL,
	[NAME] [nvarchar](255) NOT NULL,
	[PICK_DELAY] [int] NULL,
	[ADDRESS_UID] [bigint] NULL,
	[CODE] [nvarchar](64) NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TWAREHOUSEADDRESS]    Script Date: 1/28/2014 9:59:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TWAREHOUSEADDRESS](
	[UIDPK] [bigint] NOT NULL,
	[STREET_1] [nvarchar](200) NOT NULL,
	[STREET_2] [nvarchar](200) NULL,
	[CITY] [nvarchar](200) NOT NULL,
	[SUB_COUNTRY] [nvarchar](200) NULL,
	[ZIP_POSTAL_CODE] [nvarchar](50) NOT NULL,
	[COUNTRY] [nvarchar](200) NOT NULL
) ON [PRIMARY]

GO
USE [master]
GO
ALTER DATABASE [Database_ECOM1] SET  READ_WRITE 
GO