#!/bin/sh

# example5-2.sh

#  generate a table with  1000 rows for a table called keys with 2 columns and let
#  oragen autoname the columns

#  first column of varchar2 which is unique of length 2 and in lowercase
#  second column of varchar2 of length 20

echo "redirecting output to keys2.sql"

../../oragen --gen-table --rows 1000 --table-name keys2 \
          --varchar2 --unique --length 2 -c \
          --varchar2 --unique --length 30 -c \
          > keys2.sql

echo
echo "now add a primary key on col1 by doing a "
echo -e "\"alter table keys2 add constraint keys_primary_key primary key (col1);\"\n";