azkaban-memoizeit

Adding update file for auto updating.

5/16/2013 2:29:41 AM

Richard Park

Commit: 79e13e2

Tree: d07e50d

Parents: af0893d

Changes

src/sql/update.schedules.2.2.sql 3(+3 -0)

Details

src/sql/update.schedules.2.2.sql 3(+3 -0)

diff --git a/src/sql/update.schedules.2.2.sql b/src/sql/update.schedules.2.2.sql
new file mode 100644
index 0000000..98849db
--- /dev/null
+++ b/src/sql/update.schedules.2.2.sql
@@ -0,0 +1,3 @@
+ALTER TABLE schedules DROP PRIMARY KEY;
+ALTER TABLE schedules ADD COLUMN schedule_id INT PRIMARY KEY NOT NULL AUTO_INCREMENT;
+ALTER TABLE schedules ADD INDEX project_id (project_id, flow_name);