KjiU3XXB

1DROP DATABASE IF EXISTS strona;
2CREATE DATABASE strona;
3
4DROP TABLE IF EXISTS users CASCADE;
5CREATE TABLE users (
6  id        SERIAL      NOT NULL,
7  login     VARCHAR(60) NOT NULL,
8  password  VARCHAR(60) NOT NULL,
9  PRIMARY KEY (id)
10);
11
12DROP TABLE IF EXISTS applications CASCADE;
13CREATE TABLE applications (
14  id                  SERIAL      NOT NULL,
15  name                TEXT        NOT NULL,
16  surname             TEXT        NOT NULL,
17  department          TEXT        NOT NULL,
18  studies             VARCHAR(60),
19  studies_year        VARCHAR(10),
20  email               VARCHAR(60) NOT NULL,
21  telephonenumber     VARCHAR(20) NOT NULL,
22  index_number        VARCHAR(6),
23  picture_path        TEXT,
24  skills              TEXT,
25  why                 TEXT        NOT NULL,
26  expectations        TEXT        NOT NULL,
27  sth_about_me        TEXT        NOT NULL,
28  what_wanna_do       TEXT        NOT NULL,
29  responsibility      TEXT,
30  three_am            TEXT        NOT NULL,
31  feedback            TEXT,
32  wherefrom_info      TEXT,
33  other_organisations TEXT,
34  board_note          TEXT,
35  PRIMARY KEY(id)
36);
37
38DROP TABLE IF EXISTS articles CASCADE;
39CREATE TABLE articles (
40  id                  SERIAL      NOT NULL,
41  title               TEXT        NOT NULL,
42  short_description   TEXT        NOT NULL,
43  description         TEXT        NOT NULL,
44  author              VARCHAR(60) NOT NULL,
45  published_time      TIMESTAMP   NOT NULL,
46  path_to_main_image  TEXT        NOT NULL,
47  path_to_image1      TEXT,
48  path_to_image2      TEXT,
49  PRIMARY KEY(id)
50);