Database dump: Difference between revisions

Revision as of 02:13, 4 November 2012

Revision as of 04:29, 1 March 2013

Line 6:

<source lang="sql">

-- Database

CREATE DATABASE '`example'`;

USE '`example'`;

-- Table structure for table '`users'`

CREATE TABLE '`users'` (

'`id'` int(8) unsigned NOT NULL AUTO_INCREMENT,

'`username'` varchar(16) NOT NULL,

'`password'` varchar(16) NOT NULL,

PRIMARY KEY ('`id'`)

);

-- Data for table '`users'`

INSERT INTO '`users'` VALUES (1,'alice','secret'),(2,'bob','secret');

</source>