Bugfix. (database)

1 files changed, 4 insertions, 4 deletions

diff --git a/crawler/database.go b/crawler/database.go
index 4245c4e..278d891 100644
--- a/crawler/database.go
+++ b/crawler/database.go
@@ -48,12 +48,12 @@ func (app *App) createTables() error {
 
 	for _, v := range views {
 		var spirit_type string
-		if v != "misc" {
-			spirit_type = `spirit_type = "` + v + `" AND`
+		if v == "misc" {
+			spirit_type = `spirit_type NOT IN ("` + strings.Join(views, `", "`) + `") AND`
 		} else if v == "all" {
-			spirit_type = ""
+			spirit_type = "1 = 1 AND "
 		} else {
-			spirit_type = `spirit_type NOT IN ("` + strings.Join(views, `", "`) + `") AND`
+			spirit_type = `spirit_type = "` + v + `" AND`
 		}
 
 		view_query := `CREATE OR REPLACE VIEW ` + v + `_view AS