[Xoops-cvs2] xoops2/modules/news/sql mysql.sql,1.1,1.2

[<ok...@us...>]

Update of /cvsroot/xoops/xoops2/modules/news/sql
In directory sc8-pr-cvs1:/tmp/cvs-serv14503/modules/news/sql

Modified Files:
	mysql.sql 
Log Message:
added global comments feature

Index: mysql.sql
===================================================================
RCS file: /cvsroot/xoops/xoops2/modules/news/sql/mysql.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** mysql.sql	2 Jan 2003 19:22:36 -0000	1.1
--- mysql.sql	7 Jan 2003 21:32:33 -0000	1.2
***************
*** 1,34 ****
- # phpMyAdmin MySQL-Dump
- # version 2.2.2
- # http://phpwizard.net/phpMyAdmin/
- # http://phpmyadmin.sourceforge.net/ (download page)
- #
- # --------------------------------------------------------
- 
- #
- # Table structure for table `comments`
- #
- 
- CREATE TABLE comments (
-   comment_id int(8) unsigned NOT NULL auto_increment,
-   pid int(8) unsigned NOT NULL default '0',
-   item_id int(8) unsigned NOT NULL default '0',
-   date int(10) NOT NULL default '0',
-   user_id int(5) NOT NULL default '0',
-   ip varchar(15) NOT NULL default '',
-   subject varchar(255) default NULL,
-   comment text NOT NULL,
-   nohtml tinyint(1) NOT NULL default '0',
-   nosmiley tinyint(1) NOT NULL default '0',
-   noxcode tinyint(1) NOT NULL default '0',
-   icon varchar(25) NOT NULL default '',
-   PRIMARY KEY  (comment_id),
-   KEY pid (pid),
-   KEY item_id (item_id),
-   KEY user_id (user_id),
-   KEY subject (subject(40))
- ) TYPE=MyISAM;
- # --------------------------------------------------------
- 
  #
  # Table structure for table `stories`
--- 1,2 ----
***************
*** 76,78 ****
  ) TYPE=MyISAM;
  
! INSERT INTO topics VALUES (1,0,'xoops.gif','XOOPS')
\ No newline at end of file
--- 44,46 ----
  ) TYPE=MyISAM;
  
! INSERT INTO topics VALUES (1,0,'xoops.gif','XOOPS');