INSERT INTO biz_admin_config VALUES (nextval('biz_admin_config_biz_admin_config_id_seq'),'IS_CLOSED_SHISETSU','0');
INSERT INTO c_action VALUES (nextval('c_action_c_action_id_seq'),'入会する',0);
INSERT INTO c_action VALUES (nextval('c_action_c_action_id_seq'),'自分の日記にコメントされる',0);
INSERT INTO c_action VALUES (nextval('c_action_c_action_id_seq'),'他人の日記にコメントする',0);
INSERT INTO c_action VALUES (nextval('c_action_c_action_id_seq'),'日記を書く',0);
INSERT INTO c_action VALUES (nextval('c_action_c_action_id_seq'),'マイフレンドの紹介文を書く',0);
INSERT INTO c_action VALUES (nextval('c_action_c_action_id_seq'),'レビューを書く',0);
INSERT INTO c_action VALUES (nextval('c_action_c_action_id_seq'),'友人を招待する',0);
INSERT INTO c_action VALUES (nextval('c_action_c_action_id_seq'),'マイフレンドにメンバーを紹介する',0);
INSERT INTO c_action VALUES (nextval('c_action_c_action_id_seq'),'コミュニティにトピックを作成する',0);
INSERT INTO c_action VALUES (nextval('c_action_c_action_id_seq'),'コミュニティにイベントを作成する',0);
INSERT INTO c_action VALUES (nextval('c_action_c_action_id_seq'),'コミュニティのトピック・イベントにコメントする',0);
INSERT INTO c_admin_config VALUES (nextval('c_admin_config_c_admin_config_id_seq'),'OPENPNE_USE_DECORATION',1);
INSERT INTO c_api VALUES (nextval('c_api_c_api_id_seq'),'000_auth','');
INSERT INTO c_api VALUES (nextval('c_api_c_api_id_seq'),'001_get_c_member','');
INSERT INTO c_api VALUES (nextval('c_api_c_api_id_seq'),'002_get_member_point','');
INSERT INTO c_api VALUES (nextval('c_api_c_api_id_seq'),'101_add_point','');
INSERT INTO c_api VALUES (nextval('c_api_c_api_id_seq'),'smtp2pne','');
INSERT INTO c_commu_category VALUES (nextval('c_commu_category_c_commu_category_id_seq'),'地域',100,1);
INSERT INTO c_commu_category VALUES (nextval('c_commu_category_c_commu_category_id_seq'),'グルメ',200,1);
INSERT INTO c_commu_category VALUES (nextval('c_commu_category_c_commu_category_id_seq'),'スポーツ',300,1);
INSERT INTO c_commu_category_parent VALUES (nextval('c_commu_category_parent_c_commu_category_parent_id_seq'),'コミュニティカテゴリ',1);
INSERT INTO c_config_color VALUES (nextval('c_config_color_c_config_color_id_seq'),'FFFFFF','CCCCCC','CCCCCC','FFFFFF','FFFFFF','CCCCCC','FFFFFF','FFFFFF','CCCCCC','FFFFFF','36B3D1','CCCCCC','FFFFFF','FFFFFF','CCCCCC','DDDDDD','FFFFFF','FFFFFF','FFFFFF','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','現在の設定');
INSERT INTO c_config_color_ktai VALUES (nextval('c_config_color_ktai_c_config_color_ktai_id_seq'),'FFFFFF','FFFFFF','0D6DDF','DDDDDD','EEEEFF','7DDADF','E0EAEF','FFFFFF','C49FFF','DCD1EF','FFFFFF','0D6DDF','B3CEEF','BFA4EF','000000','0000FF','0000FF','800080','EEEEEE','999966','0C5F0F','C49FFF','FF0000','','','','','','','','','','','','','','','','','','','','','','','','','','','','','現在の設定');
INSERT INTO c_config_decoration VALUES (nextval('c_config_decoration_c_config_decoration_id_seq'),'op:b','太字','<strong>表示例</strong>',1);
INSERT INTO c_config_decoration VALUES (nextval('c_config_decoration_c_config_decoration_id_seq'),'op:u','下線','<ins>表示例</ins>',1);
INSERT INTO c_config_decoration VALUES (nextval('c_config_decoration_c_config_decoration_id_seq'),'op:s','取り消し線','<del>表示例</del>',1);
INSERT INTO c_config_decoration VALUES (nextval('c_config_decoration_c_config_decoration_id_seq'),'op:i','斜体','<em>表示例</em>',1);
INSERT INTO c_config_decoration VALUES (nextval('c_config_decoration_c_config_decoration_id_seq'),'op:large','大きめの文字','<span style="font-size:20px;">表示例</span>',1);
INSERT INTO c_config_decoration VALUES (nextval('c_config_decoration_c_config_decoration_id_seq'),'op:small','小さめの文字','<span style="font-size:8px;">表示例</span>',1);
INSERT INTO c_config_decoration VALUES (nextval('c_config_decoration_c_config_decoration_id_seq'),'op:color','文字色指定','<span style="color:#33F864;">表示例</span>',1);
INSERT INTO c_image VALUES (nextval('c_image_c_image_id_seq'),'skin_no_image.gif',' ',TO_TIMESTAMP(NOW()::text, 'YYYY-MM-DD HH24:MI:SS'),'gif');
INSERT INTO c_image VALUES (nextval('c_image_c_image_id_seq'),'skin_no_logo.gif',' ',TO_TIMESTAMP(NOW()::text, 'YYYY-MM-DD HH24:MI:SS'),'gif');
INSERT INTO c_image VALUES (nextval('c_image_c_image_id_seq'),'skin_no_logo_small.gif','R0lGODlhTABMAOYAAO3t7fr6+vz8/Pf39/v7+/n5+fj4+PT09PX19fPz8/b29uHh4fLy8u7u7vDw8P39/ezs7O/v78/Pz/Hx8cvLy+Dg4OTk5Obm5qampujo6M3Nzevr6+Pj49vb2+fn5+rq6tXV1YSEhOnp6bm5uczMzOXl5bS0tJiYmH19fc7Ozr29vXt7e3V1ddzc3J6ent/f35aWluLi4ri4uNbW1tDQ0NPT05qampycnKenp97e3qOjo4iIiNnZ2a2trdra2qurq9jY2KKiotHR0ZCQkJSUlLKystfX17GxscrKypOTk4uLi7a2tsTExMjIyMPDw7Ozs93d3cLCwq6urv7+/re3t8bGxomJibW1tcXFxby8vJmZmcfHx5+fn7+/v42NjcDAwLCwsMHBwaCgoJGRkaGhoYKCgr6+vqysrJKSktLS0snJyZubm46Ojo+Pj6ioqLu7u9TU1JWVlaSkpAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACH5BAAAAAAALAAAAABMAEwAQAf/gD4Lg4SFhoeIiYqLjImCIgEEkpOUlZaXmJmam5QBIoMWCgWjpKWmp6ipqquspQoWgy8TCrS1tre4ubq7vL22Ey+DPBAJxQ1QMzMWxczNzs/Q0dLNIssJDdIQPIMUFQAAJ0MX31ErNAAYVi8AJisvNCvfAObfJybz5+D37CcAXOIvhsSDJ88eP3ZD5PUoY0VeBQrcvMmbSLGixYsYM2qs+HABBxIcJogcSbKkyZMoU6pcSfIjhwwaMgyYSbOmzZs4c+rcybMmzAwQJEB4QLSo0aNIkypdyrSp0aAQFmwgIKCq1atYs2rdyrWr16sENgzyYCCA2bNo06pdy7at27do/w14GBTjgIG7ePPq3cu3r9+/gPMeiDGoRQMEiBMrXsy4sePHkCMrbtAiIoAoZ741iOBgAgMGI4JcYMAExoUOMEYwAAEDB4QLN5AwaP36xo0FEHo8YdCDyWfUDFCrXhCbdI8LI3BUcHBDA4AMMNIA6Lig28br2LNjlCInx0TqEBuIH0++vPnz6NOrX0+++oISJC4cmE+/vv37+PPr38+//gUSJXyQwgdwFWjggQgK+MECAEzx1YMQRijhFAAMQqCEGGaoYQALLpBBAZyEKOKIJBaQwSAXDIDgiiy2OMAFg3CAQGA01mjjjQhwMEgFDPTk449ABslABYNAEYFkSCap5P+SEUAxiA8A9CfllFRWCYAgC2hgwQQJmKEBMxYsYU0CGVgQgTNlFrOBmc2seWYEFmwwTTFpOgMCFtFMYIEGlmWBBkXjAICCEJrZsEQNKIyEAgif2SADA4s2+igDMtjAgKOfgZAoHIk6EIGhAFyhRaijAoAECheIgcM34En0jQQqqMDgRB2A4ME3HoAgj63fdMAgrwD4+s0CHeBqa64AINsrg8T2qmuFXhTLKkTVuardtdhq12q23HabUUccUMCBA+SWa+656Kar7rrstmtuuBxYQIIFn9Vr77345qvvvvz2e6+8FniggQe+FGzwwQgL7IEIKYjQysMQRywxwyJsIMH/BhpmrHFXFm8AQAsShCzyyCSXbPLJKKescsktVJhBAxDELPPMNNds880456zzzA2cKNXGQAdtlVgLfECV0EhnSECHkJDo9NNQezLIh1BXbbUmJo5VVotcd92WXCiq6PXYZL84SAmiSKz22msrUAIoCLAt99yrIACLR3bdqPfeex+g4yAJBCn44IQnQIgshCeu+E7ADJKDAwhHLvnkDuRQ2JFLZq655hFU1myVoIcuerDCQCD66ajvp80gQMiZwAdVSNABEFWAMOftuM+5ABAJ5CCBNBsAYVkLGGzAADMziHDNCBhg8MMMCVSAQRPNOzFD8z8oP33zJlTwQ/MdJDDC/5fRY1C+E82DgY0G4zc/Qgc/JMCAAyqEMR211r1BRkWbtaGGZwyIgxOMsAPjMWAHQviMDlRwwAQyQAdU+IwKdPBABjKAgBcsoAIZqIIgOCALQfiGFNwAgC2wYVqWmQELvCOPNYQQBV+QRwhkIAEWaIYFNIhABIhQBAewQAjkIsITyPUEIjiAhzpsAgsaUEN5JOEIADhCEqI4xW/MkAVbQGG1vnGBE4TABV7sAhddEIIQKAELAKhBCGRYg2+4YAQACEEbAfDGb4zABWlUghmLsEY1yqOOdwQACUIwhm/wIARFcAj+rOWtRmLHCFRYlSIt48hKcmtblsykthapyU5eB4o8C2CPKEdJylK6JwYUiIEOV8nKVrrylbCMpSxn2UpUxgBe7sqlLnfJS3gBzF/ADKYwhwkw+JQgd8hMpjKjYcwLaOACm4umNCHjzAv8ZHHYzOYAfgITEfDtm+D8iwhioiCymbNrChLQVK7GznZuYEBQcYo850nPekIFAM7xpD4z4hwO7POfGOFAIAAAOw==',TO_TIMESTAMP(NOW()::text, 'YYYY-MM-DD HH24:MI:SS'),'gif');
INSERT INTO c_image VALUES (nextval('c_image_c_image_id_seq'),'r_1_regular.gif','R0lGODlheAAUAOYAAP+UAP+MAP+NAP/ozP/pzP/qzP+4Vf/NiP/OiP+3Vf/37v+0Vf+yVf+pRP/iu//LiP/Bd/+2Vf/Qmf+6Vf+zVf/47v/x3f+1Vf/Cd/+5Vf/MiP/w3f/gu/++Zv/aqv+hIv+/Zv+lIv+fIv/hu//Rmf/ju//Dd/+GAP+zRP+bAP+uRP+xRP/Tmf/Smf/Vmf+iIv/Yqv+gIv+kIv+cIv+VEf/Hd//KiP/BZv/Gd/+UEf+6Zv/IiP/Fd//JiP+aEf+fEf/bqv+rRP/Id/+aIv+SEf+eIv+5Zv/Umf+9Zv+tRP+KAP+QAP+RAP+WAP+TAP+XAP+PAP+YAP+JAP+HAP+aAP+IAP+cAP+FAP+ZAP///wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACH5BAAAAAAALAAAAAB4ABQAAAf/gFaCg4SFhoeIiYqLjI2OjylZkpOUlZaXmJmam5ydnp0pVFlUpKWmp6ipqqusra6vsK2jWFlYtre4ubq7vL2+v8DBwr+1UVlRyMnKy8zNzs4/ExMoz9XW19jYx09ZT97f4OHeE5cI3+SWBeAhJZVC3wiS5k/xWepP6PfiTyGTN+EF0qHYRxBctyZZmihcyLChwgyYajy8VGChDEwZFNZDoFFSxSYQ7Tlc6GJSiYYBLVUYyZJhQgBZAMicSbOmTAOSLBgw4ECSg5s5d+5cMbNnFgsgDADxKfOApANNPQK1Z3NmpRc0U+IwAGIS0apgZcZ0ksWJ2bNo05pNkDNBAqNH/9ZKqnCg7oEPZyfhXYvWaZYDZv0SkJtlsFonHSoBPktAEo8EiSX5OEw5rxMmWZho3sy5s+YImGJ8vhRhtCTNlTRrkKRBtSQCpmF7ZmIUyVzOjS2xmM2bc+YlWZYIH068uPALl0QMR/6agHMVwlVMEl5J+ANJD6xLGnH8tfElIiY9qCDpwvDclFh8X188OJQsUOLLn08//oLXSSa1kH+/cP34k5gAxQL9wQeFCZJsEF8L2Nn32n/XWeKBfLkt4MEkRfyn4XzwCZCFACCGKOKIIFIgyQACYDBJECVOMsCLL4Zog4sDKDAJiDNMssEAk2DQ4okw+iiAjZfQACKPWVAw5OZ2JDZJ4ocBZBHAlFRWaeWUDJw4JZIDYIlJlUhWQgKVJFiyQQ5eWtJDADpIogCVHEiCwZaSMBBAlnVeqaeVUiqRhRKABirooIA28KIEhcLYgBKGwujooBBwYOMAEgwBqaRZDLADEYE26ugAECgBwYuhAmrEizAAKsGLiyqxKqWExjron1JkIcWtuOaq66689urrr8AGK+ywwNpaRRZVJKvsssw26+yz0EYr7bTUVistslNkMcW23Hbr7bfghivuuOSWa+655Gp7wifstuvuu/B2csIV9NZr77345qvvvvz26++/AAccCAA7',TO_TIMESTAMP(NOW()::text, 'YYYY-MM-DD HH24:MI:SS'),'gif');
INSERT INTO c_image VALUES (nextval('c_image_c_image_id_seq'),'r_2_silver.gif','R0lGODlheAAUAPcAAN/e17Ctoaupm+Xk37q5rW5uaBcXFk1NSjU0Mbu6sDs7ObCwqdjXzy4uLIuJeOjm4UREQXx8eM3MxNTTyqOhkr67sLe2q7Gwo56emNfWz4+NemlpY4aFgL68sbKwo6yrne/u6eHg2sHAtsvKwVZWU93c1IqGdqSik+bm4IWCcoOBcO3r5m9uZ/Lx7fHx7YODf5KQfn9+d56ci4aDc3R0btnY0drZ0oWEgaellqyrnKyqnO7t6dLRyJCNfNTUzOvq5eDg2o+Lerq5rKKgkKCekIWDcpaUgrq6r1JSTsG/tMPBt5yaira0qYGBfHd3dP7++21sZN7d16SikhsbGpWUi+Tk3s/Px7y6r2lpZsnJwFxbWfr69+Hg29PSyq2sn7y7sEBAPTc3NKGfkuvq5N7d1vX08eTk32ZlXeTk3Y2KeePi25aUht3c1rq3rOvr5sTDtykpJ2FhXeLh26+soKinpLSypv7++oiHg2tqYpaUhYqJd7m3q2lpZXJwas/PxfTz7/z8+qmnmZGPfZCOfJKQf/b18bSxpvPy7sbFu6Sjnnl4c4SDfsTDvaajmJiYklxbVEVFQ6akl4OBerW0rpOSiZeWkF5eWDIyMLe1ss3NxUFBPoiHfnJxaNfW0mxsZ2trZ1hXT4SDeqOhlJ+dkVVUTpmWiHBvaHt6cWtqY4GBeV9eWXt6dYOBeJORfrGwpWhoZG5tZnV1cEBAPmhnY4SDeKCgnI+OgsjHviEgH5eUhYaEemVlX5OSj359c6mmmpybjXt6b0lJRnd3bq2somNjX5STi2pqZq+vqJ2dluLh3Xl5cGRkX5+emCUlI6yspYWDepublYGAdlBPSZSTjXd2cFxcWY2Mh5+fmZiWioSCeMfFvGZlYIKBfb28tcHAubKxpaGhm3V0cIuKhSQkIqelmdva0tbWzqKgkdLRyaakluDf2crJwfz8+fHv66yrm399bff288TEuomFdcnIvltbVwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACH5BAAAAAAALAAAAAB4ABQAAAj/AOcJHEiwoMGDCBMqXMiwocOHb+BJnEixosWLGDNq3Mixo8eObzq0OHGiAggeFXK4W8mypcuXMGPKnEmzpk2aOSrwAFGBZIsOe1ZQWFHCA4N2T+wAYse0qdOnUKNKnUq1qtWrUQHZedKOgYcSQlfs8fDAwoQkaLYUOuSindu3cOPKbYeJDp1kc/Pq3cu3r1+4Lg4V2oImyQQLDzx8UENGyoMyO8Y8QIFigOXLmDNj5tUMToMGU7BcdmLAgBPLtUrL0oyl9I3LWlxbLk2b9uXatLV00sybN+UHY3aUeSCFjJoPOABc8fPnR5UQAKJLn069OqNLJOhppweGW/Q72u9E/0+k3Vj1SdoPSIegXfr29/Tcw6cHoVr1+/ijh6jy44+fKwDgMEQ5MrTjhhxslKPgggw26GA5i2jHQTnX0BOOIgpyIKGC4GjHx4Oe0IOEN+VYs6GC2y2goooLprhAJdpB8OCMNLIhhxvtyFDOEEuYA0MLA5SQgTlEFmnkkUia40yM48SBTCZFvqDdC0RioN0rSTqiXSzm8KHdMUVuF8GYEWAQpnYYYCAlPZ8k6eabGZQwgAutmLOEEej0AEIIDKDj55+ABiron+JoR0IwYUwxjZ9NaNeEn9BoN8ug3WgHCTrsEQPodgp0qsAqf273mQLaMTPoqaiiw0AIIPSAjhEwnP8TxARffEDBObjmquuuvOZqizDLiIorHtrhgSsw2lnS6zmw0EMCKNopo+t2G1S7ASe5zkePLst2uywFH3wxQRDnwCBIOg7UoMQFgaTj7rvwxitvOtLgAgct6Yix3S/pQKEdFO72op0q86Zzinak0oMNvNsVvJ0Yu2inScEUFxzIBUrU4EA6ggwigAM2jCBEADoIYPLJKKesMirZNfAIKduZzIJ2LJgcTXoI5IzAGSeL8t42KW+nc87ZmBzzKNohwbPKTDctgA4BCDGCDQ4IMIgGAWjABAOItGHIBQGELfbYZJPtC6dgaLdJ2H1o10fYz2x3wNwHsDA2NduFQrbcdB//wErY24UtiXZhNFL24YhfYEgbiDDABNYapFHHHDNIkEEWInSQwBEEdO7556B/PkwqBdATBw3FeB5DAQXE0DkVrMfOuuueUxK7K6DLLjsVncfe+Tc0sG5K6MSHfkQCHYiQRQYSzDBHHWk4YEEeROSiTRQ+WCHBCOt07/334Icv/vjkl2/++eiLP4IEVvgQxS2lEJGHBQ7okUARCZCTghddmMEFEOoIoAAHSMACGvCACEygAhfIQAMCgQtm6IIXUhCJ+yVADyYQgQpUsIYEECIF7wihCEdIwhKa8IQoTKEKV8hCFqaAEAlYwwZFYAITxOOGOMyhDnfIwx768IdADKIQG4coRBPI44hITKISl8jEJjrxiVCMohSnSMWAAAA7',TO_TIMESTAMP(NOW()::text, 'YYYY-MM-DD HH24:MI:SS'),'gif');
INSERT INTO c_image VALUES (nextval('c_image_c_image_id_seq'),'r_3_gold.gif','R0lGODlheAAUAPcAAObdi+rimc7ASsi4Lcm5Nh8PAIxVD2oxAEIxDfDpsT4dAKqgdXY3AHA0AO7mqMvAUsi2HqSNAevim8GkV5iCE/DqsmMuAEojAOfekOHXf/PtueXZeubbh7agDKKWV9PCMcq+U7KbAMaxErykANLFV7afAOnhl+rhlffzy8ayNs3BW4FRF10rALWcANDAQtXIVqyNANfKVqmLAKqNANnNZ+fek+Lbl828LN/SbOHXhMCqHubejMCqALKeGPDqtM/BR+nhmeXah+LVbqmMGKuYUqyaV/LtuMm5N/jzzZ1wHqmWTe3lo8q6OdLAJtnJRenfk4dqENrPfc26QpdnGd/Vd8q6NdnKTs7BS8u4GePZhNbLZ8/CUcKuBc7BTfLrtc7ASbekJ9nOc/PtvFkwAsu8OdXFRricNuXaiOLalNnLbO3jm+bdie/nqtfLbt7VgMWxD4pPEbCcHMi4NdLFS6aPA+LZj4dMCsq6LtLCQci4LtbLa8i2Ke7mpqV+He3mpKacZuLVdMq4Ise0Hcu9R7mjAMq8PrSYAO/nreHXft3SfPj0zrWZAOXenc/ANq6dXcW0HrGYAJmCGfLqrbylAMi0GNXGS7OPRvbwxZl5NubekbmfAL2oANTFS55uKu7nrevjncu8PrCVALmjAXxLBtXJX+vinXxLB72kEpZkElAyBvDrtH9nMbOTMX1MC0cnA35vPbyjENXGYsCoAbuqI31MCcCoAFQoAGQ9ELivgYNTHKuXTaiVNrmYSlxJI3BjPYuAUt/WgZFdD6CBG9XIZKyEPaSYXX5xR8vCeJuFJJttFopzOYdUGYJTGsGuKjYmBqiBJ2FULp6STcOuQCoaA9/VgWpPI8/GhdzUjzgaAMGwLLqZT1o8CVVHJ+LapJqEHoJUCHJLF3hoFIJSGW1JF+LXgWNVM9LAazAdA4FDBb+iUisUAItTCyUSAJl1FIhdCpJqHuPZg8a1JcW0Hd7TdOHWe/DpsPfyytbKauHak9LAJaGAAPTuvs7EZK6UANvOYHw6ACH5BAAAAAAALAAAAAB4ABQAAAj/AP0JHEiwoMGDCBMqXMiwocOHMfZJnEixosWLGDNq3Mixo8eOMSr5gACB0yEhTprkW8mypcuXMGPKnEmzpk2aTZwIOcSJpI9KeBwIcsDhwwZJipCgsMe0qdOnUKNKnUq1qtWrUVEgUSRpwwcOQh3gaVTKBSArJy6J8VIhQYJ6cOPKnUu3brcFC3DVhYt3wd6/gAMLhuu2ghcxl05YAeSiVKMbT9ZgUaOBzZJPEiQE2My5s+fPn61xY6dAAbYCvzwbK1BaQQFfnRGwK/Dn858CuHOXuwa6t+/OmT8tYaNBDZY1T24EAlAGhxE/JjDsAEC9uvXr2LMfU2fhn3fvF4pV/4dm67t3W9wA7MCQy7sj7I7Me2eBIEr2+/ivrzfhxwiOMgAEQgk8IiTARw1nZAHPggw26OCDEMLTi3dwaDNBJ95Vs6AHLHhHzASWeGeBBwsy410RDxZBIYjeNfBKhDDGyGAWZ9TARwIiwEPJG/TUogoQQSBCz5BEFmnkkUgO2d0/5hCZTpHKeNcJkRj+s8qQ4nhHxJFEeLfMkLx4d0uSZJZZJCJBAFGBLPS8wcU8I3iSSQbz1GnnnXjmqWed0XxXJ26uFVDnON5hYicm3oFT5wreKZGnEt6tUKcuLe5p6aV4ZpCJJyPMwwUP8mhCxRx3PCLPqaimquqqrMozxHenyv93qjveQYEqFN59c+oo3lGwKgXejXIqsN61auyxqT5yxxxUaCIPD5vEswg5L5CxRzzYZqvtttx2i+134cQzxKveYduOd2PMgu0Y3rWDrSneRcJtJN6Zgi2u/wTj7b78arsHGS+Qs0g8m0wygCE50PBDFXkM4PDDEEcs8cQDnPvPBQhs48p3DoPhHQPnIDANA96B4TAt3qWCwMoIOOyNdwcg4MwF3glD8c04P5xHFT/QkIMhA0xCCAGiSAEMKV+AwsQRBDTt9NNQRy31OjAfQPI/yTjdx8dWe9eH0620eMDYBzSNzHcHNOAdKlK37TbURzAByhekUCOFKAQQUkIhcsDzkIYbWpCwRRdXCGD44YgnrvjizwSDzj8GJCFN4mZMYcc/dkxhBuLvGOD55wYYvgvokbOy+OmoJ35FF1uQoIUbacAgRyEltDBIDzrAEksdiYTRhh73BC/88MQXb/zxyCev/PLMG69HG2EkUscwp+jQwyAthPAAHQ9kI0MKUTBiAxr4lG/++einr/767Lfv/vvwq4+GDYxEkYIMzWz/QAiQqBBBBHEAQQdmoI8CGvCACEygAhfIwAY68IEQhOAMOgCCOPxPBZAIBT82yMEOevCDIAyhCEdIwhKa8IQmDEU/VsjCFrrwhTCMoQxnSMMa2vCGOAwIADs=',TO_TIMESTAMP(NOW()::text, 'YYYY-MM-DD HH24:MI:SS'),'gif');
INSERT INTO c_image VALUES (nextval('c_image_c_image_id_seq'),'r_4_platinum.gif','R0lGODlheAAUAPcAACUrNUpVZT5GUkZRYmp5jGJvgX2auDI5RB0hJ1lmeUBKW8TR4nWRrMLO3Pr//2+OpP///52zzMjT4uDo8vL4/8/b6NPe65muxd7n8pOow5+yytni76W3zLPC1eXt9xATF1diczY/TfP5/2Nvf3N+jWFtfrfE1XyDj3mBjVtoeufv+XN5gH6FkHeAjF5re56krDs/RC0zOz1GVp+msau7z3aTr3GMp5ujr+70/bzK21hhbnqXtZWrxOjv+eDo85WeqoeRoElUZW18kXeVsNvl8VVebJegrFVfbVdgbUtWZkxXZmhzgzA3RIyYqC00QKCzysrW5HKRqpGowL3L3XN9jOHo8rHB1Jiux560zeft9tbg66S2y/f8/+Ts9rTD1bPE2dvl8tnj79Hb6cfS4XGAk5OrxZSqw4Gcu4mft6W4zTpDUqe4zuLq9OLq809aa3eUsYKHjqC0y/D2/neUsHWDlnuXtnmVs6e5z6/A1Nbg7LXE1qS3y6Czy3KQqpywyJGow9zl8sfT4lJecLDA0/n+/7LB1M3a6Ki5z7jJ23SPqImiv/7//+Lr9pKapO/2/tfi7tni7nqWs+30/dPe6rjF18rV43STrKa4zXWTruvz/L3K2YGbtcvZ583Z5Yqgt4ylwLbF2dDc6vH3/1pibLbH2fT6//X7/yowO6W40NTg7dXg7HmWs67A0q/A0/b8/+vy/JSrxLPE1+Pr9tfg7NHb6HyZuLXE12ZyhHmGl8HO3pyvxU9ZZU9WYF9tfoyXpn+FjoaZs2l3iUlQW4ehu1Zjd8DJ1XWGm6SyxXuNoiAlLktXaaavvsTQ4Iydsqm4yjxBSdfe6Gd1h8PQ4IaVqJCkuaOrtY2arHyFkoWSpG9/lHyImmFwhX2HlmZxgYmcsXaClIqeuJylsp2ms5uvxI+gtjM7STY+S3mImnuKnWJob32LnIGIk/T5/6euuFtkdFpjcmNqdWVqcWZtd4miu213hXWDlIeUpVlld52vw1pndlZic42Wo77G0mRxhHiFln6EjCH5BAAAAAAALAAAAAB4ABQAQAj/ABcIHEiwoMGDCBMqXMiwocOHiizUYueBiCoLGDNmRKFAwTUL4ToqwMhRAQqNGuWJVCCjEUoL7jqK01jypIWSHZ8Z6XgE404FPS38HInxyMpGwlYaealRFREPIgxYUFTDRCITuqLsoZWlTZUJYMOKHUu2rNmzaNOqXVu2SpsstPZEGWfVRI07PVqFQiRrESFTIgJTGEy4sOHDiBMrXsy4sWPDgUWYIrRIFqJQrXrc2aFhCKRAVtI80UC6NOkSHaOZLo1awYEYsGOc09AsxEqR5lYn6UjHdOsSpzsCTyAySekBHRHEANDxXundCsiJ7Ne69+rST9JYCQRpiIYdpErx/+ABSpShL1giqF/Pvr379/Djy59Pv/58LF8MiQI1vhSpKxjEwokrr3ThAwYIJoggC7cp4EQ6C3bEgoIUPiPSLwrq0GBHM2DAoAITethRCP9gMENHOiB4ogIpmihSghp2BA8G7cggUocUJuhDF6+4wkksGFxRSwariGELH2ZkoOSSS6bQoDLAKOmkAikwuaQ+HQ1AnAJMgGNlEB0JweSUVWYw5TYdldNREEoKsWabIi0JpgLEcNnRlmJayaQZfNgixioZ1PIGDVtYAoUWY+RAiR5edOCooySAAAIJj1YaqaSYgtBEB+9Ias+j30hKT6VLSLrpo5dS2kGqjmIj6RKVWv9zixsKuHHLMaRK2oE2kjpz6amVeqEHJTmMoQUUlmxBwxuYNODss9BGK+201FZr7bXYZqtttphM4cC34IYr7rjklmvuueimq+666k6BBw6w4AAGKqlQAMG9+Oar77789uvvvwAHLLDAFKSCChjw4oBHHIwAUoYKXDiSSQ8qqODBxRev8MHGHMeDscYfrIDxyBfDwTE0I8PA8cofvOAByCK/vDEMF78wc803e2DzxhirvDEcFyPAscskV9xDJo5woUIZgDASxx8bfCKCJGwQEcYGWGeN9QkdUbEMNx05sXVHJ2itdTVqiMSE1vsAAUQAXbtdzAZcK1A23SKdws8NHSH/gTXfCvi9AeAKZI2E2huss9INZmsdBhFsSCLCJxv8cUYFO8jhQx4VdO755y10dMoHyXTUTeehK9DC55870ZEvHY3CegVFdPQD6B2tXkHqI/LSURGd//B78CJ5XrtIo9g25+2zf56HD3LsUMEZdVwwxCM5HOLHBdx3370LHQlCQDbIeA++Ai54370AHclwikj5qA+3AmSY31H6F5zfizErBcC9NyOixgWCEb7uzY+AWSpAR+qnPu/54RA5eMQQLlAHO3AgEqyYRS4KQYM1XIIDIAzhCDoyghCacIQsCYEKQ+APDuyiIwUIYUfUoA4TKqEjuDghCUGIwhLiQyRKCCE6jtpnm45MI4Q3VAAH5lQPFObQhCC8xBpoUIhczIIVkeCAHeYwCDRIYRjSwMAkOlEJCZjxjGhMoxrXyMY2uvGNcIxjGyvRiUlggBnzkAIaBjGHGmjCBjbwhAk20YcHGPKQiEykIhfJyEY68pGQjGQk+7AJE3gCkJqoAQM2yclOevKToAylKEdJylKa8pSoDAgAOw==',TO_TIMESTAMP(NOW()::text, 'YYYY-MM-DD HH24:MI:SS'),'gif');
INSERT INTO c_member VALUES (nextval('c_member_c_member_id_seq'),'OpenPNE君',0,0,0,'private','public','','','','','0000-01-01 00:00:00',TO_TIMESTAMP(NOW()::text, 'YYYY-MM-DD HH24:MI:SS'),'',0,1,1,1,0,1,'public',0,0,0,0,TO_TIMESTAMP(NOW()::text, 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO c_password_query VALUES (nextval('c_password_query_c_password_query_id_seq'),'母または父の旧姓は？');
INSERT INTO c_password_query VALUES (nextval('c_password_query_c_password_query_id_seq'),'運転免許証番号の下 5 桁は？');
INSERT INTO c_password_query VALUES (nextval('c_password_query_c_password_query_id_seq'),'初恋の人の名前は？');
INSERT INTO c_password_query VALUES (nextval('c_password_query_c_password_query_id_seq'),'卒業した小学校の名前は？');
INSERT INTO c_password_query VALUES (nextval('c_password_query_c_password_query_id_seq'),'本籍地の県名は？');
INSERT INTO c_profile VALUES (nextval('c_profile_c_profile_id_seq'),'sex','性別','',0,0,'public','select',200,0,1,1,'string','',0,0);
INSERT INTO c_profile VALUES (nextval('c_profile_c_profile_id_seq'),'blood_type','血液型','',0,1,'public','select',300,0,1,1,'string','',0,0);
INSERT INTO c_profile VALUES (nextval('c_profile_c_profile_id_seq'),'pre_addr_pref','現住所','',0,1,'public','select',400,0,1,1,'string','',0,0);
INSERT INTO c_profile VALUES (nextval('c_profile_c_profile_id_seq'),'old_addr_pref','出身地','',0,1,'public','select',500,0,1,1,'string','',0,0);
INSERT INTO c_profile VALUES (nextval('c_profile_c_profile_id_seq'),'self_intro','自己紹介','',0,0,'public','textarea',600,0,1,1,'string','',0,0);
INSERT INTO c_profile VALUES (nextval('c_profile_c_profile_id_seq'),'PNE_POINT','ポイント','',0,0,'private','text',1000,0,0,0,'int','',0,0);
INSERT INTO c_profile VALUES (nextval('c_profile_c_profile_id_seq'),'PNE_MY_NEWS','My News','',0,0,'private','text',1000,0,0,0,'','',0,0);
INSERT INTO c_profile VALUES (nextval('c_profile_c_profile_id_seq'),'PNE_MY_NEWS_DATETIME','My News（更新記録）','',0,0,'private','text',1000,0,0,0,'','',0,0);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),1,'男性',1);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),1,'女性',2);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),2,'A',1);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),2,'B',2);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),2,'O',3);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),2,'AB',4);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'北海道',1);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'青森県',2);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'岩手県',3);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'宮城県',4);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'秋田県',5);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'山形県',6);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'福島県',7);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'茨城県',8);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'栃木県',9);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'群馬県',10);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'埼玉県',11);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'千葉県',12);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'東京都',13);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'神奈川県',14);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'新潟県',15);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'富山県',16);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'石川県',17);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'福井県',18);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'山梨県',19);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'長野県',20);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'岐阜県',21);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'静岡県',22);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'愛知県',23);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'三重県',24);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'滋賀県',25);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'京都府',26);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'大阪府',27);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'兵庫県',28);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'奈良県',29);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'和歌山県',30);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'鳥取県',31);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'島根県',32);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'岡山県',33);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'広島県',34);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'山口県',35);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'徳島県',36);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'香川県',37);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'愛媛県',38);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'高知県',39);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'福岡県',40);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'佐賀県',41);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'長崎県',42);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'熊本県',43);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'大分県',44);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'宮崎県',45);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'鹿児島県',46);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'沖縄県',47);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),3,'その他',48);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'北海道',1);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'青森県',2);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'岩手県',3);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'宮城県',4);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'秋田県',5);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'山形県',6);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'福島県',7);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'茨城県',8);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'栃木県',9);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'群馬県',10);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'埼玉県',11);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'千葉県',12);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'東京都',13);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'神奈川県',14);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'新潟県',15);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'富山県',16);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'石川県',17);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'福井県',18);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'山梨県',19);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'長野県',20);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'岐阜県',21);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'静岡県',22);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'愛知県',23);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'三重県',24);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'滋賀県',25);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'京都府',26);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'大阪府',27);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'兵庫県',28);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'奈良県',29);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'和歌山県',30);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'鳥取県',31);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'島根県',32);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'岡山県',33);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'広島県',34);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'山口県',35);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'徳島県',36);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'香川県',37);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'愛媛県',38);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'高知県',39);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'福岡県',40);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'佐賀県',41);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'長崎県',42);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'熊本県',43);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'大分県',44);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'宮崎県',45);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'鹿児島県',46);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'沖縄県',47);
INSERT INTO c_profile_option VALUES (nextval('c_profile_option_c_profile_option_id_seq'),4,'その他',48);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'北海道',1,43.068612,141.350768,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'青森県',2,40.828668,140.734738,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'岩手県',3,39.701547,141.136599,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'宮城県',4,38.260027,140.882158,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'秋田県',5,39.716748,140.129931,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'山形県',6,38.248098,140.327253,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'福島県',7,37.754123,140.45968,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'茨城県',8,36.370911,140.47676,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'栃木県',9,36.559246,139.898389,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'群馬県',10,36.383399,139.072833,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'埼玉県',11,35.906439,139.62405,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'千葉県',12,35.613425,140.112837,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'東京都',13,35.681391,139.766103,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'神奈川県',14,35.465941,139.622847,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'新潟県',15,37.912299,139.060869,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'富山県',16,36.701384,137.213091,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'石川県',17,36.578117,136.648166,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'福井県',18,36.061479,136.223261,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'山梨県',19,35.667054,138.569015,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'長野県',20,36.643307,138.189101,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'岐阜県',21,35.409967,136.756324,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'静岡県',22,34.971629,138.388579,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'愛知県',23,35.170694,136.881637,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'三重県',24,34.734418,136.510581,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'滋賀県',25,35.002997,135.864651,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'京都府',26,34.985705,135.758228,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'大阪府',27,34.702398,135.495188,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'兵庫県',28,34.679453,135.178221,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'奈良県',29,34.680482,135.818935,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'和歌山県',30,34.232436,135.191454,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'鳥取県',31,35.493953,134.225901,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'島根県',32,35.463947,133.063871,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'岡山県',33,34.666572,133.918552,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'広島県',34,34.397446,132.475593,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'山口県',35,34.172649,131.48061,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'徳島県',36,34.074572,134.551391,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'香川県',37,34.350754,134.046821,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'愛媛県',38,33.839954,132.751149,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'高知県',39,33.566758,133.543522,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'福岡県',40,33.590002,130.420622,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'佐賀県',41,33.264212,130.297608,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'長崎県',42,32.753085,129.870515,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'熊本県',43,32.789207,130.688499,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'大分県',44,33.232794,131.606595,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'宮崎県',45,31.915323,131.432083,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'鹿児島県',46,31.602098,130.564112,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'沖縄県',47,26.212401,127.680932,7);
INSERT INTO c_profile_pref VALUES (nextval('c_profile_pref_c_profile_pref_id_seq'),'その他',50,0,0,0);
INSERT INTO c_rank VALUES (nextval('c_rank_c_rank_id_seq'),'REGULAR','r_1_regular.gif',0);
INSERT INTO c_rank VALUES (nextval('c_rank_c_rank_id_seq'),'SILVER','r_2_silver.gif',100);
INSERT INTO c_rank VALUES (nextval('c_rank_c_rank_id_seq'),'GOLD','r_3_gold.gif',1000);
INSERT INTO c_rank VALUES (nextval('c_rank_c_rank_id_seq'),'PLATINUM','r_4_platinum.gif',10000);
INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Books','和書',1);
INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'ForeignBooks','洋書',2);
INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Music','CDポピュラー',3);
INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Classical','CDクラシック',4);
INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'DVD','DVD',5);
INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'VideoGames','ゲーム',6);
INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Software','ソフトウェア',7);
INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Electronics','エレクトロニクス',8);
INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Kitchen','キッチン',9);
INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Toys','おもちゃ＆ホビー',10);
INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'SportingGoods','スポーツ',11);
INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'HealthPersonalCare','ヘルス＆ビューティー',12);
INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Watches','時計',13);
INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Baby','ベビー＆マタニティ',14);
INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Apparel','アパレル＆シューズ',15);
INSERT INTO c_siteadmin VALUES (nextval('c_siteadmin_c_siteadmin_id_seq'),'inc_page_footer_before','<a href=\"./?m=pc&amp;a=page_o_sns_kiyaku\" target=\"_blank\">利用規約</a> <a href=\"./?m=pc&amp;a=page_o_sns_privacy\" target=\"_blank\">プライバシーポリシー</a> <a href=\"http://www.openpne.jp/about/\" target=\"_blank\">OpenPNEとは</a>',NOW());
INSERT INTO c_siteadmin VALUES (nextval('c_siteadmin_c_siteadmin_id_seq'),'inc_page_footer_after','<a href=\"./?m=pc&amp;a=page_o_sns_kiyaku\" target=\"_blank\">利用規約</a> <a href=\"./?m=pc&amp;a=page_o_sns_privacy\" target=\"_blank\">プライバシーポリシー</a>',NOW());
INSERT INTO c_siteadmin VALUES (nextval('c_siteadmin_c_siteadmin_id_seq'),'inc_custom_css','/**フォント色変更**/\n\n/*リンク関連*/\na:link    { color: #026CD1; }\na:visited { color: #004A95; }\na:hover   { color: #76AFE6; }\na:active  { color: #76AFE6; }\n\n/*コンテンツ見出しlv1*/\ntd.bg_06 span.b_b,\n.c_00 { color: #222222; }\n\n/*コンテンツ見出しlv2*/\n.c_01 { color: #444444; }\n\n/*強調文字暖色*/\n.c_02 { color: #D92C49; }\n\n/*強調文字寒色*/\n.c_03 { color: #2C65D9; }\n\n/*その他文字色*/\nbody { color: #000000; }',NOW());
INSERT INTO c_skin_filename VALUES (nextval('c_skin_filename_c_skin_filename_id_seq'),'no_image','skin_no_image.gif');
INSERT INTO c_skin_filename VALUES (nextval('c_skin_filename_c_skin_filename_id_seq'),'no_logo','skin_no_logo.gif');
INSERT INTO c_skin_filename VALUES (nextval('c_skin_filename_c_skin_filename_id_seq'),'no_logo_small','skin_no_logo_small.gif');
INSERT INTO mail_queue_seq VALUES (1);

INSERT INTO portal_config VALUES (nextval('portal_config_portal_config_id_seq'),'USE_PORTAL','0');
INSERT INTO portal_config VALUES (nextval('portal_config_portal_config_id_seq'),'HEAD_TEXT_TYPE','0');
INSERT INTO portal_config VALUES (nextval('portal_config_portal_config_id_seq'),'HEAD_TEXT','');
INSERT INTO portal_config VALUES (nextval('portal_config_portal_config_id_seq'),'LAYOUT_TYPE','2');
INSERT INTO portal_config VALUES (nextval('portal_config_portal_config_id_seq'),'COLOR_TYPE','005_openpne_blue');

INSERT INTO c_module VALUES(nextval('c_module_c_module_id_seq'), 'portal', 1);

