PostgreSQL建库建表脚本1.创建⾓⾊（create_role.sql）drop role if exists "kq_acs";create role "kq_acs" login encrypted password 'kq_acs' inherit connection limit -1;2.创建数据库（create_db.sql ） ps：要创建的数据库不存在CREATE DATABASE "kq_acs" WITH OWNER = kq_acs ENCODING = 'UTF8';3.创建表结构（create_tables.sql）/*Navicat PGSQL Data TransferSource Server : 10.0.2.138Source Server Version : 90309Source Host : 10.0.2.138:5432Source Database : acsSource Schema : publicTarget Server Type : PGSQLTarget Server Version : 90309File Encoding : 65001Date: 2017-10-16 18:25:28*/-- ------------------------------ Sequence structure for hibernate_sequence-- ----------------------------DROP SEQUENCE IF EXISTS "public"."hibernate_sequence";CREATE SEQUENCE "public"."hibernate_sequence"INCREMENT 1MINVALUE 1MAXVALUE 9223372036854775807START 1CACHE 1;-- ------------------------------ Table structure for kq_acs-- ----------------------------DROP TABLE IF EXISTS "public"."kq_acs";CREATE TABLE "public"."kq_acs" ("acs_id" varchar(32) COLLATE "default" NOT NULL,"create_time" varchar(50) COLLATE "default" NOT NULL,"emp_id" varchar(32) COLLATE "default" NOT NULL,"company_id" varchar(32) COLLATE "default","dept_id" varchar(32) COLLATE "default","latitude" varchar(20) COLLATE "default","longitude" varchar(20) COLLATE "default","acs_name" varchar(50) COLLATE "default")WITH (OIDS=FALSE);-- ------------------------------ Table structure for kq_admin-- ----------------------------DROP TABLE IF EXISTS "public"."kq_admin";CREATE TABLE "public"."kq_admin" (WITH (OIDS=FALSE);-- ------------------------------ Table structure for kq_asuq-- ----------------------------DROP TABLE IF EXISTS "public"."kq_asuq";CREATE TABLE "public"."kq_asuq" ("asuq_id" varchar(32) COLLATE "default" NOT NULL, "uuid" varchar(100) COLLATE "default" NOT NULL, "emp_number" varchar(20) COLLATE "default" NOT NULL, "emp_id" varchar(32) COLLATE "default" NOT NULL, "company_id" varchar(32) COLLATE "default" NOT NULL, "dept_id" varchar(32) COLLATE "default")WITH (OIDS=FALSE);-- ------------------------------ Table structure for kq_auth-- ----------------------------DROP TABLE IF EXISTS "public"."kq_auth";CREATE TABLE "public"."kq_auth" ("auth_id" varchar(50) COLLATE "default" NOT NULL, "auth_list" varchar(1000) COLLATE "default", "purview" varchar(50) COLLATE "default","emp_id" varchar(50) COLLATE "default" NOT NULL, "company_id" varchar(50) COLLATE "default")WITH (OIDS=FALSE);-- ------------------------------ Table structure for kq_dept-- ----------------------------DROP TABLE IF EXISTS "public"."kq_dept";CREATE TABLE "public"."kq_dept" ("dept_id" varchar(32) COLLATE "default" NOT NULL, "dept_num" varchar(20) COLLATE "default" NOT NULL, "dept_name" varchar(20) COLLATE "default" NOT NULL, "company_id" varchar(32) COLLATE "default","set_id" varchar(32) COLLATE "default")WITH (OIDS=FALSE);-- ------------------------------ Table structure for kq_emp-- ----------------------------DROP TABLE IF EXISTS "public"."kq_emp";CREATE TABLE "public"."kq_emp" ("emp_id" varchar(32) COLLATE "default" NOT NULL, "emp_number" varchar(20) COLLATE "default" NOT NULL, "emp_name" varchar(30) COLLATE "default" NOT NULL, "phone" varchar(12) COLLATE "default" NOT NULL, "email" varchar(30) COLLATE "default", "hasmod" int4 NOT NULL,"head_img" varchar(300) COLLATE "default", "gender" varchar(8) COLLATE "default","age" int4,"temp_code_limit" varchar(32) COLLATE "default","mac_name" varchar(40) COLLATE "default","dept_id" varchar(32) COLLATE "default","company_id" varchar(32) COLLATE "default")WITH (OIDS=FALSE);-- ------------------------------ Table structure for kq_employ-- ----------------------------DROP TABLE IF EXISTS "public"."kq_employ";CREATE TABLE "public"."kq_employ" ("ephone" varchar(50) COLLATE "default" NOT NULL, "epwd" varchar(50) COLLATE "default" NOT NULL, "epid" varchar(50) COLLATE "default" NOT NULL, "speaker_id" varchar(50) COLLATE "default")WITH (OIDS=FALSE);-- ------------------------------ Table structure for kq_feedback-- ----------------------------DROP TABLE IF EXISTS "public"."kq_feedback"; CREATE TABLE "public"."kq_feedback" ("feedback_id" varchar(32) COLLATE "default" NOT NULL, "feedbackinfo" text COLLATE "default" NOT NULL, "create_time" char(50) COLLATE "default" NOT NULL, "phone" varchar(50) COLLATE "default")WITH (OIDS=FALSE);-- ------------------------------ Table structure for kq_leave-- ----------------------------DROP TABLE IF EXISTS "public"."kq_leave";CREATE TABLE "public"."kq_leave" ("leave_id" varchar(32) COLLATE "default" NOT NULL, "leave_type" varchar(10) COLLATE "default" NOT NULL, "start_time" varchar(50) COLLATE "default" NOT NULL, "end_time" varchar(50) COLLATE "default","create_time" varchar(50) COLLATE "default" NOT NULL, "leave_content" varchar(100) COLLATE "default" NOT NULL, "approval_name" varchar(40) COLLATE "default" NOT NULL, "emp_id" varchar(32) COLLATE "default","company_id" varchar(32) COLLATE "default","dept_id" varchar(32) COLLATE "default")WITH (OIDS=FALSE);-- ------------------------------ Table structure for kq_loc-- ----------------------------DROP TABLE IF EXISTS "public"."kq_loc";CREATE TABLE "public"."kq_loc" ("loc_id" int4 NOT NULL,"loc_time" varchar(30) COLLATE "default",)WITH (OIDS=FALSE);-- ------------------------------ Table structure for kq_lock-- ----------------------------DROP TABLE IF EXISTS "public"."kq_lock";CREATE TABLE "public"."kq_lock" ("lock_id" varchar(32) COLLATE "default" NOT NULL, "lock_name" varchar(100) COLLATE "default","lock_number" varchar(20) COLLATE "default", "company_id" varchar(32) COLLATE "default" NOT NULL, "lock_ip" varchar(32) COLLATE "default","emp_id" varchar(32) COLLATE "default")WITH (OIDS=FALSE);-- ------------------------------ Table structure for kq_mac-- ----------------------------DROP TABLE IF EXISTS "public"."kq_mac";CREATE TABLE "public"."kq_mac" ("mac_id" varchar(32) COLLATE "default" NOT NULL, "mac" varchar(20) COLLATE "default", "macname" varchar(40) COLLATE "default", "company_id" varchar(32) COLLATE "default")WITH (OIDS=FALSE);-- ------------------------------ Table structure for kq_operation_record-- ----------------------------DROP TABLE IF EXISTS "public"."kq_operation_record"; CREATE TABLE "public"."kq_operation_record" ( "operation_id" varchar(32) COLLATE "default" NOT NULL, "operation_type" varchar(32) COLLATE "default", "operation_date" varchar(32) COLLATE "default","emp_id" varchar(32) COLLATE "default" NOT NULL, "company_id" varchar(32) COLLATE "default")WITH (OIDS=FALSE);-- ------------------------------ Table structure for kq_statistics-- ----------------------------DROP TABLE IF EXISTS "public"."kq_statistics"; CREATE TABLE "public"."kq_statistics" ("sts_id" varchar(32) COLLATE "default" NOT NULL,"on_time" varchar COLLATE "default","off_time" varchar COLLATE "default","shicha" varchar(11) COLLATE "default","result" varchar(10) COLLATE "default" NOT NULL,"on_flag" varchar(15) COLLATE "default","off_flag" varchar(15) COLLATE "default","emp_id" varchar(32) COLLATE "default","company_id" varchar(32) COLLATE "default",;-- ------------------------------ Table structure for kq_timeset-- ----------------------------DROP TABLE IF EXISTS "public"."kq_timeset";CREATE TABLE "public"."kq_timeset" ("set_id" varchar(32) COLLATE "default" NOT NULL,"am_time" varchar(100) COLLATE "default" NOT NULL, "pm_time" varchar(100) COLLATE "default" NOT NULL, "shiduan" varchar(20) COLLATE "default" NOT NULL, "company_id" varchar(32) COLLATE "default")WITH (OIDS=FALSE);-- ------------------------------ Table structure for kq_travel-- ----------------------------DROP TABLE IF EXISTS "public"."kq_travel";CREATE TABLE "public"."kq_travel" ("travel_id" varchar(32) COLLATE "default" NOT NULL, "create_time" varchar(60) COLLATE "default" NOT NULL, "travel_reason" varchar(100) COLLATE "default" NOT NULL, "emp_id" varchar(32) COLLATE "default","company_id" varchar(32) COLLATE "default","dept_id" varchar(32) COLLATE "default","travel_starttime" varchar(50) COLLATE "default","travel_endtime" varchar(50) COLLATE "default", "latitude" varchar(20) COLLATE "default", "longitude" varchar(20) COLLATE "default")WITH (OIDS=FALSE);-- ------------------------------ Table structure for kq_users-- ----------------------------DROP TABLE IF EXISTS "public"."kq_users";CREATE TABLE "public"."kq_users" ("company_id" varchar(32) COLLATE "default" NOT NULL, "name" varchar(20) COLLATE "default" NOT NULL, "username" varchar(30) COLLATE "default" NOT NULL, "password" varchar(32) COLLATE "default","email" varchar(30) COLLATE "default" NOT NULL, "company_name" varchar(50) COLLATE "default" NOT NULL, "company_tel" varchar(16) COLLATE "default", "company_logo" varchar(100) COLLATE "default","active_key" varchar(32) COLLATE "default","company_mac" varchar(100) COLLATE "default","active_code" varchar(32) COLLATE "default", "latitude" varchar(20) COLLATE "default", "longitude" varchar(20) COLLATE "default", "mobilephone" varchar(16) COLLATE "default", "checkmac" varchar(20) COLLATE "default")WITH (OIDS=FALSE);-- ----------------------------"verify_log_id" varchar(32) COLLATE "default" NOT NULL, "verify_id" varchar(32) COLLATE "default" NOT NULL, "verify_result" int4 NOT NULL,"verify_time" date NOT NULL,"verify_number" varchar(10) COLLATE "default" NOT NULL, "read_number" varchar(10) COLLATE "default" NOT NULL, "normscore" float8,"score" float8,"verify_voice" oid NOT NULL,"verify_type" int4,"emp_id" varchar(32) COLLATE "default" NOT NULL)WITH (OIDS=FALSE);-- ------------------------------ Table structure for kq_verifyrecord-- ----------------------------DROP TABLE IF EXISTS "public"."kq_verifyrecord"; CREATE TABLE "public"."kq_verifyrecord" ("verify_id" varchar(32) COLLATE "default" NOT NULL, "punch_time" varchar(50) COLLATE "default" NOT NULL, "verify_result" int4 NOT NULL,"verify_number" varchar(10) COLLATE "default" NOT NULL, "read_number" varchar(10) COLLATE "default" NOT NULL, "normscore" float8 NOT NULL,"score" float8 NOT NULL,"verify_voice" varchar(100) COLLATE "default" NOT NULL, "verify_type" int4,"verify_times" int4,"emp_id" varchar(32) COLLATE "default","company_id" varchar(32) COLLATE "default","dept_id" varchar(32) COLLATE "default")WITH (OIDS=FALSE);-- ------------------------------ Table structure for kq_vp-- ----------------------------DROP TABLE IF EXISTS "public"."kq_vp";CREATE TABLE "public"."kq_vp" ("vp_id" varchar(32) COLLATE "default" NOT NULL, "model" varchar(100) COLLATE "default","voice" varchar(100) COLLATE "default","create_time" varchar(30) COLLATE "default" NOT NULL, "company_id" varchar(32) COLLATE "default","dept_id" varchar(32) COLLATE "default","emp_id" varchar(32) COLLATE "default")WITH (OIDS=FALSE);-- ------------------------------ Table structure for kq_vp_log-- ----------------------------DROP TABLE IF EXISTS "public"."kq_vp_log";CREATE TABLE "public"."kq_vp_log" ("vp_log_id" varchar(32) COLLATE "default" NOT NULL, "vp_id" varchar(32) COLLATE "default" NOT NULL, "create_time" date NOT NULL,;-- ------------------------------ Alter Sequences Owned By-- ------------------------------ ------------------------------ Primary Key structure for table kq_acs-- ----------------------------ALTER TABLE "public"."kq_acs" ADD PRIMARY KEY ("acs_id");-- ------------------------------ Primary Key structure for table kq_admin-- ----------------------------ALTER TABLE "public"."kq_admin" ADD PRIMARY KEY ("admin_id");-- ------------------------------ Primary Key structure for table kq_asuq-- ----------------------------ALTER TABLE "public"."kq_asuq" ADD PRIMARY KEY ("asuq_id");-- ------------------------------ Primary Key structure for table kq_auth-- ----------------------------ALTER TABLE "public"."kq_auth" ADD PRIMARY KEY ("auth_id");-- ------------------------------ Primary Key structure for table kq_dept-- ----------------------------ALTER TABLE "public"."kq_dept" ADD PRIMARY KEY ("dept_id");-- ------------------------------ Primary Key structure for table kq_emp-- ----------------------------ALTER TABLE "public"."kq_emp" ADD PRIMARY KEY ("emp_id");-- ------------------------------ Primary Key structure for table kq_employ-- ----------------------------ALTER TABLE "public"."kq_employ" ADD PRIMARY KEY ("epid");-- ------------------------------ Primary Key structure for table kq_feedback-- ----------------------------ALTER TABLE "public"."kq_feedback" ADD PRIMARY KEY ("feedback_id"); -- ------------------------------ Primary Key structure for table kq_leave-- ----------------------------ALTER TABLE "public"."kq_leave" ADD PRIMARY KEY ("leave_id");-- ------------------------------ Primary Key structure for table kq_loc-- ----------------------------ALTER TABLE "public"."kq_loc" ADD PRIMARY KEY ("loc_id");-- ------------------------------ Primary Key structure for table kq_lock-- ----------------------------ALTER TABLE "public"."kq_lock" ADD PRIMARY KEY ("lock_id");-- ------------------------------ Primary Key structure for table kq_mac-- Primary Key structure for table kq_operation_record-- ----------------------------ALTER TABLE "public"."kq_operation_record" ADD PRIMARY KEY ("operation_id");-- ------------------------------ Primary Key structure for table kq_statistics-- ----------------------------ALTER TABLE "public"."kq_statistics" ADD PRIMARY KEY ("sts_id");-- ------------------------------ Primary Key structure for table kq_timeset-- ----------------------------ALTER TABLE "public"."kq_timeset" ADD PRIMARY KEY ("set_id");-- ------------------------------ Primary Key structure for table kq_travel-- ----------------------------ALTER TABLE "public"."kq_travel" ADD PRIMARY KEY ("travel_id");-- ------------------------------ Primary Key structure for table kq_users-- ----------------------------ALTER TABLE "public"."kq_users" ADD PRIMARY KEY ("company_id");-- ------------------------------ Primary Key structure for table kq_verify_log-- ----------------------------ALTER TABLE "public"."kq_verify_log" ADD PRIMARY KEY ("verify_log_id");-- ------------------------------ Primary Key structure for table kq_verifyrecord-- ----------------------------ALTER TABLE "public"."kq_verifyrecord" ADD PRIMARY KEY ("verify_id");-- ------------------------------ Primary Key structure for table kq_vp-- ----------------------------ALTER TABLE "public"."kq_vp" ADD PRIMARY KEY ("vp_id");-- ------------------------------ Primary Key structure for table kq_vp_log-- ----------------------------ALTER TABLE "public"."kq_vp_log" ADD PRIMARY KEY ("vp_log_id");-- ------------------------------ Foreign Key structure for table "public"."kq_acs"-- ----------------------------ALTER TABLE "public"."kq_acs" ADD FOREIGN KEY ("emp_id") REFERENCES "public"."kq_emp" ("emp_id") ON DELETE CASCADE ON UPDATE CASCADE;ALTER TABLE "public"."kq_acs" ADD FOREIGN KEY ("company_id") REFERENCES "public"."kq_users" ("company_id") ON DELETE CASCADE ON UPDATE CASCADE;ALTER TABLE "public"."kq_acs" ADD FOREIGN KEY ("dept_id") REFERENCES "public"."kq_dept" ("dept_id") ON DELETE CASCADE ON UPDATE CASCADE;-- ------------------------------ Foreign Key structure for table "public"."kq_asuq"-- ----------------------------ALTER TABLE "public"."kq_asuq" ADD FOREIGN KEY ("emp_id") REFERENCES "public"."kq_emp" ("emp_id") ON DELETE CASCADE ON UPDATE CASCADE;ALTER TABLE "public"."kq_asuq" ADD FOREIGN KEY ("dept_id") REFERENCES "public"."kq_dept" ("dept_id") ON DELETE CASCADE ON UPDATE CASCADE;ALTER TABLE "public"."kq_asuq" ADD FOREIGN KEY ("company_id") REFERENCES "public"."kq_users" ("company_id") ON DELETE CASCADE ON UPDATE CASCADE;CASCADE ON UPDATE CASCADE;ALTER TABLE "public"."kq_auth" ADD FOREIGN KEY ("company_id") REFERENCES "public"."kq_users" ("company_id") ON DELETE CASCADE ON UPDATE CASCADE;-- ------------------------------ Foreign Key structure for table "public"."kq_dept"-- ----------------------------ALTER TABLE "public"."kq_dept" ADD FOREIGN KEY ("company_id") REFERENCES "public"."kq_users" ("company_id") ON DELETE CASCADE ON UPDATE CASCADE;-- ------------------------------ Foreign Key structure for table "public"."kq_emp"-- ----------------------------ALTER TABLE "public"."kq_emp" ADD FOREIGN KEY ("dept_id") REFERENCES "public"."kq_dept" ("dept_id") ON DELETE CASCADE ON UPDATE CASCADE;ALTER TABLE "public"."kq_emp" ADD FOREIGN KEY ("company_id") REFERENCES "public"."kq_users" ("company_id") ON DELETE CASCADE ON UPDATE CASCADE;-- ------------------------------ Foreign Key structure for table "public"."kq_leave"-- ----------------------------ALTER TABLE "public"."kq_leave" ADD FOREIGN KEY ("emp_id") REFERENCES "public"."kq_emp" ("emp_id") ON DELETE CASCADE ON UPDATE CASCADE;ALTER TABLE "public"."kq_leave" ADD FOREIGN KEY ("company_id") REFERENCES "public"."kq_users" ("company_id") ON DELETE CASCADE ON UPDATE CASCADE;ALTER TABLE "public"."kq_leave" ADD FOREIGN KEY ("dept_id") REFERENCES "public"."kq_dept" ("dept_id") ON DELETE CASCADE ON UPDATE CASCADE;-- ------------------------------ Foreign Key structure for table "public"."kq_lock"-- ----------------------------ALTER TABLE "public"."kq_lock" ADD FOREIGN KEY ("emp_id") REFERENCES "public"."kq_emp" ("emp_id") ON DELETE CASCADE ON UPDATE CASCADE;ALTER TABLE "public"."kq_lock" ADD FOREIGN KEY ("company_id") REFERENCES "public"."kq_users" ("company_id") ON DELETE CASCADE ON UPDATE CASCADE;-- ------------------------------ Foreign Key structure for table "public"."kq_mac"-- ----------------------------ALTER TABLE "public"."kq_mac" ADD FOREIGN KEY ("company_id") REFERENCES "public"."kq_users" ("company_id") ON DELETE CASCADE ON UPDATE CASCADE;-- ------------------------------ Foreign Key structure for table "public"."kq_operation_record"-- ----------------------------ALTER TABLE "public"."kq_operation_record" ADD FOREIGN KEY ("emp_id") REFERENCES "public"."kq_emp" ("emp_id") ON DELETE CASCADE ON UPDATE CASCADE;ALTER TABLE "public"."kq_operation_record" ADD FOREIGN KEY ("company_id") REFERENCES "public"."kq_users" ("company_id") ON DELETE CASCADE ON UPDATE CASCADE;-- ------------------------------ Foreign Key structure for table "public"."kq_statistics"-- ----------------------------ALTER TABLE "public"."kq_statistics" ADD FOREIGN KEY ("emp_id") REFERENCES "public"."kq_emp" ("emp_id") ON DELETE CASCADE ON UPDATE CASCADE;ALTER TABLE "public"."kq_statistics" ADD FOREIGN KEY ("company_id") REFERENCES "public"."kq_users" ("company_id") ON DELETE CASCADE ON UPDATE CASCADE;ALTER TABLE "public"."kq_statistics" ADD FOREIGN KEY ("dept_id") REFERENCES "public"."kq_dept" ("dept_id") ON DELETE CASCADE ON UPDATE CASCADE;-- ------------------------------ Foreign Key structure for table "public"."kq_timeset"-- ----------------------------ALTER TABLE "public"."kq_timeset" ADD FOREIGN KEY ("company_id") REFERENCES "public"."kq_users" ("company_id") ON-- ----------------------------ALTER TABLE "public"."kq_travel" ADD FOREIGN KEY ("company_id") REFERENCES "public"."kq_users" ("company_id") ON DELETE CASCADE ON UPDATE CASCADE;ALTER TABLE "public"."kq_travel" ADD FOREIGN KEY ("dept_id") REFERENCES "public"."kq_dept" ("dept_id") ON DELETE CASCADE ON UPDATE CASCADE;ALTER TABLE "public"."kq_travel" ADD FOREIGN KEY ("emp_id") REFERENCES "public"."kq_emp" ("emp_id") ON DELETE CASCADE ON UPDATE CASCADE;-- ------------------------------ Foreign Key structure for table "public"."kq_verifyrecord"-- ----------------------------ALTER TABLE "public"."kq_verifyrecord" ADD FOREIGN KEY ("company_id") REFERENCES "public"."kq_users" ("company_id") ON DELETE CASCADE ON UPDATE CASCADE;ALTER TABLE "public"."kq_verifyrecord" ADD FOREIGN KEY ("dept_id") REFERENCES "public"."kq_dept" ("dept_id") ON DELETE CASCADE ON UPDATE CASCADE;ALTER TABLE "public"."kq_verifyrecord" ADD FOREIGN KEY ("emp_id") REFERENCES "public"."kq_emp" ("emp_id") ON DELETE CASCADE ON UPDATE CASCADE;-- ------------------------------ Foreign Key structure for table "public"."kq_vp"-- ----------------------------ALTER TABLE "public"."kq_vp" ADD FOREIGN KEY ("emp_id") REFERENCES "public"."kq_emp" ("emp_id") ON DELETE CASCADE ON UPDATE CASCADE;ALTER TABLE "public"."kq_vp" ADD FOREIGN KEY ("dept_id") REFERENCES "public"."kq_dept" ("dept_id") ON DELETE CASCADE ON UPDATE CASCADE;ALTER TABLE "public"."kq_vp" ADD FOREIGN KEY ("company_id") REFERENCES "public"."kq_users" ("company_id") ON DELETE CASCADE ON UPDATE CASCADE;4.赋予权限（create_authority.sql）GRANT all ON DATABASE "kq_acs" TO "kq_acs";GRANT all ON SCHEMA "public" TO "kq_acs";GRANT all ON all tables in SCHEMA "public" to "kq_acs";。
sqlserver建库建表语句
1. 嘿，你知道吗，sqlserver 建库就像给数据搭个家一样！比如创建一个学校数据库，来存放学生和课程的信息呀。
2. 哇塞，sqlserver 建表语句那可太重要啦！就像给家里分房间一样，比如为学生信息建个表，把姓名、年龄等都安排得妥妥当当。
3. 哎呀呀，sqlserver 建库不就是给数据找个安身之地嘛！像建个电商数据库，商品和订单就有地方待啦。
4. 嘿，sqlserver 建表语句就好像给数据划分地盘呢！比如为员工信息建个表，工号、职位都能各就各位啦。
5. 哇哦，sqlserver 建库就如同打造一个数据的城堡呀！比如为医院建个库，病人和病历都能好好安置。
6. 哟呵，sqlserver 建表语句不就是给数据规划小格子嘛！像为车辆信息建个表，车牌、型号都有自己的位置咯。
7. 哈哈，sqlserver 建库这不是显而易见的事情嘛！好比建个图书馆数据库，书籍和借阅记录都能有条不紊啦。
8. 呀，sqlserver 建表语句这可不能小瞧呀！就像为餐厅的菜单建个表，菜品和价格都能清楚呈现呢。
9. 嘿呀，sqlserver 建库那可是基础中的基础呀！比如为旅游景点建个库，景点和游客信息都能管理好啦。
10. 哇，sqlserver 建表语句简直太关键啦！就如同为一个游戏建个角色表，各种属性都能明确记录呢。
我的观点结论就是：sqlserver 建库建表语句真的超级重要，掌握了它们，才能让数据管理变得轻松又高效！。
mysql-建表、添加字段、修改字段、添加索引SQL语句写法表的操作1、建表--如果USERS表存在则删除DROP TABLE IF EXISTS USERS;CREATE TABLE USERS(id INT UNSIGNED NOT NULL AUTO_INCREMENT, # 主键 UNSIGNED ⽆符号 AUTO_INCREMENT ⾃增name VARCHAR(30) NOT NULL COMMENT '⽤户名',sex ENUM('男','⼥') NOT NULL DEFAULT '男', # 使⽤枚举类型，在插⼊的时候可以数值来表⽰，从1开始。
如1则代表男age TINYINT UNSIGNED NOT NULL DEFAULT 1,PRIMARY KEY (`Id`))DEFAULT CHARSET=UTF8 ENGINE=INNODB;操作字段都是ALTER TABLE 表名的格式2、添加字段ALTER TABLE USERS ADD alias varchar(20) COMMENT '别名';3、修改字段 3.1 不修改名称使⽤modifyALTER TABLE USERS MODIFY name varchar(20) NOT NULL COMMENT '⽤户名'; 3.2 修改名称使⽤change 格式是 change 要修改的名称新名称 ...ALTER TABLE USERS CHANGE name username varchar(20) NOT NULL COMMENT '⽤户名';4、删除字段ALTER TABLE USERS DROP COLUMN alias;-- 删除多个字段-- ALTER TABLE USERS DROP COLUMN alias,DROP COLUMN age;库的操作1、建库CREATE DATABASE test CHARACTER SET utf8;2、修改库的默认编码ALTER DATABASE test CHARACTER SET utf8;3、删库跑路DROP DATABASE test;索引(约束)的操作1、添加主键--删除主键ALTER TABLE 表名 DROP PRIMARY KEY;ALTER TABLE USERS ADD PRIMARY KEY ( `id` )2、添加唯⼀索引ALTER TABLE USERS ADD UNiQUE ( `username` )3、添加普通索引ALTER TABLE `USERS` ADD INDEX index_name ( `age` )4、添加全⽂索引ALTER TABLE `表名` ADD FULLTEXT (`列名`)5、添加多列索引 ALTER TABLE `表名` ADD INDEX index_name ( `列名1`, `列名2`, `列名3` )6、添加外键⼀般很少外键约束，外键约束靠代码逻辑实现alter table 表名 add constraint fk_引⽤id foreign key(引⽤id) references 被引⽤表名 (被引⽤id)alter table 表名 drop forign key fk_引⽤id数据库的管理命令1、连接mysql -u root -p123456或mysql -u root -p输⼊密码2、查看操作-- 查看所有库show databases;-- 查看所在库的表show tables;-- 查看库的创建语句show create database test;-- 查看表的创建语句show create table test;-- 查看表的索引-- show index from table_name（表名）show index from users;-- 查看mysql版本select version();-- 查看当前⽤户select user();3、创建⽤户-- 特别需要注意，在 MySQL 中，账号由两部分组成:-- 1. user-- 2. host-- 即使 user 相同，只要 host 不同，也会被认为是不同账号。
