File: phpbb_mysql_fix.sql

package info (click to toggle)
papercut 0.9.13-4
  • links: PTS
  • area: main
  • in suites: etch, etch-m68k
  • size: 396 kB
  • ctags: 496
  • sloc: python: 4,872; xml: 105; sh: 71; makefile: 49; sql: 48
file content (14 lines) | stat: -rw-r--r-- 540 bytes parent folder | download | duplicates (2) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
 
#
# Please change the values here as appropriate to your 
# setup (i.e. table name or size of the 'nntp_group_name' field)
#
# Warning: Do not change the field name to something else than 'nttp_group_name'!
#
ALTER TABLE phpbb_forums ADD nntp_group_name VARCHAR(30) AFTER forum_name;
ALTER TABLE phpbb_forums ADD UNIQUE (nntp_group_name);

#
# After dumping this file into MySQL you will need to manually update the contents
# of the 'nttp_group_name' field to associate a table name / forum with a newsgroup to
# be available on Papercut
#