diff options
| author | Savetheinternet <savetheinternet@n0v4.com> | 2011-04-12 21:11:32 +1000 |
|---|---|---|
| committer | Savetheinternet <savetheinternet@n0v4.com> | 2011-04-12 21:11:32 +1000 |
| commit | 339cb932e2782425bffe3fafe586ae5bfcd837fb (patch) | |
| tree | 95f64df47c5b1f3393b57b1cd61fcaebfe550ddd | |
| parent | c596d457112bb3288c0d650884022f72a9d7f35c (diff) | |
Fix AUTO_INCREMENT in SQL dumps
| -rw-r--r-- | install.sql | 6 | ||||
| -rw-r--r-- | templates/posts.sql | 2 |
2 files changed, 4 insertions, 4 deletions
diff --git a/install.sql b/install.sql index 3e85de98..4ceb4c85 100644 --- a/install.sql +++ b/install.sql @@ -45,7 +45,7 @@ CREATE TABLE IF NOT EXISTS `boards` ( PRIMARY KEY (`id`), UNIQUE KEY `uri` (`uri`), UNIQUE KEY `id` (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ; +) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- Dumping data for table `boards` @@ -106,7 +106,7 @@ CREATE TABLE IF NOT EXISTS `mods` ( `type` smallint(1) NOT NULL COMMENT '0: janitor, 1: mod, 2: admin', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`,`username`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; +) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- Dumping data for table `mods` @@ -204,7 +204,7 @@ CREATE TABLE IF NOT EXISTS `posts_b` ( `sticky` int(1) NOT NULL, `locked` int(1) NOT NULL, UNIQUE KEY `id` (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ; +) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -- Dumping data for table `posts_b` diff --git a/templates/posts.sql b/templates/posts.sql index d57ee568..2eb22d92 100644 --- a/templates/posts.sql +++ b/templates/posts.sql @@ -23,4 +23,4 @@ CREATE TABLE IF NOT EXISTS `posts_{board}` ( `sticky` int(1) NOT NULL, `locked` int(1) NOT NULL, UNIQUE KEY `id` (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;
\ No newline at end of file +) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
\ No newline at end of file |