diff options
| author | Kamal Wickramanayake <kamal@inbox.lk> | 2026-05-16 21:18:32 +0530 |
|---|---|---|
| committer | Kamal Wickramanayake <kamal@inbox.lk> | 2026-05-16 21:18:32 +0530 |
| commit | e51834c899ff20781295410961934eb06239385c (patch) | |
| tree | 78f0058914063e37cbd6812d204e4f84efd0ab90 /spring-boot/03-bank-jdbc-rest/db-schema | |
| parent | b1d598a2f02819bc127d0d3522dc7ac91b4dee65 (diff) | |
Added spring-boot sample applications
Diffstat (limited to 'spring-boot/03-bank-jdbc-rest/db-schema')
| -rw-r--r-- | spring-boot/03-bank-jdbc-rest/db-schema/mariadb-schema.sql | 4 | ||||
| -rw-r--r-- | spring-boot/03-bank-jdbc-rest/db-schema/postgressql-schema.sql | 10 |
2 files changed, 14 insertions, 0 deletions
diff --git a/spring-boot/03-bank-jdbc-rest/db-schema/mariadb-schema.sql b/spring-boot/03-bank-jdbc-rest/db-schema/mariadb-schema.sql new file mode 100644 index 0000000..167aa55 --- /dev/null +++ b/spring-boot/03-bank-jdbc-rest/db-schema/mariadb-schema.sql @@ -0,0 +1,4 @@ +CREATE TABLE account ( + account_number int(11) primary key NOT NULL AUTO_INCREMENT, + balance float DEFAULT NULL +) Engine=InnoDB; diff --git a/spring-boot/03-bank-jdbc-rest/db-schema/postgressql-schema.sql b/spring-boot/03-bank-jdbc-rest/db-schema/postgressql-schema.sql new file mode 100644 index 0000000..6ed17fa --- /dev/null +++ b/spring-boot/03-bank-jdbc-rest/db-schema/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 |