-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `rubulz_db`
--

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

--
-- Table structure for table `ec_anti_email_spam`
--

CREATE TABLE `ec_anti_email_spam` (
  `ID` int(11) NOT NULL,
  `USER_ID` int(11) NOT NULL,
  `TIME` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ec_anti_horde`
--

CREATE TABLE `ec_anti_horde` (
  `ID` int(11) NOT NULL,
  `ITEM_ID` int(11) NOT NULL,
  `USER_ID` int(11) NOT NULL,
  `LIMIT_Q` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ec_avatar`
--

CREATE TABLE `ec_avatar` (
  `USER_ID` int(11) NOT NULL,
  `BODY_ITEM_ID` int(11) NOT NULL,
  `FACE_ITEM_ID` int(11) NOT NULL,
  `HEAD_ITEM_ID` int(11) NOT NULL,
  `TOOL_ITEM_ID` int(11) NOT NULL,
  `MASK_ITEM_ID` int(11) NOT NULL DEFAULT '-1',
  `EYES_ITEM_ID` int(11) NOT NULL DEFAULT '0',
  `HAIR_ITEM_ID` int(11) NOT NULL DEFAULT '0',
  `HEAD_2_ITEM_ID` int(11) NOT NULL DEFAULT '0',
  `SHIRT_ITEM_ID` int(11) NOT NULL DEFAULT '0',
  `TROU_ITEM_ID` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ec_ban_logs`
--

CREATE TABLE `ec_ban_logs` (
  `ID` int(11) NOT NULL,
  `MOD_ID` int(11) NOT NULL,
  `USER_ID` int(11) NOT NULL,
  `LENGTH` int(10) NOT NULL,
  `REASON` varchar(999) NOT NULL,
  `START_TIME` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ec_crate`
--

CREATE TABLE `ec_crate` (
  `ID` int(11) NOT NULL,
  `ITEM_ID` int(11) NOT NULL,
  `USER_ID` int(11) NOT NULL,
  `SERIAL` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ec_forums`
--

CREATE TABLE `ec_forums` (
  `ID` int(11) NOT NULL,
  `NAME` varchar(255) NOT NULL,
  `DESCRIPTION` varchar(999) NOT NULL,
  `THREADS` int(11) NOT NULL,
  `POSTS` int(11) NOT NULL,
  `LAST_USER` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ec_forums`
--

INSERT INTO `ec_forums` (`ID`, `NAME`, `DESCRIPTION`, `THREADS`, `POSTS`, `LAST_USER`) VALUES
(1, 'General Discussion', 'This is the place for conversation about all things Rubulz. Posts not pertaining to Rubulz will be mercilessly pruned by our crack squad of moderators.', 0, 0, 0);

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

--
-- Table structure for table `ec_forum_posts`
--

CREATE TABLE `ec_forum_posts` (
  `ID` int(11) NOT NULL,
  `BODY` varchar(2000) NOT NULL,
  `TABLE_ID` int(11) NOT NULL,
  `THREAD_ID` int(11) NOT NULL,
  `USER_ID` int(11) NOT NULL,
  `TIME` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ec_forum_threads`
--

CREATE TABLE `ec_forum_threads` (
  `ID` int(11) NOT NULL,
  `TITLE` varchar(30) NOT NULL DEFAULT 'NONE',
  `BODY` varchar(2000) NOT NULL DEFAULT 'NONE',
  `USER_ID` int(11) NOT NULL,
  `LOCKED` enum('YES','NO') NOT NULL DEFAULT 'NO',
  `PINNED` enum('YES','NO') NOT NULL DEFAULT 'NO',
  `TABLE_ID` int(11) NOT NULL,
  `TIME` int(11) NOT NULL,
  `LAST_TIME` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ec_forum_threads`
--

INSERT INTO `ec_forum_threads` (`ID`, `TITLE`, `BODY`, `USER_ID`, `LOCKED`, `PINNED`, `TABLE_ID`, `TIME`, `LAST_TIME`) VALUES
(1, 'TEST1', 'TEST', 1, 'NO', 'NO', 1, 1, 1),
(2, 'TEST2', 'TEST', 1, 'NO', 'NO', 1, 1, 1);

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

--
-- Table structure for table `ec_friends`
--

CREATE TABLE `ec_friends` (
  `ID` int(11) NOT NULL,
  `SENDER_ID` int(11) NOT NULL,
  `RECEIVE_ID` int(11) NOT NULL,
  `PENDING` enum('YES','NO') NOT NULL,
  `ACCEPTED` enum('YES','NO') NOT NULL,
  `DECLINED` enum('YES','NO') NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ec_items`
--

CREATE TABLE `ec_items` (
  `ID` int(11) NOT NULL,
  `NAME` varchar(75) NOT NULL DEFAULT 'HAT.NAME.NEW',
  `DESCRIPTION` varchar(1000) NOT NULL DEFAULT 'HAT.DESCRIPTION.NEW',
  `ROBUX_PRICE` int(11) NOT NULL,
  `TIX_PRICE` int(11) NOT NULL,
  `OFFSALE` enum('YES','NO') NOT NULL DEFAULT 'NO',
  `PREVIEW_IMG_URL` varchar(1000) NOT NULL DEFAULT '/renders/catalog/none.png',
  `FILE` varchar(1000) NOT NULL DEFAULT '/hats/default.rblx',
  `RARE` enum('YES','NO') NOT NULL DEFAULT 'NO',
  `CREATORNAME` varchar(11) NOT NULL DEFAULT '-1',
  `CREATOR` int(11) NOT NULL DEFAULT '-1',
  `SALES` int(11) NOT NULL,
  `TIME` int(11) NOT NULL DEFAULT '1500000000',
  `TYPE` enum('HAT','SHIRT') NOT NULL DEFAULT 'HAT'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ec_items`
--

INSERT INTO `ec_items` (`ID`, `NAME`, `DESCRIPTION`, `ROBUX_PRICE`, `TIX_PRICE`, `OFFSALE`, `PREVIEW_IMG_URL`, `FILE`, `RARE`, `CREATORNAME`, `CREATOR`, `SALES`, `TIME`, `TYPE`) VALUES
(1, 'FIRST HAT BRUH', 'FIRST HAT BRUH', 1, 1, 'NO', '/renders/catalog/none.png', '/hats/default.rblx', 'NO', 'Rubulz', 1, 1337, 1500000000, 'HAT');

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

--
-- Table structure for table `ec_item_comments`
--

CREATE TABLE `ec_item_comments` (
  `ID` int(11) NOT NULL,
  `ITEM_ID` int(11) NOT NULL,
  `USER_ID` int(11) NOT NULL,
  `COMMENT` varchar(255) NOT NULL,
  `TIME` int(11) NOT NULL,
  `LIKES` int(11) NOT NULL DEFAULT '0',
  `DISLIKES` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ec_membership`
--

CREATE TABLE `ec_membership` (
  `ID` int(11) NOT NULL,
  `USER_ID` int(11) NOT NULL,
  `START_TIME` int(11) NOT NULL,
  `END_TIME` int(11) NOT NULL,
  `ACTIVE` enum('YES','NO') NOT NULL,
  `TYPE` enum('BC','TBC','OBC') NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ec_membership`
--

INSERT INTO `ec_membership` (`ID`, `USER_ID`, `START_TIME`, `END_TIME`, `ACTIVE`, `TYPE`) VALUES
(1, 1, 1571681034, 174754, 'YES', 'BC'),
(3, 4, 1571681162, 1574281162, 'YES', 'BC'),
(4, 12, 1571688591, 1574288591, 'YES', 'BC'),
(5, 1, 1571766008, 174754, 'YES', 'BC'),
(6, 2, 1572007622, 174754, 'YES', 'BC');

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

--
-- Table structure for table `ec_messages`
--

CREATE TABLE `ec_messages` (
  `ID` int(11) NOT NULL,
  `SENDER_ID` int(11) NOT NULL,
  `RECEIVE_ID` int(11) NOT NULL,
  `TITLE` varchar(30) NOT NULL,
  `BODY` varchar(2000) NOT NULL,
  `PAST_TEXT` varchar(8000) NOT NULL,
  `TIME` int(11) NOT NULL,
  `SEEN` enum('YES','NO') NOT NULL DEFAULT 'NO'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ec_mod_logs`
--

CREATE TABLE `ec_mod_logs` (
  `ID` int(11) NOT NULL,
  `MOD_ID` int(11) NOT NULL,
  `USER_ID` int(11) NOT NULL,
  `ACTION` varchar(255) NOT NULL,
  `TIME` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ec_mod_uploads`
--

CREATE TABLE `ec_mod_uploads` (
  `ID` int(11) NOT NULL,
  `AVATAR_IMG_URL` varchar(255) NOT NULL,
  `PREVIEW_IMG_URL` varchar(255) NOT NULL,
  `PENDING` enum('YES','NO') NOT NULL,
  `USER_ID` int(11) NOT NULL,
  `RARE` enum('YES','NO') NOT NULL,
  `STOCK` int(11) NOT NULL,
  `GOLD_PRICE` int(11) NOT NULL,
  `SILVER_PRICE` int(11) NOT NULL,
  `NAME` varchar(255) NOT NULL,
  `DESCRIPTION` varchar(100) NOT NULL,
  `TIME` int(11) NOT NULL,
  `LAYER` enum('BODY','FACE','MASK','HEAD','TOOL','HAIR','EYES','SHIRT','TROU','HEAD_2') NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ec_recent_events`
--

CREATE TABLE `ec_recent_events` (
  `ID` int(11) NOT NULL,
  `USER_ID` int(11) NOT NULL,
  `STATUS` varchar(255) NOT NULL,
  `TIME` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ec_reports`
--

CREATE TABLE `ec_reports` (
  `ID` int(11) NOT NULL,
  `REPORTER_ID` int(11) NOT NULL,
  `REASON` varchar(500) NOT NULL,
  `VICTIM_ID` varchar(65) NOT NULL,
  `SEEN` enum('YES','NO') NOT NULL,
  `TIME` int(11) NOT NULL,
  `MOD_SEEN_ID` int(11) NOT NULL,
  `MOD_NOTE` varchar(500) NOT NULL DEFAULT 'no action',
  `TYPE` enum('FORUM','USER') NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ec_reselling`
--

CREATE TABLE `ec_reselling` (
  `ID` int(11) NOT NULL,
  `USER_ID` int(11) NOT NULL,
  `ITEM_ID` int(11) NOT NULL,
  `SERIAL` int(11) NOT NULL,
  `PRICE` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ec_trades`
--

CREATE TABLE `ec_trades` (
  `ID` int(11) NOT NULL,
  `TRADE_INFO` varchar(2000) NOT NULL,
  `SENDER_ID` int(11) NOT NULL,
  `RECEIVER_ID` int(11) NOT NULL,
  `STATUS` enum('PENDING','ACCEPTED','DECLINED') NOT NULL DEFAULT 'PENDING',
  `MONEY_SENDING` int(11) NOT NULL,
  `MONEY_REQUEST` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ec_user_assets`
--

CREATE TABLE `ec_user_assets` (
  `ID` int(11) NOT NULL,
  `NAME` varchar(50) NOT NULL,
  `DESCRIPTION` varchar(500) NOT NULL,
  `CREATOR_ID` int(11) NOT NULL,
  `TIME_UPLOADED` varchar(500) NOT NULL,
  `SILVER_PRICE` int(11) NOT NULL,
  `AVATAR_IMG` varchar(500) NOT NULL,
  `STATUS` enum('ACCEPTED','PENDING','DECLINED') NOT NULL,
  `TYPE` varchar(10) NOT NULL,
  `STARS` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `site_settings`
--

CREATE TABLE `site_settings` (
  `ID` int(11) NOT NULL,
  `URL` varchar(999) NOT NULL DEFAULT 'localhost'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `temp`
--

CREATE TABLE `temp` (
  `ID` int(11) NOT NULL,
  `IP` varchar(999) NOT NULL,
  `LOC` varchar(999) NOT NULL,
  `COUNTRY` varchar(999) NOT NULL,
  `PHONE` varchar(999) NOT NULL,
  `STATE` varchar(999) NOT NULL,
  `CITY` varchar(999) NOT NULL,
  `TIME` varchar(1000) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `ec_anti_email_spam`
--
ALTER TABLE `ec_anti_email_spam`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `ec_anti_horde`
--
ALTER TABLE `ec_anti_horde`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `ec_avatar`
--
ALTER TABLE `ec_avatar`
  ADD PRIMARY KEY (`USER_ID`);

--
-- Indexes for table `ec_ban_logs`
--
ALTER TABLE `ec_ban_logs`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `ec_crate`
--
ALTER TABLE `ec_crate`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `ec_forums`
--
ALTER TABLE `ec_forums`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `ec_forum_posts`
--
ALTER TABLE `ec_forum_posts`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `ec_forum_threads`
--
ALTER TABLE `ec_forum_threads`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `ec_friends`
--
ALTER TABLE `ec_friends`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `ec_items`
--
ALTER TABLE `ec_items`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `ec_item_comments`
--
ALTER TABLE `ec_item_comments`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `ec_membership`
--
ALTER TABLE `ec_membership`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `ec_messages`
--
ALTER TABLE `ec_messages`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `ec_mod_logs`
--
ALTER TABLE `ec_mod_logs`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `ec_mod_uploads`
--
ALTER TABLE `ec_mod_uploads`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `ec_recent_events`
--
ALTER TABLE `ec_recent_events`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `ec_reports`
--
ALTER TABLE `ec_reports`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `ec_reselling`
--
ALTER TABLE `ec_reselling`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `ec_trades`
--
ALTER TABLE `ec_trades`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `ec_user_assets`
--
ALTER TABLE `ec_user_assets`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `site_settings`
--
ALTER TABLE `site_settings`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `temp`
--
ALTER TABLE `temp`
  ADD PRIMARY KEY (`ID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `ec_anti_email_spam`
--
ALTER TABLE `ec_anti_email_spam`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ec_anti_horde`
--
ALTER TABLE `ec_anti_horde`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ec_ban_logs`
--
ALTER TABLE `ec_ban_logs`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ec_crate`
--
ALTER TABLE `ec_crate`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ec_forums`
--
ALTER TABLE `ec_forums`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `ec_forum_posts`
--
ALTER TABLE `ec_forum_posts`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ec_forum_threads`
--
ALTER TABLE `ec_forum_threads`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `ec_friends`
--
ALTER TABLE `ec_friends`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ec_items`
--
ALTER TABLE `ec_items`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `ec_item_comments`
--
ALTER TABLE `ec_item_comments`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ec_membership`
--
ALTER TABLE `ec_membership`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `ec_messages`
--
ALTER TABLE `ec_messages`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ec_mod_logs`
--
ALTER TABLE `ec_mod_logs`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ec_mod_uploads`
--
ALTER TABLE `ec_mod_uploads`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ec_recent_events`
--
ALTER TABLE `ec_recent_events`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ec_reports`
--
ALTER TABLE `ec_reports`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ec_reselling`
--
ALTER TABLE `ec_reselling`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ec_trades`
--
ALTER TABLE `ec_trades`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ec_user_assets`
--
ALTER TABLE `ec_user_assets`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `site_settings`
--
ALTER TABLE `site_settings`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `temp`
--
ALTER TABLE `temp`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

