UPDATE ezsite_data SET value='4.3.0' WHERE name='ezpublish-version';
UPDATE ezsite_data SET value='1' WHERE name='ezpublish-release';

ALTER TABLE ezrss_export_item ADD COLUMN enclosure character varying(255);
ALTER TABLE ezrss_export_item ALTER enclosure SET DEFAULT NULL;

ALTER TABLE ezcontentclass ADD COLUMN serialized_description_list character;
ALTER TABLE ezcontentclass ALTER serialized_description_list SET DEFAULT NULL;

ALTER TABLE ezcontentclass_attribute ADD COLUMN serialized_data_text character;
ALTER TABLE ezcontentclass_attribute ALTER serialized_data_text SET DEFAULT NULL;
ALTER TABLE ezcontentclass_attribute ADD COLUMN serialized_description_list character;
ALTER TABLE ezcontentclass_attribute ALTER serialized_description_list SET DEFAULT NULL;
ALTER TABLE ezcontentclass_attribute ADD COLUMN category character varying(25);

CREATE SEQUENCE ezscheduled_script_s
  START 1
  INCREMENT 1
  MAXVALUE 9223372036854775807
  MINVALUE 1
  CACHE 1;

CREATE TABLE ezscheduled_script (
  command character varying(255) DEFAULT ''::character varying NOT NULL,
  id integer DEFAULT nextval('ezscheduled_script_s'::text) NOT NULL,
  last_report_timestamp integer DEFAULT 0 NOT NULL,
  name character varying(50) DEFAULT ''::character varying NOT NULL,
  process_id integer DEFAULT 0 NOT NULL,
  progress integer DEFAULT 0,
  user_id integer DEFAULT 0 NOT NULL
);
CREATE INDEX ezscheduled_script_timestamp ON ezscheduled_script USING btree ( last_report_timestamp );

ALTER TABLE ONLY ezscheduled_script ADD CONSTRAINT ezscheduled_script_pkey PRIMARY KEY ( id );
