From 7c9ce0f6bc22dce98216a959ec11182e7af9e790 Mon Sep 17 00:00:00 2001
From: Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com>
Date: Wed, 12 Jul 2023 12:11:56 +0300
Subject: fix: turn back to serials

Former-commit-id: 9c83d4ac7297c7306f4872d76334507fa09cbde9
---
 backend/database/init.sql | 12 ++++++------
 1 file changed, 6 insertions(+), 6 deletions(-)

(limited to 'backend/database/init.sql')

diff --git a/backend/database/init.sql b/backend/database/init.sql
index 196cb71..50e7c15 100644
--- a/backend/database/init.sql
+++ b/backend/database/init.sql
@@ -9,14 +9,14 @@ CREATE TABLE users (
 );
 
 CREATE TABLE games (
-  id SMALLSERIAL,
+  id SERIAL,
   name TEXT NOT NULL,
   is_coop BOOLEAN NOT NULL,
   PRIMARY KEY (id)
 );
 
 CREATE TABLE chapters (
-  id SMALLSERIAL,
+  id SERIAL,
   game_id SMALLINT NOT NULL,
   name TEXT NOT NULL,
   PRIMARY KEY (id),
@@ -24,13 +24,13 @@ CREATE TABLE chapters (
 );
 
 CREATE TABLE categories (
-  id SMALLSERIAL,
+  id SERIAL,
   name TEXT NOT NULL,
   PRIMARY KEY (id)
 );
 
 CREATE TABLE maps (
-  id SMALLSERIAL,
+  id SERIAL,
   game_id SMALLINT NOT NULL,
   chapter_id SMALLINT NOT NULL,
   name TEXT NOT NULL,
@@ -41,7 +41,7 @@ CREATE TABLE maps (
 );
 
 CREATE TABLE map_routes (
-  id SMALLSERIAL,
+  id SERIAL,
   map_id SMALLINT NOT NULL,
   category_id SMALLINT NOT NULL,
   score_count SMALLINT NOT NULL,
@@ -54,7 +54,7 @@ CREATE TABLE map_routes (
 );
 
 CREATE TABLE map_history (
-  id SMALLSERIAL,
+  id SERIAL,
   map_id SMALLINT NOT NULL,
   category_id SMALLINT NOT NULL,
   user_name TEXT NOT NULL,
-- 
cgit v1.2.3

