FazBrowse GitHub Viewer
|
Trending
|
URL:
|
Home
Tools:
[Download Repo ZIP]
[View Raw Code]
[Original HTTPS Page]
JavaWeb/sql.txt at main · MathsionYang/JavaWeb · GitHub
MathsionYang
JavaWeb
Repository navigation
Code
Issues
Pull requests
Actions
Projects
Security and quality
Insights
Expand file tree
Breadcrumbs
JavaWeb
/
sql.txt
Copy path
More file actions
More file actions
Latest commit
History
History
History
71 lines (54 loc) · 2.11 KB
Breadcrumbs
JavaWeb
/
sql.txt
Copy path
File metadata and controls
71 lines (54 loc) · 2.11 KB
Raw
Copy raw file
Download raw file
Open symbols panel
Edit and raw actions
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
drop table if exists ‘LmonkeyUser‘;
create table ‘LmonkeyUser‘(
USER_ID varchar(32) not null,
USER_NAME varchar(32) not null,
USER_PASSWORD varchar(20) not null,
USER_SEX varchar(1) not null,
USER_BIRTHDAY datetime default null,
USER_IDENITY_CODE varchar(60) default null,
USER_EMAIL varchar(60) default null,
USER_PHONE varchar(11) default null,
USER_ADDRESS varchar(200) default null,
USER_STATUS decimal(6,0) not null,
primary key('USER_ID')
)ENGINE=InnoDB default charset=utf8;
CREATE TABLE IF NOT EXISTS `LmonkeyUser`(
USER_ID varchar(32) not null,
USER_NAME varchar(32) not null,
USER_PASSWORD varchar(20) not null,
USER_SEX varchar(1) not null,
USER_BIRTHDAY datetime default null,
USER_IDENITY_CODE varchar(60) default null,
USER_EMAIL varchar(60) default null,
USER_PHONE varchar(11) default null,
USER_ADDRESS varchar(200) default null,
USER_STATUS decimal(6,0) not null,
PRIMARY KEY ( `USER_ID` )
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `Lmonkey_category`(
CATE_ID INT(10) not null AUTO_INCREMENT,
CATE_NAME varchar(32) not null,
CATE_PARENT_ID decimal(10,0) not null,
PRIMARY KEY ( `CATE_ID` )
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `lmonkey_product`(
PRODUCT_ID int(10) not null AUTO_INCREMENT,
PRODUCT_NAME varchar(128) not null,
PRODUCT_DESCRIPTION varchar(512) default null,
PRODUCT_PRICE decimal(10,2) not null,
PRODUCT_STOCK decimal(10,2) default null,
PRODUCT_FID decimal(10,2) default null,
PRODUCT_CID decimal(10,2) default null,
PRODUCT_FILENAME varchar(200) default null,
PRIMARY KEY ( `PRODUCT_ID` )
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
//图像拼接数据库
CREATE TABLE IF NOT EXISTS `IMAGESTICHING`(
IMAGE_ID int(10) not null AUTO_INCREMENT,
IMAGE_ONE_FILE varchar(100) not null,
IMAGE_ONE_DESCRIPTION varchar(200) default null,
IMAGE_TWO_FILE varchar(100) not null,
IMAGE_TWO_DESCRIPTION varchar(200) default null,
IMAGE_RESULT varchar(200) default null,
PRIMARY KEY ( `IMAGE_ID` )
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
Back
|
FazBrowse Home
|
New Git URL