Hello, i am thankful for your worthwile cause but i couldn't make it work.
Here what i did:
"CTRL+A" and "Execute".
Here what i saw:
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '='.
Msg 102, Level 15, State 1, Line 13
Incorrect syntax near '`'.
Msg 105, Level 15, State 1, Line 1111
Unclosed quotation mark after the character string ');
--
-- Indexes for dumped tables
--
-- Indexes for table categories
ALTER TABLE categories
ADD PRIMARY KEY (CategoryID);
--
-- Indexes for table customers
ALTER TABLE customers
ADD PRIMARY KEY (CustomerID);
--
-- Indexes for table employees
ALTER TABLE employees
ADD PRIMARY KEY (EmployeeID);
--
-- Indexes for table orders
ALTER TABLE orders
ADD PRIMARY KEY (OrderID),
ADD KEY CustomerID (CustomerID),
ADD KEY EmployeeID (EmployeeID),
ADD KEY ShipperID (ShipperID);
--
-- Indexes for table order_details
ALTER TABLE order_details
ADD PRIMARY KEY (OrderDetailID),
ADD KEY OrderID (OrderID),
ADD KEY ProductID (ProductID);
--
-- Indexes for table products
ALTER TABLE products
ADD PRIMARY KEY (ProductID),
ADD KEY CategoryID (CategoryID),
ADD KEY SupplierID (SupplierID);
--
-- Indexes for table shippers
ALTER TABLE shippers
ADD PRIMARY KEY (ShipperID);
--
-- Indexes for table suppliers
ALTER TABLE suppliers
ADD PRIMARY KEY (SupplierID);
--
-- AUTO_INCREMENT for dumped tables
--
-- AUTO_INCREMENT for table categories
ALTER TABLE categories
MODIFY CategoryID int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table customers
ALTER TABLE customers
MODIFY CustomerID int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=92;
--
-- AUTO_INCREMENT for table employees
ALTER TABLE employees
MODIFY EmployeeID int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table orders
ALTER TABLE orders
MODIFY OrderID int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10444;
--
-- AUTO_INCREMENT for table order_details
ALTER TABLE order_details
MODIFY OrderDetailID int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=519;
--
-- AUTO_INCREMENT for table products
ALTER TABLE products
MODIFY ProductID int(11) NOT NULL AUTO_INCREMENT, AUTO_INCRE...
Hello, i am thankful for your worthwile cause but i couldn't make it work.
Here what i did:
"CTRL+A" and "Execute".
Here what i saw:
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '='.
Msg 102, Level 15, State 1, Line 13
Incorrect syntax near '`'.
Msg 105, Level 15, State 1, Line 1111
Unclosed quotation mark after the character string ');
--
-- Indexes for dumped tables
--
-- Indexes for table
categoriesALTER TABLE
categoriesADD PRIMARY KEY (
CategoryID);--
-- Indexes for table
customersALTER TABLE
customersADD PRIMARY KEY (
CustomerID);--
-- Indexes for table
employeesALTER TABLE
employeesADD PRIMARY KEY (
EmployeeID);--
-- Indexes for table
ordersALTER TABLE
ordersADD PRIMARY KEY (
OrderID),ADD KEY
CustomerID(CustomerID),ADD KEY
EmployeeID(EmployeeID),ADD KEY
ShipperID(ShipperID);--
-- Indexes for table
order_detailsALTER TABLE
order_detailsADD PRIMARY KEY (
OrderDetailID),ADD KEY
OrderID(OrderID),ADD KEY
ProductID(ProductID);--
-- Indexes for table
productsALTER TABLE
productsADD PRIMARY KEY (
ProductID),ADD KEY
CategoryID(CategoryID),ADD KEY
SupplierID(SupplierID);--
-- Indexes for table
shippersALTER TABLE
shippersADD PRIMARY KEY (
ShipperID);--
-- Indexes for table
suppliersALTER TABLE
suppliersADD PRIMARY KEY (
SupplierID);--
-- AUTO_INCREMENT for dumped tables
--
-- AUTO_INCREMENT for table
categoriesALTER TABLE
categoriesMODIFY
CategoryIDint(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;--
-- AUTO_INCREMENT for table
customersALTER TABLE
customersMODIFY
CustomerIDint(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=92;--
-- AUTO_INCREMENT for table
employeesALTER TABLE
employeesMODIFY
EmployeeIDint(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;--
-- AUTO_INCREMENT for table
ordersALTER TABLE
ordersMODIFY
OrderIDint(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10444;--
-- AUTO_INCREMENT for table
order_detailsALTER TABLE
order_detailsMODIFY
OrderDetailIDint(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=519;--
-- AUTO_INCREMENT for table
productsALTER TABLE
productsMODIFY
ProductIDint(11) NOT NULL AUTO_INCREMENT, AUTO_INCRE...