1 DROP VIEW person_alias_1;
2 DROP VIEW person_alias_2;
4 ALTER TABLE community ALTER COLUMN name TYPE varchar(20);
5 ALTER TABLE community ALTER COLUMN title TYPE varchar(100);
6 ALTER TABLE person ALTER COLUMN name TYPE varchar(20);
7 ALTER TABLE person ALTER COLUMN display_name TYPE varchar(20);
9 create view person_alias_1 as select * from person;
10 create view person_alias_2 as select * from person;