/* Copyright (c) 1997 by the Oracle Corporation */
/*
** ------------------------------------------------------------------
** NAME         INGDMBLD.SQL - SQL script to create demo tables under
**              an Ingres database.                                   
**                                                                     
** ------------------------------------------------------------------
** NOTES        This file uses native datatypes to create table        
**              definitions. The script may not be portable to other    
**              databases. Use DEMODATA.sql to insert the data     	
**                                                                     
** To run this script, please use SQL*Plus with syntax similar to :-
**
** plus33w.exe scott/tiger@odbc:ING64 @ingvubld.sql 
** 
** where scott is the user name, tiger the password, ING64 the ODBC
** datasource, ingvubld.sql the sql script.
**
*/

SPOOL INGDMBLD.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
