Index: openacs-4/packages/categories/categories.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/categories/categories.info,v
diff -u -r1.19.2.3 -r1.19.2.4
--- openacs-4/packages/categories/categories.info 1 Dec 2015 13:38:53 -0000 1.19.2.3
+++ openacs-4/packages/categories/categories.info 14 May 2016 18:54:15 -0000 1.19.2.4
@@ -8,7 +8,7 @@
f
categories
-
+
timo@timohentschel.de
Manage categories in category trees and let users map objects to categories.
2015-10-04
@@ -17,7 +17,7 @@
GPL
1
-
+
Index: openacs-4/packages/categories/sql/postgresql/categories-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/categories/sql/postgresql/categories-create.sql,v
diff -u -r1.11 -r1.11.6.1
--- openacs-4/packages/categories/sql/postgresql/categories-create.sql 22 Apr 2008 16:04:38 -0000 1.11
+++ openacs-4/packages/categories/sql/postgresql/categories-create.sql 14 May 2016 18:54:16 -0000 1.11.6.1
@@ -36,9 +36,7 @@
tree_id integer primary key
constraint cat_trees_tree_id_fk
references acs_objects on delete cascade,
- site_wide_p char(1) default 't'
- constraint cat_trees_site_wide_p_ck
- check (site_wide_p in ('t','f'))
+ site_wide_p boolean default true
);
comment on table category_trees is '
@@ -91,9 +89,7 @@
on delete cascade,
parent_id integer constraint cat_parent_id_fk
references categories,
- deprecated_p char(1) default 'f'
- constraint cat_deprecated_p_ck
- check (deprecated_p in ('t','f')),
+ deprecated_p boolean default false,
left_ind integer,
right_ind integer
);
@@ -166,12 +162,8 @@
default null
constraint cat_tree_map_subtree_id_fk
references categories,
- assign_single_p char(1) default 'f'
- constraint cat_tree_map_single_p_ck
- check (assign_single_p in ('t','f')),
- require_category_p char(1) default 'f'
- constraint cat_tree_map_categ_p_ck
- check (require_category_p in ('t','f')),
+ assign_single_p boolean default false,
+ require_category_p boolean default false,
widget varchar(20),
primary key (object_id, tree_id)
);
@@ -300,9 +292,7 @@
constraint category_synonyms_locale_fk
references ad_locales on delete cascade,
name varchar(100) not null,
- synonym_p char(1) default 't'
- constraint category_synonyms_synonym_p_ck
- check (synonym_p in ('t','f'))
+ synonym_p boolean default true
);
-- to get all synonyms in given locale
Index: openacs-4/packages/categories/sql/postgresql/category-package.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/categories/sql/postgresql/category-package.sql,v
diff -u -r1.8 -r1.8.4.1
--- openacs-4/packages/categories/sql/postgresql/category-package.sql 30 Mar 2013 22:50:44 -0000 1.8
+++ openacs-4/packages/categories/sql/postgresql/category-package.sql 14 May 2016 18:54:16 -0000 1.8.4.1
@@ -20,7 +20,7 @@
p_name varchar,
p_description varchar,
p_parent_id integer,
- p_deprecated_p char,
+ p_deprecated_p boolean,
p_creation_date timestamp with time zone,
p_creation_user integer,
p_creation_ip varchar
@@ -137,7 +137,7 @@
DECLARE
BEGIN
update categories
- set deprecated_p = 't'
+ set deprecated_p = true
where category_id = p_category_id;
return 0;
@@ -159,7 +159,7 @@
DECLARE
BEGIN
update categories
- set deprecated_p = 'f'
+ set deprecated_p = false
where category_id = p_category_id;
return 0;
Index: openacs-4/packages/categories/sql/postgresql/category-synonym-package.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/categories/sql/postgresql/category-synonym-package.sql,v
diff -u -r1.3 -r1.3.4.1
--- openacs-4/packages/categories/sql/postgresql/category-synonym-package.sql 30 Mar 2013 22:50:44 -0000 1.3
+++ openacs-4/packages/categories/sql/postgresql/category-synonym-package.sql 14 May 2016 18:54:16 -0000 1.3.4.1
@@ -215,7 +215,7 @@
-- insert synonym data
insert into category_synonyms (synonym_id, category_id, locale, name, synonym_p)
- values (v_synonym_id, p_category_id, p_locale, p_name, 't');
+ values (v_synonym_id, p_category_id, p_locale, p_name, true);
-- insert in synonym index and search results
PERFORM category_synonym__reindex (v_synonym_id, p_name, p_locale);
@@ -304,7 +304,7 @@
-- mark synonym as not editable for users
update category_synonyms
- set synonym_p = 'f'
+ set synonym_p = false
where synonym_id = v_synonym_id;
return new;
@@ -329,7 +329,7 @@
where category_id = OLD.category_id
and name = OLD.name
and locale = OLD.locale
- and synonym_p = 'f';
+ and synonym_p = false;
-- update synonym
PERFORM category_synonym__edit (v_synonym_id, NEW.name, NEW.locale);
Index: openacs-4/packages/categories/sql/postgresql/category-tree-package.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/categories/sql/postgresql/category-tree-package.sql,v
diff -u -r1.14 -r1.14.4.1
--- openacs-4/packages/categories/sql/postgresql/category-tree-package.sql 30 Mar 2013 22:50:44 -0000 1.14
+++ openacs-4/packages/categories/sql/postgresql/category-tree-package.sql 14 May 2016 18:54:16 -0000 1.14.4.1
@@ -262,8 +262,8 @@
p_object_id integer,
p_tree_id integer,
p_subtree_category_id integer,
- p_assign_single_p char,
- p_require_category_p char,
+ p_assign_single_p boolean,
+ p_require_category_p boolean,
p_widget varchar
) RETURNS integer AS $$
DECLARE
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/categories/sql/postgresql/upgrade/upgrade-1.1.3d4-1.1.3d5.sql'.
Fisheye: No comparison available. Pass `N' to diff?