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

START TRANSACTION;



--
-- Database: `flexdwcb_angel`
--

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

--
-- Table structure for table `audios`
--

CREATE TABLE `audios` (
  `id` int(10) NOT NULL,
  `video_name` varchar(255) DEFAULT NULL,
  `file` varchar(50) NOT NULL,
  `type` varchar(50) NOT NULL,
  `size` varchar(50) NOT NULL,
  `firstname` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` smallint(6) NOT NULL,
  `name` varchar(256) NOT NULL,
  `description` text NOT NULL,
  `position` smallint(6) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `employee`
--

CREATE TABLE `employee` (
  `userid` int(8) NOT NULL,
  `first_name` varchar(55) NOT NULL,
  `last_name` varchar(55) NOT NULL,
  `city_name` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `employee`
--

INSERT INTO `employee` (`userid`, `first_name`, `last_name`, `city_name`, `email`) VALUES
(1, 'Marcus', 'badbman', 'king', 'king@king.com');

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

--
-- Table structure for table `flexmedia`
--

CREATE TABLE `flexmedia` (
  `v_id` int(10) NOT NULL,
  `video_name` varchar(255) DEFAULT NULL,
  `file` varchar(50) NOT NULL,
  `type` varchar(50) NOT NULL,
  `size` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `flexmedia1`
--

CREATE TABLE `flexmedia1` (
  `id` int(10) NOT NULL,
  `video_name` varchar(255) DEFAULT NULL,
  `file` varchar(50) NOT NULL,
  `type` varchar(50) NOT NULL,
  `size` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `flexmedia1`
--

INSERT INTO `flexmedia1` (`id`, `video_name`, `file`, `type`, `size`) VALUES
(1, 'warmup.mp3', '', '', ''),
(2, 'Recharged.mp3', '', '', '');

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

--
-- Table structure for table `mem_cmt_post`
--

CREATE TABLE `mem_cmt_post` (
  `post_id` int(4) NOT NULL,
  `mem_id` int(3) NOT NULL,
  `userid` varchar(15) NOT NULL,
  `dt` date DEFAULT NULL,
  `dtl` text NOT NULL,
  `status` varchar(3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `mem_msg`
--

CREATE TABLE `mem_msg` (
  `feed_id` int(5) NOT NULL,
  `mem_id` int(3) NOT NULL,
  `userid` varchar(15) NOT NULL,
  `fname` varchar(20) NOT NULL,
  `announce` text NOT NULL,
  `fback` text NOT NULL,
  `reply` text NOT NULL,
  `status` varchar(1) NOT NULL,
  `dtj` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `mem_msg`
--

INSERT INTO `mem_msg` (`feed_id`, `mem_id`, `userid`, `fname`, `announce`, `fback`, `reply`, `status`, `dtj`) VALUES
(3, 3, 'siteadmin', 'site admin', '', 'Hellozy who\'s there', '', 'B', '2020-11-09 06:22:21');

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

--
-- Table structure for table `music`
--

CREATE TABLE `music` (
  `id` int(11) NOT NULL,
  `filename` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `nametable`
--

CREATE TABLE `nametable` (
  `firstname` varchar(20) NOT NULL,
  `lastname` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

--
-- Table structure for table `plus2_db_images`
--

CREATE TABLE `plus2_db_images` (
  `p_id` int(3) NOT NULL,
  `p_name` varchar(100) NOT NULL,
  `price` decimal(5,2) NOT NULL,
  `img` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `plus2_db_images`
--

INSERT INTO `plus2_db_images` (`p_id`, `p_name`, `price`, `img`) VALUES
(1, 'Rose', 20.34, 'rose.jpg'),
(2, 'Dragon Fly', 12.45, 'dragon-fly.jpg'),
(3, 'Butter Fly', 22.34, 'butterfly.jpg'),
(4, 'Anchor', 20.12, 'anchor.jpg');

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

--
-- Table structure for table `pm`
--

CREATE TABLE `pm` (
  `id` bigint(20) NOT NULL,
  `id2` int(11) NOT NULL,
  `title` varchar(256) NOT NULL,
  `user1` bigint(20) NOT NULL,
  `user2` bigint(20) NOT NULL,
  `message` text NOT NULL,
  `timestamp` int(10) NOT NULL,
  `user1read` varchar(3) NOT NULL,
  `user2read` varchar(3) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `pm`
--

INSERT INTO `pm` (`id`, `id2`, `title`, `user1`, `user2`, `message`, `timestamp`, `user1read`, `user2read`) VALUES
(1, 1, 'Announcement', 2, 1, 'What&#039;s up fam', 1607670144, 'yes', 'yes'),
(1, 2, '', 2, 0, 'Shoutme', 1607670246, '', ''),
(3, 1, 'Work', 2, 1, 'Hope I get rich', 1607670427, 'yes', 'yes');

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

--
-- Table structure for table `promomedia`
--

CREATE TABLE `promomedia` (
  `id` int(11) NOT NULL,
  `image_url` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `promomedia`
--

INSERT INTO `promomedia` (`id`, `image_url`) VALUES
(1, 'images/919673_1610140960.jpeg');

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

--
-- Table structure for table `promomedia1`
--

CREATE TABLE `promomedia1` (
  `id` int(10) NOT NULL,
  `video_name` varchar(255) DEFAULT NULL,
  `file` varchar(50) NOT NULL,
  `type` varchar(50) NOT NULL,
  `size` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `promomedia1`
--

INSERT INTO `promomedia1` (`id`, `video_name`, `file`, `type`, `size`) VALUES
(1, 'warmup.mp3', '', '', ''),
(2, 'Recharged.mp3', '', '', '');

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

--
-- Table structure for table `public`
--

CREATE TABLE `public` (
  `v_id` int(11) NOT NULL,
  `dbvideos` int(255) NOT NULL,
  `poster` int(255) NOT NULL,
  `userid` int(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `student`
--

CREATE TABLE `student` (
  `id` int(2) NOT NULL,
  `name` varchar(50) NOT NULL DEFAULT '',
  `class` varchar(10) NOT NULL DEFAULT '',
  `mark` int(3) NOT NULL DEFAULT 0,
  `sex` varchar(6) NOT NULL DEFAULT 'male'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `student`
--

INSERT INTO `student` (`id`, `name`, `class`, `mark`, `sex`) VALUES
(1, 'John Deo', 'Four', 75, 'female'),
(2, 'Max Ruin', 'Three', 85, 'male'),
(3, 'Arnold', 'Three', 55, 'male'),
(4, 'Krish Star', 'Four', 60, 'female'),
(5, 'John Mike', 'Four', 60, 'female'),
(6, 'Alex John', 'Four', 55, 'male'),
(7, 'My John Rob', 'Fifth', 78, 'male'),
(8, 'Asruid', 'Five', 85, 'male'),
(9, 'Tes Qry', 'Six', 78, 'male'),
(10, 'Big John', 'Four', 55, 'female'),
(11, 'Ronald', 'Six', 89, 'female'),
(12, 'Recky', 'Six', 94, 'female'),
(13, 'Kty', 'Seven', 88, 'female'),
(14, 'Bigy', 'Seven', 88, 'female'),
(15, 'Tade Row', 'Four', 88, 'male'),
(16, 'Gimmy', 'Four', 88, 'male'),
(17, 'Tumyu', 'Six', 54, 'male'),
(18, 'Honny', 'Five', 75, 'male'),
(19, 'Tinny', 'Nine', 18, 'male'),
(20, 'Jackly', 'Nine', 65, 'female'),
(21, 'Babby John', 'Four', 69, 'female'),
(22, 'Reggid', 'Seven', 55, 'female'),
(23, 'Herod', 'Eight', 79, 'male'),
(24, 'Tiddy Now', 'Seven', 78, 'male'),
(25, 'Giff Tow', 'Seven', 88, 'male'),
(26, 'Crelea', 'Seven', 79, 'male'),
(27, 'Big Nose', 'Three', 81, 'female'),
(28, 'Rojj Base', 'Seven', 86, 'female'),
(29, 'Tess Played', 'Seven', 55, 'male'),
(30, 'Reppy Red', 'Six', 79, 'female'),
(31, 'Marry Toeey', 'Four', 88, 'male'),
(32, 'Binn Rott', 'Seven', 90, 'female'),
(33, 'Kenn Rein', 'Six', 96, 'female'),
(34, 'Gain Toe', 'Seven', 69, 'male'),
(35, 'Rows Noump', 'Six', 88, 'female');

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

--
-- Table structure for table `student_profile`
--

CREATE TABLE `student_profile` (
  `id` int(2) NOT NULL,
  `student` varchar(10) NOT NULL,
  `profile_photo` blob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `student_profile`
--

INSERT INTO `student_profile` (`id`, `student`, `profile_photo`) VALUES
(1, '', '');
INSERT INTO `student_profile` (`id`, `student`, `profile_photo`) VALUES
(2, 'test', 0x[BLOB]);
INSERT INTO `student_profile` (`id`, `student`, `profile_photo`) VALUES
(3, 'test2', 0x[BLOB]);
INSERT INTO `student_profile` (`id`, `student`, `profile_photo`) VALUES
(3, 'test2', 0x[BLOB]);
