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

/* -------------------------------------------------------------------- */
/* NAME         SQSDMBLD.SQL - SQL script to create demo tables under   */
/*              Sybase System 10  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 SYBDMBLD.LOG

SET AUTOCOMMIT ON

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
