1 create table site_language (
3 site_id int references site on update cascade on delete cascade not null,
4 language_id int references language on update cascade on delete cascade not null,
5 unique (site_id, language_id)
8 create table community_language (
10 community_id int references community on update cascade on delete cascade not null,
11 language_id int references language on update cascade on delete cascade not null,
12 unique (community_id, language_id)
15 -- update existing users, sites and communities to have all languages enabled
20 for xid in select id from local_user
22 insert into local_user_language (local_user_id, language_id)
23 (select xid, language.id as lid from language);
26 for xid in select id from site
28 insert into site_language (site_id, language_id)
29 (select xid, language.id as lid from language);
32 for xid in select id from community
34 insert into community_language (community_id, language_id)
35 (select xid, language.id as lid from language);