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)\" />');
|