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

/* -------------------------------------------------------------------- */
/* NAME         NSSDMBLD.SQL - SQL script to create demo tables under   */
/*              NonStop SQL Tandem  database.                     	*/
/*                                                                      */
/* NOTES        This file uses native datatypes to create table         */
/*              definition. It is database specific and thus is not     */
/*              portable. Use DEMODATA.SQL to insert  data		*/ 						*/
/*                                                                      */
/* OWNER        OCA Manager                                             */
/*                                                                      */
/* MODIFIED                                                             */
/*  				                                	*/
/* -------------------------------------------------------------------- */

SPOOL NSSDMBLD.LOG


DROP table DEPT;
DROP table EMP;

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

SPOOL OFF
