[opw-web] Remove unused addition to rograms table

[Owen Taylor <otaylor src gnome org>]

commit 661c40efadba6dec51c6a023294f99f0b11aa038
Author: Owen W. Taylor <otaylor fishsoup net>
Date:   Thu May 14 14:04:39 2015 -0400

    Remove unused addition to rograms table
    
    I decided not to denormalize and add a contract_id field to the programs
    table, since the right index on the contracts table made looking up
    the contract fast.

 schema.sql |    3 ---
 1 files changed, 0 insertions(+), 3 deletions(-)
---
diff --git a/schema.sql b/schema.sql
index 30319e6..9ef9e2b 100644
--- a/schema.sql
+++ b/schema.sql
@@ -6,7 +6,6 @@ INSERT INTO `opw_cron` (
   `timestamp`
 ) VALUES (0);
 
-/* alter table opw_programs add `contract_id` mediumint(1) unsigned ; */
 CREATE TABLE `opw_programs` (
   `id` mediumint(6) unsigned NOT NULL AUTO_INCREMENT,
   `title` varchar(255) NOT NULL DEFAULT '',
@@ -16,9 +15,7 @@ CREATE TABLE `opw_programs` (
   `dl_student` int(11) unsigned NOT NULL,
   `dl_mentor` int(11) unsigned NOT NULL,
   `is_active` tinyint(1) NOT NULL DEFAULT 0,
-  `contract_id` mediumint(10) unsigned,
   PRIMARY KEY (`id`)
-  FOREIGN KEY (`contract_id`) REFERENCES `opw_contracts`(`id`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 CREATE TABLE `opw_contracts` (