source: subversion/sites/tile.openstreetmap.org/schema.sql @ 5396

Last change on this file since 5396 was 2562, checked in by steve, 13 years ago

update tile schema

File size: 1.8 KB
RevLine 
[2029]1-- MySQL dump 10.10
2--
3-- Host: localhost    Database: tile
4-- ------------------------------------------------------
5-- Server version       5.0.22-Debian_0ubuntu6.06.2-log
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
[2351]19-- Table structure for table `access`
20--
21
22DROP TABLE IF EXISTS `access`;
23CREATE TABLE `access` (
[2354]24  `ip` varchar(255) NOT NULL default '',
25  `hits` bigint(20) default NULL,
26  PRIMARY KEY  (`ip`)
[2351]27) ENGINE=InnoDB DEFAULT CHARSET=latin1;
28
29--
[2029]30-- Table structure for table `tiles`
31--
32
33DROP TABLE IF EXISTS `tiles`;
34CREATE TABLE `tiles` (
35  `x` int(11) default NULL,
36  `y` int(11) default NULL,
37  `z` int(11) default NULL,
38  `data` mediumblob,
39  `created_at` datetime default NULL,
[2562]40  `dirty_t` varchar(255) default 'true',
[2029]41  KEY `tile_idx` (`x`,`y`,`z`),
[2562]42  KEY `tile_created_at_idx` (`created_at`),
43  KEY `tiles_dirty_t` (`dirty_t`)
[2351]44) ENGINE=InnoDB DEFAULT CHARSET=latin1;
[2029]45/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
46
47/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
48/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
49/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
50/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
51/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
52/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
53/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
54
Note: See TracBrowser for help on using the repository browser.