File: db_example.sql

Recommend this page to a friend!
  Classes of Kabir Hossain  >  DB Manager  >  db_example.sql  >  Download  
File: db_example.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: DB Manager
Execute common SQL queries to a MySQL database
Author: By
Last change:
Date: 3 years ago
Size: 1,133 bytes
 

Contents

Class file image Download
--
-- Database: `db_example`
--

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

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
`id` int(10) NOT NULL,
  `name` varchar(255) NOT NULL,
  `role` varchar(255) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1'
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `name`, `role`, `status`) VALUES
(1, 'Abc', 'Admin', 1),
(2, 'Xyz', 'Sub Admin', 0),
(3, 'Demo', 'Editor', 0),
(6, 'Demo Insert', 'Editor', 0),
(7, 'Demo Insert', 'Editor', 1),
(8, 'Demo Insert', 'Editor', 0),
(9, 'Demo Insert', 'Editor', 1),
(10, 'Demo Insert', 'Editor', 1),
(11, 'Demo Insert', 'Editor', 1),
(12, 'Demo Insert', 'Editor', 1),
(13, 'Demo Insert', 'Editor', 1),
(14, 'Demo Insert', 'Editor', 1),
(15, 'Demo Insert', 'Editor', 1),
(16, 'Demo Insert', 'Editor', 1),
(17, 'Demo Insert', 'Editor', 1),
(18, 'Demo Insert', 'Editor', 1),
(19, 'Demo Insert', 'Editor', 1);

--
-- Indexes for dumped tables
--

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

For more information send a message to info at phpclasses dot org.