--
-- Host: localhost    Database: CWZ
-- ------------------------------------------------------


--
-- Table structure for table `Crypto`
--

CREATE TABLE `Crypto` (
  `cd` int 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_now` double DEFAULT NULL,
  `delta_base` double DEFAULT NULL,
  `unit_vol` bigint DEFAULT NULL,
  PRIMARY KEY (`cd`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Crypto`
--

INSERT INTO `Crypto` VALUES (1,'BTC','Bitcoin',333333,332222,30000,60000,0.015,0.01,0);

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

CREATE TABLE `Crypto_News` (
  `id` int NOT NULL AUTO_INCREMENT,
  `news` varchar(1200) DEFAULT NULL,
  `hits` int DEFAULT NULL,
  `lasthit` datetime DEFAULT NULL,
  `freqlim` time DEFAULT NULL,
  `efx` varchar(400) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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


--
-- Table structure for table `CurrentRound`
--

CREATE TABLE `CurrentRound` (
  `hkey` varchar(32) DEFAULT NULL,
  `hval` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `CurrentRound`
--


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

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

--
-- Dumping data for table `Holding`
--

INSERT INTO `Holding` VALUES (1,'node','Staking Nodes',50,500,5000000),(2,'mfac','Mining Facilities',25,250,10000000),(3,'jets','Private Jets',0,40,100000000);

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

CREATE TABLE `Location` (
  `id` int NOT NULL,
  `shortnm` char(4) DEFAULT NULL,
  `longnm` varchar(20) DEFAULT NULL,
  `bonus_mult` double DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Location`
--

INSERT INTO `Location` 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 `Player`
--

CREATE TABLE `Player` (
  `login_id` int NOT NULL,
  `pid` int NOT NULL,
  `sid` int DEFAULT NULL,
  `charnm` varchar(16) NOT NULL,
  `chartag` varchar(40) DEFAULT NULL,
  `loc` int DEFAULT NULL,
  `glob_rank` int DEFAULT NULL,
  `loc_rank` int DEFAULT NULL,
  `turns` int DEFAULT NULL,
  `turns_queue` int DEFAULT NULL,
  `turns_faucet` int DEFAULT NULL,
  `outs` int DEFAULT NULL,
  `ins` int DEFAULT NULL,
  `calc_market` double DEFAULT NULL,
  `cash` double DEFAULT NULL,
  `bank` double DEFAULT NULL,
  `calc_val` double DEFAULT NULL,
  `sk_funding` int DEFAULT NULL,
  `sk_strength` int DEFAULT NULL,
  `sk_marketing` int DEFAULT NULL,
  `sk_techanal` int DEFAULT NULL,
  `sk_intuition` int DEFAULT NULL,
  `sk_cunning` int DEFAULT NULL,
  `sk_debate` int DEFAULT NULL,
  `sk_re` int DEFAULT NULL,
  `upg_insurance` int DEFAULT NULL,
  `upg_accountant` int DEFAULT NULL,
  `upg_degree` int DEFAULT NULL,
  `upg_advert` int DEFAULT NULL,
  `upg_lawyer` int DEFAULT NULL,
  `upg_rally` int DEFAULT NULL,
  `f_newb` int DEFAULT NULL,
  `f_hodler` int DEFAULT NULL,
  `f_whale` int DEFAULT NULL,
  `f_shill` int DEFAULT NULL,
  `f_youtuber` int DEFAULT NULL,
  `f_redditor` int DEFAULT NULL,
  `f_anon` int DEFAULT NULL,
  `f_karen` int DEFAULT NULL,
  `f_reporter` int DEFAULT NULL,
  `f_politician` int DEFAULT NULL,
  `it_fails` int DEFAULT NULL,
  `it_by` varchar(16) DEFAULT NULL,
  `it_exp` int DEFAULT NULL,
  `51_fails` int DEFAULT NULL,
  `51_by` varchar(16) DEFAULT NULL,
  `51_exp` int DEFAULT NULL,
  `fud_fails` int DEFAULT NULL,
  `fud_by` varchar(16) DEFAULT NULL,
  `fud_exp` int DEFAULT NULL,
  `att_won` int DEFAULT NULL,
  `att_lost` int DEFAULT NULL,
  `investors_killed` int DEFAULT NULL,
  `shills_killed` int DEFAULT NULL,
  `def_kills` int DEFAULT NULL,
  `loot_stole` double DEFAULT NULL,
  `influencers_stole` int DEFAULT NULL,
  `doubters_stole` int DEFAULT NULL,
  `flight_exp` int DEFAULT NULL,
  `casopt` int DEFAULT NULL,
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Player`
--


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

CREATE TABLE `Player_Crypto` (
  `pid` int DEFAULT NULL,
  `cd` int DEFAULT NULL,
  `units` bigint DEFAULT NULL,
  `basis` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Player_Crypto`
--


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

CREATE TABLE `Session` (
  `sess_hash` char(32) NOT NULL,
  `login_id` int DEFAULT NULL,
  PRIMARY KEY (`sess_hash`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Session`
--


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

CREATE TABLE `Squad` (
  `sid` int NOT NULL AUTO_INCREMENT,
  `gangnm` varchar(16) DEFAULT NULL,
  `youtube` varchar(20) DEFAULT NULL,
  `godfather` varchar(16) DEFAULT NULL,
  `underboss` varchar(16) DEFAULT NULL,
  `myfriends` varchar(400) DEFAULT NULL,
  `myenemies` varchar(400) DEFAULT NULL,
  `myignore` varchar(400) DEFAULT NULL,
  `bank` double DEFAULT NULL,
  `att_won` int DEFAULT NULL,
  `att_lost` int DEFAULT NULL,
  `investors_killed` int DEFAULT NULL,
  `shills_killed` int DEFAULT NULL,
  `def_kills` int DEFAULT NULL,
  `loot_stole` double DEFAULT NULL,
  `influencers_stole` int DEFAULT NULL,
  `doubters_stole` int DEFAULT NULL,
  PRIMARY KEY (`sid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Squad`
--


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

CREATE TABLE `Squad_Holding` (
  `sid` int DEFAULT NULL,
  `cd` int DEFAULT NULL,
  `loc` int DEFAULT NULL,
  `amt` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Squad_Holding`
--


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

CREATE TABLE `Squad_Rank` (
  `sid` int DEFAULT NULL,
  `loc` int DEFAULT NULL,
  `val` double DEFAULT NULL,
  `hourly_pct` double DEFAULT NULL,
  `daily_pct` double DEFAULT NULL,
  `hourly_ref` double DEFAULT NULL,
  `daily_ref` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Squad_Rank`
--



