PHP Classes

File: sql/mysql.sql

Recommend this page to a friend!
  Classes of Goffy G   wgTeams   sql/mysql.sql   Download  
File: sql/mysql.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: wgTeams
Module for the XOOPS CMS to present people teams
Author: By
Last change:
Date: 3 years ago
Size: 3,149 bytes
 

Contents

Class file image Download
# SQL Dump for wgteams module # PhpMyAdmin Version: 4.0.4 # http://www.phpmyadmin.net # # Host: localhost # Generated on: Sun Dec 27, 2015 to 23:18 # Server version: 5.6.16 # PHP Version: 5.5.11 # # Structure table for `wgteams_teams` 8 # CREATE TABLE `wgteams_teams` ( `team_id` INT(8) UNSIGNED NOT NULL AUTO_INCREMENT, `team_name` VARCHAR(200) NOT NULL DEFAULT '', `team_descr` TEXT NULL, `team_image` VARCHAR(200) NULL DEFAULT '', `team_nb_cols` INT(8) NOT NULL DEFAULT '1', `team_tablestyle` VARCHAR(100) DEFAULT 'default', `team_imagestyle` VARCHAR(100) DEFAULT 'default', `team_displaystyle` VARCHAR(100) DEFAULT 'default', `team_weight` INT(8) NOT NULL DEFAULT '0', `team_online` INT(1) NOT NULL DEFAULT '0', `team_submitter` INT(10) NOT NULL DEFAULT '0', `team_date_create` INT(10) NOT NULL DEFAULT '0', PRIMARY KEY (`team_id`) ) ENGINE = InnoDB; # # Structure table for `wgteams_members` 10 # CREATE TABLE `wgteams_members` ( `member_id` INT(8) UNSIGNED NOT NULL AUTO_INCREMENT, `member_firstname` VARCHAR(200) NOT NULL DEFAULT '', `member_lastname` VARCHAR(200) NULL DEFAULT '', `member_title` VARCHAR(200) NULL DEFAULT '', `member_address` TEXT NULL, `member_phone` TEXT NULL, `member_email` VARCHAR(200) NULL DEFAULT '', `member_image` VARCHAR(200) NULL DEFAULT '', `member_submitter` INT(10) NOT NULL DEFAULT '0', `member_date_create` INT(10) NOT NULL DEFAULT '0', PRIMARY KEY (`member_id`) ) ENGINE = InnoDB; # # Structure table for `wgteams_relations` 12 # CREATE TABLE `wgteams_relations` ( `rel_id` INT(8) UNSIGNED NOT NULL AUTO_INCREMENT, `rel_team_id` INT(10) NOT NULL DEFAULT '0', `rel_member_id` INT(10) NOT NULL DEFAULT '0', `rel_info_1_field` INT(10) NULL DEFAULT '0', `rel_info_1` TEXT NULL, `rel_info_2_field` INT(10) NULL DEFAULT '0', `rel_info_2` TEXT NULL, `rel_info_3_field` INT(10) NULL DEFAULT '0', `rel_info_3` TEXT NULL, `rel_info_4_field` INT(10) NULL DEFAULT '0', `rel_info_4` TEXT NULL, `rel_info_5_field` INT(10) NULL DEFAULT '0', `rel_info_5` TEXT NULL, `rel_weight` INT(10) NOT NULL DEFAULT '0', `rel_submitter` INT(10) NOT NULL DEFAULT '0', `rel_date_create` INT(10) NOT NULL DEFAULT '0', PRIMARY KEY (`rel_id`) ) ENGINE = InnoDB; # # Structure table for `wgteams_infofields` 4 # CREATE TABLE `wgteams_infofields` ( `infofield_id` INT(8) UNSIGNED NOT NULL AUTO_INCREMENT, `infofield_name` VARCHAR(200) NOT NULL DEFAULT '', `infofield_submitter` INT(10) NOT NULL DEFAULT '0', `infofield_date_created` INT(10) NOT NULL DEFAULT '0', PRIMARY KEY (`infofield_id`) ) ENGINE = InnoDB;