4 lines
247 B
MySQL
4 lines
247 B
MySQL
|
-- Place your SQL code here
|
||
|
|
ALTER TABLE vn.property ADD purchased DATE DEFAULT util.CURDATE() NOT NULL COMMENT 'date of purchase of the property';
|
||
|
|
ALTER TABLE vn.property ADD booked DATE NULL COMMENT 'date of completion of property registration';
|