File: mysql_structure_upgrade_2.3.0%2Bsvn1369.sql

package info (click to toggle)
oar 2.5.2-3%2Bdeb7u1
  • links: PTS
  • area: main
  • in suites: wheezy
  • size: 11,420 kB
  • sloc: perl: 25,140; ruby: 5,574; sh: 4,856; sql: 3,221; ansic: 2,946; cpp: 2,277; ml: 1,638; php: 632; makefile: 368; exp: 23
file content (23 lines) | stat: -rw-r--r-- 690 bytes parent folder | download | duplicates (9) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
 
# $Id$

DROP TABLE IF EXISTS `schema`;
CREATE TABLE IF NOT EXISTS `schema` (
version VARCHAR( 255 ) NOT NULL
);
INSERT INTO `schema` VALUES ('2.3.0+svn1369');

#DROP TABLE IF EXISTS gantt_jobs_predictions_log;
CREATE TABLE IF NOT EXISTS gantt_jobs_predictions_log (
sched_date INT UNSIGNED NOT NULL ,
moldable_job_id INT UNSIGNED NOT NULL ,
start_time INT UNSIGNED NOT NULL ,
PRIMARY KEY (sched_date,moldable_job_id)
);

#DROP TABLE IF EXISTS gantt_jobs_resources_log;
CREATE TABLE IF NOT EXISTS gantt_jobs_resources_log (
sched_date INT UNSIGNED NOT NULL ,
moldable_job_id INT UNSIGNED NOT NULL ,
resource_id INT UNSIGNED NOT NULL ,
PRIMARY KEY (sched_date,moldable_job_id,resource_id)
);