-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathdatabase_structure.sql
2 lines (1 loc) · 1.8 KB
/
database_structure.sql
1
-- phpMyAdmin SQL Dump-- version 2.11.11.3-- http://www.phpmyadmin.net---- Host: localhost-- Generation Time: Feb 16, 2013 at 03:20 PM-- Server version: 5.5.20-- PHP Version: 5.3.19SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";---- Database: `cloudify`---- ------------------------------------------------------------ Table structure for table `users`--CREATE TABLE IF NOT EXISTS `users` ( `uid` int(11) NOT NULL AUTO_INCREMENT, `userid` varchar(64) DEFAULT NULL, `password` varchar(64) DEFAULT NULL, `defaultmodel` varchar(64) NOT NULL, `defaultserialno` varchar(64) NOT NULL, `defaulturl` varchar(512) DEFAULT NULL, `privilege1` int(11) DEFAULT NULL, `privilege2` int(11) DEFAULT NULL, `privilege3` int(11) DEFAULT NULL, `privilege4` int(11) DEFAULT NULL, `privilege5` int(11) DEFAULT NULL, `firstname` varchar(64) DEFAULT NULL, `lastname` varchar(64) DEFAULT NULL, `msisdn` varchar(32) DEFAULT NULL, `sessionkey` int(11) DEFAULT NULL, PRIMARY KEY (`uid`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;---- Dumping data for table `users`--INSERT INTO `users` (`uid`, `userid`, `password`, `defaultmodel`, `defaultserialno`, `defaulturl`, `privilege1`, `privilege2`, `privilege3`, `privilege4`, `privilege5`, `firstname`, `lastname`, `msisdn`, `sessionkey`) VALUES(6, 'bew', 'XXFkseZ0yuKuA', 'paradigmpump', '', 'ec2-50-19-40-239.compute-1.amazonaws.com', 2, NULL, NULL, NULL, NULL, 'Ben', 'West', '7322165109', 1225532926),(3, 'new', 'XXFkseZ0yuKuA', 'onetouchultramini', '', 'commlab.ceat.okstate.edu', 2, NULL, NULL, NULL, NULL, 'Nathan', 'West', '7328584026', 1536432243),(5, 'ehw', 'XXFkseZ0yuKuA', '', '', '', 2, NULL, NULL, NULL, NULL, 'Earle', 'West III', '9082165054', 1364777716),(8, 'dog', 'XXFkseZ0yuKuA', 'onetouchultramini', '', 'http://yahoo.com', 0, NULL, NULL, NULL, NULL, 'My', 'Dog', '9082165054', NULL);