Hi!
I recently checked in scripts/postgresqldb.sh - a rewrite of the mysql version for postgresql.
Currently tested are only the "create" and "drop" commands, thus the other commands are disabled.
I had to modify the tables defintions and I'm not sure if this broke something. Thus, please report problems.
regards, klaus
During porting to postgres, I reviewed the tables. Following are the currently used tables. The ones with a question mark in front, are defined in the VERSION table, but are not defined anywhere.
acc active_sessions admin_privileges aliases ? calls_forwarding ? config dbaliases domain ? event grp location missed_calls pending phonebook ? preferences_types ? realm ? reserved server_monitoring server_monitoring_agg silo speed_dial subscriber trusted uri usr_preferences
Does someone knows the meaning of the "?" tables? If not, should we wipe them from the version table?
regards, klaus
Klaus Darilion wrote:
Hi!
I recently checked in scripts/postgresqldb.sh - a rewrite of the mysql version for postgresql.
Currently tested are only the "create" and "drop" commands, thus the other commands are disabled.
I had to modify the tables defintions and I'm not sure if this broke something. Thus, please report problems.
regards, klaus
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
Hi Klaus,
there are a lot of tables which actualy belongs to serweb - they are never used by [Open]SER. For it seams illogic to be created by [Open]SER - these table should be added by serweb, if used.
Anyhow, as serweb doesn't support postgres (only mysql), I suggest to remove completely this tables.
regards, bogdan
Klaus Darilion wrote:
During porting to postgres, I reviewed the tables. Following are the currently used tables. The ones with a question mark in front, are defined in the VERSION table, but are not defined anywhere.
acc active_sessions admin_privileges aliases
? calls_forwarding ? config dbaliases domain ? event grp location missed_calls pending phonebook ? preferences_types ? realm ? reserved server_monitoring server_monitoring_agg silo speed_dial subscriber trusted uri usr_preferences
Does someone knows the meaning of the "?" tables? If not, should we wipe them from the version table?
regards, klaus
Klaus Darilion wrote:
Hi!
I recently checked in scripts/postgresqldb.sh - a rewrite of the mysql version for postgresql.
Currently tested are only the "create" and "drop" commands, thus the other commands are disabled.
I had to modify the tables defintions and I'm not sure if this broke something. Thus, please report problems.
regards, klaus
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users