diff options
Diffstat (limited to 'chapters')
| -rw-r--r-- | chapters/physic.tex | 34 |
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 |