File: register.sql

-- phpMyAdmin SQL Dump
-- version 2.8.0.3
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Apr 29, 2006 at 05:56 PM
-- Server version: 4.1.12
-- PHP Version: 5.0.4
-- 
-- Database: `register`
-- 

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

-- 
-- Table structure for table `info`
-- 

CREATE TABLE `info` (
  `user_id` int(3) NOT NULL auto_increment,
  `company` varchar(255) NOT NULL default '',
  `position` varchar(255) NOT NULL default '',
  `telephone` varchar(255) NOT NULL default '',
  `revenues` varchar(255) NOT NULL default '',
  `residence` varchar(255) NOT NULL default '',
  `address` text NOT NULL,
  PRIMARY KEY  (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `sub_cc`
-- 

CREATE TABLE `sub_cc` (
  `user_id` int(3) NOT NULL auto_increment,
  `sub_option` varchar(255) NOT NULL default '',
  `owner_name` varchar(255) NOT NULL default '',
  `city` varchar(255) NOT NULL default '',
  `zip` varchar(255) default NULL,
  `cc_num` varchar(255) NOT NULL default '',
  `cc_type` varchar(255) NOT NULL default '',
  `security_code` varchar(255) NOT NULL default '',
  `exp_date` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `users`
-- 

CREATE TABLE `users` (
  `user_id` int(3) NOT NULL auto_increment,
  `email` varchar(255) NOT NULL default '',
  `pass` varchar(32) NOT NULL default '',
  `first_name` varchar(255) NOT NULL default '',
  `last_name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`user_id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;