0000_thick_leech.sql•3.96 kB
CREATE TABLE `anniversary` (
`id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
`year` integer NOT NULL,
`month` integer NOT NULL,
`day` integer NOT NULL,
`name` text NOT NULL,
`dayOff` integer DEFAULT 0 NOT NULL,
`dayType` integer DEFAULT 0 NOT NULL,
`historyType` integer DEFAULT 0 NOT NULL,
`historyId` integer DEFAULT 0 NOT NULL,
`del` integer DEFAULT false NOT NULL,
`created` integer NOT NULL
);
--> statement-breakpoint
CREATE TABLE `avatar_model` (
`id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
`comment` text NOT NULL,
`baseCharPrompt` text NOT NULL,
`created` integer NOT NULL,
`modelName` text NOT NULL
);
--> statement-breakpoint
CREATE TABLE `avatar_sns` (
`id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
`assignAvatarId` integer NOT NULL,
`snsType` text(4) NOT NULL,
`snsHandleName` text NOT NULL,
`snsId` text NOT NULL,
`checkedPostId` text NOT NULL,
`mentionPostId` text NOT NULL,
`created` integer NOT NULL,
`enable` integer DEFAULT false NOT NULL
);
--> statement-breakpoint
CREATE TABLE `env_kv` (
`key` text PRIMARY KEY NOT NULL,
`value` text NOT NULL,
`created` integer NOT NULL,
`updated` integer NOT NULL
);
--> statement-breakpoint
CREATE TABLE `run_abroad_route` (
`id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
`html_instructions` text NOT NULL,
`maneuver` text NOT NULL,
`duration` integer NOT NULL,
`terminalStart` integer NOT NULL
);
--> statement-breakpoint
CREATE TABLE `run_avatar` (
`id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
`name` text NOT NULL,
`modelId` integer NOT NULL,
`created` integer NOT NULL,
`enable` integer DEFAULT false NOT NULL,
`nextStayTime` integer,
`lang` text NOT NULL,
`currentRoute` text
);
--> statement-breakpoint
CREATE TABLE `run_terminal` (
`id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
`country` text NOT NULL,
`name` text NOT NULL,
`type` text NOT NULL,
`lat` real DEFAULT 0 NOT NULL,
`lng` real DEFAULT 0 NOT NULL
);
--> statement-breakpoint
CREATE TABLE `run_history` (
`seq` integer NOT NULL,
`tripId` integer NOT NULL,
`lng` real NOT NULL,
`lat` real NOT NULL,
`elapsed` integer NOT NULL,
`address` text DEFAULT 'NULL',
`imagePath` text DEFAULT 'NULL',
`coursePath` text DEFAULT 'NULL',
`placePath` text DEFAULT 'NULL',
`plainPath` text DEFAULT 'NULL',
`createTime` integer NOT NULL,
`time` integer NOT NULL,
`standOffsetX` integer DEFAULT 0 NOT NULL,
`standOffsetY` integer DEFAULT 0 NOT NULL,
`model` text DEFAULT 'NULL',
`fitImage` integer DEFAULT 0 NOT NULL,
`appendPrompt` text DEFAULT 'NULL',
`pictAuthor` text DEFAULT 'NULL'
);
--> statement-breakpoint
CREATE UNIQUE INDEX `UQ_seq` ON `run_history` (`seq`);--> statement-breakpoint
CREATE TABLE `run_status` (
`id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
`avatarId` integer DEFAULT 1 NOT NULL,
`tripId` integer DEFAULT 0 NOT NULL,
`tilEndEpoch` integer DEFAULT 0 NOT NULL,
`status` text NOT NULL,
`from` text NOT NULL,
`to` text NOT NULL,
`destination` text,
`startLat` real NOT NULL,
`startLng` real NOT NULL,
`endLat` real NOT NULL,
`endLng` real NOT NULL,
`durationSec` integer NOT NULL,
`distanceM` integer NOT NULL,
`startTime` integer NOT NULL,
`startCountry` text(4) DEFAULT 'NULL',
`endCountry` text(4) DEFAULT 'NULL',
`startTz` text DEFAULT 'NULL',
`endTz` text DEFAULT 'NULL',
`currentPathNo` integer DEFAULT 0 NOT NULL,
`currentStepNo` integer DEFAULT 0 NOT NULL
);
--> statement-breakpoint
CREATE TABLE `sns_posts` (
`id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
`snsType` text(2) NOT NULL,
`snsPostId` text NOT NULL,
`snsReplyId` text DEFAULT 'NULL',
`postType` integer NOT NULL,
`sendUserId` text NOT NULL,
`info` text DEFAULT 'NULL',
`del` integer NOT NULL,
`createTime` integer NOT NULL
);
--> statement-breakpoint
CREATE TABLE `test_tab` (
`id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
`issue_id` text NOT NULL,
`comment` text,
`del` integer DEFAULT false NOT NULL,
`created` integer NOT NULL
);