diff options
| -rw-r--r-- | backend/init.go | 56 |
1 files changed, 36 insertions, 20 deletions
diff --git a/backend/init.go b/backend/init.go index cae0e99..351028b 100644 --- a/backend/init.go +++ b/backend/init.go @@ -9,14 +9,20 @@ import ( func InitStarsTable(db *sql.DB) { query := `CREATE TABLE public.stars ( - star_id bigint NOT NULL DEFAULT nextval('stars_star_id_seq'::regclass), - x numeric, - y numeric, - vx numeric, - vy numeric, - m numeric + star_id bigserial, + x numeric, + y numeric, + vx numeric, + vy numeric, + m numeric, + PRIMARY KEY (star_id) ) -` + WITH ( + OIDS = FALSE + ); + +ALTER TABLE public.stars + OWNER to postgres;` _, err := db.Exec(query) if err != nil { log.Fatalf("[ E ] InitNodesTable query: %v \n\t\t\tquery: %s\n", err, query) @@ -25,21 +31,31 @@ func InitStarsTable(db *sql.DB) { // InitNodesTable initialises the nodes table func InitNodesTable(db *sql.DB) { + log.Println("creating the query") query := `CREATE TABLE public.nodes - ( - node_id bigint NOT NULL DEFAULT nextval('nodes_node_id_seq'::regclass), - box_width numeric NOT NULL, - total_mass numeric NOT NULL, - depth integer, - star_id bigint NOT NULL, - root_id bigint NOT NULL, - isleaf boolean, - box_center numeric[] NOT NULL, - center_of_mass numeric[] NOT NULL, - subnodes bigint[] NOT NULL - ) -` +( + node_id bigserial NOT NULL, + box_width numeric, + total_mass numeric, + depth integer, + star_id bigint, + root_id bigint, + isleaf boolean, + box_center numeric[], + center_of_mass numeric[], + subnodes bigint[], + PRIMARY KEY (node_id) +) + WITH ( + OIDS = FALSE + ); + +ALTER TABLE public.nodes + OWNER to postgres;` + log.Println("done creating the query") + log.Println("executing the query") _, err := db.Exec(query) + log.Println("done executing the query") if err != nil { log.Fatalf("[ E ] InitNodesTable query: %v \n\t\t\tquery: %s\n", err, query) } |
