PHP Classes

File: SQL File

Recommend this page to a friend!
  Classes of Cristian Radu   PHP Database Model   tests/test.sql   Download  
File: tests/test.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: PHP Database Model
Access model objects stored in a database
Author: By
Last change:
Date: 9 months ago
Size: 2,559 bytes
 

Contents

Class file image Download
-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: localhost -- Generation Time: Sep 02, 2024 at 10:55 PM -- Server version: 10.6.18-MariaDB-0ubuntu0.22.04.1 -- PHP Version: 8.1.2-1ubuntu2.18 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; -- -- Database: `test` -- -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `users_id` bigint(20) UNSIGNED NOT NULL, `user_profiles_id` int(10) UNSIGNED NOT NULL, `salt` char(64) NOT NULL, `user_name` char(255) DEFAULT NULL, `email` char(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`users_id`, `user_profiles_id`, `salt`, `user_name`, `email`) VALUES (1, 1, 'C8lE3m', 'Guest', ''), (2, 2, 'Y2hU1zY5y', 'Cristian Radu', '[email protected]'), (38, 10, 'V3oU2e', 'Cristian Radu', '[email protected]'), (42, 3, 'W1aI7o', 'BRETFELEAN M', '[email protected]'), (43, 4, 'G9xE0n', 'Alin', '[email protected]'), (44, 3, 'V3oU2e', 'sorin', '[email protected]'), (45, 10, 'Y5zL8j', 'Hr', '[email protected]'), (48, 4, 'V3oU2e', 'Cristian Radu', '[email protected]'), (49, 2, 'R6nB3e', 'DANA', '[email protected]'), (50, 2, 'B8nO0jI8x', 'Octav Goga', '[email protected]'), (51, 2, 'A2pQ4qH5i', 'Kristi Rad', '[email protected]'), (52, 2, 'G9wU2dH1k', 'Kristi Radu', '[email protected]'), (53, 3, 'P9wE7bL8u', 'L Bucur', '[email protected]'), (54, 2, 'R5sM3xA1l', 'ESCU VIOREL', '[email protected]'), (55, 2, 'K6zF4w', 'Michael Moldovan', '[email protected]'), (56, 2, 'H0yD7a', 'Cazacu Johny', '[email protected]'), (57, 2, 'U8vV9zX6d', 'Andy Sandu', '[email protected]'), (58, 2, 'K0yE6n', 'Mariasu Maria', '[email protected]'), (59, 2, 'I7tG4gM6r', 'Cintary Lehel', '[email protected]'), (60, 2, 'W3cK7q', 'R Vasilica', '[email protected]'); -- -- Indexes for dumped tables -- -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`users_id`), ADD UNIQUE KEY `email` (`email`), ADD KEY `user_profiles_id` (`user_profiles_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `users_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=300; COMMIT;