Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
branch: master
Fetching contributors…

Cannot retrieve contributors at this time

19 lines (17 sloc) 0.551 kb
-- Create tables for user comments
CREATE TABLE manual_notes
(
note_id int(11) NOT NULL AUTO_INCREMENT,
page_url varchar(100) NOT NULL,
user_name varchar(100) NOT NULL,
user_handle varchar(20) NULL,
note_text text NOT NULL,
note_time timestamp NOT NULL,
note_approved varchar(7) NOT NULL DEFAULT 'pending',
note_approved_by varchar(20) NULL,
note_deleted tinyint(1) NULL DEFAULT '0',
note_compiled text NULL,
PRIMARY KEY (note_id),
INDEX idx_page_url (page_url),
INDEX idx_note_time (note_time)
);
Jump to Line
Something went wrong with that request. Please try again.