ALTER TABLE sticker ADD COLUMN default_width integer NOT NULL DEFAULT 0;
ALTER TABLE sticker ADD COLUMN default_height integer NOT NULL DEFAULT 0;

UPDATE sticker SET default_width = 20, default_height = 20 WHERE category = 1;
UPDATE sticker SET default_width = 160, default_height = 160 WHERE category >= 2;

INSERT INTO sticker VALUES(101,5,'smile.png','/var/packages/MailClient/target/ui/images/emoji_new/face_01.png', 0, 24, 24);
INSERT INTO sticker VALUES(102,5,'laugh.png','/var/packages/MailClient/target/ui/images/emoji_new/face_02.png', 0, 24, 24);
INSERT INTO sticker VALUES(103,5,'make_faces.png','/var/packages/MailClient/target/ui/images/emoji_new/face_03.png', 0, 24, 24);
INSERT INTO sticker VALUES(104,5,'love.png','/var/packages/MailClient/target/ui/images/emoji_new/face_04.png', 0, 24, 24);
INSERT INTO sticker VALUES(105,5,'shy.png','/var/packages/MailClient/target/ui/images/emoji_new/face_05.png', 0, 24, 24);
INSERT INTO sticker VALUES(106,5,'expressionless.png','/var/packages/MailClient/target/ui/images/emoji_new/face_06.png', 0, 24, 24);

INSERT INTO sticker VALUES(107,5,'surprised.png','/var/packages/MailClient/target/ui/images/emoji_new/face_07.png', 0, 24, 24);
INSERT INTO sticker VALUES(108,5,'sigh.png','/var/packages/MailClient/target/ui/images/emoji_new/face_08.png', 0, 24, 24);
INSERT INTO sticker VALUES(109,5,'Sweating.png','/var/packages/MailClient/target/ui/images/emoji_new/face_09.png', 0, 24, 24);
INSERT INTO sticker VALUES(110,5,'cry.png','/var/packages/MailClient/target/ui/images/emoji_new/face_10.png', 0, 24, 24);
INSERT INTO sticker VALUES(111,5,'angry.png','/var/packages/MailClient/target/ui/images/emoji_new/face_11.png', 0, 24, 24);
INSERT INTO sticker VALUES(112,5,'threw_up.png','/var/packages/MailClient/target/ui/images/emoji_new/face_12.png', 0, 24, 24);

INSERT INTO sticker VALUES(113,5,'good.png','/var/packages/MailClient/target/ui/images/emoji_new/hand_01.png', 0, 24, 24);
INSERT INTO sticker VALUES(114,5,'ok.png','/var/packages/MailClient/target/ui/images/emoji_new/hand_02.png', 0, 24, 24);
INSERT INTO sticker VALUES(115,5,'please.png','/var/packages/MailClient/target/ui/images/emoji_new/hand_03.png', 0, 24, 24);
INSERT INTO sticker VALUES(116,5,'shake_hands.png','/var/packages/MailClient/target/ui/images/emoji_new/hand_04.png', 0, 24, 24);
INSERT INTO sticker VALUES(117,5,'bye.png','/var/packages/MailClient/target/ui/images/emoji_new/hand_05.png', 0, 24, 24);
INSERT INTO sticker VALUES(118,5,'Remind.png','/var/packages/MailClient/target/ui/images/emoji_new/hand_06.png', 0, 24, 24);

INSERT INTO sticker VALUES(119,5,'drink.png','/var/packages/MailClient/target/ui/images/emoji_new/symbol_01.png', 0, 24, 24);
INSERT INTO sticker VALUES(120,5,'idea.png','/var/packages/MailClient/target/ui/images/emoji_new/symbol_02.png', 0, 24, 24);
INSERT INTO sticker VALUES(121,5,'like.png','/var/packages/MailClient/target/ui/images/emoji_new/symbol_03.png', 0, 24, 24);
INSERT INTO sticker VALUES(122,5,'coffee.png','/var/packages/MailClient/target/ui/images/emoji_new/symbol_04.png', 0, 24, 24);
INSERT INTO sticker VALUES(123,5,'gift.png','/var/packages/MailClient/target/ui/images/emoji_new/symbol_05.png', 0, 24, 24);
INSERT INTO sticker VALUES(124,5,'cake.png','/var/packages/MailClient/target/ui/images/emoji_new/symbol_06.png', 0, 24, 24);

INSERT INTO sticker VALUES(125,5,'thank_you.png','/var/packages/MailClient/target/ui/images/emoji_new/font_01.png', 0, 64, 24);
INSERT INTO sticker VALUES(126,5,'wow.png','/var/packages/MailClient/target/ui/images/emoji_new/font_02.png', 0, 64, 24);
INSERT INTO sticker VALUES(127,5,'sorry.png','/var/packages/MailClient/target/ui/images/emoji_new/font_03.png', 0, 64, 24);

INSERT INTO sticker VALUES(128,5,'note.png','/var/packages/MailClient/target/ui/images/emoji_new/font_04.png', 0, 64, 24);
INSERT INTO sticker VALUES(129,5,'please_1.png','/var/packages/MailClient/target/ui/images/emoji_new/font_05.png', 0, 64, 24);
INSERT INTO sticker VALUES(130,5,'fyi.png','/var/packages/MailClient/target/ui/images/emoji_new/font_06.png', 0, 64, 24);

INSERT INTO sticker VALUES(131,5,'great.png','/var/packages/MailClient/target/ui/images/emoji_new/font_07.png', 0, 64, 24);
INSERT INTO sticker VALUES(132,5,'Excellent.png','/var/packages/MailClient/target/ui/images/emoji_new/font_08.png', 0, 64, 24);
INSERT INTO sticker VALUES(133,5,'oops.png','/var/packages/MailClient/target/ui/images/emoji_new/font_09.png', 0, 64, 24);

UPDATE sticker SET last_modified = strftime('%s','now') WHERE category = 5;

UPDATE config SET value = '23' WHERE key = 'version';