Hi,
I am facing the same issue that you have mentioned :
[java] SQL Error at line 321: java.sql.SQLException: Unexpected token: CONSTRAINT in statement [
[java]
[java]
[java] CREATE TABLE ACCOUNT (
[java] account_id VARCHAR(8) CONSTRAINT]
Would really appreciate if someone could point out why this issue is happening. Below si the extract from the script that it is trying to run :
// Create tables for Duke's Bank, the tutorial's online banking application.
// Also seed the NEXT_ID table with initial values.
DROP TABLE customer_account_xref if exists;
DROP TABLE tx if exists;
DROP TABLE customer if exists;
DROP TABLE account if exists;
DROP TABLE next_tx_id if exists;
DROP TABLE next_customer_id if exists;
DROP TABLE next_account_id if exists;
CREATE TABLE ACCOUNT (
account_id VARCHAR(8) CONSTRAINT pk_account PRIMARY KEY,
type VARCHAR(24),
description VARCHAR(30),
balance NUMERIC(10,2),
credit_line NUMERIC(10,2),
begin_balance NUMERIC(10,2),
begin_balance_time_stamp TIMESTAMP);
CREATE TABLE CUSTOMER (
customer_id VARCHAR(8) CONSTRAINT pk_customer PRIMARY KEY,
last_name VARCHAR(30),
first_name VARCHAR(30),
middle_initial VARCHAR(1),
street VARCHAR(40),
city VARCHAR(40),
state VARCHAR(2),
zip VARCHAR(5),
phone VARCHAR(16),
email VARCHAR(30));