as an example the lenght of many fields won't be enough.
it depends on every course, but the main problem is that we are using fixed lenght fields for storing an XML structure.
So, as an example, i needed to change this
-- SCORM extensions (based on SCORM 1.2 specs)
prerequisites_t varchar(100),
prerequisites_s varchar(200),
type varchar(1000),
maxtimeallowed varchar(1000),
timelimitaction varchar(1000),
datafromlms varchar(200),
masteryscore varchar(255),
isshared boolean default 'f' not null,
sort_order integer
into
-- SCORM extensions (based on SCORM 1.2 specs)
prerequisites_t varchar(100),
prerequisites_s varchar(2000),
type varchar(1000),
maxtimeallowed varchar(1000),
timelimitaction varchar(1000),
datafromlms varchar(200),
masteryscore varchar(255),
isshared boolean default 'f' not null,
sort_order integer
unfortunately, due to dependent constraints, it's very difficult to do this on a running system. or is there a shortcut ?
(PS i've tried:
ALTER TABLE ims_cp_items ALTER pr_old TYPE character varying(2000);
or the column rename copy drop for postgres 7.4
)
