Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ************************************* New Work********************************************************
- ALTER TABLE customer DROP COLUMN contact_person;
- ALTER TABLE customer DROP COLUMN email_address;
- ALTER TABLE customer ADD contact_name VARCHAR(50);
- ALTER TABLE customer ADD contact_email VARCHAR(50);
- ALTER TABLE customer ADD contact_designation VARCHAR(50);
- ALTER TABLE supplier DROP COLUMN contact_person;
- ALTER TABLE supplier DROP COLUMN email_address;
- ALTER TABLE supplier ADD contact_name VARCHAR(50);
- ALTER TABLE supplier ADD contact_email VARCHAR(50);
- ALTER TABLE supplier ADD contact_designation VARCHAR(50);
- ALTER TABLE product MODIFY code varchar(255) null;
- ALTER TABLE product ADD sub_model_no VARCHAR(50) null;
- ALTER TABLE sale ADD status enum('pending','approved', 'reject') NOT NULL DEFAULT 'pending';
- ALTER TABLE sale ADD offer_no varchar(255) null;
- ALTER TABLE sale ADD pi_no varchar(255) null;
- ALTER TABLE sale ADD lc_no varchar(255) null;
- ALTER TABLE sale ADD po_no varchar(255) null;
- ALTER TABLE sale ADD type enum('sold', 'lost') NOT NULL DEFAULT 'sold';
- ALTER TABLE product_stock_info ADD type enum('in','sold', 'lost') NULL;
- ALTER TABLE complain ADD contact_designation VARCHAR(50) null;
- ALTER TABLE complain ADD deadline DATE null;
- ALTER TABLE complain ADD supervisor_id INT(255) NULL;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement