Skip to content

Commit db92719

Browse files
jakubiszonjakubiszon
committed
adventureworks - fix install script
1 parent 73520df commit db92719

File tree

1 file changed

+23
-23
lines changed

1 file changed

+23
-23
lines changed

‎adventureworks/install.sql

Lines changed: 23 additions & 23 deletions
Original file line numberDiff line numberDiff line change
@@ -972,15 +972,15 @@ CREATE SCHEMA Purchasing
972972
COMMENT ON SCHEMA Purchasing IS 'Contains objects related to vendors and purchase orders.';
973973

974974
SELECT 'Copying data into Purchasing.ProductVendor';
975-
\copy Purchasing.ProductVendor FROM 'ProductVendor.csv' DELIMITER E'\t' CSV;
975+
\copy Purchasing.ProductVendor FROM './data/ProductVendor.csv' DELIMITER E'\t' CSV;
976976
SELECT 'Copying data into Purchasing.PurchaseOrderDetail';
977-
\copy Purchasing.PurchaseOrderDetail FROM 'PurchaseOrderDetail.csv' DELIMITER E'\t' CSV;
977+
\copy Purchasing.PurchaseOrderDetail FROM './data/PurchaseOrderDetail.csv' DELIMITER E'\t' CSV;
978978
SELECT 'Copying data into Purchasing.PurchaseOrderHeader';
979-
\copy Purchasing.PurchaseOrderHeader FROM 'PurchaseOrderHeader.csv' DELIMITER E'\t' CSV;
979+
\copy Purchasing.PurchaseOrderHeader FROM './data/PurchaseOrderHeader.csv' DELIMITER E'\t' CSV;
980980
SELECT 'Copying data into Purchasing.ShipMethod';
981-
\copy Purchasing.ShipMethod FROM 'ShipMethod.csv' DELIMITER E'\t' CSV;
981+
\copy Purchasing.ShipMethod FROM './data/ShipMethod.csv' DELIMITER E'\t' CSV;
982982
SELECT 'Copying data into Purchasing.Vendor';
983-
\copy Purchasing.Vendor FROM 'Vendor.csv' DELIMITER E'\t' CSV;
983+
\copy Purchasing.Vendor FROM './data/Vendor.csv' DELIMITER E'\t' CSV;
984984

985985
-- Calculated columns that needed to be there just for the CSV import
986986
ALTER TABLE Purchasing.PurchaseOrderDetail DROP COLUMN LineTotal;
@@ -1196,43 +1196,43 @@ CREATE SCHEMA Sales
11961196
COMMENT ON SCHEMA Sales IS 'Contains objects related to customers, sales orders, and sales territories.';
11971197

