remove auto_increment from sql dump

diff --git a/data/schema.sql b/data/schema.sql
index 61eae79cc0136097ad1d47bedfcfa02790b451fb..25e7cada8436ea6bfac815a0f295ff13c24d2f0d 100644 (file)
--- 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`)
   `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` (
 
 
 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`)
   `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 da33d4215d6d3c1a7aa6089b0a52323652859c58..a6dbca9fc7e9690a8cacdb25b0fd0d21cc17627d 100755 (executable)
--- a/scripts/dump-schema.sh
+++ b/scripts/dump-schema.sh
@@ -10,4 +10,5 @@ mysqldump\
  anoweco\
  | grep -v '^/\\*'\
  | grep -v '^--'\
  anoweco\
  | grep -v '^/\\*'\
  | grep -v '^--'\

+ | sed 's/AUTO_INCREMENT=[0-9]* //'\

  > ../data/schema.sql
  > ../data/schema.sql