File: db/noter_schema.sql

Recommend this page to a friend!
  Classes of Martin Latter  >  Noter  >  db/noter_schema.sql  >  Download  
File: db/noter_schema.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: Noter
Create and manage notes shared between users
Author: By
Last change: tidy .sql files
Date: 1 year ago
Size: 620 bytes
 

Contents

Class file image Download
CREATE TABLE notes
(
    id              INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
    title           TEXT                 NOT NULL DEFAULT (''),
    body            TEXT                 NOT NULL DEFAULT (''),
    creator         TEXT                 NOT NULL DEFAULT (''),
    create_ts       DATETIME             NOT NULL DEFAULT (DATETIME('now', 'localtime')),
    updater         TEXT                 NOT NULL DEFAULT (''),
    update_ts       DATETIME             DEFAULT NULL

);


CREATE INDEX idx_title ON notes
(
    title COLLATE NOCASE ASC
);


CREATE INDEX idx_body ON notes
(
    body COLLATE NOCASE
);

For more information send a message to info at phpclasses dot org.