0004845: MSSQL DB creation : mantis_filters_table - MantisBT - Signup temporarily disabled due to spam

ID	Project	Category	View Status	Date Submitted	Last Update

0004845	mantisbt	installation	public	2004-11-10 03:47	2005-04-18 10:26

Reporter	vny	Assigned To	grangeway
Priority	normal	Severity	major	Reproducibility	always
Status	closed	Resolution	won't fix
Product Version	0.19.1

Summary	0004845: MSSQL DB creation : mantis_filters_table
Description	CREATE TABLE mantis_filters_table ( id int NOT NULL IDENTITY (1, 1), user_id int NOT NULL default '0', project_id int NOT NULL default '0', is_public tinyint default NULL, name varchar(64) NOT NULL default '', filter_string text NOT NULL, PRIMARY KEY (id) )
Tags	No tags attached.

grangeway 2005-02-28 05:23 reporter ~0009397	Both the mssql.sql and pgsql.sql are out of date. For the next release, i'm hoping to get an adodb data dict schema defined which will generate the mssql/pgsql tables. As adodb's datadict is generic, this means that we won't have to keep multiple schema files in check. It also means that it may be possible to use other db's that are supported by adodb's datadict with mantis. If this functionality goes into the next release, the mssql/pgsql.sql files will become redundant. Notes: The aim is to have the generated adodb schema match the existing schema's created by the sql files. Once the code is added to CVS, it would be interesting to get some feedback, or any differences in the schema to the existing databases you are using I'm going to use issue 0005289 to track the datadict stuff, so closing this issue now.