bispo-daniel
diff --git a/‎HugeDB/HugeDB--DDL.sql
Copy file name to clipboard
+5-7Lines changed: 5 additions & 7 deletions b/‎HugeDB/HugeDB--DDL.sql
Copy file name to clipboard
+5-7Lines changed: 5 additions & 7 deletions
diff --git a/‎HugeDB/HugeDB--LogicalModel.png
Copy file name to clipboard
7.77 KB b/‎HugeDB/HugeDB--LogicalModel.png
Copy file name to clipboard
7.77 KB
@@ -1,17 +1,15 @@
 create database hugeDB;
-
 use hugeDB;
 
 create table person (
-	id int(9) not null auto_increment,
+	id int unsigned auto_increment primary key,
     nome varchar(30) not null,
     dia1 DATETIME DEFAULT NOW(),
 	dia2 DATETIME DEFAULT NOW(),
-    primary key(id)
+	dia3 DATETIME DEFAULT NOW(),
+	dia4 DATETIME DEFAULT NOW(),
+	dia5 DATETIME DEFAULT NOW()
 );
 
-ALTER TABLE person ADD dia3 DATETIME DEFAULT NOW();
-ALTER TABLE person ADD dia4 DATETIME DEFAULT NOW();
-ALTER TABLE person ADD dia5 DATETIME DEFAULT NOW();
-
+--DML:
 insert into person (nome) values ("dan"), ("den"), ("din"), ("don"), ("dun");