From 3b8821b7e6c00a34fe71b22f011841786bb9d7e5 Mon Sep 17 00:00:00 2001 From: Evgeny Fadeev Date: Sat, 24 Apr 2010 19:11:05 -0400 Subject: moved some files and directories inside forum from root --- sql_scripts/cnprog_new_install_2009_04_07.sql | 24 ------------------------ 1 file changed, 24 deletions(-) delete mode 100644 sql_scripts/cnprog_new_install_2009_04_07.sql (limited to 'sql_scripts/cnprog_new_install_2009_04_07.sql') diff --git a/sql_scripts/cnprog_new_install_2009_04_07.sql b/sql_scripts/cnprog_new_install_2009_04_07.sql deleted file mode 100644 index ff9016fa..00000000 --- a/sql_scripts/cnprog_new_install_2009_04_07.sql +++ /dev/null @@ -1,24 +0,0 @@ -USE cnprog; - - -/************ Add Foreign Keys to Database ***************/ - -/************ Foreign Key: fk_activity_auth_user ***************/ -ALTER TABLE activity ADD CONSTRAINT fk_activity_auth_user - FOREIGN KEY (user_id) REFERENCES auth_user (id) ON UPDATE NO ACTION ON DELETE NO ACTION; - -/************ Foreign Key: fk_question_revision_auth_user ***************/ -ALTER TABLE question_revision ADD CONSTRAINT fk_question_revision_auth_user - FOREIGN KEY (author_id) REFERENCES auth_user (id) ON UPDATE NO ACTION ON DELETE NO ACTION; - -/************ Foreign Key: fk_question_revision_question ***************/ -ALTER TABLE question_revision ADD CONSTRAINT fk_question_revision_question - FOREIGN KEY (question_id) REFERENCES question (id) ON UPDATE NO ACTION ON DELETE NO ACTION; - -/************ Foreign Key: fk_repute_auth_user ***************/ -ALTER TABLE repute ADD CONSTRAINT fk_repute_auth_user - FOREIGN KEY (user_id) REFERENCES auth_user (id) ON UPDATE NO ACTION ON DELETE NO ACTION; - -/************ Foreign Key: fk_repute_question ***************/ -ALTER TABLE repute ADD CONSTRAINT fk_repute_question - FOREIGN KEY (question_id) REFERENCES question (id) ON UPDATE NO ACTION ON DELETE NO ACTION; \ No newline at end of file -- cgit v1.2.3-1-g7c22