diff options
| author | Savetheinternet <savetheinternet@tinyboard.org> | 2011-10-10 22:39:14 +1100 |
|---|---|---|
| committer | Savetheinternet <savetheinternet@tinyboard.org> | 2011-10-10 22:39:14 +1100 |
| commit | f600ed5b3b3f7ce2a99bc2e07ae361f89f6ac422 (patch) | |
| tree | 8a16bf6e07be62cad4184fe72360b3ad3ea2a769 | |
| parent | 94cb6bf8ab4b295d639847e2d7dc904f2b4123da (diff) | |
update SQL files for v0.9.4-dev-2
| -rw-r--r-- | install.sql | 1 | ||||
| -rw-r--r-- | templates/posts.sql | 3 |
2 files changed, 3 insertions, 1 deletions
diff --git a/install.sql b/install.sql index dc2c58f2..00c67162 100644 --- a/install.sql +++ b/install.sql @@ -203,6 +203,7 @@ CREATE TABLE IF NOT EXISTS `posts_b` ( `ip` varchar(45) NOT NULL, `sticky` int(1) NOT NULL, `locked` int(1) NOT NULL, + `sage` int(1) NOT NULL, `embed` text, UNIQUE KEY `id` (`id`), KEY `thread` (`thread`), diff --git a/templates/posts.sql b/templates/posts.sql index c8a4bdc6..e3a81ee1 100644 --- a/templates/posts.sql +++ b/templates/posts.sql @@ -22,9 +22,10 @@ CREATE TABLE IF NOT EXISTS `posts_{{ board }}` ( `ip` varchar(45) NOT NULL,
`sticky` int(1) NOT NULL,
`locked` int(1) NOT NULL,
+ `sage` int(1) NOT NULL,
`embed` text,
UNIQUE KEY `id` (`id`),
KEY `thread` (`thread`),
KEY `time` (`time`),
FULLTEXT KEY `body` (`body`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
\ No newline at end of file +) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
|