[Jaws-project-commits] jaws/html/gadgets/Faq/sql MySQL.sql,1.2,1.3

[Jonathan H. <io...@us...>]

Update of /cvsroot/jaws-project/jaws/html/gadgets/Faq/sql
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv16992/sql

Modified Files:
	MySQL.sql 
Log Message:
Support categories in FAQ ;-)

Index: MySQL.sql
===================================================================
RCS file: /cvsroot/jaws-project/jaws/html/gadgets/Faq/sql/MySQL.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** MySQL.sql	14 Mar 2005 19:36:54 -0000	1.2
--- MySQL.sql	18 Mar 2005 01:59:59 -0000	1.3
***************
*** 1,8 ****
  CREATE TABLE [[faq]] (
!   faq_no int(11) NOT NULL auto_increment,
    question varchar(255) NOT NULL default '',
    answer TEXT,
    createtime datetime NOT NULL default '0000-00-00 00:00:00',
    updatetime timestamp(14) NOT NULL,
!   PRIMARY KEY  (faq_no)
  ) TYPE=MyISAM;
--- 1,24 ----
+ CREATE TABLE [[faq_category]] (
+   id int(11) NOT NULL auto_increment,
+   category varchar(255) NOT NULL default '',
+   description TEXT,
+   position int(11) NOT NULL default 0,
+   updatetime timestamp(14) NOT NULL,
+   PRIMARY KEY  (id)
+ ) TYPE=MyISAM;
+ 
+ INSERT INTO [[faq_category]] values (1,'General', 'Here you can find General questions', 1, now());
+ 
  CREATE TABLE [[faq]] (
!   id int(11) NOT NULL auto_increment,
    question varchar(255) NOT NULL default '',
    answer TEXT,
+   category int(11) NOT NULL,
+   active int(1) default '1',
+   position int(11) NOT NULL default 0,
    createtime datetime NOT NULL default '0000-00-00 00:00:00',
    updatetime timestamp(14) NOT NULL,
!   PRIMARY KEY  (id)
  ) TYPE=MyISAM;
+ 
+ INSERT INTO [[faq]] VALUES (1,'What is JAWS?','Jaws is a Framework and Content Management System for building dynamic web sites. It aims to be User Friendly giving ease of use and lots of ways to customize web sites, but at the same time is Developer Frendly, it offers a simple and powerful framework to hack your own modules.',1,1,1,now(),now());