11981198
SELECT 'Copying data into Sales.CountryRegionCurrency';
1199-
\copy Sales.CountryRegionCurrency FROM 'CountryRegionCurrency.csv' DELIMITER E'\t' CSV;
1199+
\copy Sales.CountryRegionCurrency FROM './data/CountryRegionCurrency.csv' DELIMITER E'\t' CSV;
12001200
SELECT 'Copying data into Sales.CreditCard';
1201-
\copy Sales.CreditCard FROM 'CreditCard.csv' DELIMITER E'\t' CSV;
1201+
\copy Sales.CreditCard FROM './data/CreditCard.csv' DELIMITER E'\t' CSV;
12021202
SELECT 'Copying data into Sales.Currency';
1203-
\copy Sales.Currency FROM 'Currency.csv' DELIMITER E'\t' CSV;
1203+
\copy Sales.Currency FROM './data/Currency.csv' DELIMITER E'\t' CSV;
12041204
SELECT 'Copying data into Sales.CurrencyRate';
1205-
\copy Sales.CurrencyRate FROM 'CurrencyRate.csv' DELIMITER E'\t' CSV;
1205+
\copy Sales.CurrencyRate FROM './data/CurrencyRate.csv' DELIMITER E'\t' CSV;
12061206
SELECT 'Copying data into Sales.Customer';
1207-
\copy Sales.Customer FROM 'Customer.csv' DELIMITER E'\t' CSV;
1207+
\copy Sales.Customer FROM './data/Customer.csv' DELIMITER E'\t' CSV;
12081208
SELECT 'Copying data into Sales.PersonCreditCard';
1209-
\copy Sales.PersonCreditCard FROM 'PersonCreditCard.csv' DELIMITER E'\t' CSV;
1209+
\copy Sales.PersonCreditCard FROM './data/PersonCreditCard.csv' DELIMITER E'\t' CSV;
12101210
SELECT 'Copying data into Sales.SalesOrderDetail';
1211-
\copy Sales.SalesOrderDetail FROM 'SalesOrderDetail.csv' DELIMITER E'\t' CSV;
1211+
\copy Sales.SalesOrderDetail FROM './data/SalesOrderDetail.csv' DELIMITER E'\t' CSV;
12121212
SELECT 'Copying data into Sales.SalesOrderHeader';
1213-
\copy Sales.SalesOrderHeader FROM 'SalesOrderHeader.csv' DELIMITER E'\t' CSV;
1213+
\copy Sales.SalesOrderHeader FROM './data/SalesOrderHeader.csv' DELIMITER E'\t' CSV;
12141214
SELECT 'Copying data into Sales.SalesOrderHeaderSalesReason';
1215-
\copy Sales.SalesOrderHeaderSalesReason FROM 'SalesOrderHeaderSalesReason.csv' DELIMITER E'\t' CSV;
1215+
\copy Sales.SalesOrderHeaderSalesReason FROM './data/SalesOrderHeaderSalesReason.csv' DELIMITER E'\t' CSV;
12161216
SELECT 'Copying data into Sales.SalesPerson';
1217-
\copy Sales.SalesPerson FROM 'SalesPerson.csv' DELIMITER E'\t' CSV;
1217+
\copy Sales.SalesPerson FROM './data/SalesPerson.csv' DELIMITER E'\t' CSV;
12181218
SELECT 'Copying data into Sales.SalesPersonQuotaHistory';
1219-
\copy Sales.SalesPersonQuotaHistory FROM 'SalesPersonQuotaHistory.csv' DELIMITER E'\t' CSV;
1219+
\copy Sales.SalesPersonQuotaHistory FROM './data/SalesPersonQuotaHistory.csv' DELIMITER E'\t' CSV;
12201220
SELECT 'Copying data into Sales.SalesReason';
1221-
\copy Sales.SalesReason FROM 'SalesReason.csv' DELIMITER E'\t' CSV;
1221+
\copy Sales.SalesReason FROM './data/SalesReason.csv' DELIMITER E'\t' CSV;
12221222
SELECT 'Copying data into Sales.SalesTaxRate';
1223-
\copy Sales.SalesTaxRate FROM 'SalesTaxRate.csv' DELIMITER E'\t' CSV;
1223+
\copy Sales.SalesTaxRate FROM './data/SalesTaxRate.csv' DELIMITER E'\t' CSV;
12241224
SELECT 'Copying data into Sales.SalesTerritory';
1225-
\copy Sales.SalesTerritory FROM 'SalesTerritory.csv' DELIMITER E'\t' CSV;
1225+
\copy Sales.SalesTerritory FROM './data/SalesTerritory.csv' DELIMITER E'\t' CSV;
12261226
SELECT 'Copying data into Sales.SalesTerritoryHistory';
1227-
\copy Sales.SalesTerritoryHistory FROM 'SalesTerritoryHistory.csv' DELIMITER E'\t' CSV;
1227+
\copy Sales.SalesTerritoryHistory FROM './data/SalesTerritoryHistory.csv' DELIMITER E'\t' CSV;
12281228
SELECT 'Copying data into Sales.ShoppingCartItem';
1229-
\copy Sales.ShoppingCartItem FROM 'ShoppingCartItem.csv' DELIMITER E'\t' CSV;
1229+
\copy Sales.ShoppingCartItem FROM './data/ShoppingCartItem.csv' DELIMITER E'\t' CSV;
12301230
SELECT 'Copying data into Sales.SpecialOffer';
1231-
\copy Sales.SpecialOffer FROM 'SpecialOffer.csv' DELIMITER E'\t' CSV;
1231+
\copy Sales.SpecialOffer FROM './data/SpecialOffer.csv' DELIMITER E'\t' CSV;
12321232
SELECT 'Copying data into Sales.SpecialOfferProduct';
12331233
\copy Sales.SpecialOfferProduct FROM 'SpecialOfferProduct.csv' DELIMITER E'\t' CSV;
12341234
SELECT 'Copying data into Sales.Store';
1235-
\copy Sales.Store FROM 'Store.csv' DELIMITER E'\t' CSV;
1235+
\copy Sales.Store FROM './data/Store.csv' DELIMITER E'\t' CSV;
12361236

12371237
-- Calculated columns that needed to be there just for the CSV import
12381238
ALTER TABLE Sales.Customer DROP COLUMN AccountNumber;

0 commit comments

Comments
 (0)