Mercurial > hg > pnewss

comparison database.mysql @ 14:372f4e195986 draft default tip

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added article blacklist function, switch to binary-safe latin1 character set for database
author Ivo Smits <Ivo@UCIS.nl>
date Thu, 17 Jul 2014 23:24:17 +0200
parents 7917bd536187
children
comparison
equal deleted inserted replaced
13:cccd73f72bf6 14:372f4e195986
1 -- phpMyAdmin SQL Dump 1 CREATE TABLE IF NOT EXISTS `blacklist` (
2 -- version 3.3.9.2deb1 2 `messageid` varchar(255) character set ascii NOT NULL,
3 -- http://www.phpmyadmin.net 3 PRIMARY KEY (`messageid`)
4 -- 4 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
5 -- Machine: localhost
6 -- Genereertijd: 12 Apr 2011 om 01:45
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` ( 5 CREATE TABLE IF NOT EXISTS `groupmessages` (
23 `group` int(10) unsigned NOT NULL, 6 `group` int(10) unsigned NOT NULL,
24 `message` int(10) unsigned NOT NULL, 7 `message` int(10) unsigned default NULL,
25 `number` int(10) unsigned NOT NULL auto_increment, 8 `number` int(10) unsigned NOT NULL auto_increment,
26 PRIMARY KEY (`group`,`number`), 9 PRIMARY KEY (`group`,`number`),
27 KEY `message` (`message`) 10 KEY `message` (`message`)
28 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 11 ) 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` ( 12 CREATE TABLE IF NOT EXISTS `groups` (
37 `id` int(10) unsigned NOT NULL auto_increment, 13 `id` int(10) unsigned NOT NULL auto_increment,
38 `name` varchar(255) character set ascii NOT NULL, 14 `name` varchar(255) character set ascii NOT NULL,
39 PRIMARY KEY (`id`), 15 PRIMARY KEY (`id`),
40 UNIQUE KEY `name` (`name`) 16 UNIQUE KEY `name` (`name`)
41 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 17 ) 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` ( 18 CREATE TABLE IF NOT EXISTS `messages` (
50 `id` int(10) unsigned NOT NULL auto_increment, 19 `id` int(10) unsigned NOT NULL auto_increment,
51 `messageid` varchar(255) character set ascii NOT NULL, 20 `messageid` varchar(255) character set ascii NOT NULL,
52 `header` text character set ascii NOT NULL, 21 `header` text character set latin1 collate latin1_bin NOT NULL,
53 `body` mediumtext character set ascii NOT NULL, 22 `body` mediumtext character set latin1 collate latin1_bin NOT NULL,
54 PRIMARY KEY (`id`), 23 PRIMARY KEY (`id`),
55 UNIQUE KEY `messageid` (`messageid`) 24 UNIQUE KEY `messageid` (`messageid`)
56 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 25 ) 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` ( 26 CREATE TABLE IF NOT EXISTS `peergroups` (
65 `peer` int(10) unsigned NOT NULL, 27 `peer` int(10) unsigned NOT NULL,
66 `group` int(10) unsigned NOT NULL, 28 `group` int(10) unsigned NOT NULL,
67 `low` int(10) unsigned default NULL, 29 `low` int(10) unsigned default NULL,
68 `high` int(10) unsigned default NULL, 30 `high` int(10) unsigned default NULL,
69 PRIMARY KEY (`peer`,`group`) 31 PRIMARY KEY (`peer`,`group`)
70 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 32 ) 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` ( 33 CREATE TABLE IF NOT EXISTS `peers` (
79 `id` int(10) unsigned NOT NULL auto_increment, 34 `id` int(10) unsigned NOT NULL auto_increment,
80 `address` varchar(255) collate utf8_unicode_ci NOT NULL, 35 `address` varchar(255) collate utf8_unicode_ci NOT NULL,
81 `enabled` tinyiny(1) unsigned NOT NULL DEFAULT '1', 36 `enabled` tinyint(1) unsigned NOT NULL default '1',
82 `post` tinyint(1) unsigned NOT NULL, 37 `post` tinyint(1) unsigned NOT NULL,
83 `lastposted` int(10) unsigned default NULL, 38 `lastposted` int(10) unsigned default NULL,
84 PRIMARY KEY (`id`) 39 PRIMARY KEY (`id`)
85 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 40 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
86 41