PHP Classes

File: register.sql

Recommend this page to a friend!
  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: 18 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;