diff options
| -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 |