9 Star 204 Fork 2

酒城 / peiwan

加入 Gitee
与超过 800 万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
该仓库未声明开源许可证文件(LICENSE),使用请关注具体项目描述及其代码上游依赖。
克隆/下载
数据库脚本.sql 17.10 KB
一键复制 编辑 Web IDE 原始数据 按行查看 历史
酒城 提交于 2021-11-01 08:03 . 数据库脚本|界面|ppt演示
???prompt PL/SQL Developer import file
prompt Created on 20211029 by 星辰
set feedback off
set define off
prompt Creating GAME...
create table GAME
(
id NUMBER(4) not null,
name VARCHAR2(30),
icon VARCHAR2(255)
)
tablespace SYSTEM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
alter table GAME
add primary key (ID)
using index
tablespace SYSTEM
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
prompt Creating ACCOMPANYING_PLAY...
create table ACCOMPANYING_PLAY
(
id NUMBER(10) not null,
name VARCHAR2(50),
level_ NUMBER(2,1),
order_count NUMBER(10),
loc VARCHAR2(20),
acc_img VARCHAR2(255),
message VARCHAR2(20),
price NUMBER(4),
dan VARCHAR2(20),
game_id NUMBER(10)
)
tablespace SYSTEM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
alter table ACCOMPANYING_PLAY
add primary key (ID)
using index
tablespace SYSTEM
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
alter table ACCOMPANYING_PLAY
add foreign key (GAME_ID)
references GAME (ID);
prompt Creating ACCOMPANYING_PLAY_DETAIL...
create table ACCOMPANYING_PLAY_DETAIL
(
detail_id NUMBER(10) not null,
top_img VARCHAR2(255),
state NUMBER(1),
serve_count NUMBER(10),
order_receiving_time VARCHAR2(255),
can_yield VARCHAR2(255),
can_dan VARCHAR2(255),
game_feature VARCHAR2(255),
accompanying_play_id NUMBER(10)
)
tablespace SYSTEM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
alter table ACCOMPANYING_PLAY_DETAIL
add primary key (DETAIL_ID)
using index
tablespace SYSTEM
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
alter table ACCOMPANYING_PLAY_DETAIL
add foreign key (ACCOMPANYING_PLAY_ID)
references ACCOMPANYING_PLAY (ID);
prompt Creating ORDER_DETAIL...
create table ORDER_DETAIL
(
order_id NUMBER(10) not null,
accompanying_play_id NUMBER(10),
play_time NUMBER(2),
order_price NUMBER(10)
)
tablespace SYSTEM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
alter table ORDER_DETAIL
add primary key (ORDER_ID)
using index
tablespace SYSTEM
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
alter table ORDER_DETAIL
add foreign key (ACCOMPANYING_PLAY_ID)
references ACCOMPANYING_PLAY (ID);
prompt Creating SERVICETYPE...
create table SERVICETYPE
(
id NUMBER(2) not null,
icon VARCHAR2(255) not null,
title VARCHAR2(20) not null
)
tablespace SYSTEM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
alter table SERVICETYPE
add primary key (ID)
using index
tablespace SYSTEM
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
prompt Creating USERINFO...
create table USERINFO
(
pet_name VARCHAR2(50) not null,
name VARCHAR2(50),
phone VARCHAR2(11),
icon VARCHAR2(50),
attention NUMBER(10),
fans NUMBER(10),
recentvisits NUMBER(10),
footmark NUMBER(10)
)
tablespace SYSTEM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
alter table USERINFO
add primary key (PET_NAME)
using index
tablespace SYSTEM
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
prompt Disabling triggers for GAME...
alter table GAME disable all triggers;
prompt Disabling triggers for ACCOMPANYING_PLAY...
alter table ACCOMPANYING_PLAY disable all triggers;
prompt Disabling triggers for ACCOMPANYING_PLAY_DETAIL...
alter table ACCOMPANYING_PLAY_DETAIL disable all triggers;
prompt Disabling triggers for ORDER_DETAIL...
alter table ORDER_DETAIL disable all triggers;
prompt Disabling triggers for SERVICETYPE...
alter table SERVICETYPE disable all triggers;
prompt Disabling triggers for USERINFO...
alter table USERINFO disable all triggers;
prompt Disabling foreign key constraints for ACCOMPANYING_PLAY...
alter table ACCOMPANYING_PLAY disable constraint SYS_C007077;
prompt Disabling foreign key constraints for ACCOMPANYING_PLAY_DETAIL...
alter table ACCOMPANYING_PLAY_DETAIL disable constraint SYS_C007087;
prompt Disabling foreign key constraints for ORDER_DETAIL...
alter table ORDER_DETAIL disable constraint SYS_C007090;
prompt Truncating USERINFO...
truncate table USERINFO;
prompt Truncating SERVICETYPE...
truncate table SERVICETYPE;
prompt Truncating ORDER_DETAIL...
truncate table ORDER_DETAIL;
prompt Truncating ACCOMPANYING_PLAY_DETAIL...
truncate table ACCOMPANYING_PLAY_DETAIL;
prompt Truncating ACCOMPANYING_PLAY...
truncate table ACCOMPANYING_PLAY;
prompt Truncating GAME...
truncate table GAME;
prompt Loading GAME...
insert into GAME (id, name, icon)
values (1, '和平精英', '/img/hpjy.png');
insert into GAME (id, name, icon)
values (2, '英雄联盟', '/img/yxlm.png');
insert into GAME (id, name, icon)
values (3, '王者荣耀', '/img/wzry.png');
insert into GAME (id, name, icon)
values (4, '逆战', '/img/nz.jpg');
insert into GAME (id, name, icon)
values (5, 'QQ飞车', '/img/QQ飞车.png');
commit;
prompt 5 records loaded
prompt Loading ACCOMPANYING_PLAY...
insert into ACCOMPANYING_PLAY (id, name, level_, order_count, loc, acc_img, message, price, dan, game_id)
values (1001, '打不过就...', 5, 520, '西安', '/img/1.jpg', null, 20, '无敌战神', 1);
insert into ACCOMPANYING_PLAY (id, name, level_, order_count, loc, acc_img, message, price, dan, game_id)
values (1002, '你曾胜过漫天...', 4, 200, '杭州', '/img/2.jpg', null, 30, '超凡大师', 2);
insert into ACCOMPANYING_PLAY (id, name, level_, order_count, loc, acc_img, message, price, dan, game_id)
values (1003, '繁华落尽...', 4.8, 560, '兰州', '/img/5.jpg', null, 15, '荣耀王者', 3);
insert into ACCOMPANYING_PLAY (id, name, level_, order_count, loc, acc_img, message, price, dan, game_id)
values (1006, '笙歌君独幽...', 5, 440, '青岛', '/img/5.jpg', null, 20, '超级王牌', 1);
insert into ACCOMPANYING_PLAY (id, name, level_, order_count, loc, acc_img, message, price, dan, game_id)
values (1008, '淡然的回忆...', 4.5, 380, '成都', '/img/7.jpg', null, 28, '超级王牌', 1);
insert into ACCOMPANYING_PLAY (id, name, level_, order_count, loc, acc_img, message, price, dan, game_id)
values (1009, '恰似一缕微光...', 4.8, 330, '上海', '/img/6.jpg', null, 24, '超级王牌', 1);
insert into ACCOMPANYING_PLAY (id, name, level_, order_count, loc, acc_img, message, price, dan, game_id)
values (1010, '醉挽清风...', 4.7, 430, '北京', '/img/14.png', null, 22, '最强王者', 2);
insert into ACCOMPANYING_PLAY (id, name, level_, order_count, loc, acc_img, message, price, dan, game_id)
values (1011, '夜雨微澜...', 4.9, 380, '天津', '/img/17.png', null, 35, '超凡大师', 2);
insert into ACCOMPANYING_PLAY (id, name, level_, order_count, loc, acc_img, message, price, dan, game_id)
values (1012, '凉薄少女夢...', 4.8, 300, '合肥', '/img/18.png', null, 24, '最强王者', 2);
insert into ACCOMPANYING_PLAY (id, name, level_, order_count, loc, acc_img, message, price, dan, game_id)
values (1013, '若只如初见...', 4.7, 180, '黑龙江', '/img/19.png', null, 18, '永恒钻石', 3);
insert into ACCOMPANYING_PLAY (id, name, level_, order_count, loc, acc_img, message, price, dan, game_id)
values (1014, '霓裳晚歌...', 4.9, 240, '哈尔滨', '/img/16.png', null, 16, '最强王者', 3);
insert into ACCOMPANYING_PLAY (id, name, level_, order_count, loc, acc_img, message, price, dan, game_id)
values (1015, '爱海搁浅...', 4.8, 250, '重庆', '/img/12.png', null, 15, '至尊星耀', 3);
insert into ACCOMPANYING_PLAY (id, name, level_, order_count, loc, acc_img, message, price, dan, game_id)
values (1016, '冷心为王...', 4.4, 220, '云南', '/img/13.png', null, 10, '枪王', 4);
insert into ACCOMPANYING_PLAY (id, name, level_, order_count, loc, acc_img, message, price, dan, game_id)
values (1017, '烟寒若雨...', 4, 130, '张家界', '/img/17.png', null, 40, '枪神', 4);
insert into ACCOMPANYING_PLAY (id, name, level_, order_count, loc, acc_img, message, price, dan, game_id)
values (1018, '爱在千年梦...', 4.3, 120, '沈阳', '/img/18.png', null, 20, '枪王', 4);
insert into ACCOMPANYING_PLAY (id, name, level_, order_count, loc, acc_img, message, price, dan, game_id)
values (1004, '大田子的...', 5, 660, '新疆', '/img/7.jpg', null, 25, '枪神', 4);
insert into ACCOMPANYING_PLAY (id, name, level_, order_count, loc, acc_img, message, price, dan, game_id)
values (1005, '瑶瑶梦...', 4.5, 330, '西藏', '/img/4.jpg', null, 30, '传奇车神', 5);
commit;
prompt 17 records loaded
prompt Loading ACCOMPANYING_PLAY_DETAIL...
insert into ACCOMPANYING_PLAY_DETAIL (detail_id, top_img, state, serve_count, order_receiving_time, can_yield, can_dan, game_feature, accompanying_play_id)
values (42036015, '/img/detail_和平精英.jpg', 1, 3, '全天', 'QQ、微信区', '永恒钻石,无敌战神', '会配合,技术牛,', 1001);
insert into ACCOMPANYING_PLAY_DETAIL (detail_id, top_img, state, serve_count, order_receiving_time, can_yield, can_dan, game_feature, accompanying_play_id)
values (42036027, '/img/detail_3.jpg', 1, 2, '全天', '全区', '永恒钻石,最强王者', '会配合,技术牛,', 1002);
insert into ACCOMPANYING_PLAY_DETAIL (detail_id, top_img, state, serve_count, order_receiving_time, can_yield, can_dan, game_feature, accompanying_play_id)
values (42036026, '/img/detail_4.jpg', 1, 3, '全天', '微信区', '永恒钻石,荣耀王者', '会配合,技术牛,', 1003);
insert into ACCOMPANYING_PLAY_DETAIL (detail_id, top_img, state, serve_count, order_receiving_time, can_yield, can_dan, game_feature, accompanying_play_id)
values (42036028, '/img/detail_逆战.jpg', 1, 3, '全天', '微信区', '枪王', '会配合,技术牛,', 1004);
insert into ACCOMPANYING_PLAY_DETAIL (detail_id, top_img, state, serve_count, order_receiving_time, can_yield, can_dan, game_feature, accompanying_play_id)
values (42036024, '/img/detail_1.jpg', 1, 1, '全天', 'QQ、微信区', '永恒钻石,荣耀王者', '会配合,技术牛,', 1005);
insert into ACCOMPANYING_PLAY_DETAIL (detail_id, top_img, state, serve_count, order_receiving_time, can_yield, can_dan, game_feature, accompanying_play_id)
values (42036023, '/img/detail_和平精英2.jpg', 1, 3, '全天', '微信区', '永恒钻石,无敌战神', '会配合,技术牛,', 1006);
insert into ACCOMPANYING_PLAY_DETAIL (detail_id, top_img, state, serve_count, order_receiving_time, can_yield, can_dan, game_feature, accompanying_play_id)
values (42036022, '/img/detail_和平精英3.jpg', 1, 2, '全天', 'QQ、微信区', '永恒钻石,无敌战神', '会配合,技术牛,', 1008);
insert into ACCOMPANYING_PLAY_DETAIL (detail_id, top_img, state, serve_count, order_receiving_time, can_yield, can_dan, game_feature, accompanying_play_id)
values (42036021, '/img/detail_和平精英4.jpg', 1, 3, '全天', 'QQ、微信区', '永恒钻石,无敌战神', '会配合,技术牛,', 1009);
insert into ACCOMPANYING_PLAY_DETAIL (detail_id, top_img, state, serve_count, order_receiving_time, can_yield, can_dan, game_feature, accompanying_play_id)
values (42036020, '/img/detail_lol.jpg', 1, 2, '全天', '全区', '超凡大师', '会配合,技术牛,', 1010);
insert into ACCOMPANYING_PLAY_DETAIL (detail_id, top_img, state, serve_count, order_receiving_time, can_yield, can_dan, game_feature, accompanying_play_id)
values (42036019, '/img/detail_lol1.jpg', 1, 3, '全天', '全区', '永恒钻石,宗师', '会配合,技术牛,', 1011);
insert into ACCOMPANYING_PLAY_DETAIL (detail_id, top_img, state, serve_count, order_receiving_time, can_yield, can_dan, game_feature, accompanying_play_id)
values (42036018, '/img/detail_lol3.jpg', 1, 2, '全天', '全区', '永恒钻石,超凡大师', '会配合,技术牛,', 1012);
insert into ACCOMPANYING_PLAY_DETAIL (detail_id, top_img, state, serve_count, order_receiving_time, can_yield, can_dan, game_feature, accompanying_play_id)
values (42036017, '/img/detail_5.jpg', 1, 3, '全天', '微信区', '荣耀王者', '会配合,技术牛,', 1013);
insert into ACCOMPANYING_PLAY_DETAIL (detail_id, top_img, state, serve_count, order_receiving_time, can_yield, can_dan, game_feature, accompanying_play_id)
values (42036016, '/img/detail_6.jpg', 1, 3, '全天', '微信区', '永恒钻石,荣耀王者', '会配合,技术牛,', 1014);
insert into ACCOMPANYING_PLAY_DETAIL (detail_id, top_img, state, serve_count, order_receiving_time, can_yield, can_dan, game_feature, accompanying_play_id)
values (42036014, '/img/detail_4.jpg', 1, 4, '全天', '全区', '枪神', '会配合,技术牛,', 1015);
insert into ACCOMPANYING_PLAY_DETAIL (detail_id, top_img, state, serve_count, order_receiving_time, can_yield, can_dan, game_feature, accompanying_play_id)
values (42036013, 'img/detail_逆战2.jpg', 1, 3, '全天', '全区', '枪王', '会配合,技术牛,', 1016);
insert into ACCOMPANYING_PLAY_DETAIL (detail_id, top_img, state, serve_count, order_receiving_time, can_yield, can_dan, game_feature, accompanying_play_id)
values (42036012, 'img/detail_逆战4.jpg', 1, 2, '全天', '全区', '枪神', '会配合,技术牛,', 1017);
insert into ACCOMPANYING_PLAY_DETAIL (detail_id, top_img, state, serve_count, order_receiving_time, can_yield, can_dan, game_feature, accompanying_play_id)
values (42036011, 'img/detail_逆战1.jpg', 1, 4, '全天', '全区', '枪神', '会配合,技术牛,', 1018);
commit;
prompt 17 records loaded
prompt Loading ORDER_DETAIL...
insert into ORDER_DETAIL (order_id, accompanying_play_id, play_time, order_price)
values (2, 1003, 3, 15);
insert into ORDER_DETAIL (order_id, accompanying_play_id, play_time, order_price)
values (3, 1017, 2, 160);
insert into ORDER_DETAIL (order_id, accompanying_play_id, play_time, order_price)
values (1, 1004, 3, 25);
insert into ORDER_DETAIL (order_id, accompanying_play_id, play_time, order_price)
values (4, 1004, 3, 100);
insert into ORDER_DETAIL (order_id, accompanying_play_id, play_time, order_price)
values (5, 1016, 3, 10);
insert into ORDER_DETAIL (order_id, accompanying_play_id, play_time, order_price)
values (6, 1016, 3, 10);
insert into ORDER_DETAIL (order_id, accompanying_play_id, play_time, order_price)
values (7, 1016, 3, 30);
insert into ORDER_DETAIL (order_id, accompanying_play_id, play_time, order_price)
values (8, 1013, 3, 36);
insert into ORDER_DETAIL (order_id, accompanying_play_id, play_time, order_price)
values (9, 1009, 3, 24);
commit;
prompt 9 records loaded
prompt Loading SERVICETYPE...
insert into SERVICETYPE (id, icon, title)
values (1, '/img/hpjy.png', '和平精英');
insert into SERVICETYPE (id, icon, title)
values (2, '/img/yxlm.png', '英雄联盟');
insert into SERVICETYPE (id, icon, title)
values (3, '/img/wzry.png', '王者荣耀');
insert into SERVICETYPE (id, icon, title)
values (4, '/img/nz.jpg', '逆战');
insert into SERVICETYPE (id, icon, title)
values (5, '/img/tj.png', '更多');
commit;
prompt 5 records loaded
prompt Loading USERINFO...
insert into USERINFO (pet_name, name, phone, icon, attention, fans, recentvisits, footmark)
values ('酒城', '憨憨', '17793383560', '/img/15.png', 102, 111, 40, 50);
commit;
prompt 1 records loaded
prompt Enabling foreign key constraints for ACCOMPANYING_PLAY...
alter table ACCOMPANYING_PLAY enable constraint SYS_C007077;
prompt Enabling foreign key constraints for ACCOMPANYING_PLAY_DETAIL...
alter table ACCOMPANYING_PLAY_DETAIL enable constraint SYS_C007087;
prompt Enabling foreign key constraints for ORDER_DETAIL...
alter table ORDER_DETAIL enable constraint SYS_C007090;
prompt Enabling triggers for GAME...
alter table GAME enable all triggers;
prompt Enabling triggers for ACCOMPANYING_PLAY...
alter table ACCOMPANYING_PLAY enable all triggers;
prompt Enabling triggers for ACCOMPANYING_PLAY_DETAIL...
alter table ACCOMPANYING_PLAY_DETAIL enable all triggers;
prompt Enabling triggers for ORDER_DETAIL...
alter table ORDER_DETAIL enable all triggers;
prompt Enabling triggers for SERVICETYPE...
alter table SERVICETYPE enable all triggers;
prompt Enabling triggers for USERINFO...
alter table USERINFO enable all triggers;
set feedback on
set define on
prompt Done.
Java
1
https://gitee.com/htzGittee/peiwan.git
git@gitee.com:htzGittee/peiwan.git
htzGittee
peiwan
peiwan
master

搜索帮助