Topic: I'm looking to hire a devloper. Project information inside...
I'm looking to hire a devloper to code a administrative interface to the following MySQL tables:
-- phpMyAdmin SQL Dump
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Table structure for table `orgs`
--
CREATE TABLE `orgs` (
`key` int(6) NOT NULL auto_increment,
`name_long` varchar(50) NOT NULL default '',
`name_short` varchar(30) NOT NULL default '',
`street` varchar(30) NOT NULL default '',
`city` varchar(20) NOT NULL default '',
`state` char(2) NOT NULL default '',
`zip` varchar(5) NOT NULL default '',
`advisor_email` varchar(50) NOT NULL default '',
`advisor_street` varchar(30) NOT NULL default '',
`advisor_city` varchar(20) NOT NULL default '',
`advisor_state` char(2) NOT NULL default '',
`advisor_zip` int(5) NOT NULL default '0',
`advisor_firstname` varchar(20) NOT NULL default '',
`advisor_lastname` varchar(20) NOT NULL default '',
`advisor_phone` varchar(15) NOT NULL default '',
`org_url` varchar(100) NOT NULL default '',
`school_id` varchar(4) NOT NULL default '',
`contact_firstname` varchar(20) NOT NULL default '',
`contact_lastname` varchar(20) NOT NULL default '',
`contact_phone` varchar(15) NOT NULL default '',
`contact_email` varchar(50) NOT NULL default '',
PRIMARY KEY (`key`),
UNIQUE KEY `org_url` (`org_url`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `orgs`
--
--
-- Table structure for table `schools`
--
CREATE TABLE `schools` (
`key` int(4) NOT NULL auto_increment,
`name_long` varchar(50) NOT NULL default '',
`name_short` varchar(30) NOT NULL default '',
`street` varchar(30) NOT NULL default '',
`city` varchar(20) NOT NULL default '',
`state` char(2) NOT NULL default '',
`zip` int(5) NOT NULL default '0',
`org_phone` varchar(15) NOT NULL default '',
`directory_phone` varchar(15) NOT NULL default '',
`school_url` varchar(100) NOT NULL default '',
`directory_url` varchar(100) NOT NULL default '',
`notes` longtext NOT NULL,
PRIMARY KEY (`key`),
UNIQUE KEY `name_long` (`name_long`,`name_short`,`org_phone`,`directory_phone`,`school_url`,`directory_url`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `schools`
--
--
-- Table structure for table `students`
--
CREATE TABLE `students` (
`key` int(8) NOT NULL auto_increment,
`name_first` varchar(20) NOT NULL default '',
`name_last` varchar(20) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`org_id` int(6) NOT NULL default '0',
`school_id` int(4) NOT NULL default '0',
PRIMARY KEY (`key`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `students`
--
-------------------------------------------------------------------------------* I'd like the state fields to dropdowns with the state abbreviations.
* When a new org is added, the school is assigned by selecting the state from a drop down and then the school is selected from a drop down where school = selected state
* When a new org is added and assigned to a school, the city state and zip shall be defaultly copied from the school, but still be able to be edited.
Please respond by email, this thread, or 602-761-0565 with a quote. Please also include expected delivery time and information about your portifolio.
Depending on your reputation around here, I'm open to 1/3 upfront, 1/3 once completed (on your server), and 1/3 when installed to my server (virgin pun install). This all depends on the quote size. If the quote is small, we can work something out.
Also, if things work out between us, there is an oppertunity for alot of well paid, additional work.
Thanks! Hope to hear from you guys soon.
