The mailing list for listmasters using Sympa

[Glen Eustace <address@concealed>]

On 02/04/2014 10:35 PM, David Verdin wrote:

address@concealed">What RDBMS are you using as Sympa backend? MySQL did update the database structure alright.

PostgreSQL, Sybase and Orcal don't update their database structure automatically. That might be the problem.

PostgreSQL.

But the changes are not in the create_db.Pg file (dates 31-01-2014) either as seen below.  So the instructions to review the schema were not much help either.  I also checked the mySQL script and they are not there either.


CREATE TABLE session_table (
         data_session   varchar(500),
         date_session   int4 NOT NULL,
         email_session  varchar(100),
         hit_session    int4,
         id_session     varchar(30) NOT NULL,
         remote_addr_session    varchar(60),
         robot_session  varchar(80),
         start_date_session     int4 NOT NULL,
         CONSTRAINT ind_session PRIMARY KEY (id_session)
 );

-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Glen Eustace,
GodZone Internet Services, a division of AGRE Enterprises Ltd.,
P.O. Box 8020, Palmerston North, New Zealand 4446
Ph: +64 6 357 8168, Fax: +64 6 357 8165, Mob: +64 27 542 4015

"A Ministry specialising in providing low-cost professional Internet
Services to NZ Christian Churches, Ministries and Organisations"