SQL / C++ Tutorial using sqlwrapped

2. Creating the tutorial database
PreviousNextIndex

This tutorial will work with three database tables,
describing players, resources, and the link between those two tables.

The following sql scripts are used to create the databases. There are small 
syntax differences between MySQL and sqlite3, primary key definition isn't always
the same as is the auto_increment / autoincrement keyword.

MySQL

CREATE TABLE player (
	num integer auto_increment not null,
	name varchar(100) default '' not null,
	primary key(num),
	unique(name)
);

CREATE TABLE resource (
	num integer auto_increment not null,
	name varchar(100) default '' not null,
	primary key(num),
	unique(name)
);

CREATE TABLE playerresource (
	player integer default 0 not null,
	resource integer default 0 not null,
	amount integer default 0,
	primary key(player, resource)
);
tutorialdb-mysql.sql

Create database using MySQL:

$ mysqladmin create tutorialdb
$ mysql tutorialdb
mysql> _enter the above sql script to create the tables_
mysql> quit
$
sqlite3

CREATE TABLE player (
	num integer primary key autoincrement not null,
	name varchar(100) default '' not null,
	unique(name)
);

CREATE TABLE resource (
	num integer primary key autoincrement not null,
	name varchar(100) default '' not null,
	unique(name)
);

CREATE TABLE playerresource (
	player integer default 0 not null,
	resource integer default 0 not null,
	amount integer default 0,
	primary key(player, resource)
);
tutorialdb-sqlite3.sql

Create database using sqlite3:

$ sqlite3 tutorial.db
sqlite> _enter the above sql script to create the tables_
sqlite> .q
$


PreviousNext