322
323
324
325
326
327
328
329
330
331
332
333
334
335
|
published TEXT NOT NULL CHECK (datetime(published) = published),
modified TEXT NOT NULL CHECK (datetime(modified) = modified),
title TEXT NOT NULL,
content TEXT NOT NULL
);
CREATE UNIQUE INDEX IF NOT EXISTS web_pages_path ON web_pages (path);
CREATE UNIQUE INDEX IF NOT EXISTS web_pages_file_path ON web_pages (file_path);
CREATE INDEX IF NOT EXISTS web_pages_parent ON web_pages (parent);
CREATE INDEX IF NOT EXISTS web_pages_published ON web_pages (published);
CREATE INDEX IF NOT EXISTS web_pages_title ON web_pages (title);
-- FIXME: rename to english
CREATE TABLE IF NOT EXISTS recherches
|
>
|
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
|
published TEXT NOT NULL CHECK (datetime(published) = published),
modified TEXT NOT NULL CHECK (datetime(modified) = modified),
title TEXT NOT NULL,
content TEXT NOT NULL
);
CREATE UNIQUE INDEX IF NOT EXISTS web_pages_path ON web_pages (path);
CREATE UNIQUE INDEX IF NOT EXISTS web_pages_uri ON web_pages (uri);
CREATE UNIQUE INDEX IF NOT EXISTS web_pages_file_path ON web_pages (file_path);
CREATE INDEX IF NOT EXISTS web_pages_parent ON web_pages (parent);
CREATE INDEX IF NOT EXISTS web_pages_published ON web_pages (published);
CREATE INDEX IF NOT EXISTS web_pages_title ON web_pages (title);
-- FIXME: rename to english
CREATE TABLE IF NOT EXISTS recherches
|