File: pg_structure_upgrade_2.3.3-2.4.0.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 (14 lines) | stat: -rw-r--r-- 580 bytes parent folder | download | duplicates (10) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
 
alter table resources rename column cm_availability to available_upto;
alter table resources add last_available_upto integer NOT NULL default '0';
delete from schema;
alter table schema add name VARCHAR( 255 ) NOT NULL;
INSERT INTO schema(version, name) VALUES ('2.4.0', 'Thriller');
CREATE TABLE scheduler (
  name VARCHAR(100) NOT NULL,
  script VARCHAR(100) NOT NULL,
  description VARCHAR(255) NOT NULL,
  PRIMARY KEY (name)
);
CREATE INDEX job_array_id ON jobs(array_id);
CREATE INDEX event_job_id ON event_logs (job_id);
CREATE INDEX challenge_job_id ON challenges(job_id);