From 4afcff940551079617e8f4116e52bb0ef9df7fcc Mon Sep 17 00:00:00 2001
From: Kamal Wickramanayake <kamal@inbox.lk>
Date: Sat, 25 Apr 2026 21:53:33 +0530
Subject: Added Spring Framework sample code

---
 .../08-bank-jdbc-servlet-webapp/misc/postgressql-schema.sql    | 10 ++++++++++
 1 file changed, 10 insertions(+)
 create mode 100644 spring-framework/08-bank-jdbc-servlet-webapp/misc/postgressql-schema.sql

(limited to 'spring-framework/08-bank-jdbc-servlet-webapp/misc/postgressql-schema.sql')

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
-- 
cgit v1.2.3

