You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
30 lines
1.1 KiB
30 lines
1.1 KiB
-- 在appointment表的period字段上创建索引
|
|
CREATE INDEX idx_appointment_period ON appointment(period);
|
|
|
|
-- 在feedback表的date字段上创建索引
|
|
CREATE INDEX idx_feedback_date ON feedback(date);
|
|
|
|
-- 在invoice表的date字段上创建索引
|
|
CREATE INDEX idx_invoice_date ON invoice(date);
|
|
|
|
-- 在training_record表的record_id字段上创建索引
|
|
CREATE INDEX idx_training_record_record_id ON training_record(record_id);
|
|
|
|
-- 在booking_slot表的start_time和end_time字段上创建复合索引
|
|
CREATE INDEX idx_booking_slot_start_end_time ON booking_slot(start_time, end_time);
|
|
|
|
-- 在account表的status字段上创建索引
|
|
CREATE INDEX idx_account_status ON account(status);
|
|
|
|
-- 在student表的name字段上创建索引
|
|
CREATE INDEX idx_student_name ON student(name);
|
|
|
|
-- 在coach表的name字段上创建索引
|
|
CREATE INDEX idx_coach_name ON coach(name);
|
|
|
|
-- 在venue表的name字段上创建索引
|
|
CREATE INDEX idx_venue_name ON venue(name);
|
|
|
|
-- 在personal_info表的email字段上创建唯一索引
|
|
CREATE UNIQUE INDEX idx_personal_info_email ON personal_info(email);
|
|
-- 添加新学员的存储过程 |