Skip to content

MartinGassner/remember

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

34 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Remember

Prerequisites

You will need the following things properly installed on your computer.

Installation

  • git clone [email protected]:MartinGassner/remember.git
  • `cd remember
  • npm install
  • bower install

Running

Create SQL table

CREATE TABLE `memories` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `text` text,
  `img`longtext,
  `sender_id` int(11) unsigned NOT NULL,
  `consumer_id` int(11) unsigned NOT NULL,
  `title` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `sender` (`sender_id`),
  KEY `consumer` (`consumer_id`),
  CONSTRAINT `consumer` FOREIGN KEY (`consumer_id`) REFERENCES `users` (`id`),
  CONSTRAINT `sender` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

  
CREATE TABLE `users` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Packages

No packages published