INSERT INTO account_tbl VALUES(1,1,'takahshi','yujiro@rakuto.net','abcd123');
SQLiteにはalterが無いので以下のステップで代用します。
メールマガジンの受信フラグを追加します。
CREATE TEMPORARY TABLE account_tbl_alter (
id integer,
flag integer,
name varchar(64),
email varchar(128),
password varchar(32),
magazine integer
);
INSERT INTO account_tbl_alter SELECT *,1 AS magazine FROM account_tbl;
DROP TABLE account_tbl;
CREATE TABLE account_tbl (
id integer NOT NULL,
flag integer DEFAULT 1,
name varchar(64) NOT NULL,
email varchar(128) UNIQUE,
password varchar(32),
magazine integer DEFAULT 1,
CONSTRAINT account_pky PRIMARY KEY (id)
);
INSERT INTO account_tbl SELECT * FROM account_tbl_alter;
DROP TABLE account_tbl_alter;
|