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

START TRANSACTION;



--
-- Database: `CWZ_main`
--

DELIMITER $$
--
-- Functions
--
DROP FUNCTION IF EXISTS `ABBV`$$
CREATE DEFINER=`root`@`localhost` FUNCTION `ABBV` (`num` DOUBLE) RETURNS VARCHAR(16) CHARSET utf8mb4 NO SQL
    DETERMINISTIC
BEGIN
   DECLARE fnum varchar(16);
    
   IF num >= 0 AND num < 1000 THEN
    	SET fnum = CONCAT('$', FORMAT(num, 0));
   ELSEIF num >= 1000 AND num < 1000000 THEN
   	SET fnum = CONCAT('$', FORMAT(num DIV 1000, 0), "K");
   ELSEIF num >= 1000000 AND num < 1000000000 THEN
      SET fnum = CONCAT('$', FORMAT(num DIV 1000000, 0), "M");
   ELSEIF num >= 1000000000 AND num < 1000000000000 THEN
      SET fnum = CONCAT('$', FORMAT(num / 1000000000, 1), "B");
   ELSEIF num >= 1000000000000 THEN
      SET fnum = CONCAT('$', FORMAT(num / 1000000000000, 2), "T");
   ELSE
    	SET fnum = "###";
   END IF;
    
   RETURN fnum;
END$$

DROP FUNCTION IF EXISTS `FMT`$$
CREATE DEFINER=`root`@`localhost` FUNCTION `FMT` (`val` DOUBLE) RETURNS VARCHAR(32) CHARSET utf8mb4 NO SQL
    DETERMINISTIC
BEGIN
	RETURN CONCAT('$', FORMAT(val, 2));
END$$

DELIMITER ;
-- --------------------------------------------------------

--
-- Table structure for table `Attack_Log`
--

CREATE TABLE IF NOT EXISTS `Attack_Log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `attacker` varchar(40) NOT NULL,
  `a_sid` int(11) NOT NULL,
  `defender` varchar(40) NOT NULL,
  `d_sid` int(11) NOT NULL,
  `result` varchar(800) NOT NULL,
  `timestamp` timestamp NOT NULL,
  `ret` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `chat`
--

CREATE TABLE IF NOT EXISTS `Chat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ts` datetime DEFAULT NULL,
  `chan` int(11) DEFAULT NULL,
  `aid` int(11) DEFAULT NULL,
  `sid` int(11) DEFAULT NULL,
  `pid` int(11) DEFAULT NULL,
  `msg` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `Console`
--

CREATE TABLE IF NOT EXISTS `Console` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ts` datetime DEFAULT NULL,
  `chan` int(11) DEFAULT NULL,
  `aid` int(11) DEFAULT NULL,
  `sid` int(11) DEFAULT NULL,
  `pid` int(11) DEFAULT NULL,
  `msg` varchar(400) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `Crypto_Game`
--

