OK! I succeeded in upgrading! Thanks to David!
I've not only created conf_table but, by hand, upgraded all database structure.
(diff between old and new create_db).
On the bottom of this mail the SQL I've used ... if may be useful for somebody.
Than, when upgrading with "apt-get install sympa" there was till an error.
I ran "sympa.pl --upgrade" and get:
"Cannot access cafile /usr/share/sympa/ca-bundle.crt"
I copied the old file "ca-bundle.crt" from 5.4 files and than upgrade went ok
till the end.
The file was deleted while upgrading debian package: is this an error?
(now problems with wwsympa but this is another story!)
Giorgio
------------------------------------------------------
alter table user_table add column last_login_date_user int4;
alter table user_table add column last_login_host_user varchar (60);
alter table user_table add column wrong_login_count_user int4;
alter table user_table add column data_user varchar (255);
alter table subscriber_table add column custom_attribute_subscriber varchar
(500);
alter table subscriber_table add column suspend_subscriber smallint;
alter table subscriber_table add column suspend_start_date_subscriber int4;
alter table subscriber_table add column suspend_end_date_subscriber int4;
CREATE INDEX subscriber_idx2 ON subscriber_table (user_subscriber);
alter TABLE admin_table add column visibility_admin varchar(20);
CREATE TABLE exclusion_table (
list_exclusion varchar(50),
user_exclusion varchar(100),
date_exclusion int4,
CONSTRAINT ind_exclusion PRIMARY KEY (list_exclusion, user_exclusion)
);
CREATE INDEX exclusion_idx ON exclusion_table(list_exclusion, user_exclusion);
CREATE TABLE session_table (
id_session int8 NOT NULL,
start_date_session int4 NOT NULL,
date_session int4 NOT NULL,
remote_addr_session varchar(60),
robot_session varchar(80),
email_session varchar(100),
hit_session int4,
data_session varchar(255),
CONSTRAINT ind_session PRIMARY KEY (id_session)
);
CREATE INDEX session_idx ON session_table(id_session);
CREATE TABLE one_time_ticket_table (
ticket_one_time_ticket varchar(30),
robot_one_time_ticket varchar(80),
email_one_time_ticket varchar(100),
date_one_time_ticket bigint,
data_one_time_ticket varchar(200),
remote_addr_one_time_ticket varchar(60),
status_one_time_ticket varchar(60),
CONSTRAINT ind_one_time_ticket PRIMARY KEY (ticket_one_time_ticket)
);
CREATE INDEX one_time_ticket_idx ON
one_time_ticket_table(ticket_one_time_ticket);
CREATE TABLE bulkmailer_table(
messagekey_bulkmailer varchar(80),
packetid_bulkmailer varchar(33),
messageid_bulkmailer varchar(100),
receipients_bulkmailer text,
returnpath_bulkmailer varchar(100),
robot_bulkmailer varchar(80),
listname_bulkmailer varchar(50),
verp_bulkmailer smallint,
merge_bulkmailer smallint,
priority_message_bulkmailer int4,
priority_packet_bulkmailer int4,
reception_date_bulkmailer int4,
delivery_date_bulkmailer int4,
lock_bulkmailer varchar(30),
constraint ind_bulkmailer PRIMARY KEY (messagekey_bulkmailer,
packetid_bulkmailer)
);
CREATE INDEX messagekey_bulkmailer_idx ON
bulkmailer_table(messagekey_bulkmailer);
CREATE INDEX packetid_bulkmailer_idx ON bulkmailer_table(packetid_bulkmailer);
CREATE TABLE bulkspool_table (
messagekey_bulkspool varchar(33),
messageid_bulkspool varchar(100),
message_bulkspool text,
lock_bulkspool smallint,
dkim_privatekey_bulkspool varchar(100),
dkim_selector_bulkspool varchar(50),
dkim_d_bulkspool varchar(50),
dkim_i_bulkspool varchar(50),
dkim_header_list_bulkspool varchar(500),
constraint ind_bulkspool primary key (messagekey_bulkspool)
);
CREATE INDEX messagekey_bulkspool_idx ON bulkspool_table(messagekey_bulkspool);
CREATE TABLE conf_table (
robot_conf varchar(80),
label_conf varchar(80),
value_conf varchar(300),
constraint ind_conf primary key (robot_conf,label_conf)
);
CREATE INDEX robot_conf_idx ON conf_table(robot_conf,label_conf);
GRANT ALL on exclusion_table,session_table, one_time_ticket_table,
bulkmailer_table,bulkspool_table, conf_table TO sympa;
