面试题

drop database if exists exam;

create database exam;

use exam;

drop table if exists T_User;

drop table if exists T_Activity;

drop table if exists T_ApproveMessage;

create table if not exists T_User
(
   C_UID                        varchar(50)   primary key        not null,
   C_Name                      varchar(255)                     not null,
   C_PWD                       varchar(32) not null
);

create table if not exists T_Activity
(
   C_ID                        varchar(32)   primary key        not null,
   C_Name                      varchar(255)                     not null,
   C_Content                   varchar(1000) not null,
   N_Money                     int(10) not null,
   N_State                     int(1) not null
);

create table if not exists T_ApproveMessage
(
   C_ID                        varchar(32)   primary key        not null,
   C_ Activity                 varchar(32)     not null,
   N_Result                    int(1) ,
   C_ Advice                   varchar(500)
);
insert into T_User(C_UID, C_Name, C_PWD) values ('001', 'xiaozhuzhang', '123456');
insert into T_User(C_UID, C_Name, C_PWD) values ('002', 'lingdao', '123456');