maximozz / solidaria

0 stars 0 forks source link

Create DB table for MLM tree #8

Open maximozz opened 8 years ago

maximozz commented 8 years ago

CREATE TABLE IF NOT EXISTS mozz_mlm_tree ( id bigint(20) NOT NULL AUTO_INCREMENT, customer_id bigint(20) NOT NULL, customer_sponsor_id bigint(20) NOT NULL, customer_level int(11) NOT NULL, customer_stage int(11) NOT NULL, customer_cycle int(11) NOT NULL, customer_status int(11) NOT NULL, customer_clients_cycle int(11) NOT NULL, customer_clients_total int(11) NOT NULL, time_created int(11) NOT NULL, last_action int(11) NOT NULL, date_activated datetime DEFAULT NULL, date_expiry datetime DEFAULT NULL, status enum('enabled','disabled','suspended') NOT NULL DEFAULT 'enabled', PRIMARY KEY (id), UNIQUE KEY customer_id (customer_id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;