changes-3.0.sql 945 Bytes
-- Changes from RCAAPv2 to RCAAPv3
-- Last change to script: 2010-08-17T00:00:00
-- Privileges needed to execute script: user must be able to create and alter


use metarepository;
-- New columns needed for:
--    degois (compliant or not)
--    repositories and magazines portuguese-brazilian directory
--    tags for grouping/filter repositories
ALTER TABLE repositories ADD COLUMN country varchar(50) default 'portugal';
ALTER TABLE repositories ADD COLUMN tags_pt varchar(500) default '';
ALTER TABLE repositories ADD COLUMN tags_en varchar(500) default '';
ALTER TABLE repositories ADD COLUMN directoryURL varchar(100) default '';
ALTER TABLE repositories ADD COLUMN degois tinyint(1) default '0';
ALTER TABLE repositories ADD COLUMN openAire tinyint(1) default '0';
ALTER TABLE repositories ADD COLUMN driver tinyint(1) default '0';
CREATE INDEX country_index ON repositories (country);
CREATE INDEX active_index ON repositories (active);