From a9d650a45c62c311b36b229702079bca1c3bb715 Mon Sep 17 00:00:00 2001
From: Christian Weiske <cweiske@cweiske.de>
Date: Wed, 3 Aug 2016 22:54:33 +0200
Subject: [PATCH] remove auto_increment from sql dump

---
 data/schema.sql        | 4 ++--
 scripts/dump-schema.sh | 1 +
 2 files changed, 3 insertions(+), 2 deletions(-)

diff --git a/data/schema.sql b/data/schema.sql
index 61eae79..25e7cad 100644
--- a/data/schema.sql
+++ b/data/schema.sql
@@ -9,7 +9,7 @@ CREATE TABLE `comments` (
   `comment_type` varchar(32) NOT NULL,
   `comment_json` mediumtext NOT NULL,
   PRIMARY KEY (`comment_id`)
-) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 
 CREATE TABLE `users` (
@@ -18,6 +18,6 @@ CREATE TABLE `users` (
   `user_email` varchar(256) NOT NULL,
   `user_imageurl` varchar(1024) NOT NULL,
   PRIMARY KEY (`user_id`)
-) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 
diff --git a/scripts/dump-schema.sh b/scripts/dump-schema.sh
index da33d42..a6dbca9 100755
--- a/scripts/dump-schema.sh
+++ b/scripts/dump-schema.sh
@@ -10,4 +10,5 @@ mysqldump\
  anoweco\
  | grep -v '^/\\*'\
  | grep -v '^--'\
+ | sed 's/AUTO_INCREMENT=[0-9]* //'\
  > ../data/schema.sql
-- 
2.30.2