// this line assumes that mymaster is the master password that you // provided during installation
\connect -d JP1 -u SUPERDBA,mymaster
//
DROP USER SAPDEMO
//
CREATE USER SAPDEMO PASSWORD SAPDEMO DBA NOT EXCLUSIVE
//
\disconnect
//
\connect -u SAPDEMO,SAPDEMO
//------------------------------------------------------------------
// Create tables for Car Rental Application
//------------------------------------------------------------------
CREATE TABLE BC_CR_CUSTOMER ( CUSTOMERID Varchar (10) UNICODE NOT NULL DEFAULT '0', FIRSTNAME Varchar (35) UNICODE NOT NULL DEFAULT '''', LASTNAME Varchar (35) UNICODE NOT NULL DEFAULT '''', USERNAME Varchar (50) UNICODE NOT NULL DEFAULT 'user', PASSWORD Varchar (10) UNICODE NOT NULL DEFAULT '''', FORM Varchar (10) UNICODE, COUNTRY Varchar (3) UNICODE NOT NULL DEFAULT '''', REGION Varchar (50) UNICODE, CITY Varchar (50) UNICODE NOT NULL DEFAULT '''', POSTALCODE Varchar (10) UNICODE NOT NULL DEFAULT '0', ADDRESS Varchar (100) UNICODE NOT NULL DEFAULT '''', DRIVERLICENSE Varchar (15) UNICODE NOT NULL DEFAULT '0', PASSPORTNR Varchar (15) UNICODE NOT NULL DEFAULT '0', PHONE Varchar (20) UNICODE, MOBILE Varchar (20) UNICODE, EMAIL Varchar (75) UNICODE, CREDITCARDID Varchar (16) UNICODE, CREDITCARDTYPE Varchar (20) UNICODE, COMPANY Varchar (50) UNICODE, USERTYPE Varchar (20) UNICODE NOT NULL DEFAULT 'regular customer', CUMULATEDVALUE Fixed (16,2) NOT NULL DEFAULT 0.00, PRIMARY KEY (CUSTOMERID) )
//
CREATE TABLE BC_CR_IDGENERATOR ( TABLENAME Varchar (50) UNICODE NOT NULL DEFAULT '''', LASTID Varchar (10) UNICODE NOT NULL DEFAULT '0', PRIMARY KEY (TABLENAME) )
//
CREATE TABLE BC_CR_LOCATION ( LOCATIONID Varchar (10) UNICODE NOT NULL DEFAULT ' ', COUNTRY Varchar (3) UNICODE NOT NULL DEFAULT '''', REGION Varchar (50) UNICODE, CITY Varchar (50) UNICODE NOT NULL DEFAULT '''', POSTALCODE Varchar (10) UNICODE NOT NULL DEFAULT '0', ADDRESS Varchar (100) UNICODE NOT NULL DEFAULT '''', PRIMARY KEY (LOCATIONID) )
//
CREATE TABLE BC_CR_RESERVATION ( ID Varchar (10) UNICODE NOT NULL DEFAULT '0', RESERVATIONDATE Timestamp NOT NULL, DATEFROM Timestamp, DATETO Timestamp, STATUS Varchar (20) UNICODE NOT NULL DEFAULT 'incomplete', EXPIREDDATE Timestamp NOT NULL, CUSTOMERID Varchar (10) UNICODE, VEHICLETYPEID Varchar (10) UNICODE, VEHICLEID Varchar (20) UNICODE, PICKUPLOCATION Varchar (10) UNICODE, DROPOFFLOCATION Varchar (10) UNICODE, PRIMARY KEY (ID) )
//
CREATE TABLE BC_CR_VEHICLE ( VEHICLEID Varchar (20) UNICODE NOT NULL DEFAULT '0', MAKE Varchar (50) UNICODE NOT NULL DEFAULT '''', MODEL Varchar (20) UNICODE NOT NULL DEFAULT ' ', FUEL Varchar (20) UNICODE NOT NULL DEFAULT 'patrol', CONSUMPTION Fixed (2,1) NOT NULL DEFAULT 0.0, SEATS Smallint NOT NULL DEFAULT 0, TANKVOLUME Smallint, MILEAGE Integer NOT NULL DEFAULT 0, DESCRIPTION Varchar (500) UNICODE, PICTURE Varchar (50) UNICODE, AVAILABILITY Varchar (20) UNICODE NOT NULL DEFAULT 'available', STATUS Varchar (20) UNICODE NOT NULL DEFAULT '0', LOCATIONID Varchar (10) UNICODE, TYPEID Varchar (10) UNICODE, PRIMARY KEY (VEHICLEID) )
//
CREATE TABLE BC_CR_VEHICLETYPE ( VEHICLETYPEID Varchar (10) UNICODE NOT NULL DEFAULT '0', NAME Varchar (50) UNICODE NOT NULL DEFAULT '''', DESCRIPTION Varchar (500) UNICODE, PRICE Fixed (16,2) NOT NULL DEFAULT 0.00, CURRENCY Varchar (5) UNICODE NOT NULL DEFAULT '''', COUNTRY Varchar (3) UNICODE NOT NULL DEFAULT '''', PICTURE Varchar (50) UNICODE NOT NULL DEFAULT '''', PRIMARY KEY (VEHICLETYPEID) )
//
\disconnect
|