1 ALTER TABLE doc_data ADD COLUMN filesize INTEGER;
2 UPDATE doc_data SET filesize=0;
3 ALTER TABLE doc_data ALTER COLUMN filesize SET NOT NULL;
4 ALTER TABLE doc_data ALTER COLUMN filesize SET DEFAULT 0;
8 CREATE VIEW docdata_vw AS
9 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
11 NATURAL JOIN doc_states
12 NATURAL JOIN doc_groups
13 JOIN supported_languages sl ON sl.language_id = d.language_id
14 JOIN users ON users.user_id = d.created_by;