File: 20100730-docman.sql

package info (click to toggle)
fusionforge 5.3.2%2B20141104-3
  • links: PTS, VCS
  • area: main
  • in suites: jessie-kfreebsd
  • size: 60,472 kB
  • sloc: php: 271,846; sql: 36,817; python: 14,575; perl: 6,406; sh: 5,980; xml: 4,294; pascal: 1,411; makefile: 911; cpp: 52; awk: 27
file content (9 lines) | stat: -rw-r--r-- 468 bytes parent folder | download | duplicates (4) 
1
2
3
4
5
6
7
8
9
 
ALTER TABLE GROUPS ADD COLUMN use_docman_search INT;
ALTER TABLE GROUPS ALTER COLUMN use_docman_search SET DEFAULT 1;
UPDATE GROUPS SET use_docman_search = 1;
ALTER TABLE GROUPS ADD COLUMN force_docman_reindex INT;
ALTER TABLE GROUPS ALTER COLUMN force_docman_reindex SET DEFAULT 0;
UPDATE GROUPS SET force_docman_reindex = 0;
ALTER TABLE DOC_GROUPS ADD COLUMN stateid INT;
ALTER TABLE DOC_GROUPS ALTER COLUMN stateid SET DEFAULT 1;
UPDATE DOC_GROUPS SET stateid = 1;