Mercurial > hg > pnewss

annotate 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
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
14
372f4e195986 Added article blacklist function, switch to binary-safe latin1 character set for database
Ivo Smits <Ivo@UCIS.nl>
parents: 12
diff changeset
1 CREATE TABLE IF NOT EXISTS `blacklist` (
372f4e195986 Added article blacklist function, switch to binary-safe latin1 character set for database
Ivo Smits <Ivo@UCIS.nl>
parents: 12
diff changeset
2 `messageid` varchar(255) character set ascii NOT NULL,
372f4e195986 Added article blacklist function, switch to binary-safe latin1 character set for database
Ivo Smits <Ivo@UCIS.nl>
parents: 12
diff changeset
3 PRIMARY KEY (`messageid`)
372f4e195986 Added article blacklist function, switch to binary-safe latin1 character set for database
Ivo Smits <Ivo@UCIS.nl>
parents: 12
diff changeset
4 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1
61fac319ca3e Update Path and Xref header fields while fetching messages, added database schema export
Ivo Smits <Ivo@UCIS.nl>
parents:
diff changeset
5 CREATE TABLE IF NOT EXISTS `groupmessages` (
61fac319ca3e Update Path and Xref header fields while fetching messages, added database schema export
Ivo Smits <Ivo@UCIS.nl>
parents:
diff changeset
6 `group` int(10) unsigned NOT NULL,
14
372f4e195986 Added article blacklist function, switch to binary-safe latin1 character set for database
Ivo Smits <Ivo@UCIS.nl>
parents: 12
diff changeset
7 `message` int(10) unsigned default NULL,
1
61fac319ca3e Update Path and Xref header fields while fetching messages, added database schema export
Ivo Smits <Ivo@UCIS.nl>
parents:
diff changeset
8 `number` int(10) unsigned NOT NULL auto_increment,
61fac319ca3e Update Path and Xref header fields while fetching messages, added database schema export
Ivo Smits <Ivo@UCIS.nl>
parents:
diff changeset
9 PRIMARY KEY (`group`,`number`),
61fac319ca3e Update Path and Xref header fields while fetching messages, added database schema export
Ivo Smits <Ivo@UCIS.nl>
parents:
diff changeset
10 KEY `message` (`message`)
61fac319ca3e Update Path and Xref header fields while fetching messages, added database schema export
Ivo Smits <Ivo@UCIS.nl>
parents:
diff changeset
11 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
61fac319ca3e Update Path and Xref header fields while fetching messages, added database schema export
Ivo Smits <Ivo@UCIS.nl>
parents:
diff changeset
12 CREATE TABLE IF NOT EXISTS `groups` (
61fac319ca3e Update Path and Xref header fields while fetching messages, added database schema export
Ivo Smits <Ivo@UCIS.nl>
parents:
diff changeset
13 `id` int(10) unsigned NOT NULL auto_increment,
61fac319ca3e Update Path and Xref header fields while fetching messages, added database schema export
Ivo Smits <Ivo@UCIS.nl>
parents:
diff changeset
14 `name` varchar(255) character set ascii NOT NULL,
61fac319ca3e Update Path and Xref header fields while fetching messages, added database schema export
Ivo Smits <Ivo@UCIS.nl>
parents:
diff changeset
15 PRIMARY KEY (`id`),
61fac319ca3e Update Path and Xref header fields while fetching messages, added database schema export
Ivo Smits <Ivo@UCIS.nl>
parents:
diff changeset
16 UNIQUE KEY `name` (`name`)
14
372f4e195986 Added article blacklist function, switch to binary-safe latin1 character set for database
Ivo Smits <Ivo@UCIS.nl>
parents: 12
diff changeset
17 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1
61fac319ca3e Update Path and Xref header fields while fetching messages, added database schema export
Ivo Smits <Ivo@UCIS.nl>
parents:
diff changeset
18 CREATE TABLE IF NOT EXISTS `messages` (
61fac319ca3e Update Path and Xref header fields while fetching messages, added database schema export
Ivo Smits <Ivo@UCIS.nl>
parents:
diff changeset
19 `id` int(10) unsigned NOT NULL auto_increment,
61fac319ca3e Update Path and Xref header fields while fetching messages, added database schema export
Ivo Smits <Ivo@UCIS.nl>
parents:
diff changeset
20 `messageid` varchar(255) character set ascii NOT NULL,
14
372f4e195986 Added article blacklist function, switch to binary-safe latin1 character set for database
Ivo Smits <Ivo@UCIS.nl>
parents: 12
diff changeset
21 `header` text character set latin1 collate latin1_bin NOT NULL,
372f4e195986 Added article blacklist function, switch to binary-safe latin1 character set for database
Ivo Smits <Ivo@UCIS.nl>
parents: 12
diff changeset
22 `body` mediumtext character set latin1 collate latin1_bin NOT NULL,
1
61fac319ca3e Update Path and Xref header fields while fetching messages, added database schema export
Ivo Smits <Ivo@UCIS.nl>
parents:
diff changeset
23 PRIMARY KEY (`id`),
61fac319ca3e Update Path and Xref header fields while fetching messages, added database schema export
Ivo Smits <Ivo@UCIS.nl>
parents:
diff changeset
24 UNIQUE KEY `messageid` (`messageid`)
14
372f4e195986 Added article blacklist function, switch to binary-safe latin1 character set for database
Ivo Smits <Ivo@UCIS.nl>
parents: 12
diff changeset
25 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1
61fac319ca3e Update Path and Xref header fields while fetching messages, added database schema export
Ivo Smits <Ivo@UCIS.nl>
parents:
diff changeset
26 CREATE TABLE IF NOT EXISTS `peergroups` (
61fac319ca3e Update Path and Xref header fields while fetching messages, added database schema export
Ivo Smits <Ivo@UCIS.nl>
parents:
diff changeset
27 `peer` int(10) unsigned NOT NULL,
61fac319ca3e Update Path and Xref header fields while fetching messages, added database schema export
Ivo Smits <Ivo@UCIS.nl>
parents:
diff changeset
28 `group` int(10) unsigned NOT NULL,
61fac319ca3e Update Path and Xref header fields while fetching messages, added database schema export
Ivo Smits <Ivo@UCIS.nl>
parents:
diff changeset
29 `low` int(10) unsigned default NULL,
61fac319ca3e Update Path and Xref header fields while fetching messages, added database schema export
Ivo Smits <Ivo@UCIS.nl>
parents:
diff changeset
30 `high` int(10) unsigned default NULL,
61fac319ca3e Update Path and Xref header fields while fetching messages, added database schema export
Ivo Smits <Ivo@UCIS.nl>
parents:
diff changeset
31 PRIMARY KEY (`peer`,`group`)
61fac319ca3e Update Path and Xref header fields while fetching messages, added database schema export
Ivo Smits <Ivo@UCIS.nl>
parents:
diff changeset
32 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
61fac319ca3e Update Path and Xref header fields while fetching messages, added database schema export
Ivo Smits <Ivo@UCIS.nl>
parents:
diff changeset
33 CREATE TABLE IF NOT EXISTS `peers` (
61fac319ca3e Update Path and Xref header fields while fetching messages, added database schema export
Ivo Smits <Ivo@UCIS.nl>
parents:
diff changeset
34 `id` int(10) unsigned NOT NULL auto_increment,
61fac319ca3e Update Path and Xref header fields while fetching messages, added database schema export
Ivo Smits <Ivo@UCIS.nl>
parents:
diff changeset
35 `address` varchar(255) collate utf8_unicode_ci NOT NULL,
14
372f4e195986 Added article blacklist function, switch to binary-safe latin1 character set for database
Ivo Smits <Ivo@UCIS.nl>
parents: 12
diff changeset
36 `enabled` tinyint(1) unsigned NOT NULL default '1',
2
40e545510a57 Added support for POSTing to the server, added readme and todo, added support for upstream synchronization using POST
Ivo Smits <Ivo@UCIS.nl>
parents: 1
diff changeset
37 `post` tinyint(1) unsigned NOT NULL,
40e545510a57 Added support for POSTing to the server, added readme and todo, added support for upstream synchronization using POST
Ivo Smits <Ivo@UCIS.nl>
parents: 1
diff changeset
38 `lastposted` int(10) unsigned default NULL,
1
61fac319ca3e Update Path and Xref header fields while fetching messages, added database schema export
Ivo Smits <Ivo@UCIS.nl>
parents:
diff changeset
39 PRIMARY KEY (`id`)
14
372f4e195986 Added article blacklist function, switch to binary-safe latin1 character set for database
Ivo Smits <Ivo@UCIS.nl>
parents: 12
diff changeset
40 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1
61fac319ca3e Update Path and Xref header fields while fetching messages, added database schema export
Ivo Smits <Ivo@UCIS.nl>
parents:
diff changeset
41