| 1 | /*!40101 SET NAMES utf8 */; |
|---|
| 2 | |
|---|
| 3 | CREATE TABLE `koko` ( |
|---|
| 4 | `koko_id` int(11) NOT NULL auto_increment, |
|---|
| 5 | `lat` varchar(64) NOT NULL default '0', |
|---|
| 6 | `lon` varchar(64) NOT NULL default '0', |
|---|
| 7 | `c_member_id` int(11) NOT NULL default '0', |
|---|
| 8 | `useragent` text NOT NULL, |
|---|
| 9 | `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
|---|
| 10 | `r_date` date NOT NULL default '0000-00-00', |
|---|
| 11 | PRIMARY KEY (`koko_id`) |
|---|
| 12 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
|---|
| 13 | CREATE INDEX c_member_id ON koko (c_member_id DESC); |
|---|
| 14 | CREATE INDEX r_datetime ON koko (r_datetime DESC); |
|---|
| 15 | CREATE INDEX r_date ON koko (r_date DESC); |
|---|
| 16 | |
|---|
| 17 | CREATE TABLE `koko_diary` ( |
|---|
| 18 | `koko_diary_id` int(11) NOT NULL auto_increment, |
|---|
| 19 | `koko_id` int(11) NOT NULL default '0', |
|---|
| 20 | `c_member_id` int(11) NOT NULL default '0', |
|---|
| 21 | `comment` text NULL, |
|---|
| 22 | `public_flag` enum('public','friend','private') NOT NULL default 'private', |
|---|
| 23 | `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
|---|
| 24 | `r_date` date NOT NULL default '0000-00-00', |
|---|
| 25 | PRIMARY KEY (`koko_diary_id`) |
|---|
| 26 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
|---|
| 27 | CREATE INDEX c_member_id ON koko_diary (c_member_id DESC); |
|---|
| 28 | CREATE INDEX koko_id ON koko_diary (koko_id DESC); |
|---|
| 29 | CREATE INDEX public_flag ON koko_diary (public_flag); |
|---|