8 lines
396 B
SQL
8 lines
396 B
SQL
ALTER TABLE library_documents
|
|
ADD COLUMN category VARCHAR(100) DEFAULT NULL,
|
|
ADD COLUMN category_ar VARCHAR(100) DEFAULT NULL,
|
|
ADD COLUMN sub_category VARCHAR(100) DEFAULT NULL,
|
|
ADD COLUMN sub_category_ar VARCHAR(100) DEFAULT NULL,
|
|
ADD COLUMN allow_download TINYINT(1) NOT NULL DEFAULT 0,
|
|
ADD COLUMN allow_print TINYINT(1) NOT NULL DEFAULT 0,
|
|
ADD COLUMN allow_copy TINYINT(1) NOT NULL DEFAULT 0; |