File: pg_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 (21 lines) | stat: -rw-r--r-- 655 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
 
-- $Id$
-- info version, change here if you have updated the db schema
DROP TABLE schema;
CREATE TABLE schema (
  version VARCHAR( 255 ) NOT NULL
);
INSERT INTO schema VALUES ('2.3.0+svn1369');

CREATE TABLE gantt_jobs_predictions_log (
  sched_date integer NOT NULL default '0',
  moldable_job_id integer NOT NULL default '0',
  start_time integer NOT NULL default '0',
  PRIMARY KEY  (sched_date, moldable_job_id)
);

CREATE TABLE gantt_jobs_resources_log (
  sched_date integer NOT NULL default '0',
  moldable_job_id integer NOT NULL default '0',
  resource_id integer NOT NULL default '0',
  PRIMARY KEY  (sched_date, moldable_job_id,resource_id)
);