forked from science-ation/science-ation
3e3c28268c
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.
11 lines
290 B
SQL
11 lines
290 B
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
|
|
|