aboutsummaryrefslogtreecommitdiff
path: root/server/database/database.go
diff options
context:
space:
mode:
authorMikunoNaka <bokuwakanojogahoshii@yahoo.com>2021-07-12 12:14:35 +0530
committerMikunoNaka <bokuwakanojogahoshii@yahoo.com>2021-07-12 12:14:35 +0530
commit6baad020ce5037a90d902c8f41f1f37f52419a10 (patch)
tree7b69f6b7b6bc70c2d7edb3e881d8dbf2dca01109 /server/database/database.go
parent554a99c96d223eacc4bb6e10e3f6ad1712397f3a (diff)
Added support for more client details in server
Diffstat (limited to 'server/database/database.go')
-rw-r--r--server/database/database.go18
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()