CREATE TABLE C ( id INTEGER PRIMARY KEY, store_code TEXT DEFAULT "store1" NOT NULL, name TEXT);
The HeidiSQL lost DEFAULT in definition althought it work unintentionally. When you enter new record, the field not seems to be DEFAULT, and you may put there something. If you leave it blank, and accept the record, then DEFAULT value appears.
In Heidi: CREATE TABLE "C" ( "id" INTEGER NOT NULL, "store_code" TEXT NOT NULL, "name" TEXT NULL, PRIMARY KEY ("id")); althought it works in the above way.