science-ation/db/db.update.75.sql

CREATE TABLE `reports_committee` (
	`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
	`users_id` INT NOT NULL ,
	`reports_id` INT NOT NULL ,
	`category` VARCHAR( 128 ) NOT NULL ,
	`comment` TEXT NOT NULL ,
	`format` VARCHAR( 64 ) NOT NULL ,
	`stock` VARCHAR( 64 ) NOT NULL
) ENGINE = MYISAM
- Implement "My Reports". Committee members (with admin access, because reports require admin access) can define a list of reports out of all the reports, and tag each one with a category and comments. - Add all except the ceremony scripts as "Custom" reports. The My Reports system can handle links to custom reports now, but not the ceremony scripts. They're too special. I think they should be moved out of the Reports Area. - Clean up some report variables to avoid collisions with local names ($options, and $stock) - Implment a new screen for report generation that lets the user set the format, stock, and year of the report. 2007-12-10 02:50:53 +00:00			CREATE TABLE `reports_committee` (
			`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
			`users_id` INT NOT NULL ,
			`reports_id` INT NOT NULL ,
			`category` VARCHAR( 128 ) NOT NULL ,
			`comment` TEXT NOT NULL ,
			`format` VARCHAR( 64 ) NOT NULL ,
			`stock` VARCHAR( 64 ) NOT NULL
			`) ENGINE = MYISAM`