14 lines
608 B
SQL
14 lines
608 B
SQL
-- Add logo, favicon and other details to companies table
|
|
ALTER TABLE companies
|
|
ADD COLUMN logo VARCHAR(255) DEFAULT NULL AFTER name_ar,
|
|
ADD COLUMN favicon VARCHAR(255) DEFAULT NULL AFTER logo,
|
|
ADD COLUMN email VARCHAR(100) DEFAULT NULL AFTER favicon,
|
|
ADD COLUMN phone VARCHAR(20) DEFAULT NULL AFTER email,
|
|
ADD COLUMN address_en TEXT DEFAULT NULL AFTER phone,
|
|
ADD COLUMN address_ar TEXT DEFAULT NULL AFTER address_en,
|
|
ADD COLUMN vat_number VARCHAR(50) DEFAULT NULL AFTER address_ar;
|
|
|
|
-- Add profile_picture to users table
|
|
ALTER TABLE users
|
|
ADD COLUMN profile_picture VARCHAR(255) DEFAULT NULL AFTER email;
|