DB/update.sql at master · youke2019/DB · 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
28
29
30
31
32
/*==============================================================*/
/* Table: system_message                                        */
/*==============================================================*/
create table system_message
(
   admin_id             int,
   content              varchar(3000),
   image_url            varchar(30),
   time                 varchar(40),
   message_id           int not null auto_increment,
   primary key (message_id)
);

/*==============================================================*/
/* Table: feedback                                              */
/*==============================================================*/
create table feedback
(
   ID                   varchar(40),
   content              varchar(3000),
   time                 varchar(40),
   feedback_id          int not null auto_increment,
   primary key (feedback_id)
);


alter table system_message add constraint FK_Relationship_135 foreign key (admin_id)
      references admins (admin_id) on delete restrict on update restrict;

alter table feedback add constraint FK_Relationship_136 foreign key (ID)
      references user (ID) on delete restrict on update restrict;