Login   Register  
PHP Classes
elePHPant
Icontem

File: register.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Ashraf Gheith  >  Full Payment and Registration  >  register.sql  >  Download  
File: register.sql
Role: Auxiliary data
Content type: text/plain
Description: The SQL code file
Class: Full Payment and Registration
Paid subscription user registration system
Author: By
Last change:
Date: 8 years ago
Size: 1,789 bytes
 

Contents

Class file image Download
-- 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;