Forums / Cotonti / Extensions / XsCompleteClanSolution

CREATE TABLE sed_xsccs_cfg (
  cfg_cname varchar(255) NOT NULL,
  cfg_tags varchar(255) NOT NULL,
  cfg_email varchar(255) NOT NULL,
  cfg_sedplus tinyint(1) NOT NULL default '0',
  cfg_nav tinyint(1) NOT NULL default '0',
  cfg_ros_pag tinyint(3) NOT NULL default '0',
  cfg_sig_act tinyint(1) NOT NULL default '0',
  cfg_sig_con tinyint(1) NOT NULL default '0',
  cfg_sig_xf1_mem tinyint(1) NOT NULL default '0',
  cfg_sig_xf1_ttl varchar(255) NOT NULL,
  cfg_sig_xf2_mem tinyint(1) NOT NULL default '0',
  cfg_sig_xf2_ttl varchar(255) NOT NULL,
  cfg_sig_xf3_mem tinyint(1) NOT NULL default '0',
  cfg_sig_xf3_ttl varchar(255) NOT NULL,
  cfg_sig_xf4_mem tinyint(1) NOT NULL default '0',
  cfg_sig_xf4_ttl varchar(255) NOT NULL,
  cfg_sig_xf5_ttl varchar(255) NOT NULL,
  cfg_con_act tinyint(1) NOT NULL default '0',
  cfg_con_txt text NOT NULL,
  cfg_mat_pag tinyint(3) NOT NULL default '0',
  cfg_mat_xf1_ttl varchar(255) NOT NULL,
  cfg_mat_xf2_ttl varchar(255) NOT NULL,
  cfg_mat_xf3_ttl varchar(255) NOT NULL,
  cfg_mat_xf4_ttl varchar(255) NOT NULL,
  cfg_mat_xf5_ttl varchar(255) NOT NULL,
  cfg_cha_pag tinyint(3) NOT NULL default '0',
  cfg_cus_act tinyint(1) NOT NULL default '0',
  cfg_cus_cap tinyint(1) NOT NULL default '0',
  cfg_cus_xf1_mem tinyint(1) NOT NULL default '0',
  cfg_cus_xf1_ttl varchar(255) NOT NULL,
  cfg_cus_xf2_mem tinyint(1) NOT NULL default '0',
  cfg_cus_xf2_ttl varchar(255) NOT NULL,
  cfg_cus_xf3_mem tinyint(1) NOT NULL default '0',
  cfg_cus_xf3_ttl varchar(255) NOT NULL,
  cfg_cus_xf4_mem tinyint(1) NOT NULL default '0',
  cfg_cus_xf4_ttl varchar(255) NOT NULL,
  cfg_cus_xf5_ttl varchar(255) NOT NULL,
  cfg_ran_pag tinyint(3) NOT NULL default '0',
  cfg_sta_pag tinyint(3) NOT NULL default '0',
  cfg_squ_pag tinyint(3) NOT NULL default '0',
  cfg_gam_pag tinyint(3) NOT NULL default '0',
  cfg_gty_pag tinyint(3) NOT NULL default '0'
) ENGINE=MyISAM;

INSERT INTO sed_xsccs_cfg (cfg_cname, cfg_tags, cfg_email, cfg_sedplus, cfg_nav, cfg_ros_pag, cfg_sig_act, cfg_sig_con, cfg_sig_xf1_mem, cfg_sig_xf1_ttl, cfg_sig_xf2_mem, cfg_sig_xf2_ttl, cfg_sig_xf3_mem, cfg_sig_xf3_ttl, cfg_sig_xf4_mem, cfg_sig_xf4_ttl, cfg_sig_xf5_ttl, cfg_con_act, cfg_con_txt, cfg_mat_pag, cfg_cha_pag, cfg_cus_act, cfg_cus_cap, cfg_cus_xf1_mem, cfg_cus_xf1_ttl, cfg_cus_xf2_mem, cfg_cus_xf2_ttl, cfg_cus_xf3_mem, cfg_cus_xf3_ttl, cfg_cus_xf4_mem, cfg_cus_xf4_ttl, cfg_cus_xf5_ttl, cfg_ran_pag, cfg_sta_pag, cfg_squ_pag, cfg_gam_pag, cfg_gty_pag) VALUES 
('Clan Name', '[TAGS]', 'email@domain.com', 0, 1, 10, 1, 1, 0, '', 0, '', 0, '', 0, '', '', 1, 'Our Code of Conduct is coming soon!', 10, 10, 1, 1, 0, '', 0, '', 0, '', 0, '', '', 10, 10, 10, 10, 10);

-- --------------------------------------------------------

CREATE TABLE sed_xsccs_challenge (
  chall_id int(11) unsigned NOT NULL auto_increment,
  chall_yname varchar(255) NOT NULL,
  chall_yemail varchar(255) NOT NULL,
  chall_yip varchar(16) NOT NULL default '',
  chall_tname varchar(255) NOT NULL,
  chall_tsite varchar(255) NOT NULL,
  chall_game int(11) NOT NULL default '0',
  chall_mtype int(11) NOT NULL default '0',
  chall_gtype int(11) NOT NULL default '0',
  chall_tnumb int(11) NOT NULL default '0',
  chall_when int(11) NOT NULL default '0',
  chall_where varchar(255) NOT NULL default '',
  chall_xinfo text NOT NULL,
  chall_xf1 varchar(255) NOT NULL,
  chall_xf2 varchar(255) NOT NULL,
  chall_xf3 varchar(255) NOT NULL,
  chall_xf4 varchar(255) NOT NULL,
  chall_xf5 tinyint(1) NOT NULL default '0',
  chall_status tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (chall_id)
) ENGINE=MyISAM;

