forked from din982/socialnetwork
-
Notifications
You must be signed in to change notification settings - Fork 0
saiyashwanth/socialnetwork
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
Repository files navigation
High Level================== /accounts id name email password birthday school /friends /invite /privacy not friend - only see profile information friend - see all posts both - send message /posts /status updates .comment .likes post on friends walls Database===================== /accounts id - INT AUTO INCREMENT name - TEXT email - TEXT password - TEXT birthday - TEXT school - TEXT /friends firstperson id - INT second person id - INT /invite initiator id - INT potential id - INT /posts id - INT timestamp - DATE poster id - INT receiver id(yourself if status update, other person if post) - INT MySQL Queries================== CREATE DATABASE socialnetwork; USE socialnetwork; CREATE TABLE `accounts` ( `id` INT(11) AUTO_INCREMENT, `name` text, `email` text, `password` text,`birthday` TEXT, `school` TEXT, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=1; CREATE TABLE `friends` (`firstperson` INT(11), `secondperson` INT(11)); CREATE TABLE `invite` (`initiator` INT(11), `respondent` INT(11)); CREATE TABLE `posts` (`id` INT(11), `content` TEXT, `timestamp` DATE, `poster` INT(11), `receiver` INT(11), `postername` TEXT, `receivername` TEXT);
About
Basic social network made from scratch with PHP/MySQL using MVC
Resources
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published
Languages
- PHP 87.5%
- HTML 12.5%