1)Schema changes --
a) Adding custom fields to parliamentary_items and groups --
adding to parliamentary_items will add to all question, motion, bill
etc... similarly adding to groups will enable it for parliaments,
committes, parliamentary groups, sessions, sittings. So :
parliamentary_items : custom1 → 4 unicode text fields
groups : custom1 → 4 unicode text fields
b) Field size changes --
users.national_id currently Unicode(32) , make it Unicode(256)
user.uri currently String(120) , make it Unicode(1024), similarly
parliamentary_items.uri to Unicode(1024)
tabled_documents.link currently String(256), needs to be character
varying (2000) , see http://www.boutell.com/newfaq/misc/urllength.html
holidays.holiday_name from Unicode(32) to Unicode(1024)
attached_files.file_name to String(200)
parliamentary_items.geolocation UnicodeText
2) Enabled assign to group / committee for all parliamentary items --
(currently enabled only for bill ).
-- Perhaps this can be done on the ParliamentaryItems domain
definition so all items get it ...
3) Fix workflow for Events and Attachments - to allow private ,
publish-internal , publish -public states
4)Enable "event" for all parliamentary items (currently enabled only
for Bill i think). Also enable "attachment" and "event" to
groupmemberhips so MPs, members of groups (like clerks) also get it
Original issue reported on code.google.com by ashok.ha...@gmail.com on 23 Jun 2011 at 12:53
Original issue reported on code.google.com by
ashok.ha...@gmail.com
on 23 Jun 2011 at 12:53