diff options
author | MikunoNaka <bokuwakanojogahoshii@yahoo.com> | 2021-07-12 12:14:35 +0530 |
---|---|---|
committer | MikunoNaka <bokuwakanojogahoshii@yahoo.com> | 2021-07-12 12:14:35 +0530 |
commit | 6baad020ce5037a90d902c8f41f1f37f52419a10 (patch) | |
tree | 7b69f6b7b6bc70c2d7edb3e881d8dbf2dca01109 /server/database/database.go | |
parent | 554a99c96d223eacc4bb6e10e3f6ad1712397f3a (diff) |
Added support for more client details in server
Diffstat (limited to 'server/database/database.go')
-rw-r--r-- | server/database/database.go | 18 |
1 files changed, 14 insertions, 4 deletions
diff --git a/server/database/database.go b/server/database/database.go index 0499b68..68c3c76 100644 --- a/server/database/database.go +++ b/server/database/database.go @@ -13,6 +13,14 @@ import ( _ "github.com/mattn/go-sqlite3" ) +type Address struct { + AddressLine string + City string + State string + PINCode string + Country string +} + var myDatabase *sql.DB func InitDB() { myDatabase, _ = sql.Open("sqlite3", "./openbills.db") @@ -33,10 +41,12 @@ func InitDB() { init_people, _ := myDatabase.Prepare( `CREATE TABLE IF NOT EXISTS People (id INTEGER PRIMARY KEY AUTOINCREMENT, - Name TEXT, - Address TEXT, - Phone TEXT, - Email TEXT)`, + Name TEXT, + Phone TEXT, + Email TEXT, + BillAddress BLOB, + ShipAddress BLOB, + GSTIN TEXT)`, ) init_people.Exec() |