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

Last change on this file since 4311 was 4311, checked in by david, 12 years ago
File size: 3.2 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 21, 2007 at 05:34 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 `canon`
26--
27
28CREATE TABLE `canon` (
29  `named_id` int(11) NOT NULL,
30  `canon` varchar(255) character set utf8 NOT NULL,
31  KEY `canon` (`canon`),
32  KEY `named_id` (`named_id`)
33) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
34
35-- --------------------------------------------------------
36
37--
38-- Table structure for table `lock`
39--
40
41CREATE TABLE `lock` (
42  `id` int(11) NOT NULL default '0',
43  PRIMARY KEY  (`id`)
44) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
45
46-- --------------------------------------------------------
47
48--
49-- Table structure for table `named`
50--
51
52CREATE TABLE `named` (
53  `id` int(11) NOT NULL auto_increment,
54  `region` int(11) NOT NULL,
55  `lat` double NOT NULL,
56  `lon` double NOT NULL,
57  `name` varchar(255) character set utf8 NOT NULL,
58  `category` varchar(255) character set utf8 NOT NULL,
59  `is_in` varchar(255) character set utf8 NOT NULL,
60  `rank` tinyint(4) NOT NULL,
61  `info` text character set utf8 NOT NULL,
62  PRIMARY KEY  (`id`),
63  KEY `region` (`region`),
64  KEY `category` (`category`)
65) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=352023472 ;
66
67-- --------------------------------------------------------
68
69--
70-- Table structure for table `node`
71--
72
73CREATE TABLE `node` (
74  `id` int(11) NOT NULL,
75  `lat` double NOT NULL,
76  `lon` double NOT NULL,
77  PRIMARY KEY  (`id`)
78) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
79
80-- --------------------------------------------------------
81
82--
83-- Table structure for table `options`
84--
85
86CREATE TABLE `options` (
87  `id` int(11) NOT NULL auto_increment,
88  `name` varchar(255) NOT NULL,
89  `value` text NOT NULL,
90  PRIMARY KEY  (`id`),
91  UNIQUE KEY `name` (`name`)
92) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=83 ;
93
94-- --------------------------------------------------------
95
96--
97-- Table structure for table `placeindex`
98--
99
100CREATE TABLE `placeindex` (
101  `id` int(11) NOT NULL,
102  `region` int(11) NOT NULL,
103  `lat` double NOT NULL,
104  `lon` double NOT NULL,
105  `rank` tinyint(4) NOT NULL,
106  UNIQUE KEY `id` (`id`),
107  KEY `region` (`region`)
108) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
109
110-- --------------------------------------------------------
111
112--
113-- Table structure for table `segment`
114--
115
116CREATE TABLE `segment` (
117  `id` int(11) NOT NULL,
118  `from` int(11) NOT NULL,
119  `to` int(11) NOT NULL,
120  `lat` double NOT NULL,
121  `lon` double NOT NULL,
122  PRIMARY KEY  (`id`)
123) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
124
125/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
126/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
127/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Note: See TracBrowser for help on using the repository browser.