Index: openacs-4/packages/attachments/attachments.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/attachments/attachments.info,v
diff -u -N -r1.19.2.3 -r1.19.2.4
--- openacs-4/packages/attachments/attachments.info 1 Dec 2015 13:38:53 -0000 1.19.2.3
+++ openacs-4/packages/attachments/attachments.info 14 May 2016 18:10:52 -0000 1.19.2.4
@@ -8,15 +8,15 @@
t
attachments
-
+
OpenACS
Attachment support
2
- 2015-10-04
+ 2016-05-14
OpenACS
Provide widgets and datamodel to support attachments on arbitrary objects. Used by forums.
-
+
Index: openacs-4/packages/attachments/sql/postgresql/attachments-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/attachments/sql/postgresql/attachments-create.sql,v
diff -u -N -r1.4 -r1.4.20.1
--- openacs-4/packages/attachments/sql/postgresql/attachments-create.sql 17 May 2003 10:12:03 -0000 1.4
+++ openacs-4/packages/attachments/sql/postgresql/attachments-create.sql 14 May 2016 18:10:52 -0000 1.4.20.1
@@ -44,10 +44,8 @@
constraint attachments_item_id_fk
references acs_objects(object_id)
on delete cascade,
- approved_p char(1)
- default 't'
- constraint attachments_approved_p_ck
- check (approved_p in ('t', 'f'))
+ approved_p boolean
+ default true
constraint attachments_approved_p_nn
not null,
constraint attachments_pk
Index: openacs-4/packages/attachments/sql/postgresql/upgrade/upgrade-0.11d2-0.11d3.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/attachments/sql/postgresql/upgrade/upgrade-0.11d2-0.11d3.sql,v
diff -u -N
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/attachments/sql/postgresql/upgrade/upgrade-0.11d2-0.11d3.sql 14 May 2016 18:10:52 -0000 1.1.2.1
@@ -0,0 +1,11 @@
+--
+-- Alter caveman style booleans (type character(1)) to real SQL boolean types.
+--
+
+ALTER TABLE attachments
+ DROP constraint IF EXISTS attachments_approved_p_ck,
+ ALTER COLUMN approved_p DROP DEFAULT,
+ ALTER COLUMN approved_p TYPE boolean
+ USING approved_p::boolean,
+ ALTER COLUMN approved_p SET DEFAULT true;
+
Index: openacs-4/packages/faq/faq.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/faq/faq.info,v
diff -u -N -r1.27.2.4 -r1.27.2.5
--- openacs-4/packages/faq/faq.info 1 Dec 2015 13:56:11 -0000 1.27.2.4
+++ openacs-4/packages/faq/faq.info 14 May 2016 18:03:15 -0000 1.27.2.5
@@ -7,18 +7,18 @@
f
f
-
+
Nima Mazloumi
Jennie Kim Housman
Elizabeth Wirth
Manage simple and categorized Question and Answer style FAQs with WYSIWYG and notification functionalities.
- 2015-10-04
+ 2016-05-14
Ybos Corporation
Handles frequently asked questions Q&A presentation. Can be one Q&A per page or all presented flat. Straightforward application with room for improvement. Support for notification as well as WYSIQYG Editor and Categories - both optional. Category trees are displayed flat. No multiple filters.
2
#faq.FAQs#
-
+
Index: openacs-4/packages/faq/sql/postgresql/faq-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/faq/sql/postgresql/faq-create.sql,v
diff -u -N -r1.7 -r1.7.4.1
--- openacs-4/packages/faq/sql/postgresql/faq-create.sql 12 Aug 2013 09:34:30 -0000 1.7
+++ openacs-4/packages/faq/sql/postgresql/faq-create.sql 14 May 2016 18:03:15 -0000 1.7.4.1
@@ -34,8 +34,8 @@
primary key,
faq_name varchar (250)
constraint faqs_faq_name_nn not null,
- separate_p boolean check(separate_p in ('f','t')),
- disabled_p char(1) default 'f' check(disabled_p in ('f','t'))
+ separate_p boolean
+ disabled_p boolean default false
);
Index: openacs-4/packages/faq/sql/postgresql/upgrade/upgrade-5.9.0-5.9.1d1.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/faq/sql/postgresql/upgrade/upgrade-5.9.0-5.9.1d1.sql,v
diff -u -N
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/faq/sql/postgresql/upgrade/upgrade-5.9.0-5.9.1d1.sql 14 May 2016 18:03:15 -0000 1.1.2.1
@@ -0,0 +1,12 @@
+--
+-- Alter caveman style booleans (type character(1)) to real SQL boolean types.
+--
+
+ALTER TABLE faqs
+ DROP constraint IF EXISTS faqs_disabled_p_check,
+ DROP constraint IF EXISTS faqs_separate_p_check,
+ ALTER COLUMN disabled_p DROP DEFAULT,
+ ALTER COLUMN disabled_p TYPE boolean
+ USING disabled_p::boolean,
+ ALTER COLUMN disabled_p SET DEFAULT false;
+