Improve page layout, add navbar

2 files changed, 3 insertions, 1 deletions

diff --git a/cmd/parser/main.go b/cmd/parser/main.go
index bf79439..6d3c3c4 100644
--- a/cmd/parser/main.go
+++ b/cmd/parser/main.go
@@ -123,7 +123,7 @@ func main() {
 
 	_, table_check := db.Query("SELECT * FROM posts;")
 	if table_check != nil {
-		_, err = db.Exec("CREATE TABLE posts (id SERIAL PRIMARY KEY, name VARCHAR(50) NOT NULL, time DATE DEFAULT CURRENT_DATE, content TEXT NOT NULL);")
+		_, err = db.Exec("CREATE TABLE posts (id SERIAL PRIMARY KEY, name VARCHAR(50) NOT NULL, time TIMESTAMP DEFAULT CURRENT_TIMESTAMP, content TEXT NOT NULL);")
 		if err != nil {
 			fmt.Fprintf(os.Stderr, "Unable to create posts table: %v\n", err)
 			os.Exit(1)
diff --git a/cmd/web/handlers/blog.go b/cmd/web/handlers/blog.go
index 07ab361..bd2d97f 100644
--- a/cmd/web/handlers/blog.go
+++ b/cmd/web/handlers/blog.go
@@ -18,6 +18,8 @@ type blogContext struct {
 }
 
 func (ctx *blogContext) index(w http.ResponseWriter, r *http.Request) {
+	ctx.Rows = []models.Post{}
+
 	if r.URL.Path != "/" {
 		http.NotFound(w, r)
 		return