Since I suck at SQL, here are a few notes and reminders if ever my memory fails me (and it always does)

sql_notes.sql

UPDATE table_name
SET column1=value1
WHERE some_column=some_value;

ALTER TABLE table_name
ADD column_name datatype;

/* SQL Server */
alter table DEFAULT_PROPRIED_DOCTO
add VERSION bigint not null default 1;

ALTER TABLE {TABLENAME} 
ADD {COLUMNNAME} {TYPE} {NULL|NOT NULL} 
CONSTRAINT {CONSTRAINT_NAME} DEFAULT {DEFAULT_VALUE}