ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear 'C

@echo off
set user=MyUser
set password=MyPassword
set host=localhost
CD C:Program FilesMySQLMySQL Server 5.5bin
mysql  -h %host% -u %user% -p%password% < C:MyDocuments2WebMysqlSQLServer70Structure.txt --tee=Run.log --comments --debug-info --verbose

cmd

CREATE TABLE dbo.admins (
idAdmin int IDENTITY (1, 1) NOT NULL,
adminName nvarchar (50) NULL,
adminPassword nvarchar (100) NULL,
adminLevel nvarchar (50) NULL,
lastLogin nvarchar (30) NULL,
idSupplier int NULL DEFAULT 0,
idAffiliate int NULL DEFAULT 0,
idStore int NULL DEFAULT 0
) ON PRIMARY
GO

CREATE TABLE dbo.affiliates (
idAffiliate int IDENTITY (1, 1) NOT NULL ,
affiliateName nvarchar (50) NULL ,
affiliateEmail nvarchar (50) NULL ,
commission float NULL DEFAULT 0,
idStore int NULL DEFAULT 0
) ON PRIMARY
GO

CREATE TABLE dbo.affiliatesTransfers  (
idAffiliateTransfer  int  IDENTITY (1, 1) NOT NULL ,
idAffiliate int NULL DEFAULT 0,
amount float NULL DEFAULT 0,
transferDate nvarchar (30) NULL ,
comments nvarchar (200) NULL
) ON PRIMARY
GO

CREATE TABLE dbo.auctionOffers (
idAuctionOffer int IDENTITY (1, 1) NOT NULL ,
idAuction int NULL DEFAULT 0,
idCustomer int NULL DEFAULT 0,
offerDate nvarchar (30) NULL ,
offerAmount float NULL DEFAULT 0
) ON PRIMARY
GO

CREATE TABLE dbo.auctions (
idAuction int IDENTITY (1, 1) NOT NULL ,
auctionName nvarchar (50) NULL ,
details ntext NULL ,
startDate nvarchar (30) NOT NULL ,
endDate nvarchar (30) NOT NULL ,
active int NULL DEFAULT 0,
idProduct int NOT NULL DEFAULT 0,
startPrice float NULL DEFAULT 0,
endPrice int NULL DEFAULT 0,
currentPrice float NULL DEFAULT 0,
idCustomerType int NULL DEFAULT 0,
minOfferAmount float NULL DEFAULT 0,
maxOfferAmount float NULL DEFAULT 0
) ON PRIMARY
GO

CREATE TABLE dbo.backOrder (
idBackOrder int IDENTITY (1, 1) NOT NULL ,
backOrderDate nvarchar (12) NOT NULL ,
idProduct int NULL DEFAULT 0,
idCustomer int NULL DEFAULT 0,
active int NULL DEFAULT 0
) ON PRIMARY
GO

CREATE TABLE dbo.blockKeywords (
idBlockKeyword int IDENTITY (1, 1) NOT NULL ,
keyWordText nvarchar (50) NULL,
idStore int NULL DEFAULT 0
) ON PRIMARY
GO

CREATE TABLE dbo.bundles (
idBundle int IDENTITY (1, 1) NOT NULL ,
mainIdProduct int NULL DEFAULT 0,
idProduct int NULL DEFAULT 0
) ON PRIMARY
GO

CREATE TABLE dbo.cartRows (
idCartRow int IDENTITY (1, 1) NOT NULL ,
idProduct int NULL DEFAULT 0,
quantity int NULL DEFAULT 0,
unitPrice float NULL DEFAULT 0,
unitCost float NULL DEFAULT 0,
unitWeight float NULL DEFAULT 0,
idDbSessionCart int NULL DEFAULT 0,
personalizationDesc nvarchar (150) NULL
) ON PRIMARY
GO

CREATE TABLE dbo.cartRowsOptions (
idCartRow int NULL DEFAULT 0,
idOption int NULL DEFAULT 0,
priceToAdd float NULL DEFAULT 0,
optionDescrip nvarchar (50) NULL
) ON PRIMARY
GO

CREATE TABLE dbo.categories (
idCategory int IDENTITY (1, 1) NOT NULL ,
categoryDesc nvarchar (50) NULL ,
keywords nvarchar (50) NULL ,
details nvarchar (150) NULL ,
idParentCategory int NULL DEFAULT 0,
displayOrder int NULL DEFAULT 0,
active int NULL DEFAULT -1,
imageCategory char (50) NULL
) ON PRIMARY
GO

CREATE TABLE dbo.categories_products (
idProduct int NULL DEFAULT 0,
idCategory int NULL DEFAULT 0
) ON PRIMARY
GO

CREATE TABLE dbo.countryCodes (
countryName nvarchar (150) NULL ,
countryCode nvarchar (4) NULL
) ON PRIMARY
GO

CREATE TABLE dbo.creditCards (
idOrder int NULL ,
cardType nvarchar (50) NULL ,
cardNumber nvarchar (80) NULL ,
expiration nvarchar (30) NULL ,
seqCode nvarchar (6) NULL ,
obs nvarchar (150) NULL
) ON PRIMARY
GO

CREATE TABLE dbo.currencyStatic (
idCurrencyStatic int IDENTITY (1, 1) NOT NULL ,
currencyName nvarchar (150) NULL ,
conversion float NULL DEFAULT 0,
currencySign nvarchar (4) NULL
) ON PRIMARY
GO

CREATE TABLE dbo.customer_specialPrices (
idCustomer_SpecialPrice int IDENTITY (1, 1) NOT NULL ,
idCustomer int NULL DEFAULT 0,
idProduct int NULL DEFAULT 0,
specialPrice float NULL DEFAULT 0
) ON PRIMARY
GO

CREATE TABLE dbo.customerTracking (
idCustomerTracking int IDENTITY (1, 1) NOT NULL ,
idCustomer int NULL DEFAULT 0,
trackingDate nvarchar (12) NULL ,
trackingHour nvarchar (20) NULL ,
action nvarchar (100) NULL ,
misc nvarchar (50) NULL ,
idStore int NULL DEFAULT 0,
) ON PRIMARY
GO