database/tests/Database/files/mysql-nette_test4.sql at d8d52f7980c7c04b94a957f23655619b5d372a79 · nette/database · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
DROP DATABASE IF EXISTS nette_test;
CREATE DATABASE nette_test;
USE nette_test;

CREATE TABLE simple_pk_autoincrement (
	identifier1 int NOT NULL AUTO_INCREMENT,
	note varchar(100),
	PRIMARY KEY (identifier1)
) ENGINE=InnoDB;

CREATE TABLE simple_pk_no_autoincrement (
	identifier1 int NOT NULL,
	note varchar(100),
	PRIMARY KEY (identifier1)
) ENGINE=InnoDB;

CREATE TABLE multi_pk_no_autoincrement (
	identifier1 int NOT NULL,
	identifier2 int NOT NULL,
	note varchar(100),
	PRIMARY KEY (identifier1, identifier2)
) ENGINE=InnoDB;

CREATE TABLE multi_pk_autoincrement(
	identifier1 int NOT NULL AUTO_INCREMENT,
	identifier2 int NOT NULL,
	note varchar(100),
	PRIMARY KEY (identifier1, identifier2)
) ENGINE=InnoDB;

CREATE TABLE no_pk (
	note varchar(100)
) ENGINE=InnoDB;