24 lines
606 B
SQL
24 lines
606 B
SQL
CREATE TABLE `images` (
|
|
`id` INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
`name` TEXT NOT NULL,
|
|
`path` TEXT DEFAULT NULL,
|
|
`thumb` TEXT DEFAULT NULL,
|
|
`type` TEXT NOT NULL,
|
|
`md5` TEXT NOT NULL,
|
|
`datetime` INTEGER NOT NULL,
|
|
`status` INTEGER NOT NULL
|
|
);
|
|
|
|
CREATE TABLE `posts` (
|
|
`id` INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
`text` TEXT NOT NULL,
|
|
`plain_text` TEXT NOT NULL,
|
|
`feeling` TEXT NOT NULL,
|
|
`persons` TEXT NOT NULL,
|
|
`location` TEXT NOT NULL,
|
|
`content` TEXT NOT NULL,
|
|
`content_type` TEXT NOT NULL,
|
|
`privacy` TEXT NOT NULL,
|
|
`datetime` INTEGER NOT NULL,
|
|
`status` INTEGER NOT NULL
|
|
);
|