¹¹¿·¤¹¤ë¾ì¹ç¡¢¾å½ñ¤¤¹¤ë¤Î¤«¡¢Äɲ䷤ƺǿ·¤Î¾ðÊó¤ò»È¤¦¤Î¤«
¥Õ¥£¡¼¥ë¥É̾ | ¥Ç¡¼¥¿·¿ | ¥Õ¥£¡¼¥ë¥É¤Ë³ÊǼ¤¹¤ë¤â¤Î | ÀâÌÀ¤Ê¤É |
facility | TEXT | »ÜÀß̾ | ¡¡»ÜÀߡʾ®³Ø¹»,Ãæ³Ø¹»,ɱ¡¡¤¶ä¹Ô¡¤Í¹Êضɡ¤Í¹Êإݥ¹¥È¡Ë |
address | TEXT | ½»½ê | |
latitude | DOUBLE | °ÞÅÙ | |
longitude | DOUBLE | ·ÐÅÙ | |
date | TEXT | ¹¹¿·ÆüÉÕ | |
photo | TEXT | ³°´Ñ¼Ì¿¿ | ¡ú¼Ì¿¿¤ò¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ë³ÊǼ¤¹¤ëÊýË¡¤ò³Îǧ¤¹¤ë |
toilet_photo | TEXT | ¥È¥¤¥ì¤Î¼Ì¿¿ | ¡ú¼Ì¿¿¤ò¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ë³ÊǼ¤¹¤ëÊýË¡¤ò³Îǧ¤¹¤ë |
toilet_info | TEXT | ¥È¥¤¥ì¤Î¾ðÊó | ¤É¤Î¤è¤¦¤Ê¾ðÊó¤¬Îɤ¤¤Î¤«¸¡Æ¤Ãæ |
etc | TEXT | ¤½¤Î¾ | |
¸ø³«¤·¤Ê¤¤¾ðÊó | |||
user_id | TEXT | Åê¹Æ¼Ô | |
access_ip | TEXT | ¥¢¥¯¥»¥¹IP |
mysql -u root -p create database ¥Ç¡¼¥¿¥Ù¡¼¥¹Ì¾; grant all on ¥Ç¡¼¥¿¥Ù¡¼¥¹Ì¾.* to ¥æ¡¼¥¶Ì¾@localhost identified by '¥Ñ¥¹¥ï¡¼¥É'; flush privileges;
CREATE TABLE `OtaruAPIver1` ( `facility` TEXT NOT NULL , `address` TEXT , `latitude` DOUBLE , `longitude` DOUBLE , `date` TEXT NOT NULL , `photo` TEXT , `toilet_phot` TEXT , `toilet_info` TEXT , `etc` TEXT , `user_id` TEXT NOT NULL , `access_ip` TEXT NOT NULL ) ENGINE = MYISAM ;
¸ø¶¦»ÜÀß
´ØÏ¢ÃÄÂÎ