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

START TRANSACTION;



--
-- Database: `higgycoin`
--

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

--
-- Table structure for table `assignments`
--

CREATE TABLE `assignments` (
  `id` int(11) NOT NULL,
  `assignmentName` varchar(200) NOT NULL,
  `teacherUploadName` varchar(200) NOT NULL,
  `assignmentAnswer` varchar(200) DEFAULT NULL,
  `studentCompletionName` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `assignments`
--

INSERT INTO `assignments` (`id`, `assignmentName`, `teacherUploadName`, `assignmentAnswer`, `studentCompletionName`) VALUES
(1, 'Do you want to participate?', 'Coach Higgy', NULL, NULL),
(2, '', '', 'answered', 'David Tarver'),
(3, '', '', 'answered', 'David Tarver'),
(4, '', '', 'answered', 'David Tarver');

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

--
-- Table structure for table `higgycoin`
--

CREATE TABLE `higgycoin` (
  `id` int(11) NOT NULL,
  `tokensupply` int(11) NOT NULL,
  `tokensawarded` int(11) NOT NULL,
  `tokenname` varchar(25) NOT NULL,
  `holderamount` int(11) NOT NULL,
  `price` varchar(200) NOT NULL,
  `liquidity` int(11) NOT NULL,
  `liquidityprice` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `higgycoin`
--

INSERT INTO `higgycoin` (`id`, `tokensupply`, `tokensawarded`, `tokenname`, `holderamount`, `price`, `liquidity`, `liquidityprice`) VALUES
(1, 2500, 0, 'HiggyCoin', 0, '0.004', 20000, 10);

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

--
-- Table structure for table `login`
--

CREATE TABLE `login` (
  `id` int(11) NOT NULL,
  `fullName` varchar(200) NOT NULL,
  `password` varchar(200) NOT NULL,
  `tokenAmount` int(200) DEFAULT NULL,
  `teacher` varchar(8) DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `login`
--

INSERT INTO `login` (`id`, `fullName`, `password`, `tokenAmount`, `teacher`, `timestamp`) VALUES
(1, 'David Tarver', 'password', 2499, NULL, '2021-12-02 18:27:38'),
(2, 'Coach Higgy', 'password', 0, 'teacher', '0000-00-00 00:00:00');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `assignments`
--
ALTER TABLE `assignments`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `higgycoin`
--
ALTER TABLE `higgycoin`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `login`
--
ALTER TABLE `login`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `assignments`
--
ALTER TABLE `assignments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

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

--
-- AUTO_INCREMENT for table `login`
--
ALTER TABLE `login`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
COMMIT;

