• Home
• win.doyto
• doyto-query-test
• 2.0.0
• source code

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

to-query-test.2.0.0.source-code.doytowin.db Maven / Gradle / Ivy

SQLite format 3

@  >
>.f?


?
??E	??;?????
9+
?-indexa_perm_and_menu_uindexa_perm_and_menuCREATE UNIQUE INDEX a_perm_and_menu_uindex on a_perm_and_menu (perm_id, menu_id)l++
?tablea_perm_and_menua_perm_and_menu
CREATE TABLE a_perm_and_menu
(
    perm_id int,
    menu_id int
)?9+
?-indexa_role_and_perm_uindexa_role_and_permCREATE UNIQUE INDEX a_role_and_perm_uindex on a_role_and_perm (role_id, perm_id)l
++
?tablea_role_and_perma_role_and_permCREATE TABLE a_role_and_perm
(
    role_id int,
    perm_id int
)?;	
?Qtablet_permt_perm
CREATE TABLE t_perm
(
    id             integer primary key autoincrement,
    perm_name varchar(100)         not null,
    valid     boolean DEFAULT TRUE null
)?9+
?-indexa_user_and_role_uindexa_user_and_role	CREATE UNIQUE INDEX a_user_and_role_uindex on a_user_and_role (user_id, role_id)?++
?gtablea_user_and_rolea_user_and_roleCREATE TABLE a_user_and_role
(
    user_id        bigint,
    role_id        int,
    create_user_id bigint
)?>
?Wtablet_rolet_roleCREATE TABLE t_role
(
    id             integer primary key autoincrement,
    role_name      varchar(100)                        not null,
    role_code      varchar(100)                        not null,
    valid          boolean   DEFAULT TRUE,
    create_time    timestamp default (strftime('%Y-%m-%dT%H:%M:%f','now','localtime')),
    create_user_id bigint,
    update_time    timestamp,
    update_user_id bigint
)?+
?1tablet_menut_menuCREATE TABLE t_menu
(
    id             integer primary key autoincrement,
    platform       varchar(15),
    memo           varchar(255),
    menu_name      varchar(255),
    parent_id      integer,
    valid          boolean,
    create_time    timestamp default (strftime('%Y-%m-%dT%H:%M:%f','now','localtime')),
    create_user_id bigint,
    update_time    timestamp,
    update_user_id bigint
)?4
?7tablet_menu_01t_menu_01CREATE TABLE t_menu_01
(
    id             integer primary key autoincrement,
    platform       varchar(15),
    memo           varchar(255),
    menu_name      varchar(255),
    parent_id      integer,
    valid          boolean,
    create_time    timestamp default (strftime('%Y-%m-%dT%H:%M:%f','now','localtime')),
    create_user_id bigint,
    update_time    timestamp,
    update_user_id bigint
)?	''
?Qtablet_user_detailt_user_detailCREATE TABLE t_user_detail
(
    id      integer,
    address varchar(255),
    primary key (id)
)P++
Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)?#

?!tablet_usert_userCREATE TABLE t_user
(
    id             integer primary key autoincrement,
    email          varchar(255),
    mobile         varchar(255),
    nickname       varchar(255),
    password       varchar(255),
    user_level     varchar(255),
    username       varchar(255),
    memo           varchar(255),
    valid          boolean   default true,
    create_time    timestamp default (strftime('%Y-%m-%dT%H:%M:%f','now','localtime')),
    create_user_id bigint,
    update_time    timestamp,
    update_user_id bigint
)
??U??U%#	;
[email protected]测试4123456普通user42023-06-24T14:57:20.909Y%#	;
[email protected]测试3123456普通user3memo2023-06-24T14:57:20.893T%#;	[email protected]测试2123456普通user22023-06-24T14:57:20.881S
%#	;	[email protected]测试1123456高级f0rb2023-06-24T14:57:20.860
??????

t_perm

t_role

t_menu

t_menu_01


t_user

???3!		;01first menufirst2023-06-24T14:57:20.9301
	;01root menuroot2023-06-24T14:57:20.918
???3??K	
?
?
<??J;)
;00Menu for Permission Op3Permission Op32023-06-24T14:57:21.025J;)
	;00Menu for Permission Op2Permission Op22023-06-24T14:57:21.017J
;)
	;00Menu for Permission Op1Permission Op12023-06-24T14:57:21.0101		;02root menuroot2023-06-24T14:57:21.004L=+
	;00Menu for Permission ListPermission List2023-06-24T14:57:20.995@1
	;00Menu for Role ListRole List2023-06-24T14:57:20.987@1
	;00Menu for User ListUser List2023-06-24T14:57:20.980K=+		;00Menu for Menu ManagementMenu Management2023-06-24T14:57:20.972WI7		;00Menu for Permission ManagementPermission Management2023-06-24T14:57:20.964K=+		;00Menu for Role ManagementRole Management2023-06-24T14:57:20.957K=+		;00Menu for User ManagementUser Management2023-06-24T14:57:20.9491
	;00root menuroot2023-06-24T14:57:20.939
,???V,(		;vip4VIP42023-06-24T14:57:21.068(		;vip3VIP32023-06-24T14:57:21.055)		;
vip2VIP22023-06-24T14:57:21.047'		;
vipVIP2023-06-24T14:57:21.040*
		;	adminADMIN2023-06-24T14:57:21.032
??????


	
		

		
??????



	

	
	

			
???????
	perm:list
	role:list#	user:delete#	user:update	user:get

	user:list
????????


	





	

		
????????



	









	

			
	??????????	




	




		
	

		
	??????????