Chaosplay

My PHP has gone rusty. I have been spending a quite bit of time research different syntax for PHP. Anyways, now my app has just one basic ability, check to see if user is a new app user, and if so then gather some basic info in the database.

I have set the app in dev mode, so I don’t think anyone can really add it, (other than developers, of course). But here’s the URL anyways: http://chaosplay.com/facebook/Stuff/.

So let me present to you my database structure for now. It is still evolving:

-- phpMyAdmin SQL Dump
-- version 2.11.6
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 31, 2008 at 04:31 PM
-- Server version: 4.1.22
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `chaospla_facebook`
--

-- --------------------------------------------------------

--
-- Table structure for table `t_platforms`
--

CREATE TABLE IF NOT EXISTS `t_platforms` (
  `platformid` int(11) NOT NULL auto_increment,
  `platform_name` varchar(25) NOT NULL default '',
  PRIMARY KEY  (`platformid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `t_platforms`
--

INSERT INTO `t_platforms` (`platformid`, `platform_name`) VALUES(1, 'facebook');

-- --------------------------------------------------------

--
-- Table structure for table `t_properties`
--

CREATE TABLE IF NOT EXISTS `t_properties` (
  `propertyid` int(11) NOT NULL auto_increment,
  `property_name` varchar(32) NOT NULL default '' COMMENT 'name, address, phone, ',
  PRIMARY KEY  (`propertyid`),
  UNIQUE KEY `property_name` (`property_name`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

--
-- Dumping data for table `t_properties`
--

INSERT INTO `t_properties` (`propertyid`, `property_name`) VALUES(1, 'First Name');
INSERT INTO `t_properties` (`propertyid`, `property_name`) VALUES(2, 'Last Name');
INSERT INTO `t_properties` (`propertyid`, `property_name`) VALUES(3, 'City');
INSERT INTO `t_properties` (`propertyid`, `property_name`) VALUES(4, 'State');
INSERT INTO `t_properties` (`propertyid`, `property_name`) VALUES(5, 'Country');
INSERT INTO `t_properties` (`propertyid`, `property_name`) VALUES(6, 'Zip');
INSERT INTO `t_properties` (`propertyid`, `property_name`) VALUES(7, 'Sex');
INSERT INTO `t_properties` (`propertyid`, `property_name`) VALUES(8, 'Relationship');
INSERT INTO `t_properties` (`propertyid`, `property_name`) VALUES(9, 'Religion');
INSERT INTO `t_properties` (`propertyid`, `property_name`) VALUES(10, 'politics');
INSERT INTO `t_properties` (`propertyid`, `property_name`) VALUES(11, 'Network');
INSERT INTO `t_properties` (`propertyid`, `property_name`) VALUES(12, 'Looking For');

-- --------------------------------------------------------

--
-- Table structure for table `t_users`
--

CREATE TABLE IF NOT EXISTS `t_users` (
  `userid` int(10) unsigned NOT NULL auto_increment,
  `platformid` int(11) NOT NULL default '0',
  `platform_userid` varchar(60) NOT NULL default '',
  `crte_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `active` tinyint(1) NOT NULL default '0',
  `updt_date` datetime default NULL,
  PRIMARY KEY  (`userid`),
  UNIQUE KEY `platformid` (`platformid`,`platform_userid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `t_users`
--

INSERT INTO `t_users` (`userid`, `platformid`, `platform_userid`, `crte_date`, `active`, `updt_date`) VALUES(1, 1, '25311983', '2008-07-31 16:30:25', 1, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `t_user_properties`
--

CREATE TABLE IF NOT EXISTS `t_user_properties` (
  `userid` int(10) unsigned NOT NULL default '0' COMMENT 'FK',
  `propertyid` int(10) unsigned NOT NULL default '0' COMMENT 'FK',
  `value` varchar(64) NOT NULL default '',
  `active` tinyint(1) NOT NULL default '0',
  `updt_date` datetime NOT NULL default '0000-00-00 00:00:00',
  UNIQUE KEY `userid_2` (`userid`,`propertyid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;