PageRenderTime 25ms CodeModel.GetById 30ms RepoModel.GetById 0ms app.codeStats 0ms

/Database files/paragraph_users.sql

https://gitlab.com/rahulranjan96/team2cs243
SQL | 68 lines | 25 code | 13 blank | 30 comment | 0 complexity | 1f69b2ec42bc609d47df9ed76a8d6ab7 MD5 | raw file
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.5.1
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: 127.0.0.1
  6. -- Generation Time: Apr 25, 2016 at 02:19 PM
  7. -- Server version: 10.1.10-MariaDB
  8. -- PHP Version: 7.0.2
  9. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  10. SET time_zone = "+00:00";
  11. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  12. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  13. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  14. /*!40101 SET NAMES utf8mb4 */;
  15. --
  16. -- Database: `annotated_words`
  17. --
  18. -- --------------------------------------------------------
  19. --
  20. -- Table structure for table `paragraph_users`
  21. --
  22. CREATE TABLE `paragraph_users` (
  23. `id` int(11) NOT NULL,
  24. `username` varchar(60) NOT NULL,
  25. `paragraph` longtext NOT NULL,
  26. `title` varchar(60) NOT NULL
  27. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  28. --
  29. -- Dumping data for table `paragraph_users`
  30. --
  31. INSERT INTO `paragraph_users` (`id`, `username`, `paragraph`, `title`) VALUES
  32. (1, 'kamal', 'Animals are multicellular, eukaryotic organisms of the kingdom Animalia (also called Metazoa). All animals are motile, meaning they can move spontaneously and independently, at some point in their lives. Their body plan eventually becomes fixed as they develop, although some undergo a process of metamorphosis later on in their lives. All animals are heterotrophs: they must ingest other organisms or their products for sustenance.\r\n\r\nMost known animal phyla appeared in the fossil record as marine species during the Cambrian explosion, about 542 million years ago. Animals are divided into various sub-groups, some of which are: vertebrates (birds, mammals, amphibians, reptiles, fish); molluscs (clams, oysters, octopuses, squid, snails); arthropods (millipedes, centipedes, insects, spiders, scorpions, crabs, lobsters, shrimp); annelids (earthworms, leeches); cnidarians (jellyfish, anemones, corals); and sponges.\r\n', 'animals'),
  33. (2, 'kamal', 'With a few exceptions, most notably the sponges (Phylum Porifera) and Placozoa, animals have bodies differentiated into separate tissues. These include muscles, which are able to contract and control locomotion, and nerve tissues, which send and process signals. Typically, there is also an internal digestive chamber, with one or two openings.[13] Animals with this sort of organization are called metazoans, or eumetazoans when the former is used for animals in general.[14]\r\n\r\nAll animals have eukaryotic cells, surrounded by a characteristic extracellular matrix composed of collagen and elastic glycoproteins.[15] This may be calcified to form structures like shells, bones, and spicules.[16] During development, it forms a relatively flexible framework[17] upon which cells can move about and be reorganized, making complex structures possible. In contrast, other multicellular organisms, like plants and fungi, have cells held in place by cell walls, and so develop by progressive growth.[13] Also, unique to animal cells are the following intercellular junctions: tight junctions, gap junctions, and desmosomes.[18]\r\n', 'structure'),
  34. (3, 'kamal', 'With a few exceptions, most notably the sponges (Phylum Porifera) and Placozoa, animals have bodies differentiated into separate tissues. These include muscles, which are able to contract and control locomotion, and nerve tissues, which send and process signals. Typically, there is also an internal digestive chamber, with one or two openings.[13] Animals with this sort of organization are called metazoans, or eumetazoans when the former is used for animals in general.[14]\r\n', 'structure'),
  35. (4, 'kamal', 'All animals have eukaryotic cells, surrounded by a characteristic extracellular matrix composed of collagen and elastic glycoproteins.[15] This may be calcified to form structures like shells, bones, and spicules.[16] During development, it forms a relatively flexible framework[17] upon which cells can move about and be reorganized, making complex structures possible. In contrast, other multicellular organisms, like plants and fungi, have cells held in place by cell walls, and so develop by progressive growth.[13] Also, unique to animal cells are the following intercellular junctions: tight junctions, gap junctions, and desmosomes.[18]\r\n', 'kamal'),
  36. (5, 'kamal', 'Animals are multicellular, eukaryotic organisms of the kingdom Animalia (also called Metazoa). All animals are motile, meaning they can move spontaneously and independently, at some point in their lives. Their body plan eventually becomes fixed as they develop, although some undergo a process of metamorphosis later on in their lives. All animals are heterotrophs: they must ingest other organisms or their products for sustenance.\r\n\r\nMost known animal phyla appeared in the fossil record as marine species during the Cambrian explosion, about 542 million years ago. Animals are divided into various sub-groups, some of which are: vertebrates (birds, mammals, amphibians, reptiles, fish); molluscs (clams, oysters, octopuses, squid, snails); arthropods (millipedes, centipedes, insects, spiders, scorpions, crabs, lobsters, shrimp); annelids (earthworms, leeches); cnidarians (jellyfish, anemones, corals); and sponges.\r\n\r\n', 'text animals');
  37. --
  38. -- Indexes for dumped tables
  39. --
  40. --
  41. -- Indexes for table `paragraph_users`
  42. --
  43. ALTER TABLE `paragraph_users`
  44. ADD PRIMARY KEY (`id`);
  45. --
  46. -- AUTO_INCREMENT for dumped tables
  47. --
  48. --
  49. -- AUTO_INCREMENT for table `paragraph_users`
  50. --
  51. ALTER TABLE `paragraph_users`
  52. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  53. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  54. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  55. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;