DELETE FROM Emoticon WHERE EmoticonId = '1'; DELETE FROM Emoticon WHERE EmoticonId = '2'; DELETE FROM Emoticon WHERE EmoticonId = '3'; DELETE FROM Emoticon WHERE EmoticonId = '4'; DELETE FROM Emoticon WHERE EmoticonId = '5'; DELETE FROM Emoticon WHERE EmoticonId = '6'; DELETE FROM Emoticon WHERE EmoticonId = '7'; DELETE FROM Emoticon WHERE EmoticonId = '8'; DELETE FROM Emoticon WHERE EmoticonId = '9'; DELETE FROM Emoticon WHERE EmoticonId = '10'; DELETE FROM Emoticon WHERE EmoticonId = '11'; DELETE FROM Emoticon WHERE EmoticonId = '12'; DELETE FROM Emoticon WHERE EmoticonId = '13'; DELETE FROM Emoticon WHERE EmoticonId = '14'; DELETE FROM Emoticon WHERE EmoticonId = '15'; DELETE FROM Emoticon WHERE EmoticonId = '16'; DELETE FROM Emoticon WHERE EmoticonId = '17'; DELETE FROM Emoticon WHERE EmoticonId = '18'; DELETE FROM Emoticon WHERE EmoticonId = '19'; DELETE FROM Emoticon WHERE EmoticonId = '20'; INSERT INTO Emoticon (EmoticonId, Name, ImageId, KeyStroke, Enabled) VALUES (1, 'Happy Smile', 1, ':)', 1); INSERT INTO Emoticon (EmoticonId, Name, ImageId, KeyStroke, Enabled) VALUES (2, 'Big Grin', 2, ':grin:', 1); INSERT INTO Emoticon (EmoticonId, Name, ImageId, KeyStroke, Enabled) VALUES (3, 'Wink', 3, ';)', 1); INSERT INTO Emoticon (EmoticonId, Name, ImageId, KeyStroke, Enabled) VALUES (4, 'Scared', 4, ':scared:', 1); INSERT INTO Emoticon (EmoticonId, Name, ImageId, KeyStroke, Enabled) VALUES (5, 'Teasing', 5, ':eek:', 1); INSERT INTO Emoticon (EmoticonId, Name, ImageId, KeyStroke, Enabled) VALUES (6, 'Cool', 6, ':cool:', 1); INSERT INTO Emoticon (EmoticonId, Name, ImageId, KeyStroke, Enabled) VALUES (7, 'Angry', 7, ':@', 1); INSERT INTO Emoticon (EmoticonId, Name, ImageId, KeyStroke, Enabled) VALUES (8, 'Squint', 8, ':squint:', 1); INSERT INTO Emoticon (EmoticonId, Name, ImageId, KeyStroke, Enabled) VALUES (9, 'Oops', 9, ':o', 1); INSERT INTO Emoticon (EmoticonId, Name, ImageId, KeyStroke, Enabled) VALUES (10, 'Sad', 10, ':(', 1); INSERT INTO Emoticon (EmoticonId, Name, ImageId, KeyStroke, Enabled) VALUES (11, 'Cry', 11, ':cry:', 1); INSERT INTO Emoticon (EmoticonId, Name, ImageId, KeyStroke, Enabled) VALUES (12, 'Smirk', 12, ';]', 1); INSERT INTO Emoticon (EmoticonId, Name, ImageId, KeyStroke, Enabled) VALUES (13, 'Happy sleep', 13, ':sleep:', 1); INSERT INTO Emoticon (EmoticonId, Name, ImageId, KeyStroke, Enabled) VALUES (14, 'Very angry', 14, ':x', 1); INSERT INTO Emoticon (EmoticonId, Name, ImageId, KeyStroke, Enabled) VALUES (15, 'Geek', 15, ':geek:', 1); INSERT INTO Emoticon (EmoticonId, Name, ImageId, KeyStroke, Enabled) VALUES (16, 'Upset', 16, ';(', 1); INSERT INTO Emoticon (EmoticonId, Name, ImageId, KeyStroke, Enabled) VALUES (17, 'LOL', 17, ':lol:', 1); INSERT INTO Emoticon (EmoticonId, Name, ImageId, KeyStroke, Enabled) VALUES (18, 'Yawn', 18, ':O', 1); INSERT INTO Emoticon (EmoticonId, Name, ImageId, KeyStroke, Enabled) VALUES (19, 'Thinking', 19, ':hm:', 1); INSERT INTO Emoticon (EmoticonId, Name, ImageId, KeyStroke, Enabled) VALUES (20, 'Secret', 20, ':|', 1); UPDATE Modules SET Version = '1.0.5' WHERE Name = 'In-Bulletin';