Mercurial > hg > pnewss

comparison database.mysql @ 1:61fac319ca3e

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Update Path and Xref header fields while fetching messages, added database schema export
author Ivo Smits <Ivo@UCIS.nl>
date Mon, 11 Apr 2011 23:17:27 +0200
parents
children 40e545510a57
comparison
equal deleted inserted replaced
0:d7ab68b71c74 1:61fac319ca3e
1 -- phpMyAdmin SQL Dump
2 -- version 3.3.9.2deb1
3 -- http://www.phpmyadmin.net
4 --
5 -- Machine: localhost
6 -- Genereertijd: 11 Apr 2011 om 23:15
7 -- Serverversie: 5.0.51
8 -- PHP-Versie: 5.3.3-7
9
10 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11
12 --
13 -- Database: `ivo_pnewss`
14 --
15
16 -- --------------------------------------------------------
17
18 --
19 -- Tabelstructuur voor tabel `groupmessages`
20 --
21
22 CREATE TABLE IF NOT EXISTS `groupmessages` (
23 `group` int(10) unsigned NOT NULL,
24 `message` int(10) unsigned NOT NULL,
25 `number` int(10) unsigned NOT NULL auto_increment,
26 PRIMARY KEY (`group`,`number`),
27 KEY `message` (`message`)
28 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
29
30 -- --------------------------------------------------------
31
32 --
33 -- Tabelstructuur voor tabel `groups`
34 --
35
36 CREATE TABLE IF NOT EXISTS `groups` (
37 `id` int(10) unsigned NOT NULL auto_increment,
38 `name` varchar(255) character set ascii NOT NULL,
39 PRIMARY KEY (`id`),
40 UNIQUE KEY `name` (`name`)
41 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
42
43 -- --------------------------------------------------------
44
45 --
46 -- Tabelstructuur voor tabel `messages`
47 --
48
49 CREATE TABLE IF NOT EXISTS `messages` (
50 `id` int(10) unsigned NOT NULL auto_increment,
51 `messageid` varchar(255) character set ascii NOT NULL,
52 `header` text character set ascii NOT NULL,
53 `body` text character set ascii NOT NULL,
54 PRIMARY KEY (`id`),
55 UNIQUE KEY `messageid` (`messageid`)
56 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
57
58 -- --------------------------------------------------------
59
60 --
61 -- Tabelstructuur voor tabel `peergroups`
62 --
63
64 CREATE TABLE IF NOT EXISTS `peergroups` (
65 `peer` int(10) unsigned NOT NULL,
66 `group` int(10) unsigned NOT NULL,
67 `low` int(10) unsigned default NULL,
68 `high` int(10) unsigned default NULL,
69 PRIMARY KEY (`peer`,`group`)
70 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
71
72 -- --------------------------------------------------------
73
74 --
75 -- Tabelstructuur voor tabel `peers`
76 --
77
78 CREATE TABLE IF NOT EXISTS `peers` (
79 `id` int(10) unsigned NOT NULL auto_increment,
80 `address` varchar(255) collate utf8_unicode_ci NOT NULL,
81 PRIMARY KEY (`id`)
82 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
83