/* Copyright (c) 1993 by the Oracle Corporation				 */

/* -------------------------------------------------------------------- */
/* NAME         ACCDMBLD.SQL - SQL script to create demo tables under   */
/*              MS Access database. 	                      	        */
/*                                                                      */
/* NOTES        This file uses native datatypes to create table         */
/*              definition. It is database specific and thus is not     */
/*              portable. Use demodata.sql afterwards to insert the  	*/
/*		demo data.							*/
/*                                                                      */
/* OWNER        OCA Manager                                             */
/*                                                                      */
/* MODIFIED                                                             */
/*  				                                	*/
/* -------------------------------------------------------------------- */

SPOOL ACCDMBLD.LOG


DROP table DEPT;
DROP table EMP;

/* Create tables 							*/

CREATE TABLE DEPT (
 DEPTNO              smallint,
 DNAME               varchar(14),
 LOC                 varchar(13));

CREATE TABLE EMP (
 EMPNO               integer , 
 ENAME               varchar(10),
 JOB                 varchar(9),
 MGR                 integer ,
 HIREDATE            DATE,
 SAL                 float,
 COMM                float,
 DEPTNO              smallint );

Create unique index i_dept on dept(deptno);

Create unique index i_emp on emp(empno);

SPOOL OFF
