Newsbot/database.sql at master · piergale/Newsbot · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
CREATE DATABASE `newsbot` /*!40100 DEFAULT CHARACTER SET utf8 */;

CREATE TABLE GROUP_TELEGRAM (
  `group_id` bigint(20) NOT NULL,
  `registered` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE NEWS (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `link` varchar(1000) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `pubblication_date` date DEFAULT NULL,
  `creation_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `sent` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `link` (`link`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

CREATE TABLE USER_TELEGRAM (
  `user_id` bigint(20) NOT NULL,
  `user_name` varchar(150) DEFAULT NULL,
  `first_name` varchar(150) DEFAULT NULL,
  `last_name` varchar(150) DEFAULT NULL,
  `registered` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;