/* ----------------------------------------------------------*/ DROP TABLE IF EXISTS `administrators`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `administrators` ( `id` int(11) NOT NULL auto_increment, `uid` varchar(15) NOT NULL, `pwd` varchar(15), PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; LOCK TABLES `administrators` WRITE; INSERT INTO `administrators` VALUES (1,'twins','password'); UNLOCK TABLES; /* ----------------------------------------------------------*/ DROP TABLE IF EXISTS `news`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `news` ( `id` int(11) NOT NULL auto_increment, `title` varchar(255) NOT NULL, `text` text NOT NULL, `image1` varchar(255), `image2` varchar(255), `image3` varchar(255), `created_at` datetime default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; LOCK TABLES `news` WRITE; UNLOCK TABLES; /* ----------------------------------------------------------*/ DROP TABLE IF EXISTS `areas`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `areas` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; LOCK TABLES `areas` WRITE; INSERT INTO `areas` VALUES (1, "北海道"); INSERT INTO `areas` VALUES (2, "東北"); INSERT INTO `areas` VALUES (3, "関東"); INSERT INTO `areas` VALUES (4, "甲信越"); INSERT INTO `areas` VALUES (5, "北陸"); INSERT INTO `areas` VALUES (6, "東海"); INSERT INTO `areas` VALUES (7, "関西"); INSERT INTO `areas` VALUES (8, "中国"); INSERT INTO `areas` VALUES (9, "四国"); INSERT INTO `areas` VALUES (10, "九州"); INSERT INTO `areas` VALUES (11, "沖縄"); INSERT INTO `areas` VALUES (12, "海外"); UNLOCK TABLES; /* ----------------------------------------------------------*/ DROP TABLE IF EXISTS `prefs`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `prefs` ( `id` int(11) NOT NULL auto_increment, `area_id` int(11) NOT NULL, `name` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; LOCK TABLES `prefs` WRITE; INSERT INTO `prefs` (area_id, name) VALUES (1, "北海道"); INSERT INTO `prefs` (area_id, name) VALUES (2, "青森県"); INSERT INTO `prefs` (area_id, name) VALUES (2, "岩手県"); INSERT INTO `prefs` (area_id, name) VALUES (2, "宮城県"); INSERT INTO `prefs` (area_id, name) VALUES (2, "秋田県"); INSERT INTO `prefs` (area_id, name) VALUES (2, "山形県"); INSERT INTO `prefs` (area_id, name) VALUES (2, "福島県"); INSERT INTO `prefs` (area_id, name) VALUES (3, "茨城県"); INSERT INTO `prefs` (area_id, name) VALUES (3, "栃木県"); INSERT INTO `prefs` (area_id, name) VALUES (3, "群馬県"); INSERT INTO `prefs` (area_id, name) VALUES (3, "埼玉県"); INSERT INTO `prefs` (area_id, name) VALUES (3, "千葉県"); INSERT INTO `prefs` (area_id, name) VALUES (3, "東京都"); INSERT INTO `prefs` (area_id, name) VALUES (3, "神奈川県"); INSERT INTO `prefs` (area_id, name) VALUES (4, "山梨県"); INSERT INTO `prefs` (area_id, name) VALUES (4, "長野県"); INSERT INTO `prefs` (area_id, name) VALUES (4, "新潟県"); INSERT INTO `prefs` (area_id, name) VALUES (5, "富山県"); INSERT INTO `prefs` (area_id, name) VALUES (5, "石川県"); INSERT INTO `prefs` (area_id, name) VALUES (5, "福井県"); INSERT INTO `prefs` (area_id, name) VALUES (6, "岐阜県"); INSERT INTO `prefs` (area_id, name) VALUES (6, "静岡県"); INSERT INTO `prefs` (area_id, name) VALUES (6, "愛知県"); INSERT INTO `prefs` (area_id, name) VALUES (6, "三重県"); INSERT INTO `prefs` (area_id, name) VALUES (7, "滋賀県"); INSERT INTO `prefs` (area_id, name) VALUES (7, "京都府"); INSERT INTO `prefs` (area_id, name) VALUES (7, "大阪府"); INSERT INTO `prefs` (area_id, name) VALUES (7, "兵庫県"); INSERT INTO `prefs` (area_id, name) VALUES (7, "奈良県"); INSERT INTO `prefs` (area_id, name) VALUES (7, "和歌山県"); INSERT INTO `prefs` (area_id, name) VALUES (8, "鳥取県"); INSERT INTO `prefs` (area_id, name) VALUES (8, "島根県"); INSERT INTO `prefs` (area_id, name) VALUES (8, "岡山県"); INSERT INTO `prefs` (area_id, name) VALUES (8, "広島県"); INSERT INTO `prefs` (area_id, name) VALUES (8, "山口県"); INSERT INTO `prefs` (area_id, name) VALUES (9, "徳島県"); INSERT INTO `prefs` (area_id, name) VALUES (9, "香川県"); INSERT INTO `prefs` (area_id, name) VALUES (9, "愛媛県"); INSERT INTO `prefs` (area_id, name) VALUES (9, "高知県"); INSERT INTO `prefs` (area_id, name) VALUES (10, "福岡県"); INSERT INTO `prefs` (area_id, name) VALUES (10, "佐賀県"); INSERT INTO `prefs` (area_id, name) VALUES (10, "長崎県"); INSERT INTO `prefs` (area_id, name) VALUES (10, "熊本県"); INSERT INTO `prefs` (area_id, name) VALUES (10, "大分県"); INSERT INTO `prefs` (area_id, name) VALUES (10, "宮崎県"); INSERT INTO `prefs` (area_id, name) VALUES (10, "鹿児島県"); INSERT INTO `prefs` (area_id, name) VALUES (11, "沖縄県"); INSERT INTO `prefs` (area_id, name) VALUES (12, "香港"); UNLOCK TABLES; /* ----------------------------------------------------------*/ DROP TABLE IF EXISTS `shops`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `shops` ( `id` int(11) NOT NULL auto_increment, `pref_id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `addr1` varchar(255), `addr2` varchar(255), `tel` varchar(255) NOT NULL, `url` varchar(255), PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; LOCK TABLES `shops` WRITE; INSERT INTO `shops` (pref_id,name,addr1,addr2,tel,url) VALUES (13,"kakimoto arms自由が丘店" ,"目黒区自由が丘1-29-14 J-FRONTビル2F" ,"" ,"03-3718-4646" ,"http://www.kakimoto-arms.com/"); INSERT INTO `shops` (pref_id,name,addr1,addr2,tel,url) VALUES (13,"kakimoto arms自由が丘CREO店" ,"目黒区自由が丘1-7-13クレオビル2Ｆ" ,"" ,"03-3724-7790" ,"http://www.kakimoto-arms.com/"); INSERT INTO `shops` (pref_id,name,addr1,addr2,tel,url) VALUES (13,"kakimoto arms田園調布店" ,"大田区田園調布3-1-6" ,"" ,"03-3722-3681" ,"http://www.kakimoto-arms.com/"); INSERT INTO `shops` (pref_id,name,addr1,addr2,tel,url) VALUES (13,"kakimoto arms青山店" ,"港区南青山5-6-12" "" ,"" ,"03-5464-0011" ,"http://www.kakimoto-arms.com/"); INSERT INTO `shops` (pref_id,name,addr1,addr2,tel,url) VALUES (13,"kakimoto arms銀座店" ,"中央区銀座6-8-7 交詢ビル3F" ,"" ,"03-5537-1088" ,"http://www.kakimoto-arms.com/"); INSERT INTO `shops` (pref_id,name,addr1,addr2,tel,url) VALUES (13,"kakimoto arms六本木ヒルズ店" ,"港区六本木6-10-3 六本木ヒルズウェストウォーク2F" ,"" ,"03-5786-9810" ,"http://www.kakimoto-arms.com/"); INSERT INTO `shops` (pref_id,name,addr1,addr2,tel,url) VALUES (13,"kakimoto arms GINZA 2chome店" ,"中央区銀座2-4-6 銀座ベルビア館6F" ,"" ,"03-5761-7766" ,"http://www.kakimoto-arms.com/"); INSERT INTO `shops` (pref_id,name,addr1,addr2,tel,url) VALUES (13,"nadine EXECUTIVE SALON" ,"" ,"" ,"03-5414-0039" ,"http://www.nadine.jp/"); INSERT INTO `shops` (pref_id,name,addr1,addr2,tel,url) VALUES (13,"nadine NAILS" ,"渋谷区東3-24-4 高間ビル2階" ,"" ,"03-5778-3170" ,"http://www.nadine.jp/"); INSERT INTO `shops` (pref_id,name,addr1,addr2,tel,url) VALUES (13,"Nail Salon color恵比寿" ,"渋谷区東3-26-4タチムラビル6階" ,"" ,"03-6277-4273" ,"http://www.color-nailsalon.com/"); INSERT INTO `shops` (pref_id,name,addr1,addr2,tel,url) VALUES (13,"Nail Salon color田端" ,"荒川区西尾久1-12-8野崎ビル1階" ,"" ,"03-3894-2338" ,"http://www.ashitawa.com/"); INSERT INTO `shops` (pref_id,name,addr1,addr2,tel,url) VALUES (13,"Nailful" ,"渋谷区神南1-18-2神南坂フレームビル2階" ,"" ,"0120-42-8215" ,"http://www.nailful.com/"); INSERT INTO `shops` (pref_id,name,addr1,addr2,tel,url) VALUES (13,"nailroom自由が丘" ,"世田谷区奥沢5-24-2-302株式会社アルファセクション内" ,"" ,"090-5419-0041","http://ameblo.jp/nailroom/"); INSERT INTO `shops` (pref_id,name,addr1,addr2,tel,url) VALUES (13,"Nail Salon NaNa" ,"新宿区四谷4-3 エクシーナ四谷502" ,"" ,"03-6380-6039" ,"http://www.nana-nail.com/"); INSERT INTO `shops` (pref_id,name,addr1,addr2,tel,url) VALUES (13,"nina nail and foot" ,"港区西麻布3-2-15 藤田万年堂ビル4階" ,"" ,"03-5411-1527" ,"http://www.nina-nail.com/"); INSERT INTO `shops` (pref_id,name,addr1,addr2,tel,url) VALUES (13,"HARU" ,"港区南麻布1丁目5-1" ,"" ,"03-3453-0430" ,"http://www.haru-salon.com/"); INSERT INTO `shops` (pref_id,name,addr1,addr2,tel,url) VALUES (13,"ネイルサロンEIMY 小岩店" ,"江戸川区南小岩7-26-20 並木ビル2階" ,"" ,"03-5589-8025" ,"http://members.jcom.home.ne.jp/eimy/"); INSERT INTO `shops` (pref_id,name,addr1,addr2,tel,url) VALUES (14,"Nail Rei" ,"横浜市中区本牧緑ヶ丘82-44" ,"" ,"045-622-9816" ,"http://www5f.biglobe.ne.jp/~nailrei/"); INSERT INTO `shops` (pref_id,name,addr1,addr2,tel,url) VALUES (14,"kakimoto arms Oval店" ,"川崎市幸区堀川町72-1" ,"LEZONAKAWASAKIPLAZA2F 25400","044-874-8266" ,"http://www.kakimoto-arms.com/"); INSERT INTO `shops` (pref_id,name,addr1,addr2,tel,url) VALUES (14,"kakimoto arms LA CITTADELLA店" ,"川崎市川崎区小川町4-1 LA CITTADELLA内" ,"" ,"044-230-116" ,"http://www.kakimoto-arms.com/"); INSERT INTO `shops` (pref_id,name,addr1,addr2,tel,url) VALUES (14,"NAIL SALON＆OXY BAR AQUA Marine" ,"横浜市中区尾上町5-73 馬車道ビル5階" ,"" ,"045-663-0258" ,"http://www.nail-aquamarine.com/"); INSERT INTO `shops` (pref_id,name,addr1,addr2,tel,url) VALUES (12,"カジュアルエステ Brave" ,"木更津市請西東8-2-9" ,"" ,"0438-72-1116" ,"http://www.brave8.com/"); INSERT INTO `shops` (pref_id,name,addr1,addr2,tel,url) VALUES (12,"ネイルサロンEIMY 柏店" ,"柏市中央2-1-3 柏中央ビル3階" ,"" ,"04-7139-9270" ,"http://members.jcom.home.ne.jp/eimy/"); INSERT INTO `shops` (pref_id,name,addr1,addr2,tel,url) VALUES (17,"Nail Salon Gem" ,"長岡市殿町1-4-1鉢伏屋ビル2階" ,"" ,"0258-37-4065" ,"http://www.najilabo.net/shop/shop.shtml?s=958"); INSERT INTO `shops` (pref_id,name,addr1,addr2,tel,url) VALUES (17,"NAIL SALON f" ,"長岡市城内町1-61-1 JR駅ビル2階" ,"" ,"0258-35-5525" ,""); INSERT INTO `shops` (pref_id,name,addr1,addr2,tel,url) VALUES (23,"Nailist 松坂屋本店本館店" ,"名古屋市中区栄3-16-1松坂屋本店本館1階" ,"" ,"052-264-2601" ,"http://www.nailist.co.jp/index.html"); INSERT INTO `shops` (pref_id,name,addr1,addr2,tel,url) VALUES (23,"Nailist メナードビレック店" ,"名古屋市東区泉1-22-7メナードビレック2階" ,"" ,"052-951-2831" ,"http://www.nailist.co.jp/index.html"); INSERT INTO `shops` (pref_id,name,addr1,addr2,tel,url) VALUES (23,"MIMIC nails" ,"豊田市若宮町1-57-1豊田T-FACE3階" ,"" ,"0565-32-2500" ,"http://www.nailist.co.jp/index.html"); INSERT INTO `shops` (pref_id,name,addr1,addr2,tel,url) VALUES (22,"トータルビューティーサロンROTIEA" ,"御殿場市東田中2-20-5 2階" ,"" ,"090-4798-4043","http://www9.plala.or.jp/ROTIEA/"); INSERT INTO `shops` (pref_id,name,addr1,addr2,tel,url) VALUES (28,"nails pulire" ,"神戸市灘区八幡町2-7-16" ,"" ,"078-841-7572" ,"http://www.nails-pulire.com/"); INSERT INTO `shops` (pref_id,name,addr1,addr2,tel,url) VALUES (26,"nailすまいる京都三条店内 Briller Reve","京都市中京区中之町9 グランデアサイ3C号室" ,"" ,"090-1159-3896","http://ameblo.jp/briller-reve0717/"); INSERT INTO `shops` (pref_id,name,addr1,addr2,tel,url) VALUES (26,"Nail Salon etoile" ,"京都市中京区壬生坊城町2 NARUMIビル2階" ,"" ,"075-821-5556" ,"http://www.nail-etoile.com"); INSERT INTO `shops` (pref_id,name,addr1,addr2,tel,url) VALUES (27,"Nail Salon gros-grain" ,"河内長野市西之山町2-1 503号室" ,"" ,"075-52-7030" ,"http://ameblo.jp/gros-grain/"); INSERT INTO `shops` (pref_id,name,addr1,addr2,tel,url) VALUES (27,"nail salon spirit" ,"大阪市西成区鶴見橋3-2-25" ,"" ,"080-3367-2417","http://ameblo.jp/nail-share/"); INSERT INTO `shops` (pref_id,name,addr1,addr2,tel,url) VALUES (34,"Nail&Relaxation COCORO" ,"広島市西区三條北町7-9" ,"" ,"082-509-1733" ,"http://www.cocoro-inc.biz/"); INSERT INTO `shops` (pref_id,name,addr1,addr2,tel,url) VALUES (34,"Nail Salon Nomblic" ,"広島市中区三川町5-7 並木ビル4階" ,"" ,"082-545-2236" ,"http://www.nomblic.com/"); INSERT INTO `shops` (pref_id,name,addr1,addr2,tel,url) VALUES (48,"Creative Designs of Nails" ,"22/F, The Loop, 33 Wellington St. Central, Hong Kong","" ,"852-2104-7898","http://www.nailsalon.com.hk/"); UNLOCK TABLES;