ZyNAUdmC

1-- phpMyAdmin SQL Dump
2-- version 3.2.1
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Nov 09, 2016 at 02:40 PM
7-- Server version: 5.1.37
8-- PHP Version: 5.2.10
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11
12--
13-- Database: `mydatabase`
14--
15CREATE DATABASE `mydatabase` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
16USE `mydatabase`;
17
18-- --------------------------------------------------------
19
20--
21-- Table structure for table `usermaster`
22--
23
24CREATE TABLE IF NOT EXISTS `usermaster` (
25  `userid` varchar(50) NOT NULL,
26  `username` varchar(50) NOT NULL,
27  `password` varchar(30) NOT NULL,
28  `userlevel` int(11) NOT NULL,
29  `status` varchar(10) NOT NULL
30) ENGINE=MyISAM DEFAULT CHARSET=latin1;
31
32--
33-- Dumping data for table `usermaster`
34--
35
36INSERT INTO `usermaster` (`userid`, `username`, `password`, `userlevel`, `status`) VALUES
37('admin', 'Administrator', 'admin', 1, 'Active'),
38('vsk', 'VIGSHAKRI', '15', 1, 'Active'),
39('Orion', 'Belt Dee', '1223', 2, 'Active'),
40('Orion2', 'Belt Dee 2 ', '1223 22', 2, 'Active');