Merge pull request #1466 from schani/stage-unified-card-table-scanning

[mono.git] / mcs / class / System.Data.Linq / tests / instnwnd.SQLite.sql

diff --git a/mcs/class/System.Data.Linq/tests/instnwnd.SQLite.sql b/mcs/class/System.Data.Linq/tests/instnwnd.SQLite.sql
index 668169401dd6d0b176ef2b5d24152cbb5f2a77cc..e47e5462ab6129da52775ab65d1211ee83858a81 100644 (file)
--- a/mcs/class/System.Data.Linq/tests/instnwnd.SQLite.sql
+++ b/mcs/class/System.Data.Linq/tests/instnwnd.SQLite.sql
@@ -55,7 +55,7 @@ CREATE TABLE "Employees" (
        "Extension" nvarchar (4) NULL ,\r
        "Photo" "image" NULL ,\r
        "Notes" "ntext" NULL ,\r
-       "ReportsTo" "int" NULL ,\r
+       "ReportsTo" INTEGER NULL ,\r
        "PhotoPath" nvarchar (255) NULL ,\r
        CONSTRAINT "PK_Employees" PRIMARY KEY \r
        (\r
@@ -130,11 +130,11 @@ CREATE TABLE "Suppliers" (
 CREATE TABLE "Orders" (\r
        "OrderID" INTEGER NOT NULL ,\r
        "CustomerID" nchar (5) NULL ,\r
-       "EmployeeID" "int" NULL ,\r
+       "EmployeeID" INTEGER NULL ,\r
        "OrderDate" "datetime" NULL ,\r
        "RequiredDate" "datetime" NULL ,\r
        "ShippedDate" "datetime" NULL ,\r
-       "ShipVia" "int" NULL ,\r
+       "ShipVia" INTEGER NULL ,\r
        "Freight" "money" NULL CONSTRAINT "DF_Orders_Freight" DEFAULT (0),\r
        "ShipName" nvarchar (40) NULL ,\r
        "ShipAddress" nvarchar (60) NULL ,\r
@@ -169,8 +169,8 @@ CREATE TABLE "Orders" (
 CREATE TABLE "Products" (\r
        "ProductID" INTEGER NOT NULL ,\r
        "ProductName" nvarchar (40) NOT NULL ,\r
-       "SupplierID" "int" NULL ,\r
-       "CategoryID" "int" NULL ,\r
+       "SupplierID" INTEGER NULL ,\r
+       "CategoryID" INTEGER NULL ,\r
        "QuantityPerUnit" nvarchar (20) NULL ,\r
        "UnitPrice" "money" NULL CONSTRAINT "DF_Products_UnitPrice" DEFAULT (0),\r
        "UnitsInStock" "smallint" NULL CONSTRAINT "DF_Products_UnitsInStock" DEFAULT (0),\r
@@ -200,8 +200,8 @@ CREATE TABLE "Products" (
 );\r
 \r
 CREATE TABLE "Order Details" (\r
-       "OrderID" "int" NOT NULL ,\r
-       "ProductID" "int" NOT NULL ,\r
+       "OrderID" INTEGER NOT NULL ,\r
+       "ProductID" INTEGER NOT NULL ,\r
        "UnitPrice" "money" NOT NULL CONSTRAINT "DF_Order_Details_UnitPrice" DEFAULT (0),\r
        "Quantity" "smallint" NOT NULL CONSTRAINT "DF_Order_Details_Quantity" DEFAULT (1),\r
        "Discount" "real" NOT NULL CONSTRAINT "DF_Order_Details_Discount" DEFAULT (0),\r
@@ -8868,7 +8868,7 @@ CREATE TABLE [CustomerDemographics]
 \r
        \r
 CREATE TABLE [Region] \r
-       ( [RegionID] [int] NOT NULL ,\r
+       ( [RegionID] INTEGER NOT NULL ,\r
        [RegionDescription] [nchar] (50) NOT NULL,\r
        CONSTRAINT [PK_Region] PRIMARY KEY\r
        (\r
@@ -8880,7 +8880,7 @@ CREATE TABLE [Region]
 CREATE TABLE [Territories] \r
        ([TerritoryID] [nvarchar] (20) NOT NULL ,\r
        [TerritoryDescription] [nchar] (50) NOT NULL ,\r
-        [RegionID] [int] NOT NULL,\r
+        [RegionID] INTEGER NOT NULL,\r
        CONSTRAINT [PK_Territories] PRIMARY KEY\r
        (\r
                [TerritoryID]\r
@@ -8895,7 +8895,7 @@ CREATE TABLE [Territories]
 \r
 \r
 CREATE TABLE [EmployeeTerritories] \r
-       ([EmployeeID] [int] NOT NULL,\r
+       ([EmployeeID] INTEGER NOT NULL,\r
        [TerritoryID] [nvarchar] (20) NOT NULL ,\r
        CONSTRAINT [PK_EmployeeTerritories] PRIMARY KEY\r
        (\r