diff options
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() |