summaryrefslogtreecommitdiff
path: root/chapters
diff options
context:
space:
mode:
Diffstat (limited to 'chapters')
-rw-r--r--chapters/physic.tex34
1 files changed, 34 insertions, 0 deletions
diff --git a/chapters/physic.tex b/chapters/physic.tex
new file mode 100644
index 0000000..1e923a9
--- /dev/null
+++ b/chapters/physic.tex
@@ -0,0 +1,34 @@
+Qui di seguito รจ riportato il \verb|dump| in SQL per la creazione delle tabelle all'interno di PostgreSQL
+\begin{lstlisting}[language=SQL]
+CREATE TABLE "repository" (
+ id serial PRIMARY KEY NOT NULL,
+ url varchar(255) UNIQUE NOT NULL,
+ created_date timestamp NOT NULL,
+ updated_date timestamp NOT NULL,
+ uploader_ip varchar(15) NOT NULL
+);
+
+CREATE TABLE "email"(
+ email varchar(120) PRIMARY KEY NOT NULL,
+ hash_md5 varchar(32) UNIQUE NOT NULL
+);
+
+CREATE TABLE "commit" (
+ hash varchar(40) PRIMARY KEY NOT NULL,
+ tree varchar(40) REFERENCES commit(hash) NULL,
+ text text NOT NULL,
+ date timestamp NOT NULL,
+ author_email varchar(120) REFERENCES email(email) NOT NULL,
+ author_name varchar(120) NOT NULL,
+ committer_email varchar(120) REFERENCES email(email) NOT NULL,
+ committer_name varchar(120) NOT NULL,
+ repository_url varchar(256) REFERENCES repository(url) NOT NULL
+);
+
+CREATE TABLE "branch" (
+ id serial PRIMARY KEY NOT NULL,
+ name varchar(120) NOT NULL,
+ repository_id integer REFERENCES repository(id) NOT NULL,
+ head varchar(40) REFERENCES commit(hash) NULL
+);
+\end{lstlisting} \ No newline at end of file