added new article field to store a menu value which can be filtered in certain articl...

[bse.git] / schema / bse.sql

diff --git a/schema/bse.sql b/schema/bse.sql
index cf223f4a3cb58aeef54da6cc44988bc22e42f38d..d63eba94ce95457675866ba3537ef94807e7c0fd 100644 (file)
--- a/schema/bse.sql
+++ b/schema/bse.sql
@@ -90,6 +90,10 @@ CREATE TABLE article (
   -- x just so we don't get a name issue with product
   summaryx text default '' not null,
 
+  -- added by adrian
+  -- filter menu value in allkids_of iterators
+  menu smallint(5) not null default 0,
+  
   PRIMARY KEY (id),
 
   -- if we keep id in the indexes MySQL will sometimes be able to