mysql-init.txt

drop database mypa;
create database mypa;
use mypa;

revoke all privileges on *.* from 'bill'@'localhost';
drop user 'bill'@'localhost';
create user 'bill'@'localhost' identified by 'clinton';
grant delete, insert, select, update on mypa.* to 'bill'@'localhost';

CREATE TABLE `notes` (
  `note_id` varchar(50) NOT NULL,
  `user` varchar(100) NOT NULL,
  `subject` text NOT NULL,
  `body` text,
  `creation_epoch` bigint(20) NOT NULL,
  `exec_cron` varchar(20) DEFAULT NULL,
  `attachments` text,
  `receipents` text,
  `actions` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `schedules` (
  `note_id` varchar(50) NOT NULL,
  `timestamp` varchar(50) DEFAULT NULL,
  `user` varchar(100) NOT NULL,
  UNIQUE KEY `note_id` (`note_id`,`timestamp`,`user`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1