-------------------
Author: Manuj Singh
-------------------

About Address Book
------------------
Address Book is an online application to store all your contacts.
Currently, only email, phone numbers and social networking IDs
can be stored but in future it can even store home and office
addresses.

Requirements
------------
1. Python
2. Django
3. MySQL
4. Web Server(e.g. Apache)

Installation
------------
To install make sure you have python, django and mysql installed
on your system, then follow the following steps:

1. Clone the git repository (git@github.com:manujsingh/AddressBook.git).
2. Change database settings in settings.py.
3. Create required tables by calling "python manage.py sycdb" from the
root folder. Create contacts_contact and contacts_group table for
contacts app.
4. Start django server with "python manage.py runserver" from the
project root.
5. Enjoy the app

Table Schema
------------

For Contact Table:
------------------
CREATE TABLE `contacts_contact` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(50) NOT NULL,
  `last_name` varchar(50) NOT NULL,
  `image` varchar(200) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `home_phone` varchar(20) DEFAULT NULL,
  `mobile_phone` varchar(20) DEFAULT NULL,
  `office_phone` varchar(20) DEFAULT NULL,
  `office_phone_extn` varchar(5) DEFAULT NULL,
  `facebook` varchar(100) DEFAULT NULL,
  `twitter` varchar(100) DEFAULT NULL,
  `owner_id` int(11) NOT NULL,
  `group_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 

For Group Table:
----------------
CREATE TABLE `contacts_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `owner_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8