ここの情報は古いです。ご理解頂いた上でお取り扱いください。

source: OpenPNE/branches/takanashi/prj_takanashi/setup/sql/update/061116_insert_data_2.4to2.6.sql @ 904

Last change on this file since 904 was 904, checked in by takanashi, 16 years ago

アクション・ランク機能

File size: 8.6 KB
Line 
1INSERT c_action VALUE('','入会する',200);
2INSERT c_action VALUE('','日記にコメントされる',5);
3INSERT c_action VALUE('','日記にコメントする',2);
4INSERT c_action VALUE('','日記を書く',2);
5INSERT c_action VALUE('','紹介文を書く',5);
6INSERT c_action VALUE('','マイレビューを書く',3);
7INSERT c_action VALUE('','友達を誘う',80);
8INSERT c_action VALUE('','マイフレンドにこの人を紹介する',5);
9
10INSERT INTO c_rank VALUES ('','rank1','skin_rank1.gif','200');
11INSERT INTO c_rank VALUES ('','rank2','skin_rank2.gif','1000');
12INSERT INTO c_rank VALUES ('','rank3','skin_rank3.gif','5000');
13INSERT INTO c_rank VALUES ('','rank4','skin_rank4.gif','50000');
14INSERT INTO c_rank VALUES ('','rank5','skin_rank5.gif','99999');
15
16INSERT INTO `c_image` VALUES ('','skin_rank1.gif','R0lGODdhWAAfAOcAAAAAAP///wAAgAAA/wAgAAAgQAAggAAg/wBAAABAQABAgABA/wBgAABgQABggABg/wCAAACAQACAgACA/wCgAACgQACggACg/wDAAADAQADAgADA/wD/AAD/QAD/gAD//yAAACAAQCAAgCAA/yAgACAgQCAggCAg/yBAACBAQCBAgCBA/yBgACBgQCBggCBg/yCAACCAQCCAgCCA/yCgACCgQCCggCCg/yDAACDAQCDAgCDA/yD/ACD/QCD/gCD//0AAAEAAQEAAgEAA/0AgAEAgQEAggEAg/0BAAEBAQEBAgEBA/0BgAEBgQEBggEBg/0CAAECAQECAgECA/0CgAECgQECggECg/0DAAEDAQEDAgEDA/0D/AED/QED/gED//2AAAGAAQGAAgGAA/2AgAGAgQGAggGAg/2BAAGBAQGBAgGBA/2BgAGBgQGBggGBg/2CAAGCAQGCAgGCA/2CgAGCgQGCggGCg/2DAAGDAQGDAgGDA/2D/AGD/QGD/gGD//4AAAIAAQIAAgIAA/4AgAIAgQIAggIAg/4BAAIBAQIBAgIBA/4BgAIBgQIBggIBg/4CAAICAQICAgICA/4CgAICgQICggICg/4DAAIDAQIDAgIDA/4D/AID/QID/gID//6AAAKAAQKAAgKAA/6AgAKAgQKAggKAg/6BAAKBAQKBAgKBA/6BgAKBgQKBggKBg/6CAAKCAQKCAgKCA/6CgAKCgQKCggKCg/6DAAKDAQKDAgKDA/6D/AKD/QKD/gKD//8AAAMAAQMAAgMAA/8AgAMAgQMAggMAg/8BAAMBAQMBAgMBA/8BgAMBgQMBggMBg/8CAAMCAQMCAgMCA/8CgAMCgQMCggMCg/8DAAMDAQMDAgMDA/8D/AMD/QMD/gMD///8AAP8AQP8AgP8A//8gAP8gQP8ggP8g//9AAP9AQP9AgP9A//9gAP9gQP9ggP9g//+AAP+AQP+AgP+A//+gAP+gQP+ggP+g/z8/P19fX39/f7+/vx8fH5+fn9/f3////ywAAAAAWAAfAAAI/gD/CRxIsKDBgwgTKlzIMCGAfwAiSpxIsaLFixgzatxoUdJDjiBDihyZ0SNEkihTqqxocqXLlyJbwpxJk+XHmjhpyszJc+XOnkBH/gxKdOPQokg73kw60d++jP2ezjyaNIA/jPys6lzKNKJWi/z2fYVJFenYfPwi6gvA9upUriT99evHll9Yq/okytXnL8A+fAC+rs0LwGm+sS/LgmRrdR+/vn0DEGZsta7Ww/7STkTsUjFHtoTp5gOAz6/XAP3UoraKWfNmt2ThjhyLT19tum4RV2bs+vXWkylp9923NjfswJHZpq7I2adskWP7av6qOzI+saMpNlfpeePYr7i9Ux6vfPVxAMC+3wJHORY35afVv5Y+jvz3SqcS+eHOV7yw1IhOySVRPpk19V9iz3WVVHcKAsVggzw9CCFOEk74myQYZqjhhhx26OGHIIYooocWThgQADs=',NOW(),'gif');
17INSERT INTO `c_image` VALUES ('','skin_rank2.gif','R0lGODdhWAAfAOcAAAAAAP///wAAgAAA/wAgAAAgQAAggAAg/wBAAABAQABAgABA/wBgAABgQABggABg/wCAAACAQACAgACA/wCgAACgQACggACg/wDAAADAQADAgADA/wD/AAD/QAD/gAD//yAAACAAQCAAgCAA/yAgACAgQCAggCAg/yBAACBAQCBAgCBA/yBgACBgQCBggCBg/yCAACCAQCCAgCCA/yCgACCgQCCggCCg/yDAACDAQCDAgCDA/yD/ACD/QCD/gCD//0AAAEAAQEAAgEAA/0AgAEAgQEAggEAg/0BAAEBAQEBAgEBA/0BgAEBgQEBggEBg/0CAAECAQECAgECA/0CgAECgQECggECg/0DAAEDAQEDAgEDA/0D/AED/QED/gED//2AAAGAAQGAAgGAA/2AgAGAgQGAggGAg/2BAAGBAQGBAgGBA/2BgAGBgQGBggGBg/2CAAGCAQGCAgGCA/2CgAGCgQGCggGCg/2DAAGDAQGDAgGDA/2D/AGD/QGD/gGD//4AAAIAAQIAAgIAA/4AgAIAgQIAggIAg/4BAAIBAQIBAgIBA/4BgAIBgQIBggIBg/4CAAICAQICAgICA/4CgAICgQICggICg/4DAAIDAQIDAgIDA/4D/AID/QID/gID//6AAAKAAQKAAgKAA/6AgAKAgQKAggKAg/6BAAKBAQKBAgKBA/6BgAKBgQKBggKBg/6CAAKCAQKCAgKCA/6CgAKCgQKCggKCg/6DAAKDAQKDAgKDA/6D/AKD/QKD/gKD//8AAAMAAQMAAgMAA/8AgAMAgQMAggMAg/8BAAMBAQMBAgMBA/8BgAMBgQMBggMBg/8CAAMCAQMCAgMCA/8CgAMCgQMCggMCg/8DAAMDAQMDAgMDA/8D/AMD/QMD/gMD///8AAP8AQP8AgP8A//8gAP8gQP8ggP8g//9AAP9AQP9AgP9A//9gAP9gQP9ggP9g//+AAP+AQP+AgP+A//+gAP+gQP+ggP+g/z8/P19fX39/f7+/vx8fH5+fn9/f3////ywAAAAAWAAfAAAI/gD/CRxIsKDBgwgTKlzIMCGAfwAiSpxIsaLFixgzatxoUdJDjiBDihyZ0SNEkihTqqxocqXLlyJbwpxJk+XHmjhpyszJc+XOnkBH/gxKdOPQokg73kw60d++i/j2BQiwjx/Mo0kD+LOYb6o/f1OtusSKVGtFflrFdu33kmxRsxHzWcUXIN9EuD6XovTXr19YflL96ZPIVx/YffgAwNUXYHBFxmzH6iU5VWtVsGAbR6ysNazZrv7ETgQtWqVbjlMd+7VL96niAJEhayX9OO3VySPx4tO32+9Wxb83Zw5b0XfpvCdT6j7M+Dde4JwjS5TqeubpjXjBioX7vHOAqHWnZsPGeV0jXri+hd/FDIAf2MSQc5bPiNc356fd2QOguxXz1//VmYabSE5JxI9v+TQHQIGE7cOXRPmEJhVnXrU1IFNMzYdhTxpuKN+FHhLVYYg6PSTJiSimqOKKLLbo4oswxtgiiTQGBAA7',NOW(),'gif');
18INSERT INTO `c_image` VALUES ('','skin_rank3.gif','R0lGODdhWAAfAOcAAAAAAP///wAAgAAA/wAgAAAgQAAggAAg/wBAAABAQABAgABA/wBgAABgQABggABg/wCAAACAQACAgACA/wCgAACgQACggACg/wDAAADAQADAgADA/wD/AAD/QAD/gAD//yAAACAAQCAAgCAA/yAgACAgQCAggCAg/yBAACBAQCBAgCBA/yBgACBgQCBggCBg/yCAACCAQCCAgCCA/yCgACCgQCCggCCg/yDAACDAQCDAgCDA/yD/ACD/QCD/gCD//0AAAEAAQEAAgEAA/0AgAEAgQEAggEAg/0BAAEBAQEBAgEBA/0BgAEBgQEBggEBg/0CAAECAQECAgECA/0CgAECgQECggECg/0DAAEDAQEDAgEDA/0D/AED/QED/gED//2AAAGAAQGAAgGAA/2AgAGAgQGAggGAg/2BAAGBAQGBAgGBA/2BgAGBgQGBggGBg/2CAAGCAQGCAgGCA/2CgAGCgQGCggGCg/2DAAGDAQGDAgGDA/2D/AGD/QGD/gGD//4AAAIAAQIAAgIAA/4AgAIAgQIAggIAg/4BAAIBAQIBAgIBA/4BgAIBgQIBggIBg/4CAAICAQICAgICA/4CgAICgQICggICg/4DAAIDAQIDAgIDA/4D/AID/QID/gID//6AAAKAAQKAAgKAA/6AgAKAgQKAggKAg/6BAAKBAQKBAgKBA/6BgAKBgQKBggKBg/6CAAKCAQKCAgKCA/6CgAKCgQKCggKCg/6DAAKDAQKDAgKDA/6D/AKD/QKD/gKD//8AAAMAAQMAAgMAA/8AgAMAgQMAggMAg/8BAAMBAQMBAgMBA/8BgAMBgQMBggMBg/8CAAMCAQMCAgMCA/8CgAMCgQMCggMCg/8DAAMDAQMDAgMDA/8D/AMD/QMD/gMD///8AAP8AQP8AgP8A//8gAP8gQP8ggP8g//9AAP9AQP9AgP9A//9gAP9gQP9ggP9g//+AAP+AQP+AgP+A//+gAP+gQP+ggP+g/z8/P19fX39/f7+/vx8fH5+fn9/f3////ywAAAAAWAAfAAAI/gD/CRxIsKDBgwgTKlzIMCGAfwAiSpxIsaLFixgzatxoUdJDjiBDihyZ0SNEkihTqqxocqXLlyJbwpxJk+XHmjhpyszJc+XOnkBH/gxKdOPQokg73kw60d8+i/z6+Qvgrx8/mEeTUrW4LwBVr/6uusyKdCtFfQH6SeyX9iXZomYB5LuKVmzEuCrfcqzKNgA/fl396ZNYVd/UffgAmEU7GIBdAGifjl2K0ivVffymTg3Q2PJXv1vzUbUL2J/mxJNPpvTamG0+APgCSPaqFnJaqqLDTuTnWXLqlXHx6RPO1t9d4xI/e328m21jn5RJBj+MFjle5W0jVt0t2230kXGndIo1e30zvq6vFSOPyHt93u8i45otfnziV+OZAyRGvzY7dNWVrVdcb+rZp1lEseFn2Wb6eQcgSU5JFBVu1QEQIWH7bBdRPrpFpRliWMHHFFN6jUhUiSYChWKKPK3IIk4mSSLjjDTWaOONOOao44484vjijwEBADs=',NOW(),'gif');
19INSERT INTO `c_image` VALUES ('','skin_rank4.gif','R0lGODdhWAAfAOcAAAAAAP///wAAgAAA/wAgAAAgQAAggAAg/wBAAABAQABAgABA/wBgAABgQABggABg/wCAAACAQACAgACA/wCgAACgQACggACg/wDAAADAQADAgADA/wD/AAD/QAD/gAD//yAAACAAQCAAgCAA/yAgACAgQCAggCAg/yBAACBAQCBAgCBA/yBgACBgQCBggCBg/yCAACCAQCCAgCCA/yCgACCgQCCggCCg/yDAACDAQCDAgCDA/yD/ACD/QCD/gCD//0AAAEAAQEAAgEAA/0AgAEAgQEAggEAg/0BAAEBAQEBAgEBA/0BgAEBgQEBggEBg/0CAAECAQECAgECA/0CgAECgQECggECg/0DAAEDAQEDAgEDA/0D/AED/QED/gED//2AAAGAAQGAAgGAA/2AgAGAgQGAggGAg/2BAAGBAQGBAgGBA/2BgAGBgQGBggGBg/2CAAGCAQGCAgGCA/2CgAGCgQGCggGCg/2DAAGDAQGDAgGDA/2D/AGD/QGD/gGD//4AAAIAAQIAAgIAA/4AgAIAgQIAggIAg/4BAAIBAQIBAgIBA/4BgAIBgQIBggIBg/4CAAICAQICAgICA/4CgAICgQICggICg/4DAAIDAQIDAgIDA/4D/AID/QID/gID//6AAAKAAQKAAgKAA/6AgAKAgQKAggKAg/6BAAKBAQKBAgKBA/6BgAKBgQKBggKBg/6CAAKCAQKCAgKCA/6CgAKCgQKCggKCg/6DAAKDAQKDAgKDA/6D/AKD/QKD/gKD//8AAAMAAQMAAgMAA/8AgAMAgQMAggMAg/8BAAMBAQMBAgMBA/8BgAMBgQMBggMBg/8CAAMCAQMCAgMCA/8CgAMCgQMCggMCg/8DAAMDAQMDAgMDA/8D/AMD/QMD/gMD///8AAP8AQP8AgP8A//8gAP8gQP8ggP8g//9AAP9AQP9AgP9A//9gAP9gQP9ggP9g//+AAP+AQP+AgP+A//+gAP+gQP+ggP+g/z8/P19fX39/f7+/vx8fH5+fn9/f3////ywAAAAAWAAfAAAI/gD/CRxIsKDBgwgTKlzIMCGAfwAiSpxIsaLFixgzatxoUdJDjiBDihyZ0SNEkihTqqxocqXLlyJbwpxJk+XHmjhpyszJc+XOnkBH/gxKdOPQokg73kw60d++jfuevjyaNIA/jfqswqSKVCvGfAG8uuRaVGw+fhP5WRXrcylKf/36heXHb59VfRLh6vMXYB8+AF6z4s0bAB9blWQ5hrW6jx9fvgEGL14bQO1VsP7QRpSbD/DVqW5Jhh3MGYBhqWH7Rcwq1x9mzQDAqva8NfRIsfj05W4dkS3luRJPSzycMvFG3Hz3Zf3sG3JqwpMXf0ZsW6RYvpq9Ng+Lz25nAPv8ZokXH9bp2OohxXrlTXv4YwCOC1skjtK4RrGtJz/d/tnw9In0kWRfRuZFxE9r+SwHQIEROQWXRPlkVtGDoJ3E1IUTDYghTxpuiFOHHuqEXohAmSTJiSimqOKKLLbo4oswxtgiiSEGBAA7',NOW(),'gif');
20INSERT INTO `c_image` VALUES ('','skin_rank5.gif','R0lGODdhWAAfAOcAAAAAAP///wAAgAAA/wAgAAAgQAAggAAg/wBAAABAQABAgABA/wBgAABgQABggABg/wCAAACAQACAgACA/wCgAACgQACggACg/wDAAADAQADAgADA/wD/AAD/QAD/gAD//yAAACAAQCAAgCAA/yAgACAgQCAggCAg/yBAACBAQCBAgCBA/yBgACBgQCBggCBg/yCAACCAQCCAgCCA/yCgACCgQCCggCCg/yDAACDAQCDAgCDA/yD/ACD/QCD/gCD//0AAAEAAQEAAgEAA/0AgAEAgQEAggEAg/0BAAEBAQEBAgEBA/0BgAEBgQEBggEBg/0CAAECAQECAgECA/0CgAECgQECggECg/0DAAEDAQEDAgEDA/0D/AED/QED/gED//2AAAGAAQGAAgGAA/2AgAGAgQGAggGAg/2BAAGBAQGBAgGBA/2BgAGBgQGBggGBg/2CAAGCAQGCAgGCA/2CgAGCgQGCggGCg/2DAAGDAQGDAgGDA/2D/AGD/QGD/gGD//4AAAIAAQIAAgIAA/4AgAIAgQIAggIAg/4BAAIBAQIBAgIBA/4BgAIBgQIBggIBg/4CAAICAQICAgICA/4CgAICgQICggICg/4DAAIDAQIDAgIDA/4D/AID/QID/gID//6AAAKAAQKAAgKAA/6AgAKAgQKAggKAg/6BAAKBAQKBAgKBA/6BgAKBgQKBggKBg/6CAAKCAQKCAgKCA/6CgAKCgQKCggKCg/6DAAKDAQKDAgKDA/6D/AKD/QKD/gKD//8AAAMAAQMAAgMAA/8AgAMAgQMAggMAg/8BAAMBAQMBAgMBA/8BgAMBgQMBggMBg/8CAAMCAQMCAgMCA/8CgAMCgQMCggMCg/8DAAMDAQMDAgMDA/8D/AMD/QMD/gMD///8AAP8AQP8AgP8A//8gAP8gQP8ggP8g//9AAP9AQP9AgP9A//9gAP9gQP9ggP9g//+AAP+AQP+AgP+A//+gAP+gQP+ggP+g/z8/P19fX39/f7+/vx8fH5+fn9/f3////ywAAAAAWAAfAAAI/gD/CRxIsKDBgwgTKlzIMCGAfwAiSpxIsaLFixgzatxoUdJDjiBDihyZ0SNEkihTqqxocqXLlyJbwpxJk+XHmjhpyszJc+XOnkBH/gxKdOPQokg73kw60d8+i/4CSJXqD+bRpAGqUsxH1Z/Xpy+vIs1aUV8AfDnFFiUbMR8/AGbf4lTL0V+/flL58duXVZ9Eu/qi7kPL1qxfvP2i+ss3k+7GqU75KZbqF8DUrHnJcvX3li9VylaXogQNAC9jfAHASu0X0SzexVnlCn6792xY0STZAsCnj/friLotR50qtzRriajB+sQ9Ujc+wWa1Bsc89fju4sC1Lj+ZUndUuWyncg/Hx5cxvwDWAZxXrtKxRt1sfwufiLmqZNtRGavnW3n7St2vXfaUeGyhVhVXWQ3HXnvMieSURPy8lk90ADz41z52SZQPZ7th2FdjDTLFlHsiAkViiTydiOJcIa4YlEmSxCjjjDTWaOONOOao4443uuhjQAA7',NOW(),'gif');
Note: See TracBrowser for help on using the repository browser.