CREATE TABLE IF NOT EXISTS `Crypto_Game` (
  `cd` int(11) NOT NULL,
  `shortnm` varchar(8) DEFAULT NULL,
  `longnm` varchar(20) DEFAULT NULL,
  `price_now` double DEFAULT NULL,
  `price_ref` double DEFAULT NULL,
  `price_min` double DEFAULT NULL,
  `price_max` double DEFAULT NULL,
  `delta_base` double DEFAULT NULL,
  `delta_fluc` double DEFAULT NULL,
  `unit_vol` bigint(20) DEFAULT NULL,
  `unit_prev` bigint(20) DEFAULT NULL,
  `unit_ref` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`cd`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Crypto_Game`
--

INSERT INTO `Crypto_Game` (`cd`, `shortnm`, `longnm`, `price_now`, `price_ref`, `price_min`, `price_max`, `delta_base`, `delta_fluc`, `unit_vol`, `unit_prev`, `unit_ref`) VALUES
(1, 'BTCW', 'Bitcoin Warz', 61071.39, 61071.39, 20000, 69420, -0.00007540743793517301, 0, 118, 118, 118),
(2, 'FETH', 'Fethereum', 5164.09, 5164.09, 1337, 8008, -0.001904268389211616, 0, 6, 2, 6),
(3, 'TNT', 'Trinance', 211.67, 211.67, 68.2, 420.65, -0.000571666, 0.0005604568622518959, 101, 1, 51),
(4, 'USDB', 'Bether', 1, 1, 0.95, 1.05, 0, 0, 4705129, 4681570, 4693350),
(5, 'LKC', 'Likecoin', 369.11, 369.11, 68.2, 420.65, 0.000056666, 0.000056666, 28, 0, 14),
(6, 'AST', 'Astral', 0.6636, 0.6636, 0.1007, 0.6942, 0.000518254874195635, -0.000000036946389981406823, 813518, 813634, 813576),
(7, 'GINK', 'Gamelink', 41.45, 41.45, 8.45, 42.05, 0.000166666, 0.00017678463009454014, 264, 0, 132),
(8, 'LOGE', 'Logecoin', 0.1122, 0.1122, 0.042, 0.2325, 0.000133333, 0.000071142476010032, 70443, 21424, 45934),
(9, 'XWP', 'Wave', 0.1756, 0.1756, 0.1785, 1.25, -2.6788766983178318e-106, 5.261800715978387e-106, 93963, 849, 47406),
(10, 'BROW', 'Unibrow', 28.28, 28.28, 6.12, 40.87, -0.00021666600000000007, -0.00021528983658436208, 423, 132773, 66598);

--
-- Triggers `Crypto_Game`
--
DROP TRIGGER IF EXISTS `CG_decimal_format`;
DELIMITER $$
CREATE TRIGGER `CG_decimal_format` BEFORE UPDATE ON `Crypto_Game` FOR EACH ROW BEGIN
  IF NEW.price_now >= 10 THEN
    SET NEW.price_now = ROUND(NEW.price_now, 2);
  ELSEIF NEW.price_now > 0.01 THEN
    SET NEW.price_now = ROUND(NEW.price_now, 4);
  ELSE
    SET NEW.price_now = ROUND(NEW.price_now, 7);
  END IF;

  IF NEW.price_ref >= 10 THEN
    SET NEW.price_ref = ROUND(NEW.price_ref, 2);
  ELSEIF NEW.price_ref > 0.01 THEN
    SET NEW.price_ref = ROUND(NEW.price_ref, 4);
  ELSE
    SET NEW.price_ref = ROUND(NEW.price_ref, 7);
  END IF;
END
$$
DELIMITER ;

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

--
-- Table structure for table `Crypto_Game_History` 
--

CREATE TABLE IF NOT EXISTS `Crypto_Game_History` (
  `cd` int(11) NOT NULL AUTO_INCREMENT,
  `shortnm` varchar(8) NOT NULL,
  `longnm` varchar(20) NOT NULL,
  `price_history` longtext NOT NULL,
  `circulating_supply` varchar(99) DEFAULT NULL,
  `max_supply` varchar(99) DEFAULT NULL,
  `notes` text NOT NULL,
  `timestamp` timestamp NOT NULL,
  PRIMARY KEY (`cd`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `Crypto_Game_History` (`cd`, `shortnm`, `longnm`, `price_history`, `circulating_supply`, `max_supply`, `notes`, `timestamp`) VALUES
(1, 'BTCW', 'Bitcoin Warz', '0', '19382650', '21000000', 'Get ready for the ultimate crypto showdown with Bitcoin Warz, the heavyweight champion of the digital ring! While Bitcoin paved the way, Bitcoin Warz takes the battle to a whole new level, bringing fierce competition and relentless innovation. It\'s like Bitcoin on steroids, fueling your financial ambitions with turbocharged speed and jaw-dropping features. In this epic warzone, traditional finance meets blockchain technology, delivering knockout punches of profitability and excitement. So buckle up, grab your popcorn, and witness the clash of the titans as Bitcoin Warz takes the world of crypto by storm!', '2023-07-26 14:10:59'),
(2, 'FETH', 'Fethereum', '0', '120262782', '13333333337', 'The cryptocurrency that\'s like Ethereum\'s cool, distant cousin who decided to take a detour to the wild side. With Fethereum, you\'ll experience a thrilling rollercoaster ride through the crypto universe, where volatility meets audacious innovation. Buckle up and get ready for a thrilling adventure that\'ll leave you saying, \"Who needs stability when you can have excitement?\"', '2023-07-26 14:10:59'),
(3, 'TNT', 'Trinance', '0', '166801148', '166801148', 'Meet Trinance, the crypto exchange that takes \"bi\" and turns it into \"tri\" times the fun! With Trinance, you\'ll experience a trifecta of excellence, innovation, and outrageous profitability. Bid farewell to the ordinary and say hello to the extraordinary, where every trade becomes a triumphant success. Get ready to transcend the boundaries of conventional trading and embrace the thrill of tri-winning with Trinance!', '2023-07-26 14:10:59'),
(4, 'USDB', 'Bether', '1', '83026924196', '999999999999999', 'Bether, the cryptocurrency that proves it\'s just \"bether\" than the rest! With Bether, you\'ll step into a world where stability meets charm, where reliability meets sophistication. It\'s not about being like the others; it\'s about standing out and being bether. So why settle for ordinary when you can elevate your crypto game to extraordinary heights? Experience the magic of Bether and say goodbye to the mundane. After all, when it comes to cryptocurrencies, it\'s all about being \"bether\" than the rest!', '2023-07-26 14:10:59'),
(5, 'LKC', 'Likecoin', '0', '72992989', '84000000', 'Introducing Likecoin, the cryptocurrency that\'s like a catchy remix of a hit song you just can\'t resist. Likecoin is the playful and vibrant sibling of the crypto world, a creative fork that takes the best elements and adds its own unique flavor. Just like how a good remix can take a song to new heights, Likecoin takes the foundation of another big coin and transforms it into a captivating and refreshing experience. So get ready to hit that \"like\" button and join the party, because with Likecoin, it\'s all about bringing the fun back into the crypto game!', '2023-07-26 14:10:59'),
(6, 'AST', 'Astral', '0', '27187305937', '50001806812', 'Astral (ASTR), the cosmic phenomenon that promises to revolutionize the way we transact and connect with the universe of finance. Powered by an otherworldly blockchain, Astral offers lightning-fast, low-cost transactions, catapulting you to new dimensions of financial freedom. But Astral\'s mission extends beyond mere transactions; it aims to break down barriers and empower individuals from all corners of the galaxy, ensuring access to banking services and economic opportunities. With its groundbreaking Astral Consensus Protocol (ACP), the network achieves remarkable security and decentralization, paving the way for interstellar prosperity. Prepare to embark on a celestial journey where tokenization possibilities are infinite, real-world assets become stardust, and financial inclusivity is the guiding star. Join the Astral revolution and watch your crypto dreams ascend to the cosmos!', '2023-07-26 14:10:59'),
(7, 'GINK', 'Gamelink', '0', '517099970', '1000000000', 'Gamelink, the crypto that\'s all about gaming the system without the chain of real progress! While Chainlink forges partnerships like a master strategist, Gamelink takes a playful approach, teaming up with every game studio in the virtual universe. From epic MMOs to casual mobile games, Gamelink promises seamless integration, endless virtual rewards, and an abundance of in-game loot. But beware, while Gamelink excels at racking up partnerships, it seems to have forgotten about moving the market needle. So, gear up, grab your controller, and get ready for a crypto adventure where the partnerships are plenty, but the market movement is on a permanent pause. Game on, crypto enthusiasts, and may the lack of market excitement be ever in your favor!', '2023-07-26 14:10:59'),
(8, 'LOGE', 'Logecoin', '0', '139482146383', '999999999999999', 'Logecoin, the crypto that\'s all about rolling with the timber and turning logs into digital gold! While Dogecoin had its fun with memes, Logecoin takes a different route, embracing the enchanting world of lumber and logging. With Logecoin, you\'ll feel the raw power of the forest, as every transaction becomes a log-rolling adventure. It\'s a crypto that\'s as solid as oak, as reliable as a sturdy log cabin, and as exciting as a high-speed chainsaw race. So grab your flannel, sharpen your axe, and join the Logecoin revolution as we carve our way through the crypto forest, one log at a time!', '2023-07-26 14:10:59'),
(9, 'XWP', 'Wave', '0', '45404028640', '100000000000', 'Dive into the cryptocurrency ocean with Wave, the token that makes a splash like no other in comparison to Ripple XRP! While Ripple ripples the waters of financial transactions, Wave creates a tidal wave of innovation that leaves no stone unturned. With Wave, you\'ll ride the crest of a crypto tsunami, making waves with lightning-fast transactions and a disruptive approach to the financial world. Forget about ripples; it\'s time to embrace the full force of the Wave! So grab your surfboard, ride the crypto currents, and prepare to make a splash that will shake the industry to its core. Hang ten with Wave and ride the crypto wave of the future!', '2023-07-26 14:10:59'),
(10, 'BROW', 'Unibrow', '0', '577501036 ', '1000000000', 'The crypto that raises eyebrows and breaks all boundaries, making even Uniswap look ordinary! With Unibrow, you\'ll experience a decentralized exchange like no other, where uniqueness is celebrated and conformity is left behind. Sporting a magnificent unibrow of innovation, this token defies conventional norms, bringing together diverse communities and defying the status quo. Say goodbye to perfectly groomed eyebrows and hello to the wild and untamed world of Unibrow, where imperfection is embraced and beauty lies in the eye of the beholder. Join the Unibrow revolution and let your eccentricity shine through in the crypto world!', '2023-07-26 14:10:59');

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

--
-- Table structure for table `Crypto_Live`
--

CREATE TABLE IF NOT EXISTS `Crypto_Live` (
  `cd` int(11) NOT NULL AUTO_INCREMENT,
  `shortnm` varchar(8) NOT NULL,
  `longnm` varchar(35) DEFAULT NULL,
  `price_now` double DEFAULT NULL,
  `price_ref` double DEFAULT NULL,
  `price_min` double DEFAULT NULL,
  `price_max` double DEFAULT NULL,
  `delta_base` double DEFAULT NULL,
  `delta_fluc` double DEFAULT NULL,
  `unit_vol` bigint(20) DEFAULT NULL,
  `unit_prev` bigint(20) DEFAULT NULL,
  `unit_ref` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`cd`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `Crypto_Live_History`
--

CREATE TABLE IF NOT EXISTS `Crypto_Live_History` (
  `cd` int(11) NOT NULL AUTO_INCREMENT,
  `shortnm` varchar(8) NOT NULL,
  `longnm` varchar(30) NOT NULL,
  `price_history` varchar(9999) NOT NULL,
  `circulating_supply` varchar(99) NOT NULL,
  `max_supply` varchar(99) NOT NULL,
  `notes` text NOT NULL,
  `timestamp` timestamp NOT NULL,
  PRIMARY KEY (`cd`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `Crypto_News`
--

CREATE TABLE IF NOT EXISTS `Crypto_News` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `news` varchar(2048) DEFAULT NULL,
  `wgt` int(11) DEFAULT NULL,
  `efx` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Crypto_News`
--

INSERT INTO `Crypto_News` (`id`, `news`, `wgt`, `efx`) VALUES
(3, 'China announces that Bitcoin has been banned for the 420th time. Investors hands shatter as the entire crypto market plummets.', 300, 'BTCW:=-1.1*0.5,FETH:=-1.8,TNT:=-3.43,LKC:=-2.15,AST:=-1.83,GINK:-1*0.3,LOGE:=-7.35,XWP:=-5.7,BROW:=-3.1'),
(4, 'Melon Tusk tweeted \"If Logecoin hits $1 Million per token, I will eat my own genitals\" the coin has surged since his announcement.', 100, 'FETH:+0.25,LKC:=+0.34,AST:=+1.8,GINK:=+1.6,LOGE:+4.3,XWP:=-0.9'),
(5, 'South Parks future episode showed crypto prices in the year 2045. Already confused investors rave good reviews which as increase demand in the entire crypto space.', 300, 'BTCW:=+2.2,FETH:=+2.4*0.8,TNT:+1.7,LKC:=+1.3,AST:=+2.2,GINK:+2.2,LOGE:=+1.6,XWP:=+1.7,BROW:+1.1*1'),
(6, 'Ghost Hunters claim to have found the spirit of John McAfee next to a jar containing...a one-eyed trouser snake. Instead of leaving the spirit be, the hunters attempt to communicate. The spirit is restless and unwilling to participate. In a final attempt, the hunters grab the jar and the McAfee ghost unleashes his fury by taking everyones phone and tweeting \"Fethereum to 50k or I eat my phantom menace on GhostTube\".', 200, 'BTCW:=+0.14,FETH:=+4.2,TNT:=+1.6,LKC:=+0.78,AST:=+0.24,GINK:=+1.3,BROW:=+1.2'),
(7, 'Satoshi emerges for the first time. His git commit message states FUNDS ARE SAFU. The entire crypto market has paused.', 399, 'BTCW:=0,FETH:=0,TNT:=0,LKC:=0,AST:=0,GINK:=0,LOGE:=0,XWP:=0,BROW:=0'),
(8, 'As El Salvador becomes the next crypto utopia, President Bukele sets focus on his next target. He announces that they will use Meteor Power to mine Astral coin. The coin gains momentum. ', 100, 'AST:=+2.2*2,BROW:+0.6'),
(9, 'Gamelink has announced partnership with Google, Amazon, Apple, NASA, Walmart, Tesla, and the American Government, the price slightly goes up. ', 100, 'GINK:=+1'),
(10, 'Genius, billionaire, playboy, philanthropist Italik Bolderin, creator of Fethereum, has reported that he...is...Miner Man. Fethereum fans go wild and the price flies. ', 100, 'BTCW:+0.5,FETH:=+5.4*2,LKC:+0.2,AST:=+.6,GINK:+0.5'),
(11, 'Logecoin creator briefs reporter that people who invest in LOGE are idiots. As the report airs, people catch wind and buy more.', 100, 'FETH:-0.6,LOGE:=+0.8'),
(12, 'As the price of razors increase, the fad of unibrows does as well. Buyers are embracing the Frida Kahlo look and the price of BROW follows this odd trend.', 100, 'BROW:=+1.7'),
(13, 'Bitcoin Warz has hit an all time high! Investors pull back to regain earlier losses and to let the market settle.', -1, 'BTCW:=-8*4'),
(14, 'As Fethereum reaches an ATH, the masses begin selling and taking profits.', -2, 'FETH:=-8*4'),
(15, 'Trinance has shattered all its previous highs. Weary investors decide to pull out while a correction looms.', -3, 'TNT:=-8*4'),
(16, 'Bether has become depegged. Investors worry and sell off their bags.', -4, 'USDB:=-6*2'),
(17, 'Charts show Likecoin teetering near all time highs without much news lately. Whales begin to dump their LKC back into the market making it crash', -5, 'LKC:=-8*4'),
(18, 'Astrals market dominance is through the roof as its value passes an all time high triggering a sell-off. ', -6, 'AST:=-8*4'),
(19, 'Gamelinks partnership announcements have pushed the value of GINK to an all time high. Institutions take advantage of this price and begin selling. ', -7, 'GINK:=-8*4'),
(20, 'As soon as the meme coin LOGE hit an ATH, a massive sell off began. Investors are warned to hold off on purchasing any LOGE at the moment.', -8, 'LOGE:=-8*4'),
(21, 'Waves have been made this quarter as XWP smashes its all time high value. Investors sell and send WAVE crashing after. Will it recover soon?', -9, 'XWP:=-8*4'),
(22, 'Unibrows marketing efforts have paid dividends as BROW hits an all time high. Users sell off and take profits as the price of this hideous coin does not seem justified.', -10, 'BROW:=-8*4'),
(23, '\"The time to buy is when theres blood in the streets\" - Baron Rothschild. Bitcoin Warz has taken a pounding in the markets, but investors are buying in while the cost is low.', 1, 'BTCW:=+5*3'),
(24, 'Investors place multiple buy orders of FETH as Fethereum touches the lowest value in the last 12 months.', 2, 'FETH:=+5*3'),
(25, 'TNT is looking to explode as it hits a 12 month low. Buy orders are coming in and looking to turn Trinance bullish for the first time in a long time.', 3, 'TNT:=+5*3'),
(26, 'After USDB depegged, the team has agreed to print more money to get the stable coin back to 1.00. Brrrr', 4, 'USDB:=+5*3'),
(27, '\"Is Likecoin dead? No one knows. But its cheap so its bound to bounce, right?!\" - some crypto expert. LKC begins to bounce back. ', 5, 'LKC:=+5*3'),
(28, 'Astral has crashed to 12 month lows, investors begin throwing their money back in. AST starts moving upwards. ', 6, 'AST:=+5*3'),
(29, 'Fear, uncertainty, and doubt have brought GINK down to its lowest prices in ages. Institutional money has begun flowing back in to take advantage of this clearance.', 7, 'GINK:=+5*3'),
(30, 'LOGE ARMY swarms the streets with signs and pitchforks (tracked by the LOGE blockchain). Casuals begin to realize this shitcoin still exists so it must be worth investing in it… again.', 8, 'LOGE:=+5*3'),
(31, 'Recovery begins as nothing but good news keeps coming in, wave after WAVE. XWP trends positively as it touches yearly low prices.', 9, 'XWP:=+5*3'),
(32, 'Unibrow market cap has shaved down to all time lows. Investors are not surprised and take advantage of this price to buy back in.', 10, 'BROW:=+5*3'),
(33, 'Bitcoin Warz developers admit to a coding error that resulted in an unintentional inflation bug, causing billions of extra tokens to flood the market and crash the price.', 100, 'BTCW:=-3.2,FETH:=-0.4'),
(34, 'Fethereum announces a controversial hard fork to undo a hack that drained millions of FETH tokens from a smart contract, leading to a community split and loss of investor confidence.', 100, 'FETH:=-4.4,XWP:+0.7'),
(35, 'Trinance founder arrested on charges of insider trading, manipulating the market, and using Trinance funds for personal fast food and beer runs, leading to a major sell-off and regulatory scrutiny.', 100, 'BTCW:=+2.2,FETH:=+2.4*0.8,TNT:+1.7,LKC:=+1.3,AST:=+2.2,GINK:+2.2,LOGE:=+1.6,XWP:=+1.7,BROW:+1.1*1'),
(36, 'The CEO of Likecoin has been caught in a social media scandal involving fake accounts, paid influencers, and fake positive reviews, resulting in a wave of negative sentiment and a rapid decline in token value.', 100, 'LKC:=-3.3,GINK:+1.2'),
(37, 'Astrals ambitious space colony project fails due to technical setbacks, lack of funding, and disputes among team members, resulting in a collapse of the Astral token price.', 100, 'AST:=-3.8'),
(38, 'The Oracles prediction has come to pass. Gamelinks smart contract was hacked, resulting in the theft of millions of GINK tokens, causing panic among investors and a sharp sell-off as confidence in the platform wanes.', 100, 'BTCW:=+1.1*2,GINK:-4.4'),
(39, 'Logecoins founder disappears with the entire treasury fund, leaving behind a cryptic message on the website, causing widespread panic and a massive dump of Logecoin tokens.', 100, 'BTCW:+0.2,LOGE:=-3.6'),
(40, 'Waves partnership with a controversial environmental organization comes under scrutiny, with allegations of greenwashing and hypocrisy, leading to a loss of trust among investors and a market sell-off.', 100, 'BTCW:+1,FETH:+0.4,XWP:=-2.2'),
(41, 'Unibrows NFT marketplace hit with a lawsuit for hosting unauthorized digital artwork, resulting in a loss of credibility and value for Unibrow tokens as users flee the platform.', 100, 'TNT:+0.7,BROW:=-4'),
(42, 'Bitcoin Warz announces a partnership with the toy company Hashbro to release limited edition action figures of crypto influencers battling it out in a virtual war for the future of finance.', 200, 'BTCW:=+4.2,FETH:=+1.5,TNT:+0.7,LKC:=+1.1,AST:=+1.2,GINK:+1.8,LOGE:=+0.6,XWP:+0.7,BROW:=1.3'),
(43, 'Astral unveils their ambitious plan to build a blockchain-powered space colony on Mars, with tokenized assets representing virtual real estate and extraterrestrial resources.', 100, 'AST:=+5.2,XWP:=+0.4,BROW:=-1.4'),
(44, 'Logecoin founder returns from his previous cryptic message. Apparently he was just out chopping wood. LOGE manics rejoice and buy back in.', 100, 'LOGE:=+2.9,XWP:+0.4'),
(45, 'Wave announces their revolutionary \"Proof-of-Surfing\" consensus algorithm, where users can mine WAV tokens by riding actual ocean waves and capturing them as NFTs on the blockchain.', 100, 'FETH:+1.4,AST:=+1.2,XWP:=+5.9'),
(46, 'Unibrow introduces a unique NFT marketplace where users can buy and sell digital artwork that features exaggerated and eccentric unibrow styles, turning facial hair into a digital collectible.', 100, 'BROW:=+4.2'),
(47, 'Hey hey HEYYYYY. WASA WASA WASA WASSUP', 300, 'BTCW:=-3.2,FETH:=-1.6,TNT:-1.7,LKC:=-1.3,AST:=-2.2,GINK:=-2.4,LOGE:=-4.6,XWP:=-2.7,BROW:=-3.1'),
(48, 'Bitcoin Warz forgets to switch accounts and leaves the following tweet on primary account. \"OMG! Cant believe I won ! Thank you Bitcoin Warz team! Keep doing the great work. Muscle muscle rocket rocket\"', 300, 'BTCW:=-5.2,FETH:=-2.6,TNT:-2.1,LKC:=-2.3,AST:=-1.4,GINK:-1.2,LOGE:=-2.3,XWP:=-1.0,BROW:=-1.9'),
(49, '1. What   2. H', 300, 'BTCW:=-1.2,FETH:=-1.6,TNT:-1.1,LKC:=-1.5,AST:=-0.6,GINK=-2.2,LOGE:=-3.1,XWP:=-1.3,BROW:=-0.9');

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

--
-- Table structure for table `Crypto_Reel`
--

CREATE TABLE IF NOT EXISTS `Crypto_Reel` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ts` datetime DEFAULT NULL,
  `news_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO Crypto_Reel (`ts`, `news_id`) VALUES
('2023-05-24 18:50:01', 3),
('2023-05-24 19:24:24', 10),
('2023-05-24 19:29:25', 4),
('2023-05-24 19:41:01', 8),
('2023-05-24 20:13:01', 9),
('2023-05-24 20:23:01', 31),
('2023-05-24 20:58:25', 27),
('2023-05-24 21:22:01', 8),
('2023-05-24 22:08:01', 11),
('2023-05-24 22:36:24', 8);
-- --------------------------------------------------------

--
-- Table structure for table `Hofplayer`
--

CREATE TABLE IF NOT EXISTS `Hofplayer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `round_id` int(11) NOT NULL,
  `start` datetime NOT NULL,
  `end` datetime NOT NULL,
  `pid` int(11) NOT NULL,
  `sid` int(11) DEFAULT NULL,
  `charnm` varchar(16) NOT NULL,
  `chartag` varchar(40) DEFAULT NULL,
  `loc` int(11) DEFAULT NULL,
  `locsnm` varchar(5) NOT NULL,
  `locnm` varchar(40) NOT NULL,
  `glob_rank` int(11) DEFAULT NULL,
  `loc_rank` int(11) DEFAULT NULL,
  `market` double DEFAULT NULL,
  `cash` double DEFAULT NULL,
  `sk_class` varchar(16) DEFAULT NULL,
  `f_newb` int(11) DEFAULT NULL,
  `f_hodler` int(11) DEFAULT NULL,
  `f_whale` int(11) DEFAULT NULL,
  `f_shill` int(11) DEFAULT NULL,
  `f_youtuber` int(11) DEFAULT NULL,
  `f_redditor` int(11) DEFAULT NULL,
  `f_anon` int(11) DEFAULT NULL,
  `f_karen` int(11) DEFAULT NULL,
  `f_reporter` int(11) DEFAULT NULL,
  `f_politician` int(11) DEFAULT NULL,
  `it_by` varchar(16) DEFAULT NULL,
  `a51_by` varchar(16) DEFAULT NULL,
  `fud_by` varchar(16) DEFAULT NULL,
  `att_won` int(11) DEFAULT NULL,
  `att_lost` int(11) DEFAULT NULL,
  `whales_smashed` int(11) DEFAULT NULL,
  `shills_smashed` int(11) DEFAULT NULL,
  `def_count` int(11) DEFAULT NULL,
  `loot_stole` double DEFAULT NULL,
  `influencers_stole` int(11) DEFAULT NULL,
  `doubters_stole` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `Hofsquad`
--

CREATE TABLE IF NOT EXISTS `Hofsquad` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `round_id` int(11) NOT NULL,
  `start` datetime NOT NULL,
  `end` datetime NOT NULL,
  `sid` int(11) NOT NULL,
  `squadnm` varchar(16) NOT NULL,
  `founder` varchar(40) NOT NULL,
  `cofounder` varchar(40) DEFAULT NULL,
  `loc` int(11) DEFAULT NULL,
  `loc_rank` int(11) DEFAULT NULL,
  `value` double DEFAULT NULL,
  `hourly_pct` float DEFAULT NULL,
  `daily_pct` float DEFAULT NULL,
  `att_won` int(11) DEFAULT NULL,
  `att_lost` int(11) DEFAULT NULL,
  `whales_smashed` int(11) DEFAULT NULL,
  `shills_smashed` int(11) DEFAULT NULL,
  `def_count` int(11) DEFAULT NULL,
  `loot_stole` double DEFAULT NULL,
  `influencers_stole` int(11) DEFAULT NULL,
  `doubters_stole` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `Holding`
--

CREATE TABLE IF NOT EXISTS `Holding` (
  `cd` int(11) NOT NULL,
  `shortnm` varchar(8) DEFAULT NULL,
  `longnm` varchar(20) DEFAULT NULL,
  `init` int(11) DEFAULT NULL,
  `max` int(11) DEFAULT NULL,
  `cost` double DEFAULT NULL,
  PRIMARY KEY (`cd`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO Holding (`cd`, `shortnm`, `longnm`, `init`, `max`, `cost`) VALUES
(1, 'node', 'Staking Nodes', 50, 500, 50000),
(2, 'mfac', 'Mining Facilities', 25, 250, 100000),
(3, 'jets', 'Private Jets', 0, 40, 1000000);
-- --------------------------------------------------------

--
-- Table structure for table `Location`
--

CREATE TABLE IF NOT EXISTS `Location` (
  `id` int(11) NOT NULL,
  `shortnm` char(4) DEFAULT NULL,
  `longnm` varchar(20) DEFAULT NULL,
  `bonus_mult` double DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO Location (`id`, `shortnm`, `longnm`, `bonus_mult`) VALUES
(1, 'SF', 'San Francisco', 0),
(2, 'NY', 'New York', 0),
(3, 'MIA', 'Miami', 0),
(4, 'VBC', 'Vancouver', 0),
(5, 'LDN', 'London', 0),
(6, 'HK', 'Hong Kong', 0),
(7, 'AMS', 'Amsterdam', 0),
(8, 'ELSL', 'El Salvador', 0),
(9, 'MSK', 'Moscow', 0);
-- --------------------------------------------------------

--
-- Table structure for table `Messaging`
--

CREATE TABLE IF NOT EXISTS `Messaging` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `f_p1` varchar(20) NOT NULL,
  `t_p2` varchar(20) NOT NULL,
  `msg` varchar(255) NOT NULL,
  `timestamp` timestamp NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `Player`
--

CREATE TABLE IF NOT EXISTS `Player` (
  `login_id` int(11) NOT NULL,
  `pid` int(11) NOT NULL,
  `sid` int(11) DEFAULT NULL,
  `slot` int(11) DEFAULT NULL,
  `charnm` varchar(16) NOT NULL,
  `chartag` varchar(40) DEFAULT NULL,
  `loc` int(11) DEFAULT NULL,
  `glob_rank` int(11) DEFAULT NULL,
  `loc_rank` int(11) DEFAULT NULL,
  `turns` int(11) DEFAULT NULL,
  `turns_queue` int(11) DEFAULT NULL,
  `turns_faucet` int(11) DEFAULT NULL,
  `outs` int(11) DEFAULT NULL,
  `ins` int(11) DEFAULT NULL,
  `market` decimal(20,2) DEFAULT NULL,
  `cash` decimal(20,2) DEFAULT NULL,
  `bank` decimal(10,2) DEFAULT NULL,
  `sk_funding` int(11) DEFAULT NULL,
  `sk_strength` int(11) DEFAULT NULL,
  `sk_marketing` int(11) DEFAULT NULL,
  `sk_techanal` int(11) DEFAULT NULL,
  `sk_intuition` int(11) DEFAULT NULL,
  `sk_cunning` int(11) DEFAULT NULL,
  `sk_debate` int(11) DEFAULT NULL,
  `sk_re` int(11) DEFAULT NULL,
  `sk_class` varchar(16) DEFAULT NULL,
  `upg_insurance` int(11) DEFAULT NULL,
  `upg_accountant` int(11) DEFAULT NULL,
  `upg_degree` int(11) DEFAULT NULL,
  `upg_advert` int(11) DEFAULT NULL,
  `upg_lawyer` int(11) DEFAULT NULL,
  `upg_rally` int(11) DEFAULT NULL,
  `f_newb` int(11) DEFAULT NULL,
  `f_hodler` int(11) DEFAULT NULL,
  `f_whale` int(11) DEFAULT NULL,
  `f_shill` int(11) DEFAULT NULL,
  `f_youtuber` int(11) DEFAULT NULL,
  `f_redditor` int(11) DEFAULT NULL,
  `f_anon` int(11) DEFAULT NULL,
  `f_karen` int(11) DEFAULT NULL,
  `f_reporter` int(11) DEFAULT NULL,
  `f_politician` int(11) DEFAULT NULL,
  `it_fails` int(11) DEFAULT NULL,
  `it_by` varchar(16) DEFAULT NULL,
  `it_exp` int(11) DEFAULT NULL,
  `a51_fails` int(11) DEFAULT NULL,
  `a51_by` varchar(16) DEFAULT NULL,
  `a51_exp` int(11) DEFAULT NULL,
  `fud_fails` int(11) DEFAULT NULL,
  `fud_by` varchar(16) DEFAULT NULL,
  `fud_exp` int(11) DEFAULT NULL,
  `bog_by` varchar(16) DEFAULT NULL,
  `bog_exp` int(11) DEFAULT NULL,
  `att_won` int(11) DEFAULT NULL,
  `att_lost` int(11) DEFAULT NULL,
  `whales_smashed` int(11) DEFAULT NULL,
  `shills_smashed` int(11) DEFAULT NULL,
  `def_count` int(11) DEFAULT NULL,
  `loot_stole` double DEFAULT NULL,
  `influencers_stole` int(11) DEFAULT NULL,
  `doubters_stole` int(11) DEFAULT NULL,
  `shill_exp` int(11) DEFAULT NULL,
  `flight_exp` int(11) DEFAULT NULL,
  `donated` decimal(20,2) NOT NULL,
  `payouts` int(3) NOT NULL,
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `Player_Crypto`
--

CREATE TABLE IF NOT EXISTS `Player_Crypto` (
  `pid` int(11) DEFAULT NULL,
  `cd` int(11) DEFAULT NULL,
  `units` bigint(20) DEFAULT NULL,
  `basis` double DEFAULT NULL,
  UNIQUE KEY `pid` (`pid`,`cd`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `Round`
--

CREATE TABLE IF NOT EXISTS `Round` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `payouts`int(11) NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

INSERT INTO Round (`id`, `start_date`, `end_date`, `payouts`) VALUES
(1, '2023-05-24 10:00:00', '2023-05-30 19:00:00', 0),
(2, '2023-06-01 10:00:00', '2023-06-14 19:00:00', 0),
(3, '2023-06-15 10:00:00', '2023-06-30 19:00:00', 0);

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

--
-- Table structure for table `Session`
--

CREATE TABLE IF NOT EXISTS `Session` (
  `sess_hash` char(32) NOT NULL,
  `login_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`sess_hash`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `Squad`
--

CREATE TABLE IF NOT EXISTS `Squad` (
  `sid` int(11) NOT NULL AUTO_INCREMENT,
  `squadnm` varchar(16) DEFAULT NULL,
  `founder` int(11) DEFAULT NULL,
  `cofounder` int(11) DEFAULT NULL,
  `myfriends` varchar(400) DEFAULT NULL,
  `myenemies` varchar(400) DEFAULT NULL,
  `myignore` varchar(400) DEFAULT NULL,
  `note` varchar(200) NOT NULL,
  `bank` decimal(20,2) DEFAULT NULL,
  `recruiting` int(11) DEFAULT NULL,
  `att_won` int(11) DEFAULT NULL,
  `att_lost` int(11) DEFAULT NULL,
  `whales_smashed` int(11) DEFAULT NULL,
  `shills_smashed` int(11) DEFAULT NULL,
  `def_count` int(11) DEFAULT NULL,
  `loot_stole` double DEFAULT NULL,
  `influencers_stole` int(11) DEFAULT NULL,
  `doubters_stole` int(11) DEFAULT NULL,
  PRIMARY KEY (`sid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `Squadlog`
--

CREATE TABLE IF NOT EXISTS `Squadlog` (
  `sid` int(11) NOT NULL,
  `log` varchar(99) NOT NULL,
  `timestamp` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `Squad_Holding`
--

CREATE TABLE IF NOT EXISTS `Squad_Holding` (
  `sid` int(11) DEFAULT NULL,
  `cd` int(11) DEFAULT NULL,
  `loc` int(11) DEFAULT NULL,
  `amt` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `Squad_Invite`
--

CREATE TABLE IF NOT EXISTS `Squad_Invite` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sid` int(11) DEFAULT NULL,
  `pid` int(11) DEFAULT NULL,
  `itype` char(8) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sid` (`sid`,`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `Squad_Rank`
--

CREATE TABLE IF NOT EXISTS `Squad_Rank` (
  `sid` int(11) DEFAULT NULL,
  `loc` int(11) DEFAULT NULL,
  `loc_rank` int(11) DEFAULT NULL,
  `value` double DEFAULT NULL,
  `hourly_pct` float DEFAULT NULL,
  `daily_pct` float DEFAULT NULL,
  `hourly_ref` float DEFAULT NULL,
  `daily_ref` float DEFAULT NULL,
  UNIQUE KEY `sid_loc` (`sid`,`loc`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
COMMIT;

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

--
-- Table structure for table `Alliance`
--

CREATE TABLE IF NOT EXISTS `Alliance` (
  `aid` int(11) NOT NULL AUTO_INCREMENT,
  `aname` varchar(16) DEFAULT NULL,
  `founder` int(11) DEFAULT NULL,
  `note` VARCHAR(200) NOT NULL,
  PRIMARY KEY (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
COMMIT;

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

--
-- Table structure for table `Alliance_Invite`
--

CREATE TABLE IF NOT EXISTS `Alliance_Invite` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `aid` int(11) DEFAULT NULL,
  `sid` int(11) DEFAULT NULL,
  `itype` char(8) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
COMMIT;

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

--
-- Table structure for table `Alliance_Rank`
--

CREATE TABLE IF NOT EXISTS `Alliance_Rank` (
  `aid` int(11) DEFAULT NULL,
  `loc` int(11) DEFAULT NULL,
  `loc_rank` int(11) DEFAULT NULL,
  `value` double DEFAULT NULL,
  `hourly_pct` float DEFAULT NULL,
  `daily_pct` float DEFAULT NULL,
  `hourly_ref` float DEFAULT NULL,
  `daily_ref` float DEFAULT NULL,
  UNIQUE KEY `aid_loc` (`aid`,`loc`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
COMMIT;

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

--
-- Table structure for table `Boosts`
--

CREATE TABLE IF NOT EXISTS `Boosts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` int(11) NOT NULL,
  `package` int(11) NOT NULL,
  `timestamp` datetime NOT NULL,
  `notes` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
COMMIT;


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

--
-- Table structure for table `Plus`
--

CREATE TABLE IF NOT EXISTS `Plus` (
  `active` tinyint(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;


INSERT INTO `Plus` (`active`) VALUES
(0);
COMMIT;