-- --------------------------------------------------------

CREATE TABLE sed_xsccs_game (
  game_id int(11) unsigned NOT NULL auto_increment,
  game_name varchar(255) NOT NULL,
  game_order int(11) NOT NULL default '0',
  game_img varchar(255) NOT NULL,
  game_desc text NOT NULL,
  PRIMARY KEY  (game_id)
) ENGINE=MyISAM;

-- --------------------------------------------------------

CREATE TABLE sed_xsccs_gamej (
  gaj_id int(11) unsigned NOT NULL auto_increment,
  gaj_memid int(11) NOT NULL default '0',
  gaj_gaid int(11) NOT NULL default '0',
  PRIMARY KEY  (gaj_id)
) ENGINE=MyISAM;

-- --------------------------------------------------------

CREATE TABLE sed_xsccs_match (
  mat_id int(11) unsigned NOT NULL auto_increment,
  mat_date int(11) NOT NULL default '0',
  mat_game int(11) NOT NULL default '0',
  mat_mtype int(11) NOT NULL default '0',
  mat_gtype int(11) NOT NULL default '0',
  mat_opp varchar(255) NOT NULL,
  mat_opps varchar(255) NOT NULL,
  mat_yscore int(11) NOT NULL default '0',
  mat_oscore int(11) NOT NULL default '0',
  mat_notes text NOT NULL,
  mat_xf1 varchar(255) NOT NULL,
  mat_xf2 varchar(255) NOT NULL,
  mat_xf3 varchar(255) NOT NULL,
  mat_xf4 varchar(255) NOT NULL,
  mat_xf5 tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (mat_id)
) ENGINE=MyISAM;

-- --------------------------------------------------------

CREATE TABLE sed_xsccs_rank (
  rank_id int(11) unsigned NOT NULL auto_increment,
  rank_name varchar(255) NOT NULL,
  rank_order int(11) NOT NULL default '0',
  rank_img varchar(255) NOT NULL,
  rank_desc text NOT NULL,
  PRIMARY KEY  (rank_id)
) ENGINE=MyISAM;

-- --------------------------------------------------------

CREATE TABLE sed_xsccs_gtype (
  gtype_id int(11) unsigned NOT NULL auto_increment,
  gtype_name varchar(255) NOT NULL,
  gtype_order int(11) NOT NULL default '0',
  gtype_img varchar(255) NOT NULL,
  gtype_desc text NOT NULL,
  PRIMARY KEY  (gtype_id)
) ENGINE=MyISAM;

-- --------------------------------------------------------

CREATE TABLE sed_xsccs_roster (
  mem_id int(11) unsigned NOT NULL auto_increment,
  mem_gname varchar(255) NOT NULL,
  mem_rank int(11) NOT NULL default '0',
  mem_games text NOT NULL,
  mem_status int(11) NOT NULL default '0',
  mem_est int(11) NOT NULL,
  mem_rname varchar(255) NOT NULL,
  mem_glength varchar(255) NOT NULL,
  mem_ptime varchar(255) NOT NULL,
  mem_about text NOT NULL,
  mem_skills text NOT NULL,
  mem_cpu varchar(255) NOT NULL,
  mem_mobo varchar(255) NOT NULL,
  mem_vc varchar(255) NOT NULL,
  mem_ram varchar(255) NOT NULL,
  mem_os varchar(255) NOT NULL,
  mem_conn varchar(255) NOT NULL,
  mem_pscore int(3) NOT NULL,
  mem_xf1 varchar(255) NOT NULL,
  mem_xf2 varchar(255) NOT NULL,
  mem_xf3 varchar(255) NOT NULL,
  mem_xf4 varchar(255) NOT NULL,
  mem_xf5 tinyint(1) NOT NULL default '0',
  mem_activated tinyint(1) NOT NULL default '0',
  mem_siteid mediumint(40) unsigned NOT NULL default '0',
  PRIMARY KEY  (mem_id)
) ENGINE=MyISAM;

-- --------------------------------------------------------

CREATE TABLE sed_xsccs_squad (
  squad_id int(11) unsigned NOT NULL auto_increment,
  squad_name varchar(255) NOT NULL,
  squad_order int(11) NOT NULL default '0',
  squad_img varchar(255) NOT NULL,
  squad_desc text NOT NULL,
  PRIMARY KEY  (squad_id)
) ENGINE=MyISAM;

-- --------------------------------------------------------

CREATE TABLE sed_xsccs_squadj (
  sqj_id int(11) unsigned NOT NULL auto_increment,
  sqj_memid int(11) NOT NULL default '0',
  sqj_sqid int(11) NOT NULL default '0',
  PRIMARY KEY  (sqj_id)
) ENGINE=MyISAM;

-- --------------------------------------------------------

CREATE TABLE sed_xsccs_status (
  status_id int(11) unsigned NOT NULL auto_increment,
  status_name varchar(255) NOT NULL,
  status_desc text NOT NULL,
  PRIMARY KEY  (status_id)
) ENGINE=MyISAM;

-- --------------------------------------------------------

CREATE TABLE sed_xsccs_memparj (
  mpj_id int(11) unsigned NOT NULL auto_increment,
  mpj_memid int(11) NOT NULL default '0',
  mpj_mpid int(11) NOT NULL default '0',
  PRIMARY KEY  (mpj_id)
) ENGINE=MyISAM;