diff options
Diffstat (limited to 'spring-framework/08-bank-jdbc-servlet-webapp/misc/postgressql-schema.sql')
| -rw-r--r-- | spring-framework/08-bank-jdbc-servlet-webapp/misc/postgressql-schema.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/spring-framework/08-bank-jdbc-servlet-webapp/misc/postgressql-schema.sql b/spring-framework/08-bank-jdbc-servlet-webapp/misc/postgressql-schema.sql new file mode 100644 index 0000000..6ed17fa --- /dev/null +++ b/spring-framework/08-bank-jdbc-servlet-webapp/misc/postgressql-schema.sql @@ -0,0 +1,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');
\ No newline at end of file |