25 lines
1.2 KiB
MySQL
25 lines
1.2 KiB
MySQL
|
drop table icon;
|
||
|
|
BEGIN TRANSACTION;
|
||
|
|
CREATE TABLE icon (pkey int, filename varchar, description varchar, sort int);
|
||
|
|
INSERT INTO "icon" VALUES(1,'exclamationMark.png','Exclamation Mark',1);
|
||
|
|
INSERT INTO "icon" VALUES(2,'questionSign.png','Question Sign',2);
|
||
|
|
INSERT INTO "icon" VALUES(3,'smileyGood.png','Smiley Good',3);
|
||
|
|
INSERT INTO "icon" VALUES(4,'smileyBad.png','Smiley Bad',4);
|
||
|
|
INSERT INTO "icon" VALUES(5,'smileyOh.png','Smiley Oh',5);
|
||
|
|
INSERT INTO "icon" VALUES(6,'tick.png','Tick',6);
|
||
|
|
INSERT INTO "icon" VALUES(7,'bulb.png','Idea',7);
|
||
|
|
INSERT INTO "icon" VALUES(8,'thumbUp.png','Good',8);
|
||
|
|
INSERT INTO "icon" VALUES(9,'thumbDown.png','Bad',9);
|
||
|
|
INSERT INTO "icon" VALUES(10,'clock.png','Time',10);
|
||
|
|
INSERT INTO "icon" VALUES(11,'heart.png','Heart',11);
|
||
|
|
INSERT INTO "icon" VALUES(12,'phone.png','Phone',12);
|
||
|
|
INSERT INTO "icon" VALUES(13,'arrowLeft.png','Left',13);
|
||
|
|
INSERT INTO "icon" VALUES(14,'arrowRight.png','Right',14);
|
||
|
|
INSERT INTO "icon" VALUES(15,'arrowUp.png','Up',15);
|
||
|
|
INSERT INTO "icon" VALUES(16,'arrowDown.png','Down',16);
|
||
|
|
INSERT INTO "icon" VALUES(17,'arrowUpExclam.png','Up!',17);
|
||
|
|
INSERT INTO "icon" VALUES(18,'arrowDownExclam.png','Down!',18);
|
||
|
|
INSERT INTO "icon" VALUES(19,'rose.png','Rose',19);
|
||
|
|
INSERT INTO "icon" VALUES(20,'cross.png','Not Ok!',6);
|
||
|
|
COMMIT;
|