OpenPNE3 Azure SQL (INSERT)

gistfile1.sql

INSERT INTO sns_term (name,application) VALUES ('friend','pc_frontend'),('friend','mobile_frontend'),('my_friend','pc_frontend'),('my_friend','mobile_frontend'),('community','pc_frontend'),('community','mobile_frontend'),('nickname','pc_frontend'),('nickname','mobile_frontend'),('activity','pc_frontend'),('activity','mobile_frontend'),('post_activity','pc_frontend'),('post_activity','mobile_frontend');
INSERT INTO sns_term_translation (value,lang) VALUES ('friend','en'),('フレンド','ja_JP'),('friend','en'),('ﾌﾚﾝﾄﾞ','ja_JP'),('my friend','en'),('マイフレンド','ja_JP'),('my friend','en'),('ﾏｲﾌﾚﾝﾄﾞ','ja_JP'),('community','en'),('コミュニティ','ja_JP'),('community','en'),('ｺﾐｭﾆﾃｨ','ja_JP'),('nickname','en'),('ニックネーム','ja_JP'),('nickname','en'),('ﾆｯｸﾈｰﾑ','ja_JP'),('activity','en'),('アクティビティ','ja_JP'),('activity','en'),('ｱｸﾃｨﾋﾞﾃｨ','ja_JP'),('Post Activity','en'),('アクティビティ投稿','ja_JP'),('Post Activity','en'),('投稿','ja_JP');
INSERT INTO sns_config (name,value) VALUES ('OpenPNE_revision','46'),('opAshiatoPlugin_revision','3'),('opAuthMobileUIDPlugin_revision','1'),('opBlogPlugin_revision','2'),('opCommunityTopicPlugin_revision','5'),('opDiaryPlugin_revision','8'),('opFavoritePlugin_revision','4'),('opIntroFriendPlugin_revision','2'),('opMessagePlugin_revision','4'),('opOpenSocialPlugin_revision','16'),('shindig_token_cipher_key','37c4b8be784d02328e671703e921a693'),('shindig_token_hmac_key','3be023eb5bc1e14bfd1c1c0391836ce4'),('op_web_api_plugin_auth_type','1'),('op_web_api_plugin_using_cdata','1');
INSERT INTO profile (name,is_required,is_unique,is_edit_public_flag,default_public_flag,form_type,value_type,is_disp_regist,is_disp_config,is_disp_search,is_public_web,value_regexp,value_min,value_max,sort_order,created_at,updated_at) VALUES ('op_preset_sex',1,0,0,1,'select','string',1,1,1,0,NULL,NULL,NULL,110,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('op_preset_birthday',0,0,0,1,'date','string',1,1,1,0,NULL,NULL,NULL,120,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('op_preset_region',0,0,0,1,'region_select','JP',1,1,1,0,NULL,NULL,NULL,125,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('op_preset_self_introduction',0,0,0,1,'textarea','string',1,1,1,0,NULL,NULL,NULL,130,'2011-04-28 23:30:55','2011-04-28 23:30:55');
INSERT INTO navigation (type,uri,sort_order,created_at,updated_at) VALUES ('secure_global','@homepage',0,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('secure_global','@member_search',10,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('secure_global','@community_search',20,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('secure_global','@member_config',30,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('secure_global','@member_invite',40,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('secure_global','@member_logout',50,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('default','@homepage',0,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('default','@friend_list',10,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('default','@member_profile_mine',20,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('default','@member_editProfile',30,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('friend','@member_profile',10,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('friend','@friend_list',20,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('community','@community_home',0,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('community','@community_join',10,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('community','@community_quit',20,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('mobile_home_side','@member_invite',0,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('mobile_home','@friend_list',0,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('mobile_home','@community_joinlist',10,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('mobile_home_center','@member_profile_mine',0,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('backend_side','member/index',10,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('backend_side','monitoring/index',20,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('backend_side','community/index',30,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('backend_side','sns/config',40,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('backend_side','@mail_config',35,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('backend_side','design/index',50,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('backend_side','navigation/index',60,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('backend_side','profile/list',70,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('backend_side','plugin/list',80,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('backend_side','admin/index',90,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('secure_global','@album_list',25,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('default','@album_list_mine',15,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('friend','@album_list_member',15,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('default','ashiato/list',12,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('mobile_home','ashiato/list',12,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('secure_global','blog/index',26,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('community','communityTopic/listCommunity',5,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('community','communityEvent/listCommunity',6,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('backend_side','communityTopic/topicList',25,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('secure_global','diary/index',25,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('default','diary/listMember',15,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('friend','diary/listMember',15,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('mobile_home_side','@diary_new',15,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('mobile_home_side','@diary_list',16,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('default','favorite/list',19,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('friend','favorite/add',21,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('mobile_home_side','favorite/list',25,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('friend','@obj_member_introfriend',21,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('default','message/index',11,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('friend','message/sendToFriend',22,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('mobile_home_side','message/index',20,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('default','@application',15,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('friend','@application_list',25,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('secure_global','@ranking',23,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('mobile_home_side','@ranking',23,'2011-04-28 23:30:55','2011-04-28 23:30:55');
INSERT INTO navigation_translation (caption,lang) VALUES ('My Home','en'),('マイホーム','ja_JP'),('Search Members','en'),('メンバー検索','ja_JP'),('Search Communities','en'),('コミュニティ検索','ja_JP'),('Settings','en'),('設定変更','ja_JP'),('Invite','en'),('友人を招待する','ja_JP'),('Logout','en'),('ログアウト','ja_JP'),('Home','en'),('ホーム','ja_JP'),('My Friends','en'),('マイフレンド','ja_JP'),('Profile','en'),('プロフィール確認','ja_JP'),('Edit Profile','en'),('プロフィール編集','ja_JP'),('Home','en'),('ホーム','ja_JP'),('Friends','en'),('フレンドリスト','ja_JP'),('Community Top','en'),('コミュニティトップ','ja_JP'),('Join Community','en'),('コミュニティに参加','ja_JP'),('Leave Community','en'),('コミュニティを退会','ja_JP'),('Invite','en'),('[i:140]友人を誘う','ja_JP'),('My Friends','en'),('[i:140]ﾏｲﾌﾚﾝﾄﾞ','ja_JP'),('Communities','en'),('[i:155]参加ｺﾐｭﾆﾃｨ','ja_JP'),('Profile','en'),('[i:140]ﾌﾟﾛﾌｨｰﾙ','ja_JP'),('Members','en'),('メンバー管理','ja_JP'),('Media','en'),('画像・書き込み管理','ja_JP'),('Communities','en'),('コミュニティ管理','ja_JP'),('SNS','en'),('SNS設定','ja_JP'),('Email','en'),('メール設定','ja_JP'),('Appearance','en'),('デザイン設定','ja_JP'),('Navigations','en'),('ナビゲーション設定','ja_JP'),('Profile','en'),('プロフィール項目設定','ja_JP'),('Plugins','en'),('プラグイン設定','ja_JP'),('Administration settings','en'),('管理画面設定','ja_JP'),('Album','en'),('アルバム','ja_JP'),('Album','en'),('アルバム','ja_JP'),('Album','en'),('アルバム','ja_JP'),('Footprint','en'),('あしあと','ja_JP'),('Footprint','en'),('[i:91]あしあと','ja_JP'),('Newest Blog','en'),('最新Blog','ja_JP'),('Topics','en'),('トピックリスト','ja_JP'),('Events','en'),('イベントリスト','ja_JP'),('トピック管理','ja_JP'),('Diary','en'),('日記','ja_JP'),('Diary','en'),('日記','ja_JP'),('Diary','en'),('日記','ja_JP'),('Post a Diary','en'),('日記を書く','ja_JP'),('Recently Posted Diaries','en'),('最新日記','ja_JP'),('Favorite','en'),('お気に入り','ja_JP'),('Add to favorite','en'),('お気に入りに追加','ja_JP'),('Favorite','en'),('お気に入り','ja_JP'),('Write introductory','en'),('紹介文を書く','ja_JP'),('Message','en'),('メッセージ','ja_JP'),('Send Message','en'),('メッセージを送る','ja_JP'),('Message','en'),('ﾒｯｾｰｼﾞ','ja_JP'),('Apps','en'),('アプリ','ja_JP'),('Apps','en'),('アプリ','ja_JP'),('Ranking','en'),('ランキング','ja_JP'),('Rankingﾞ','en'),('[i:191]ﾗﾝｷﾝｸﾞ','ja_JP');
INSERT INTO message_type (type_name,foreign_table,is_deleted,created_at,updated_at)VALUES ('message',NULL,0,'2011-04-28 23:30:56','2011-04-28 23:30:56'),('friend_link',NULL,0,'2011-04-28 23:30:56','2011-04-28 23:30:56'),('community_message','community',0,'2011-04-28 23:30:56','2011-04-28 23:30:56'),('community_taking_over','community',0,'2011-04-28 23:30:56','2011-04-28 23:30:56'),('community_joining_request','community_member',0,'2011-04-28 23:30:56','2011-04-28 23:30:56');
INSERT INTO message_type_translation (body,subject,caption,info,lang) VALUES (NULL,NULL,'通常のメッセージ',NULL,'ja_JP'),(NULL,NULL,'フレンド申請',NULL,'ja_JP'),(NULL,NULL,'コミュニティ一括メッセージ',NULL,'ja_JP'),(NULL,NULL,'コミュニティ管理者交代メッセージ',NULL,'ja_JP'),(NULL,NULL,'コミュニティ参加申請メッセージ',NULL,'ja_JP');
INSERT INTO member (name,invite_member_id,is_login_rejected,created_at,updated_at,is_active) VALUES ('OpenPNE君',NULL,0,'2011-04-28 23:30:55','2011-04-28 23:30:55',1);
INSERT INTO member_profile (member_id,profile_id,profile_option_id,value,value_datetime,public_flag,tree_key,lft,rgt,level,created_at,updated_at) VALUES (1,1,NULL,'Man',NULL,1,1,1,2,0,'2011-04-28 23:30:55','2011-04-28 23:30:55'),(1,2,NULL,'1988-04-23','1988-04-23 00:00:00',1,2,1,2,0,'2011-04-28 23:30:55','2011-04-28 23:30:55'),(1,3,NULL,'Tokyo',NULL,1,3,1,2,0,'2011-04-28 23:30:55','2011-04-28 23:30:55'),(1,4,NULL,'よろしくお願いします。',NULL,1,4,1,2,0,'2011-04-28 23:30:55','2011-04-28 23:30:55');
INSERT INTO member_config (member_id,name,value,value_datetime,name_value_hash,created_at,updated_at) VALUES (1,'pc_address','sns@example.com',NULL,'885654aa381dfadbc6ea2c47a4a30f6a','2011-04-28 23:30:55','2011-04-28 23:30:55'),(1,'password','5f4dcc3b5aa765d61d8327deb882cf99',NULL,'927246e0e2492bb1c4334e89edfa252f','2011-04-28 23:30:55','2011-04-28 23:30:55'),(1,'secret_question','5',NULL,'0ca0709b3ef4d5c7bde5e0f67c2021e1','2011-04-28 23:30:55','2011-04-28 23:30:55'),(1,'secret_answer','c81c00cad27aa757b313626c3c02094f',NULL,'8e460ad7facdeae96bfb1871f5d7a5b3','2011-04-28 23:30:55','2011-04-28 23:30:55');
INSERT INTO gadget (type,name,sort_order,created_at,updated_at) VALUES ('top','birthdayBox',10,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('top','searchBox',10,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('top','informationBox',20,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('sideMenu','memberImageBox',10,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('sideMenu','friendListBox',20,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('sideMenu','communityJoinListBox',30,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('sideBannerContents','languageSelecterBox',10,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('sideBannerContents','sideBanner',20,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('mobileTop','birthdayBox',10,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('mobileTop','informationBox',10,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('loginTop','loginForm',10,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('mobileLoginContents','loginForm',10,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('profileTop','birthdayBox',10,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('profileSideMenu','memberImageBox',10,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('profileSideMenu','friendListBox',20,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('profileSideMenu','communityJoinListBox',30,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('profileContents','profileListBox',10,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('mobileProfileTop','birthdayBox',10,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('mobileProfileBottom','friendListBox',10,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('mobileProfileBottom','communityJoinListBox',20,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('contents','albumFriendList',141,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('contents','albumList',142,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('contents','albumMyList',143,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('profileContents','albumMemberList',141,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('contents','blogFriend',100,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('contents','blogUser',110,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('profileContents','blogUser',100,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('contents','recentCommunityTopicComment',131,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('mobileContents','recentCommunityTopicComment',110,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('contents','recentCommunityEventComment',132,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('mobileContents','recentCommunityEventComment',111,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('contents','diaryFriendList',101,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('contents','diaryList',102,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('contents','diaryCommentHistory',103,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('contents','diaryMyList',104,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('profileContents','diaryMemberList',101,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('mobileContents','diaryFriendList',101,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('mobileContents','diaryList',102,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('mobileContents','diaryCommentHistory',103,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('mobileContents','diaryMyList',104,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('mobileProfileContents','diaryMemberList',101,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('sideMenu','favoriteListBox',40,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('contents','favoriteDiaryNews',103,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('contents','favoriteBlogNews',104,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('mobileContents','favoriteDiaryNews',105,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('contents','applicationBoxes',110,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('profileContents','applicationBoxes',110,'2011-04-28 23:30:55','2011-04-28 23:30:55');
INSERT INTO community_category (name,is_allow_member_community,tree_key,sort_order,lft,rgt,level,created_at,updated_at) VALUES ('コミュニティカテゴリ',1,1,NULL,1,8,0,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('地域',1,1,NULL,2,3,1,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('グルメ',1,1,NULL,4,5,1,'2011-04-28 23:30:55','2011-04-28 23:30:55'),('スポーツ',1,1,NULL,6,7,1,'2011-04-28 23:30:55','2011-04-28 23:30:55');
INSERT INTO banner (name,html,is_use_html) VALUES ('top_before',NULL,0),('side_before',NULL,0),('top_after',NULL,0),('side_after',NULL,0);
INSERT INTO banner_translation (caption,lang) VALUES ('Top banner(before login)','en'),('トップバナー（ログイン前）','ja_JP'),('Side banner(before login)','en'),('サイドバナー（ログイン前）','ja_JP'),('Top banner (after login)','en'),('トップバナー（ログイン後）','ja_JP'),('Side banner (after login)','en'),('サイドバナー（ログイン後）','ja_JP');
INSERT INTO application (member_id,url,height,scrolling,singleton,is_active,is_pc,is_mobile,links,consumer_key,consumer_secret)  VALUES (NULL,'http://labs.spicebox.jp/opensocial/apps/paypalbutton.xml',NULL,0,1,1,1,0,NULL,'','');
INSERT INTO application_translation (title,title_url,description,directory_title,screenshot,thumbnail,author,author_aboutme,author_affiliation,author_email,author_photo,author_link,author_quote,settings,views,lang,created_at,updated_at) VALUES ('PayPal ボタン（寄付・購入）',NULL,'PayPal（ペイパル）の決済サービスを簡単に設置・利用できるアプリです。会費の集金、アイテム購入の支払いに使える「購入ボタン」と、SNSへの寄付や募金に使える「寄付」ボタンがあります。PayPal ボタンのご利用には PayPal アカウントの登録が必要です。',NULL,'http://labs.spicebox.jp/opensocial/apps/paypalbutton/ppbutton_screenshot280.png','http://labs.spicebox.jp/opensocial/apps/paypalbutton/ppgadget.png','スパイスボックスラボラトリ','神部竜二','SPICEBOX LABORATORY','lab@spicebox.co.jp','http://labs.spicebox.jp/about/images/members/member002.jpg','http://labs.spicebox.jp/','spicebox.NEXT をつくる',NULL,NULL,'ja_JP','2011-04-28 23:30:55','1989-01-08 00:00:00');