Versions Compared

Old Version 33

changes.mady.by.user Former user

Saved on

compared with

New Version 34

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Install the MySQL server.
  2. Download the JDBC driver for MySQL from here and copy it to your <DSS_HOME>/repository/components/lib directory.
  3. Set up a database for storing information of offices:

    1. Create a database called OfficeDetails.: CREATE DATABASE OfficeDetails;

    2. Create the Offices table:

      Code Block
      USE OfficeDetails;
CREATE TABLE `OFFICES``Offices` (`OfficeCode` int(11) NOT NULL, `AddressLine1` varchar(255) NOT NULL, `AddressLine2` varchar(255) DEFAULT NULL, `City` varchar(255) DEFAULT NULL, `State` varchar(255) DEFAULT NULL, `Country` varchar(255) DEFAULT NULL, `Phone` varchar(255) DEFAULT NULL, PRIMARY KEY (`OfficeCode`));
  4. Set up a database for storing information of employees:
    1. Create a database called EmployeeDetails.: CREATE DATABASE EmployeeDetails;

    2. Create the Employees table:

      Code Block
      USE EmployeeDetails;
CREATE TABLE `EMPLOYEES``Employees` (`EmployeeNumber` int(11) NOT NULL, `FirstName` varchar(255) NOT NULL, `LastName` varchar(255) DEFAULT NULL, `Email` varchar(255) DEFAULT NULL, `JobTitle` varchar(255) DEFAULT NULL, `OfficeCode` int(11) NOT NULL, PRIMARY KEY (`EmployeeNumber`));

...