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;