CREATE TABLE pdf_reports_completed
	(pdf_id INT(25) AUTO_INCREMENT,
	org_id INT(11),
	school_year INT(2),
	parent_folder_name VARCHAR(100),
	sub_folder_name VARCHAR(30),
	pdf_file_name VARCHAR(200),
	report_type_id INT(11),
	sort_order INT(3),
	PRIMARY KEY (pdf_id));


INSERT INTO pdf_reports_completed (org_id, school_year, parent_folder_name, sub_folder_name, pdf_file_name, report_type_id, sort_order)
VALUES(17, 17, "reports_pdf", "year", "annual_report", 1, 1);

CREATE TABLE annual_report_pages_completed
(completed_report_id INT(11) AUTO_INCREMENT COMMENT 'The id of this completed report', rpt_type_id INT(11)
COMMENT 'The id of the report type', org_id INT(11), school_year INT(11),
sort_order INT(3) COMMENT 'The sort order for this page in the entire report', primary key (completed_report_id));

ALTER TABLE `annual_report_pages_completed` ADD `date_created` TIMESTAMP NOT NULL AFTER `sort_order`;