spring-framework/08-bank-jdbc-servlet-webapp/misc/postgressql-schema.sql


1
2
3
4
5
6
7
8
9
10

CREATE TABLE account (
  account_number int(11) primary key NOT NULL,
  balance float DEFAULT NULL
);

CREATE SEQUENCE account_account_number_seq;

ALTER TABLE account
    ALTER COLUMN account_number
        SET DEFAULT NEXTVAL('account_account_number_seq');