/* $Id: rdbdmbld.sql,v 1.1 1998/03/26 22:00:35 yxia Exp $		*/
/* $Log: rdbdmbld.sql,v $
# Revision 1.1  1998/03/26  22:00:35  yxia
# Initial revision
#
# Revision 1.1  1997/09/03  21:53:27  bgutierr
# Initial revision
#
# Revision 1.4  1997/07/09  23:41:58  aclarke
# log: OCA 2.0.2.11.0 files.
#
# Revision 1.1  1996/02/06  18:05:44  kmuniasa
# log: Initial version for d2 1.3 release.
#	*/
/* Copyright (c) 1993 by the Oracle Corporation */

/* -------------------------------------------------------------------- */
/* NAME         RDBDMBLD.SQL - SQL script to create demo tables under   */
/*              RDB database.                                		*/
/*                                                                      */
/* NOTES        This file uses native datatypes to create table         */
/*              definition. The script may not be portable to other     */
/*              databases. Use DEMODATA.sql 		to insert  	*/
/*		data     				                */
/*                                                                      */
/* OWNER        	                                                */
/*                                                                      */
/* MODIFIED   
/*   kmuniasa   03/03/95 - Modofied for RDB                             */
/*   hthio      11/02/93 - Created                                      */
/* -------------------------------------------------------------------- */

SPOOL RDBDMBLD.LOG

DROP table DEPT;
DROP table EMP;

CREATE TABLE DEPT (
   DEPTNO smallint ,
   DNAME varchar (  14 )  ,
   LOC varchar (  13 )  
 ) ;
CREATE TABLE EMP (
   EMPNO smallint ,
   ENAME varchar (  10 )  ,
   JOB varchar (  9 )  ,
   MGR smallint ,
   HIREDATE date ,
   SAL float ,
   COMM float ,
   DEPTNO smallint 
 ) ;

SPOOL OFF
