ALTER TABLE
M
K
alter table emailsignups add column source TEXT CHECK(source IN ('A','B'));--local
PRAGMA ignore_check_constraints 
SSSSSSSSSSSSS
M
T
D1_ERROR: Error: Internal error in D1 storage caused object to be reset.KKKMMKKPRAGMA ignore_check_constraintsSqliteError: NOT NULL constraint failed: lines.lineInPersonBuffer D1_ERROR: Error: Internal error in D1 storage caused object to be reset.CREATE TABLE lines (
lineNum INT IDENTITY(1,1) NOT NULL UNIQUE,
lineCreator INT NOT NULL,
lineImage TEXT NOT NULL DEFAULT 'https://maps.lineonline.app/line_default.png',
lineName VARCHAR(100) NOT NULL,
lineDescription TEXT,
lineType VARCHAR(100) NOT NULL,
permanent BOOLEAN NOT NULL,
lineEndTime DATETIME NOT NULL,
lineStartTime DATETIME NOT NULL,
lineInPersonBuffer INT NOT NULL DEFAULT 5,
-- -1 = auto based on average time per person and adjusted by number of misses
lineNumberOfRetries INT NOT NULL DEFAULT 3,
lineTimeoutOfRetryEligibilityMins INT NOT NULL DEFAULT 61,
PRIMARY KEY (lineNum)
);insFields.hasOwnProperty('lineImage')const line = await env.DB.prepare("INSERT INTO lines (?1) VALUES (?2, ?3, ?4, ?5, ?6, ?7, ?8, ?9, ?10, ?11, ?12, ?13)")
.bind("lineNum, lineCreator, lineImage, lineName, lineDescription, lineType, permanent, lineEndTime, lineStartTime, lineInPersonBuffer, lineNumberOfRetries, lineTimeoutOfRetryEligibilityMins",
insFields.lineNum, insFields.lineCreator, insFields.lineImage, insFields.lineName, insFields.lineDescription, insFields.lineType, insFields.permanent.toString(), insFields.lineEndTime, insFields.lineStartTime, insFields.lineInPersonBuffer, insFields.lineNumberOfRetries, insFields.lineTimeoutOfRetryEligibilityMins).run();const defaultVal = null;
if (!insFields.hasOwnProperty('lineImage')) {
insFields.lineImage = defaultVal;
}
if (!insFields.hasOwnProperty('lineInPersonBuffer')) {
insFields.lineInPersonBuffer = defaultVal;
}
if (!insFields.hasOwnProperty('lineNumberOfRetries')) {
insFields.lineNumberOfRetries = defaultVal;
}
if (!insFields.hasOwnProperty('lineTimeoutOfRetryEligibilityMins')) {
insFields.lineTimeoutOfRetryEligibilityMins = defaultVal;
}
console.log(typeof insFields.permanent.toString());
const line = await env.DB.prepare("INSERT INTO lines (lineNum, lineCreator, lineImage, lineName, lineDescription, lineType, permanent, lineEndTime, lineStartTime, lineInPersonBuffer, lineNumberOfRetries, lineTimeoutOfRetryEligibilityMins) VALUES (?1, ?2, ?3, ?4, ?5, ?6, ?7, ?8, ?9, ?10, ?11, ?12)")
.bind(insFields.lineNum, insFields.lineCreator, insFields.lineImage, insFields.lineName, insFields.lineDescription, insFields.lineType, insFields.permanent.toString(), insFields.lineEndTime, insFields.lineStartTime, insFields.lineInPersonBuffer, insFields.lineNumberOfRetries, insFields.lineTimeoutOfRetryEligibilityMins).run();