File: 20051027-1.sql

package info (click to toggle)
gforge 4.5.14-22etch13
  • links: PTS
  • area: main
  • in suites: etch
  • size: 13,004 kB
  • ctags: 11,918
  • sloc: php: 36,047; sql: 29,050; sh: 10,538; perl: 6,496; xml: 3,810; makefile: 341; python: 263; ansic: 256
file content (14 lines) | stat: -rw-r--r-- 734 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
 
ALTER TABLE doc_data ADD COLUMN filesize INTEGER;
UPDATE doc_data SET filesize=0;
ALTER TABLE doc_data ALTER COLUMN filesize SET NOT NULL;
ALTER TABLE doc_data ALTER COLUMN filesize SET DEFAULT 0;

DROP VIEW docdata_vw;

CREATE VIEW docdata_vw AS 
SELECT users.user_name, users.realname, users.email, d.group_id, d.docid, d.stateid, d.title, d.updatedate, d.createdate, d.created_by, d.doc_group, d.description, d.language_id, d.filename, d.filetype,  d.filesize, doc_states.name AS state_name, doc_groups.groupname AS group_name, sl.name AS language_name
   FROM doc_data d
NATURAL JOIN doc_states
NATURAL JOIN doc_groups
   JOIN supported_languages sl ON sl.language_id = d.language_id
   JOIN users ON users.user_id = d.created_by;