/* Disable foreign keys */
PRAGMA foreign_keys = 'off';

/* Begin transaction */
BEGIN;

/* Database properties */
PRAGMA auto_vacuum = 0;
PRAGMA encoding = 'UTF-8';
PRAGMA page_size = 4096;

/* Drop table [something] */
DROP TABLE IF EXISTS [main].[something];

/* Table structure [something] */
CREATE TABLE [main].[something](
  [id] INTEGER PRIMARY KEY AUTOINCREMENT, 
  [x] TEXT);

/* Drop table [used] */
DROP TABLE IF EXISTS [main].[used];

/* Table structure [used] */
CREATE TABLE [main].[used](
  [id] INTEGER PRIMARY KEY AUTOINCREMENT, 
  [id_something] INTEGER CONSTRAINT [fk] REFERENCES [something]([id]));

/* Table data [something] Record count: 5 */
INSERT INTO [something]([rowid], [id], [x]) VALUES(1, 1, 'a');
INSERT INTO [something]([rowid], [id], [x]) VALUES(2, 2, 'b');
INSERT INTO [something]([rowid], [id], [x]) VALUES(3, 3, 'c');
INSERT INTO [something]([rowid], [id], [x]) VALUES(4, 4, 'd');
INSERT INTO [something]([rowid], [id], [x]) VALUES(5, 5, 'e');

/* Table data [used] Record count: 3 */
INSERT INTO [used]([rowid], [id], [id_something]) VALUES(1, 1, 1);
INSERT INTO [used]([rowid], [id], [id_something]) VALUES(2, 2, 3);
INSERT INTO [used]([rowid], [id], [id_something]) VALUES(3, 3, 5);

/* Commit transaction */
COMMIT;

/* Enable foreign keys */
PRAGMA foreign_keys = 'on';