Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

Commit 33a5a62

Browse filesBrowse files
committed
updateHugeDB
1 parent 34a1a15 commit 33a5a62
Copy full SHA for 33a5a62

File tree

Expand file treeCollapse file tree

2 files changed

+5
-7
lines changed
Filter options
Expand file treeCollapse file tree

2 files changed

+5
-7
lines changed

‎HugeDB/HugeDB--DDL.sql

Copy file name to clipboard
+5-7Lines changed: 5 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -1,17 +1,15 @@
11
create database hugeDB;
2-
32
use hugeDB;
43

54
create table person (
6-
id int(9) not null auto_increment,
5+
id int unsigned auto_increment primary key,
76
nome varchar(30) not null,
87
dia1 DATETIME DEFAULT NOW(),
98
dia2 DATETIME DEFAULT NOW(),
10-
primary key(id)
9+
dia3 DATETIME DEFAULT NOW(),
10+
dia4 DATETIME DEFAULT NOW(),
11+
dia5 DATETIME DEFAULT NOW()
1112
);
1213

13-
ALTER TABLE person ADD dia3 DATETIME DEFAULT NOW();
14-
ALTER TABLE person ADD dia4 DATETIME DEFAULT NOW();
15-
ALTER TABLE person ADD dia5 DATETIME DEFAULT NOW();
16-
14+
--DML:
1715
insert into person (nome) values ("dan"), ("den"), ("din"), ("don"), ("dun");

‎HugeDB/HugeDB--LogicalModel.png

Copy file name to clipboard
7.77 KB
Loading

0 commit comments

Comments
0 (0)
Morty Proxy This is a proxified and sanitized view of the page, visit original site.