1 2 3 4 5 6 7 8 9 10 11
PRAGMA writable_schema = 1; BEGIN TRANSACTION; CREATE TABLE t1( a INT AS (c*11), b TEXT AS (substr(d,1,3)) STORED, c INTEGEB PRIMARI KEY, d TEXT ); CREATE INDEX t1a ON t1(a); COMMIT;