[Openfirst-cvscommit] emoticon/setup setup.mysql,1.1,1.2

[<xt...@us...>]

Update of /cvsroot/openfirst/emoticon/setup
In directory sc8-pr-cvs1:/tmp/cvs-serv25223/setup

Modified Files:
	setup.mysql 
Log Message:
Change MySQL script to conform with new standard.

Index: setup.mysql
===================================================================
RCS file: /cvsroot/openfirst/emoticon/setup/setup.mysql,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** setup.mysql	8 Jun 2003 02:06:08 -0000	1.1
--- setup.mysql	21 Jun 2003 15:50:12 -0000	1.2
***************
*** 1,9 ****
! CREATE TABLE ofirst_emoticon (
! ID tinyint(3) unsigned NOT NULL auto_increment,
! emoticon text,
! substitution text,
! PRIMARY KEY  (ID)
! ) TYPE=MyISAM;
! 
  INSERT INTO ofirst_emoticon (emoticon, substitution) VALUES (':-)','<img src=\"http://openfirst.sourceforge.net/image/icon/emote/smile.png\" alt=\":-)\" title=\":-)\" />');
  INSERT INTO ofirst_emoticon (emoticon, substitution) VALUES (':-(','<img src=\"http://openfirst.sourceforge.net/image/icon/emote/frown.png\" alt=\":-(\" title=\":-(\" />');
--- 1,3 ----
! CREATE TABLE ofirst_emoticon (ID tinyint(3) unsigned NOT NULL auto_increment, emoticon text, substitution text, PRIMARY KEY  (ID)) TYPE=MyISAM;
  INSERT INTO ofirst_emoticon (emoticon, substitution) VALUES (':-)','<img src=\"http://openfirst.sourceforge.net/image/icon/emote/smile.png\" alt=\":-)\" title=\":-)\" />');
  INSERT INTO ofirst_emoticon (emoticon, substitution) VALUES (':-(','<img src=\"http://openfirst.sourceforge.net/image/icon/emote/frown.png\" alt=\":-(\" title=\":-(\" />');
***************
*** 444,446 ****
  INSERT INTO ofirst_emoticon (emoticon, substitution) VALUES ('(pphs)','<img src=\"http://openfirst.sourceforge.net/image/minipphs.png\" alt=\"(pphs)\" title=\"(pphs)\" />');
  INSERT INTO ofirst_emoticon (emoticon, substitution) VALUES ('(torch)','<img src=\"http://openfirst.sourceforge.net/image/minimascot.png\" alt=\"(torch)\" title=\"(torch)\" />');
! INSERT INTO ofirst_emoticon (emoticon, substitution) VALUES ('(first)','<img src=\"http://openfirst.sourceforge.net/image/icon/flag/first.png\" alt=\"(first)\" title=\"(first)\" />');
\ No newline at end of file
--- 438,440 ----
  INSERT INTO ofirst_emoticon (emoticon, substitution) VALUES ('(pphs)','<img src=\"http://openfirst.sourceforge.net/image/minipphs.png\" alt=\"(pphs)\" title=\"(pphs)\" />');
  INSERT INTO ofirst_emoticon (emoticon, substitution) VALUES ('(torch)','<img src=\"http://openfirst.sourceforge.net/image/minimascot.png\" alt=\"(torch)\" title=\"(torch)\" />');
! INSERT INTO ofirst_emoticon (emoticon, substitution) VALUES ('(first)','<img src=\"http://openfirst.sourceforge.net/image/icon/flag/first.png\" alt=\"(first)\" title=\"(first)\" />');