File: 20050305.sql

package info (click to toggle)
gforge 4.5.14-22etch13
  • links: PTS
  • area: main
  • in suites: etch
  • size: 13,004 kB
  • ctags: 11,918
  • sloc: php: 36,047; sql: 29,050; sh: 10,538; perl: 6,496; xml: 3,810; makefile: 341; python: 263; ansic: 256
file content (14 lines) | stat: -rw-r--r-- 947 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
 
DROP INDEX plugin_cvstracker_group_artifact_id;

ALTER TABLE plugin_cvstracker_data_master ADD COLUMN cvs_date2 int4;
ALTER TABLE plugin_cvstracker_data_master RENAME COLUMN cvs_date to dead1;
ALTER TABLE plugin_cvstracker_data_master ALTER COLUMN dead1 DROP NOT NULL;
ALTER TABLE plugin_cvstracker_data_master RENAME COLUMN cvs_date2 to cvs_date;                                   
UPDATE plugin_cvstracker_data_master SET cvs_date=date_part('epoch', dead1);
ALTER TABLE plugin_cvstracker_data_master ALTER COLUMN cvs_date SET NOT NULL;

CREATE INDEX plugincvstrackerdataartifact_groupartifactid ON plugin_cvstracker_data_artifact(group_artifact_id);
CREATE INDEX plugincvstrackerdataartifact_projecttaskid ON plugin_cvstracker_data_artifact(project_task_id);

CREATE INDEX plugincvstrackerdatamaster_holderid ON plugin_cvstracker_data_master(holder_id);
CREATE INDEX plugincvstrackerdatamaster_cvsdate ON plugin_cvstracker_data_master(cvs_date);