source: subversion/sites/namefinder/namefinder.sql @ 4132

Last change on this file since 4132 was 4132, checked in by david, 12 years ago

Name finder source code, first public release

File size: 3.0 KB
Line 
1-- phpMyAdmin SQL Dump
2-- version 2.10.0.2
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Aug 14, 2007 at 05:11 PM
7-- Server version: 5.0.37
8-- PHP Version: 5.2.1
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11
12
13/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
14/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
15/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
16/*!40101 SET NAMES utf8 */;
17
18--
19-- Database: `osmplaces`
20--
21
22-- --------------------------------------------------------
23
24--
25-- Table structure for table `lock`
26--
27
28CREATE TABLE `lock` (
29  `id` int(11) NOT NULL default '0',
30  PRIMARY KEY  (`id`)
31) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
32
33-- --------------------------------------------------------
34
35--
36-- Table structure for table `named`
37--
38
39CREATE TABLE `named` (
40  `id` int(11) NOT NULL auto_increment,
41  `region` int(11) NOT NULL,
42  `lat` double NOT NULL,
43  `lon` double NOT NULL,
44  `name` varchar(255) character set utf8 NOT NULL,
45  `canon` varchar(255) character set utf8 NOT NULL,
46  `category` varchar(255) character set utf8 NOT NULL,
47  `is_in` varchar(255) character set utf8 NOT NULL,
48  `rank` tinyint(4) NOT NULL,
49  `info` text character set utf8 NOT NULL,
50  PRIMARY KEY  (`id`),
51  KEY `region` (`region`),
52  KEY `canon` (`canon`),
53  KEY `category` (`category`)
54) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=337187152 ;
55
56-- --------------------------------------------------------
57
58--
59-- Table structure for table `node`
60--
61
62CREATE TABLE `node` (
63  `id` int(11) NOT NULL,
64  `lat` double NOT NULL,
65  `lon` double NOT NULL,
66  PRIMARY KEY  (`id`)
67) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
68
69-- --------------------------------------------------------
70
71--
72-- Table structure for table `options`
73--
74
75CREATE TABLE `options` (
76  `id` int(11) NOT NULL auto_increment,
77  `name` varchar(255) NOT NULL,
78  `value` text NOT NULL,
79  PRIMARY KEY  (`id`),
80  UNIQUE KEY `name` (`name`)
81) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=49 ;
82
83-- --------------------------------------------------------
84
85--
86-- Table structure for table `placeindex`
87--
88
89CREATE TABLE `placeindex` (
90  `id` int(11) NOT NULL,
91  `region` int(11) NOT NULL,
92  `lat` double NOT NULL,
93  `lon` double NOT NULL,
94  `rank` tinyint(4) NOT NULL,
95  UNIQUE KEY `id` (`id`),
96  KEY `region` (`region`)
97) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
98
99-- --------------------------------------------------------
100
101--
102-- Table structure for table `segment`
103--
104
105CREATE TABLE `segment` (
106  `id` int(11) NOT NULL,
107  `from` int(11) NOT NULL,
108  `to` int(11) NOT NULL,
109  `lat` double NOT NULL,
110  `lon` double NOT NULL,
111  PRIMARY KEY  (`id`)
112) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
113
114/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
115/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
116/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Note: See TracBrowser for help on using the repository browser.