diff options
| -rw-r--r-- | pkg/datamaps/db.go | 10 |
1 files changed, 7 insertions, 3 deletions
diff --git a/pkg/datamaps/db.go b/pkg/datamaps/db.go index 4c3605c..ad388e2 100644 --- a/pkg/datamaps/db.go +++ b/pkg/datamaps/db.go @@ -18,8 +18,11 @@ func setupDB(path string) (*sql.DB, error) { DROP TABLE IF EXISTS datamap_line; DROP TABLE IF EXISTS return; DROP TABLE IF EXISTS return_data; - CREATE TABLE datamap(id INTEGER PRIMARY KEY, name TEXT, date_created TEXT); - DROP TABLE IF EXISTS datamap_line; + + CREATE TABLE datamap( + id INTEGER PRIMARY KEY, + name TEXT, + date_created TEXT); CREATE TABLE datamap_line( id INTEGER PRIMARY KEY, @@ -31,10 +34,11 @@ func setupDB(path string) (*sql.DB, error) { REFERENCES datamap(id) ON DELETE CASCADE ); + CREATE TABLE return( id INTEGER PRIMARY KEY, name TEXT, - data_created TEXT + date_created TEXT ); CREATE TABLE return_data( id INTEGER PRIMARY KEY, |