! Copyright © Oracle Corporation 1995.  All Rights Reserved.
!
!  SQL$TEXT_FIELDS.SQL
!
! This SQL command procedure creates the database and tables
! used by SQL$TEXT_FIELDS.C
! You need a CDD dictionary in order to run this application.
! 
!
SET VERIFY
CREATE DATABASE FILENAME SUPPLIES PATHNAME 'CDD$DEFAULT.SUPPLIES';
CREATE TABLE SOURCES (SNUM CHAR (5), SNAME CHAR (20), STATUS SMALLINT, CITY CHAR(15));
CREATE TABLE PARTS (PNUM CHAR (6), PNAME CHAR(20), 	COLOR CHAR(6), 
		WEIGHT SMALLINT, CITY CHAR(15));
INSERT INTO PARTS ( PNUM, PNAME, COLOR, WEIGHT, CITY )
VALUES ('P1', 'Pens', 'Red', 12, 'London' );
COMMIT;
DISCONNECT ALL;
EXIT;