1 ALTER TABLE GROUPS ADD COLUMN use_docman_search INT;
2 ALTER TABLE GROUPS ALTER COLUMN use_docman_search SET DEFAULT 1;
3 UPDATE GROUPS SET use_docman_search = 1;
4 ALTER TABLE GROUPS ADD COLUMN force_docman_reindex INT;
5 ALTER TABLE GROUPS ALTER COLUMN force_docman_reindex SET DEFAULT 0;
6 UPDATE GROUPS SET force_docman_reindex = 0;
7 ALTER TABLE DOC_GROUPS ADD COLUMN stateid INT;
8 ALTER TABLE DOC_GROUPS ALTER COLUMN stateid SET DEFAULT 1;
9 UPDATE DOC_GROUPS SET stateid = 1;