PHP Classes

File: mlm_rep.sql

Recommend this page to a friend!
  Classes of Dave Smith   PHP MLM Tree Binary Plan   mlm_rep.sql   Download  
File: mlm_rep.sql
Role: Auxiliary data
Content type: text/plain
Description: Database table structure
Class: PHP MLM Tree Binary Plan
Manage members of a MLM tree binary plan
Author: By
Last change:
Date: 8 years ago
Size: 415 bytes
 

Contents

Class file image Download 
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

CREATE TABLE IF NOT EXISTS `mlm_rep` (
  `recordID` int(8) NOT NULL AUTO_INCREMENT,
  `sponsorID` int(8) NOT NULL DEFAULT '0',
  `leg` int(1) NOT NULL DEFAULT '0',
  `repID` varchar(32) NOT NULL DEFAULT '',
  `name` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`recordID`),
  UNIQUE KEY `repID` (`repID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;