This repository has been archived on 2024-11-28. You can view files and clone it, but cannot push or open issues or pull requests.
Incam_SGD/sql/mysql/upgrade/2.99.7/10-documents_normalisation.sql

14 lines
905 B
MySQL
Raw Permalink Normal View History

ALTER TABLE `documents` DROP COLUMN `document_type_id`; # was int(11) NOT NULL default '0'
ALTER TABLE `documents` DROP COLUMN `size`; # was bigint(20) NOT NULL default '0'
ALTER TABLE `documents` DROP COLUMN `description`; # was varchar(200) NOT NULL default ''
ALTER TABLE `documents` DROP COLUMN `security`; # was int(11) NOT NULL default '0'
ALTER TABLE `documents` DROP COLUMN `major_version`; # was int(11) NOT NULL default '0'
ALTER TABLE `documents` DROP COLUMN `minor_version`; # was int(11) NOT NULL default '0'
ALTER TABLE `documents` DROP COLUMN `live_document_id`; # was int(11) default NULL
ALTER TABLE `documents` DROP COLUMN `filename`; # was text NOT NULL
ALTER TABLE `documents` DROP COLUMN `storage_path`; # was varchar(250) default NULL
ALTER TABLE `documents` DROP COLUMN `mime_id`; # was int(11) NOT NULL default '0'
ALTER TABLE `documents` DROP COLUMN `name`; # was text NOT NULL