PHP Classes

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: Update of db/noter_schema.sql
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 );