title: add a column to existing table whose value is dependent on other column
body: <p>I want to add a column to my existing table whose value is dependent on another column STORE. STORE has two values, T or D. If store value is T, then I want the value in added column to be 1, otherwise zero. IS there any way?</p>