From 1c121c8245689598c568a71a3f4c2bb176fc634c Mon Sep 17 00:00:00 2001 From: Gabriel Dunne Date: Thu, 29 Dec 2011 21:38:28 -0800 Subject: [PATCH] update sql --- clmpr.sql | 2 ++ 1 file changed, 2 insertions(+) diff --git a/clmpr.sql b/clmpr.sql index 2744270..e4b505f 100644 --- a/clmpr.sql +++ b/clmpr.sql @@ -10,8 +10,10 @@ CREATE TABLE `clumps` ( `description` text NOT NULL, `tags` text NOT NULL, `date` datetime NOT NULL, + `private` tinyint(4) NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `date` (`date`), + KEY `private` (`private`), FULLTEXT KEY `tags` (`tags`) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; -- 2.34.1