--
-- Host: localhost    Database: CWZ_dev
-- ------------------------------------------------------


--
-- Table structure for table `Account`
--

CREATE TABLE `Account` (
  `id` int NOT NULL AUTO_INCREMENT,
  `login` varchar(32) NOT NULL,
  `passwd` char(40) NOT NULL,
  `email` varchar(128) DEFAULT NULL,
  `joined` datetime DEFAULT NULL,
  `lastlog` datetime DEFAULT NULL,
  `tier` int DEFAULT NULL,
  `slots` int DEFAULT NULL,
  `codes` int DEFAULT NULL,
  `flags` varchar(400) DEFAULT NULL,
  `sess` varchar(400) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Account`
--

INSERT INTO `Account` VALUES (1,'cwzwhodi','54a270f9f25c325cbfdd52cdec9aeb89fcc0a945','aabad777@gmail.com','2022-02-19 00:49:19','2022-02-19 00:49:19',100,25,10,NULL,NULL),(2,'vader','34bcdf98deb05825ee8f40bad4b5912df89b0b95','darkvader0@live.com','2022-02-19 00:54:34','2022-02-19 00:54:34',100,25,10,NULL,'chat_lastmsg:1,squadnm:Saturnine,pid:201,pg:market.cgi,login_id:2,slots:25,created:2022-06-30 21,chat_chan:1,aid:0,con_lastmsg:513,charnm:Chill01,sid:1,slot:1'),(6,'blu','fed8e0354adeaf7975ced5ca0c229e8222eaa95b','blu','2022-03-10 04:59:34','2022-03-10 04:59:34',1,1,0,NULL,NULL),(7,'fat','f684bcac2f0d38e3fcce2ae3309f7ff1eabcbfbe','aabad777@gmail.com','2022-03-10 14:45:41','2022-03-10 14:45:41',1,1,0,NULL,NULL),(8,'mcoons','2ef0ce7930e5588c5cdd5bce45882ba5c446763c','mc','2022-03-30 22:17:14','2022-03-30 22:17:14',1,1,0,NULL,NULL);

--
-- Table structure for table `Chat`
--

CREATE TABLE `Chat` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ts` datetime DEFAULT NULL,
  `chan` int DEFAULT NULL,
  `aid` int DEFAULT NULL,
  `sid` int DEFAULT NULL,
  `pid` int DEFAULT NULL,
  `msg` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Chat`
--

INSERT INTO `Chat` VALUES (1,'2022-05-24 22:15:29',1,NULL,NULL,NULL,'Test Message');

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

CREATE TABLE `Console` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ts` datetime DEFAULT NULL,
  `chan` int DEFAULT NULL,
  `aid` int DEFAULT NULL,
  `sid` int DEFAULT NULL,
  `pid` int DEFAULT NULL,
  `msg` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=582 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Console`
--

INSERT INTO `Console` VALUES (1,'2022-06-30 17:20:38',0,0,0,0,'Test Message'),(479,'2022-06-30 21:50:50',4,0,0,207,'You\'ve increased your Funding by 34! Your Investors collect $235,000.00 in cash!   '),(480,'2022-06-30 22:13:17',4,0,0,207,'You\'ve increased your Funding by 28! Your Investors collect $235,000.00 in cash!   '),(481,'2022-06-30 21:50:51',4,0,0,207,'You\'ve increased your Funding by 28! Your Investors collect $235,000.00 in cash!   '),(482,'2022-06-30 21:50:52',4,0,0,207,'You\'ve increased your Funding by 12! Your Investors collect $235,000.00 in cash!   '),(483,'2022-06-30 21:50:52',4,0,0,207,'You\'ve increased your Funding by 20! Your Investors collect $235,000.00 in cash!   '),(484,'2022-06-30 21:50:52',4,0,0,207,'You\'ve increased your Funding by 28! Your Investors collect $235,000.00 in cash!   '),(485,'2022-06-30 21:50:52',4,0,0,207,'You\'ve increased your Funding by 27! Your Investors collect $235,000.00 in cash!   '),(486,'2022-06-30 21:50:52',4,0,0,207,'You\'ve increased your Funding by 18! Your Investors collect $235,000.00 in cash!   '),(487,'2022-06-30 21:50:55',4,0,0,206,'You\'ve increased your Funding by 18! Your Investors collect $235,000.00 in cash!   '),(488,'2022-06-30 21:50:56',4,0,0,206,'You\'ve increased your Funding by 15! Your Investors collect $235,000.00 in cash!   '),(489,'2022-06-30 21:50:56',4,0,0,206,'You\'ve increased your Funding by 23! Your Investors collect $235,000.00 in cash!   '),(490,'2022-06-30 21:50:56',4,0,0,206,'You\'ve increased your Funding by 20! Your Investors collect $235,000.00 in cash!   '),(491,'2022-06-30 21:51:01',4,0,0,205,'You\'ve increased your Funding by 10! Your Investors collect $235,000.00 in cash!   '),(492,'2022-06-30 21:51:02',4,0,0,205,'You\'ve increased your Funding by 15! Your Investors collect $235,000.00 in cash!   '),(493,'2022-06-30 21:51:02',4,0,0,205,'You\'ve increased your Funding by 23! Your Investors collect $235,000.00 in cash!   '),(494,'2022-06-30 21:51:02',4,0,0,205,'You\'ve increased your Funding by 24! Your Investors collect $235,000.00 in cash!   '),(495,'2022-06-30 21:51:05',4,0,0,208,'You\'ve increased your Funding by 24! Your Investors collect $235,000.00 in cash!   '),(496,'2022-06-30 21:51:05',4,0,0,208,'You\'ve increased your Funding by 21! Your Investors collect $235,000.00 in cash!   '),(497,'2022-06-30 21:51:08',4,0,0,209,'You\'ve increased your Funding by 34! Your Investors collect $235,000.00 in cash!   '),(498,'2022-06-30 21:51:08',4,0,0,209,'You\'ve increased your Funding by 20! Your Investors collect $235,000.00 in cash!   '),(499,'2022-07-01 07:59:59',4,0,0,202,'You\'ve increased your Funding by 22! Your Investors collect $235,000.00 in cash!   '),(500,'2022-07-01 07:59:59',4,0,0,202,'You\'ve increased your Funding by 35! Your Investors collect $235,000.00 in cash!   '),(501,'2022-07-01 08:00:02',4,0,0,203,'You\'ve increased your Funding by 11! Your Investors collect $235,000.00 in cash!   '),(502,'2022-07-01 08:00:02',4,0,0,203,'You\'ve increased your Funding by 27! Your Investors collect $235,000.00 in cash!   '),(503,'2022-07-01 08:00:02',4,0,0,203,'You\'ve increased your Funding by 34! Your Investors collect $235,000.00 in cash!   '),(504,'2022-07-01 08:00:05',4,0,0,204,'You\'ve increased your Funding by 19! Your Investors collect $235,000.00 in cash!   '),(505,'2022-07-01 08:00:05',4,0,0,204,'You\'ve increased your Funding by 21! Your Investors collect $235,000.00 in cash!   '),(506,'2022-07-01 08:00:05',4,0,0,204,'You\'ve increased your Funding by 28! Your Investors collect $235,000.00 in cash!   '),(507,'2022-07-01 08:00:06',4,0,0,204,'You\'ve increased your Funding by 31! Your Investors collect $235,000.00 in cash!   '),(508,'2022-07-01 08:00:08',4,0,0,205,'You\'ve increased your Funding by 20! Your Investors collect $235,000.00 in cash!   '),(509,'2022-07-01 08:00:08',4,0,0,205,'You\'ve increased your Funding by 19! Your Investors collect $235,000.00 in cash!   '),(510,'2022-07-01 08:00:09',4,0,0,205,'You\'ve increased your Funding by 23! Your Investors collect $235,000.00 in cash!   '),(511,'2022-07-01 08:00:09',4,0,0,205,'You\'ve increased your Funding by 13! Your Investors collect $235,000.00 in cash!   '),(512,'2022-07-01 08:00:09',4,0,0,205,'You\'ve increased your Funding by 14! Your Investors collect $235,000.00 in cash!   '),(513,'2022-07-01 08:00:17',4,0,0,201,'You\'ve increased your Funding by 29! Your Investors collect $235,000.00 in cash!   '),(514,'2022-07-01 14:10:40',4,0,0,210,'You\'ve increased your Strength by 33! Your Investors collect $235,000.00 in cash!   '),(515,'2022-07-01 14:10:40',4,0,0,210,'You\'ve increased your Strength by 35! Your Investors collect $235,000.00 in cash!   '),(516,'2022-07-01 14:10:41',4,0,0,210,'You\'ve increased your Strength by 30! Your Investors collect $235,000.00 in cash!   '),(517,'2022-07-01 14:10:41',4,0,0,210,'You\'ve increased your Strength by 20! Your Investors collect $235,000.00 in cash!   '),(518,'2022-07-01 14:10:41',4,0,0,210,'You\'ve increased your Strength by 29! Your Investors collect $235,000.00 in cash!   '),(519,'2022-07-01 14:10:41',4,0,0,210,'You\'ve increased your Strength by 15! Your Investors collect $235,000.00 in cash!   '),(520,'2022-07-01 14:10:44',4,0,0,209,'You\'ve increased your Strength by 21! Your Investors collect $235,000.00 in cash!   '),(521,'2022-07-01 14:33:14',4,0,0,211,'You\'ve increased your Strength by 33! Your Investors collect $235,000.00 in cash!   '),(522,'2022-07-01 14:10:47',4,0,0,211,'You\'ve increased your Strength by 24! Your Investors collect $235,000.00 in cash!   '),(523,'2022-07-01 14:10:47',4,0,0,211,'You\'ve increased your Strength by 18! Your Investors collect $235,000.00 in cash!   '),(524,'2022-07-01 14:10:50',4,0,0,212,'You\'ve increased your Strength by 16! Your Investors collect $235,000.00 in cash!   '),(525,'2022-07-01 14:10:51',4,0,0,212,'You\'ve increased your Strength by 16! Your Investors collect $235,000.00 in cash!   '),(526,'2022-07-01 14:10:52',4,0,0,212,'You\'ve increased your Strength by 31! Your Investors collect $235,000.00 in cash!   '),(527,'2022-07-01 14:10:57',4,0,0,213,'You\'ve increased your Strength by 33! Your Investors collect $235,000.00 in cash!   '),(528,'2022-07-01 14:33:24',4,0,0,213,'You\'ve increased your Strength by 29! Your Investors collect $235,000.00 in cash!   '),(529,'2022-07-01 14:10:57',4,0,0,213,'You\'ve increased your Strength by 25! Your Investors collect $235,000.00 in cash!   '),(530,'2022-07-01 14:11:00',4,0,0,214,'You\'ve increased your Strength by 27! Your Investors collect $235,000.00 in cash!   '),(531,'2022-07-01 14:11:01',4,0,0,214,'You\'ve increased your Strength by 16! Your Investors collect $235,000.00 in cash!   '),(532,'2022-07-01 14:11:01',4,0,0,214,'You\'ve increased your Strength by 27! Your Investors collect $235,000.00 in cash!   '),(533,'2022-07-01 14:11:01',4,0,0,214,'You\'ve increased your Strength by 24! Your Investors collect $235,000.00 in cash!   '),(534,'2022-07-01 14:11:08',4,0,0,215,'You\'ve increased your Strength by 22! Your Investors collect $235,000.00 in cash!   '),(535,'2022-07-01 14:11:08',4,0,0,215,'You\'ve increased your Strength by 31! Your Investors collect $235,000.00 in cash!   '),(536,'2022-07-01 14:11:08',4,0,0,215,'You\'ve increased your Strength by 35! Your Investors collect $235,000.00 in cash!   '),(537,'2022-07-01 14:11:15',4,0,0,216,'You\'ve increased your Strength by 20! Your Investors collect $235,000.00 in cash!   '),(538,'2022-07-01 14:11:21',4,0,0,217,'You\'ve increased your Strength by 28! Your Investors collect $235,000.00 in cash!   '),(539,'2022-07-01 14:11:21',4,0,0,217,'You\'ve increased your Strength by 11! Your Investors collect $235,000.00 in cash!   '),(540,'2022-07-01 14:11:21',4,0,0,217,'You\'ve increased your Strength by 17! Your Investors collect $235,000.00 in cash!   '),(541,'2022-07-01 14:11:25',4,0,0,218,'You\'ve increased your Strength by 25! Your Investors collect $235,000.00 in cash!   '),(542,'2022-07-01 14:11:25',4,0,0,218,'You\'ve increased your Strength by 30! Your Investors collect $235,000.00 in cash!   '),(543,'2022-07-01 14:12:27',4,0,0,220,'You\'ve increased your Strength by 27! Your Investors collect $235,000.00 in cash!   '),(544,'2022-07-01 14:34:54',4,0,0,220,'You\'ve increased your Strength by 34! Your Investors collect $235,000.00 in cash!   '),(545,'2022-07-01 14:12:27',4,0,0,220,'You\'ve increased your Strength by 11! Your Investors collect $235,000.00 in cash!   '),(546,'2022-07-01 14:12:30',4,0,0,221,'You\'ve increased your Strength by 27! Your Investors collect $235,000.00 in cash!   '),(547,'2022-07-01 14:12:31',4,0,0,221,'You\'ve increased your Strength by 24! Your Investors collect $235,000.00 in cash!   '),(548,'2022-07-01 14:12:31',4,0,0,221,'You\'ve increased your Strength by 24! Your Investors collect $235,000.00 in cash!   '),(549,'2022-07-01 14:12:37',4,0,0,221,'You\'ve increased your Strength by 11! Your Investors collect $235,000.00 in cash!   '),(550,'2022-07-01 14:12:37',4,0,0,221,'You\'ve increased your Strength by 14! Your Investors collect $235,000.00 in cash!   '),(551,'2022-07-01 14:12:37',4,0,0,221,'You\'ve increased your Strength by 25! Your Investors collect $235,000.00 in cash!   '),(552,'2022-07-01 14:35:04',4,0,0,221,'You\'ve increased your Strength by 13! Your Investors collect $235,000.00 in cash!   '),(553,'2022-07-01 14:12:37',4,0,0,221,'You\'ve increased your Strength by 24! Your Investors collect $235,000.00 in cash!   '),(554,'2022-07-01 14:12:37',4,0,0,221,'You\'ve increased your Strength by 20! Your Investors collect $235,000.00 in cash!   '),(555,'2022-07-01 14:12:37',4,0,0,221,'You\'ve increased your Strength by 11! Your Investors collect $235,000.00 in cash!   '),(556,'2022-07-01 14:12:38',4,0,0,221,'You\'ve increased your Strength by 19! Your Investors collect $235,000.00 in cash!   '),(557,'2022-07-01 14:12:38',4,0,0,221,'You\'ve increased your Strength by 25! Your Investors collect $235,000.00 in cash!   '),(558,'2022-07-01 14:12:38',4,0,0,221,'You\'ve increased your Strength by 30! Your Investors collect $235,000.00 in cash!   '),(559,'2022-07-01 14:12:38',4,0,0,221,'You\'ve increased your Strength by 12! Your Investors collect $235,000.00 in cash!   '),(560,'2022-07-01 14:12:38',4,0,0,221,'You\'ve increased your Strength by 12! Your Investors collect $235,000.00 in cash!   '),(561,'2022-07-01 14:12:38',4,0,0,221,'You\'ve increased your Strength by 22! Your Investors collect $235,000.00 in cash!   '),(562,'2022-07-01 14:12:41',4,0,0,222,'You\'ve increased your Strength by 33! Your Investors collect $235,000.00 in cash!   '),(563,'2022-07-01 14:12:42',4,0,0,222,'You\'ve increased your Strength by 18! Your Investors collect $235,000.00 in cash!   '),(564,'2022-07-01 14:12:42',4,0,0,222,'You\'ve increased your Strength by 19! Your Investors collect $235,000.00 in cash!   '),(565,'2022-07-01 14:12:42',4,0,0,222,'You\'ve increased your Strength by 33! Your Investors collect $235,000.00 in cash!   '),(566,'2022-07-01 14:12:42',4,0,0,222,'You\'ve increased your Strength by 28! Your Investors collect $235,000.00 in cash!   '),(567,'2022-07-01 14:12:42',4,0,0,222,'You\'ve increased your Strength by 32! Your Investors collect $235,000.00 in cash!   '),(568,'2022-07-01 14:12:42',4,0,0,222,'You\'ve increased your Strength by 29! Your Investors collect $235,000.00 in cash!   '),(569,'2022-07-01 14:12:42',4,0,0,222,'You\'ve increased your Strength by 27! Your Investors collect $235,000.00 in cash!   '),(570,'2022-07-01 14:12:43',4,0,0,222,'You\'ve increased your Strength by 27! Your Investors collect $235,000.00 in cash!   '),(571,'2022-07-01 14:12:45',4,0,0,223,'You\'ve increased your Strength by 15! Your Investors collect $235,000.00 in cash!   '),(572,'2022-07-01 14:12:45',4,0,0,223,'You\'ve increased your Strength by 11! Your Investors collect $235,000.00 in cash!   '),(573,'2022-07-01 14:12:45',4,0,0,223,'You\'ve increased your Strength by 11! Your Investors collect $235,000.00 in cash!   '),(574,'2022-07-01 14:12:46',4,0,0,223,'You\'ve increased your Strength by 14! Your Investors collect $235,000.00 in cash!   '),(575,'2022-07-01 14:12:46',4,0,0,223,'You\'ve increased your Strength by 17! Your Investors collect $235,000.00 in cash!   '),(576,'2022-07-01 14:12:46',4,0,0,223,'You\'ve increased your Strength by 14! Your Investors collect $235,000.00 in cash!   '),(577,'2022-07-01 14:12:46',4,0,0,223,'You\'ve increased your Strength by 33! Your Investors collect $235,000.00 in cash!   '),(578,'2022-07-01 14:12:46',4,0,0,223,'You\'ve increased your Strength by 16! Your Investors collect $235,000.00 in cash!   '),(579,'2022-07-01 14:12:46',4,0,0,223,'You\'ve increased your Strength by 11! Your Investors collect $235,000.00 in cash!   '),(580,'2022-07-01 15:10:18',4,0,0,219,'You\'ve increased your Strength by 31! Your Investors collect $235,000.00 in cash!   '),(581,'2022-07-01 15:32:45',4,0,0,219,'You\'ve increased your Strength by 32! Your Investors collect $235,000.00 in cash!   ');

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

CREATE TABLE `Crypto_Game` (
  `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_Game`
--

INSERT INTO `Crypto_Game` VALUES (0,'BTCW','Bitcoin Warz',333333,332222,20000,69420,0.015,0.01,0),(1,'FETH','Fethereum',2109,2118,1337,8008,0.015,0.01,0),(2,'TNT','Trinance',73.05,73.25,68.2,420.65,0.015,0.01,0),(3,'USDB','Bether',1,1,1,1,0.015,0.01,0),(4,'LKC','Likecoin',73.05,73.25,68.2,420.65,0.015,0.01,0),(5,'AST','Astral',0.1105,0.1107,0.1007,0.6942,0.015,0.01,0),(6,'GINK','Gamelink',12.37,12.35,8.45,42.05,0.015,0.01,0),(7,'LOGE','Logecoin',0.0715,0.0713,0.042,0.2325,0.015,0.01,0),(8,'XWP','Wave',0.2055,0.2071,0.1785,1.25,0.015,0.01,0),(9,'LOL','Bitconnnnect',0,0,0,0,0,0,0);

--
-- Table structure for table `Crypto_Hist`
--

CREATE TABLE `Crypto_Hist` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ts` datetime DEFAULT NULL,
  `cd` int DEFAULT NULL,
  `price_then` double DEFAULT NULL,
  `units` bigint DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Crypto_Hist`
--


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

CREATE TABLE `Crypto_Live` (
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Crypto_Live`
--

INSERT INTO `Crypto_Live` VALUES (10,'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(2048) DEFAULT NULL,
  `wgt` int DEFAULT NULL,
  `efx` varchar(256) 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 `Crypto_Reel`
--

CREATE TABLE `Crypto_Reel` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ts` datetime DEFAULT NULL,
  `news_id` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Crypto_Reel`
--


--
-- 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,
  `slot` 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,
  `market` double DEFAULT NULL,
  `cash` double DEFAULT NULL,
  `bank` 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`
--

INSERT INTO `Player` VALUES (2,201,1,1,'Chill01',NULL,1,0,0,4900,0,0,0,0,0,235000,0,48,23,2,5,18,14,17,2,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-3600,0,'',-3600,0,'',-3600,0,0,0,0,0,0,0,0,0,0),(2,202,1,2,'Chill02',NULL,1,0,0,4800,0,0,0,0,0,470000,0,105,25,12,12,4,2,20,12,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-7200,0,'',-7200,0,'',-7200,0,0,0,0,0,0,0,0,0,0),(2,203,1,3,'Chill03',NULL,1,0,0,4700,0,0,0,0,0,705000,0,75,23,2,4,15,0,17,3,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-10800,0,'',-10800,0,'',-10800,0,0,0,0,0,0,0,0,0,0),(2,204,1,4,'Chill04',NULL,1,0,0,4600,0,0,0,0,0,940000,0,111,39,4,11,4,5,16,4,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-14400,0,'',-14400,0,'',-14400,0,0,0,0,0,0,0,0,0,0),(2,205,1,5,'Chill05',NULL,1,0,0,4100,0,0,0,0,0,2115000,0,191,21,6,3,16,14,3,10,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-32400,0,'',-32400,0,'',-32400,0,0,0,0,0,0,0,0,0,0),(2,206,1,6,'Chill06',NULL,1,0,0,4600,0,0,0,0,0,940000,0,82,5,3,11,4,6,19,16,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-14400,0,'',-14400,0,'',-14400,0,0,0,0,0,0,0,0,0,0),(2,207,1,7,'Chill07',NULL,1,0,0,4200,0,0,0,0,0,1880000,0,209,46,15,19,11,16,10,1,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-28800,0,'',-28800,0,'',-28800,0,0,0,0,0,0,0,0,0,0),(2,208,1,8,'Chill08',NULL,1,0,0,4800,0,0,0,0,0,470000,0,85,43,17,11,8,5,2,13,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-7200,0,'',-7200,0,'',-7200,0,0,0,0,0,0,0,0,0,0),(2,209,1,9,'Chill09',NULL,1,0,0,4700,0,0,0,0,0,705000,0,102,67,13,10,13,14,13,20,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-10800,0,'',-10800,0,'',-10800,0,0,0,0,0,0,0,0,0,0),(2,210,1,10,'Chill10',NULL,1,0,0,4400,0,0,0,0,0,1410000,0,3,178,8,3,9,15,10,5,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-21600,0,'',-21600,0,'',-21600,0,0,0,0,0,0,0,0,0,0),(2,211,NULL,11,'Chill11',NULL,1,0,0,4700,0,0,0,0,0,705000,0,38,78,20,16,0,14,7,16,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-10800,0,'',-10800,0,'',-10800,0,0,0,0,0,0,0,0,0,0),(2,212,NULL,12,'Chill12',NULL,1,0,0,4700,0,0,0,0,0,705000,0,40,97,20,17,8,7,10,9,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-10800,0,'',-10800,0,'',-10800,0,0,0,0,0,0,0,0,0,0),(2,213,NULL,13,'Chill13',NULL,1,0,0,4700,0,0,0,0,0,705000,0,45,89,10,10,17,14,2,8,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-10800,0,'',-10800,0,'',-10800,0,0,0,0,0,0,0,0,0,0),(2,214,NULL,14,'Chill14',NULL,1,0,0,4600,0,0,0,0,0,940000,0,30,135,6,3,14,4,17,12,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-14400,0,'',-14400,0,'',-14400,0,0,0,0,0,0,0,0,0,0),(2,215,NULL,15,'Chill15',NULL,1,0,0,4700,0,0,0,0,0,705000,0,22,110,17,18,19,3,18,1,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-10800,0,'',-10800,0,'',-10800,0,0,0,0,0,0,0,0,0,0),(2,216,NULL,16,'Chill16',NULL,1,0,0,4900,0,0,0,0,0,235000,0,24,36,2,13,17,5,14,16,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-3600,0,'',-3600,0,'',-3600,0,0,0,0,0,0,0,0,0,0),(2,217,NULL,17,'Chill17',NULL,1,0,0,4700,0,0,0,0,0,705000,0,46,63,20,11,13,13,8,19,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-10800,0,'',-10800,0,'',-10800,0,0,0,0,0,0,0,0,0,0),(2,218,NULL,18,'Chill18',NULL,1,0,0,4800,0,0,0,0,0,470000,0,26,93,5,18,17,9,15,10,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-7200,0,'',-7200,0,'',-7200,0,0,0,0,0,0,0,0,0,0),(2,219,NULL,19,'Chill19',NULL,1,0,0,4800,0,0,0,0,0,470000,0,9,81,7,11,14,17,2,0,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-7200,0,'',-7200,0,'',-7200,0,0,0,0,0,0,0,0,0,0),(2,220,NULL,20,'Chill20',NULL,1,0,0,4700,0,0,0,0,0,705000,0,37,105,2,10,6,19,15,19,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-10800,0,'',-10800,0,'',-10800,0,0,0,0,0,0,0,0,0,0),(2,221,NULL,21,'Chill21',NULL,1,0,0,3400,0,0,0,0,0,3760000,0,24,341,8,5,1,11,11,1,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-57600,0,'',-57600,0,'',-57600,0,0,0,0,0,0,0,0,0,0),(2,222,NULL,22,'Chill22',NULL,1,0,0,4100,0,0,0,0,0,2115000,0,29,284,2,2,7,8,18,5,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-32400,0,'',-32400,0,'',-32400,0,0,0,0,0,0,0,0,0,0),(2,223,NULL,23,'Chill23',NULL,1,0,0,4100,0,0,0,0,0,2115000,0,30,156,12,3,0,11,14,17,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-32400,0,'',-32400,0,'',-32400,0,0,0,0,0,0,0,0,0,0),(2,224,NULL,24,'Chill24',NULL,1,0,0,5000,0,0,0,0,0,0,0,3,40,17,17,13,16,19,9,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',0,0,'',0,0,'',0,0,0,0,0,0,0,0,0,0,0),(2,225,NULL,25,'Chill25',NULL,1,0,0,5000,0,0,0,0,0,0,0,17,20,18,9,9,18,1,14,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',0,0,'',0,0,'',0,0,0,0,0,0,0,0,0,0,0);

--
-- 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`
--

INSERT INTO `Player_Crypto` VALUES (201,0,111,36999963),(201,10,222,46999963),(201,1,222,568198);

--
-- 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`
--

INSERT INTO `Session` VALUES ('375CF278FDBB280A53BA21421B077FD4',2),('4A5AE51080F02F11412292D847C9BDFA',2),('556D4E6CA2D6788B625386F96463F396',6),('6F2A261A9AB92233C5BABACCE8DD1E91',2),('DCC76752AF84E32FA39457C98500E446',2),('FD187FC3D680A43B6AB307C7E48256CB',2);

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

CREATE TABLE `Squad` (
  `sid` int NOT NULL AUTO_INCREMENT,
  `squadnm` 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 AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `Squad` VALUES (1,'Saturnine',NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,0,0,0,0,0),(2,'Tthugs',NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,0,0,0,0,0);

--
-- 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`
--



