sql.sql

create table active_class_list
(
    id        int auto_increment
        primary key,
    className varchar(255) not null
)
    row_format = DYNAMIC;

create table advertisement
(
    id      int auto_increment
        primary key,
    img_url text null
);

create table class_course
(
    id         int auto_increment
        primary key,
    className  varchar(255) not null,
    week       varchar(255) not null,
    weekDay    varchar(255) not null,
    courseList longtext     not null
);

create table class_list
(
    id        int auto_increment
        primary key,
    className varchar(255) not null
);

create table classroom_course
(
    id             int auto_increment
        primary key,
    coursePosition varchar(70) not null,
    week           varchar(20) not null,
    weekDay        varchar(10) not null,
    courseList     longtext    not null
);

create table classrooms_list
(
    id        int auto_increment
        primary key,
    classroom varchar(255) null
);

create table community
(
    id           int auto_increment
        primary key,
    position     varchar(255)                          not null,
    push_name    varchar(20)                           not null,
    pic          longtext                              not null,
    type         varchar(10) default '综合'            not null,
    content      varchar(255)                          not null,
    img_list     longtext                              null,
    view_count   int         default 0                 null,
    created_time datetime    default CURRENT_TIMESTAMP null on update CURRENT_TIMESTAMP,
    targetUrl    varchar(40)                           null,
    copyText     varchar(50)                           null
);

create table cookies
(
    value       longtext                           null,
    id          int auto_increment
        primary key,
    create_time datetime default CURRENT_TIMESTAMP not null,
    type        varchar(20)                        null
);

create table dorm
(
    student_id     varchar(100)  not null,
    id             int auto_increment
        primary key,
    weight_total   int           null,
    class          varchar(20)   null,
    weight_average int           null,
    student_count  int default 0 not null
);

create table newborn_aq
(
    id      int auto_increment
        primary key,
    title   varchar(255) not null,
    content text         not null
);

create table student_list
(
    id            int auto_increment
        primary key,
    name          varchar(30)   not null,
    sex           varchar(5)    not null,
    class         varchar(30)   not null,
    speciality    varchar(30)   not null,
    phone         varchar(20)   not null,
    dorm_weight   int           null,
    weight_detail text          null,
    has_dorm      int default 0 not null,
    career        text          not null,
    holland       text          null
);

create table tech_course
(
    id         int auto_increment
        primary key,
    tech_name  varchar(255) not null,
    week       varchar(255) not null,
    weekDay    varchar(255) not null,
    courseList longtext     not null
);

create table tech_list
(
    id        int auto_increment
        primary key,
    tech_name varchar(255) null
)
    row_format = DYNAMIC;

create table update_log
(
    id           int auto_increment
        primary key,
    updateTime   varchar(255) not null,
    updateAuthor varchar(255) not null
);