From 878feaa600deb39ba2466e798e1092423f5f615c Mon Sep 17 00:00:00 2001
From: Emile <hanemile@protonmail.com>
Date: Thu, 7 Mar 2019 17:28:57 +0100
Subject: :bug: fixed the broken sql queries

---
 backend/init.go | 56 ++++++++++++++++++++++++++++++++++++--------------------
 1 file 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)
 	}
-- 
cgit 1.4.1