-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathLibraryCryptData.sql
More file actions
25 lines (25 loc) · 18.7 KB
/
Copy pathLibraryCryptData.sql
File metadata and controls
25 lines (25 loc) · 18.7 KB
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
USE [LibraryCrypt]
GO
INSERT [dbo].[Book] ([Id], [Name], [Author], [Quantity], [KindOfBook]) VALUES (N'+gS4dL5mLEafJ9B6tYmsVw==', N'MwHJkzTbvIiExugefBYUVA==', N'NMcbmmyDeIO0fkcGEgAjnQ==', N'F1/QHlnCawwY/I7vNE5E9g==', N'amFgidG8lI9TQBZJTE40rA==')
INSERT [dbo].[Book] ([Id], [Name], [Author], [Quantity], [KindOfBook]) VALUES (N'A3xXsDWbTaoH6bUD2A4oeg==', N'ROi5GDWaFsp9xON52A4kHQ==', N'FTf3hehzELWPLMn+I6Xwdw==', N'c9aYOwPkx0akCpdcE9Q5xw==', N's5oDg4mogQ9wTAVCkiZxEw==')
INSERT [dbo].[Book] ([Id], [Name], [Author], [Quantity], [KindOfBook]) VALUES (N'e8eC6yb6e87QWKWMWW7MFA==', N'Kp5mZ3YQFBKX46MVjgcBfw==', N'KGAwoPftlG+qCjuAS0ujuw==', N'7GmpemCMNN18eAYpivH1Eg==', N'VsjR7FNhCPbFJHISmRZlQQ==')
GO
INSERT [dbo].[LibStaff] ([Id], [FullName], [Gender], [Dob], [Address], [License], [PhoneNumber], [Gmail], [StartWorkDate], [Position], [BasicSalary], [SalaryBonus], [Penalty], [ActualSalary]) VALUES (N'6czsYKrEC6ut5jyxRFNiMw==', N'w4k8N6sQBKSYwfRDjuBMrg==', N'axL/ZLKYi3FPWD9cQWDN7g==', N'Avy19hN2cv8pVCp5i6mOHQ==', N'MR8C1Wfy5TqZxPvXCMEsRA==', N'd/ILf8MpSg2U2WL9a/xD5w==', N'CbJBVj/88FSeoL3mhEDHYg==', N'w370DrkinpnN9F0aCEpFjg==', N'f6Al0tHzaX40ELNdn6QoEA==', N'wsoKH7lO8VlfixHML45BdQ==', N'df5QAi4Y/7pycM0BX/M7XQ==', N'WINiOr9Ri9Qh8x4/E/U2qg==', N'Vj8iE+ljEoVMNQt6LT6Jcw==', N'VMGCkwwGfq8p5VYr1YgGnQ==')
INSERT [dbo].[LibStaff] ([Id], [FullName], [Gender], [Dob], [Address], [License], [PhoneNumber], [Gmail], [StartWorkDate], [Position], [BasicSalary], [SalaryBonus], [Penalty], [ActualSalary]) VALUES (N'gDwedA2/9VtJFsraxibuQQ==', N'GoU/nkgsf4pI1doauEjNSA==', N'axL/ZLKYi3FPWD9cQWDN7g==', N'omXHYgbBKeBUGyH68uygrQ==', N'JglKxa48SMIVSli5iICueQ==', N'p0/GUNd5IhRoFV1Rp1kuXA==', N'MGLT4S9njRPVjJG6T4GINw==', N'rfubXBxKos1ODtjLnFq/Iw==', N'qbL+mL3Bn/rr3SkioBF+vw==', N'QkJz+mDoSaHziXxlp1PS1Q==', N'IGz7xDlqVuQVYlSmWTGF4w==', N'muDUK5O7VVdE05LNFSnXkg==', N'Vj8iE+ljEoVMNQt6LT6Jcw==', N'ozw2wlJiOOKM8wVXKq+Blg==')
INSERT [dbo].[LibStaff] ([Id], [FullName], [Gender], [Dob], [Address], [License], [PhoneNumber], [Gmail], [StartWorkDate], [Position], [BasicSalary], [SalaryBonus], [Penalty], [ActualSalary]) VALUES (N'gTDZRuIl2wdoWc/SY8bGXg==', N'VX9t7/UcivxgwAh3twmxbQ==', N'Vjh9nujm1vmAiodPheVs1w==', N'rsCU1mVXt5QovGztt71E0Q==', N'J0kTbUHXCEFSxcsdj137Nw==', N'vaL2Dl2yOfcD+HMbf0VMCQ==', N'Q39MImmaIz+jbzNwXfcU2Q==', N'QAkel6MroUlKKsfXEYjzYg==', N'0rFaXFbT6WLodqBQGE4MAA==', N'gHdYcUmvTwby/fJtCctPBg==', N'c8FiwIXgP8HjyI10c2mOCA==', N'mP0cFNtx2su0OxYQ25sChw==', N'81vwG0fkSlcHniF4pObqXw==', N'TBpDOKJOm9/RWB8jWklr3Q==')
GO
INSERT [dbo].[Reader] ([Id], [FullName], [Gender], [Dob], [Address], [License], [PhoneNumber], [Gmail], [KindOfReader], [StartDate], [endDate]) VALUES (N'/wdqYTECLt43o+OjpHNwBA==', N'Z0djzZFjGlMXMHX8QE0RWA==', N'Vjh9nujm1vmAiodPheVs1w==', N'qyLRYrMrOgCjKZSD6s1K6A==', N'J0kTbUHXCEFSxcsdj137Nw==', N'zmKYYZqwSU6Tj+EOAPXGuA==', N'TzbBTkMcEv7DDo7qrDfhjA==', N'RjmILasnNfnZ6gZI4e+nqw==', N'DvrDDRl9qQqyo9ZchCYv0g==', CAST(N'2021-12-10' AS Date), CAST(N'2022-01-05' AS Date))
INSERT [dbo].[Reader] ([Id], [FullName], [Gender], [Dob], [Address], [License], [PhoneNumber], [Gmail], [KindOfReader], [StartDate], [endDate]) VALUES (N'5C5+Tcl3IxG1QdSFEzSXsw==', N'9uc4pn3qTTHjBeuakIa9Nw==', N'Vjh9nujm1vmAiodPheVs1w==', N'YWXv6zHMRVWzl05WcyHzPg==', N'J0kTbUHXCEFSxcsdj137Nw==', N'WEHwR/bPTuE4PnJ3zyNZag==', N'Qe8ECNFr2jb8K1VnhltVWA==', N'zn9YvuvIzC6VZybbGuGMxg==', N'DvrDDRl9qQqyo9ZchCYv0g==', CAST(N'2021-11-10' AS Date), CAST(N'2021-11-27' AS Date))
INSERT [dbo].[Reader] ([Id], [FullName], [Gender], [Dob], [Address], [License], [PhoneNumber], [Gmail], [KindOfReader], [StartDate], [endDate]) VALUES (N'GCS2rLgntF9BMKtlO64ZhQ==', N'dvm8im0xrylgyLkDDhtNAQ==', N'axL/ZLKYi3FPWD9cQWDN7g==', N'indBxaUlKz29pR/OkVG+Yw==', N'JglKxa48SMIVSli5iICueQ==', N'OQBMVe7+qMFr4rBsKgIeRw==', N'J4lgSZ0XyX3eEOIcCyEcpQ==', N'O0HCkXGPXvEFSOv/+ceDsQ==', N'IOVgJUzM9OHk2kC33Wd+2g==', CAST(N'2021-12-10' AS Date), CAST(N'2022-01-05' AS Date))
GO
INSERT [dbo].[RentalInformation] ([Id], [ReaderId], [BookId], [LibStaffId], [BookBorrowDate], [BookReturnDate], [Note]) VALUES (N'+gS4dL5mLEafJ9B6tYmsVw==', N'5C5+Tcl3IxG1QdSFEzSXsw==', N'A3xXsDWbTaoH6bUD2A4oeg==', N'gTDZRuIl2wdoWc/SY8bGXg==', CAST(N'2022-10-10' AS Date), CAST(N'2022-10-30' AS Date), NULL)
INSERT [dbo].[RentalInformation] ([Id], [ReaderId], [BookId], [LibStaffId], [BookBorrowDate], [BookReturnDate], [Note]) VALUES (N'A3xXsDWbTaoH6bUD2A4oeg==', N'GCS2rLgntF9BMKtlO64ZhQ==', N'e8eC6yb6e87QWKWMWW7MFA==', N'gTDZRuIl2wdoWc/SY8bGXg==', CAST(N'2022-10-20' AS Date), CAST(N'2022-11-10' AS Date), N'kb6Gz+Gw+TdszHiJUh4BFw==')
INSERT [dbo].[RentalInformation] ([Id], [ReaderId], [BookId], [LibStaffId], [BookBorrowDate], [BookReturnDate], [Note]) VALUES (N'e8eC6yb6e87QWKWMWW7MFA==', N'/wdqYTECLt43o+OjpHNwBA==', N'+gS4dL5mLEafJ9B6tYmsVw==', N'gTDZRuIl2wdoWc/SY8bGXg==', CAST(N'2021-10-10' AS Date), CAST(N'2021-11-10' AS Date), N'cD57nIzvE2YGRDQxPsGlAw==')
GO
INSERT [dbo].[Account] ([UserName], [Password]) VALUES (N'/wdqYTECLt43o+OjpHNwBA==', N'cFR6uoBi2ToX0Bsvsngy7240g4v5GeONXSDnAAquJtGhefHWW9L1AlWzDYGzITCuP7i7B84OdrkSJCDenSIdEQfcvufULrFUrK0bDFM/BR17HvYbjNN0zmcnUGMx9A7xNz3qs5MfpjYKj4AF0S0RkPaiQlCJmr+8Iw7aqwfXdIZMBAjWkvDZfl6sCAYQC9UT7vYNwLATt0iMfZT84vgV2ciZZZhsOiaJlDkquELw7GFPJawIZaHZUhILlazjo/VXrTRnHax1rtpeV4e8ttGU7qGXjDff6P7lVFudP5tbtw+cupvMJ16LvXS+8uSSZbLJR1UaXCqXsWzRBGwPG4vf4kPBUfFRRzSFkgG7zX74PHvIT2/0bfsx+bwsLGO6lA15RAC2NgmsRAmCvQFwybr+nlVTkjFgxdfZnLa77HMdpaiu4XJZT/zlxSlAb7vzTxh/nxheofB/AMOuDgml+TXjkIieB8TYvC3YHfBiIOAdimNxz2x+3r0rtGlbWcUySTjxG7m58Iz8xV5tdRKzPZTIBr1um9d3J66SilQJW+UMZiMJmxIJ9oElah2MQbEt2dNuN6HkyaOxBizSINtRzo/REm8qoLDbYsKKrDLmvLLqpunQghjVmPVJ9iRLyjm77fCoOCJNXRBD9iCu41lzRf9UzJBlUFnl7xPRMyxM1Z0pw18=')
INSERT [dbo].[Account] ([UserName], [Password]) VALUES (N'5C5+Tcl3IxG1QdSFEzSXsw==', N'IhEQ8ktJLjuQc8UWbVKYzCvO19zV/Re20l3ZVsfhUjG5841C8FXa2OlmPx8CSUpC8ytLRqcbNG7DGwY75eWdtYtpCHyhwVDXXDDoGWv89V+Lq9yyL0LRfXl5wYHowRoWu6ReKdDv1n3v+Ob2tN2DhQ8HQ47AN2GFRR4pYLHpz4/JJbBMSdZhFN6bZE7lWlgYxYm2+E8zdePEXdZ0GCrXoOimdRSmARXoEN5mns5MSL61FTs4dCDd4Ivuw0IGXECtYhnFA8T3xaO8JB/1yr98eT6a23XcseoLmjjPPvL5i481AiUpaFZOmgeNiXMiBjk7e2CkfnNMiEdK8C4/eHW4UCsqbC33zqccJAfqVGVwkJpgboh6UsvraWpcyjrUoX44jCnp3cNcERz6UMHnwCV7MLcQPHj8AoRM0xg+ruuPbu8blGrHzWJqJwwmJbvjNQUpHtfv5iHhh2JEBD02lI9Zk9rDkfaI98CNAe+bqW6Oy2d/6SKY+CoH4vqF77Wu2BFIvMvIP2buSRQj/UmNW8PfpopTIgIM4pPKefS+1IeMTxQsMRv4n9LIIbUKLxXXOj5bM8VZ2Y6GkaPdpPeVMRnNF2FTs2qc3361M/6CtzUQqPLUto6wfIAnm6lCXQxo14bMq/UwxOCw8CoWaRyTVuvDXm2kXxVgzVou9xPFFBHwXK4=')
INSERT [dbo].[Account] ([UserName], [Password]) VALUES (N'6czsYKrEC6ut5jyxRFNiMw==', N'evs2IV2mTKjB9Xw6xYfH34uf9Lwzuok0s5p94D0yBH72Km9QI9mVU56L4iHwDmXvG+tt5JATgAoDcyb2ZfjnzvoHTsd3lfm3eEB2RTtTCZg0F0s75l0KzlUVHow2Cv62q1PqjyGW4Gm6ZHHWTsoZKj6Yb5JjQqkCflWqLnNH0f4+53NfLs6JBQ7uzDUXoSdx7W2kw2+f+2ifYWIG3R1hdX8rGV/U2EcK+LFKngpEHGDpNrnE4jyyHCLX4HiIzMQ7kunyg9BUEe7vqXJ3BbGyvHpUtJpMvIH4Xmx+pFucGR1YCeBDAXB2kgaIKDztq9gXM3/J7CI0XUs9XtBGV0Yk+kbOBZHCYGUIs6KtlAOq9+C7Rfi6YzFHQ7gfbWhK78h3E1TdzvS6HMOyJ5WcsyI10d15SH0kUqYfcrkPg5TZk3AsulKXycvfgYZE8LIywr2zFybiXpDx/q/BXyQ7KOZTgb160WsI+OFEVaP+jrPmlvtWf0fJkpCrSN+dS9DYeEb+Bvpz6OOPp/riLd234WPOVrk4JwtpiQlcDKNndWRXF5VF2pGw3/K+fNMim/DUx+f5h5VWfvlRApwO/I30VA0c/cbc0pHVyMZD5rndbu3Z5uMXAb34JyYakEXiuXyddq7vlnTKU88q4kZgJNNhkVXErjZ1AUd/2Ygb0KTH0UK+OVY=')
INSERT [dbo].[Account] ([UserName], [Password]) VALUES (N'GCS2rLgntF9BMKtlO64ZhQ==', N'Bp/hfj1ElD4Z7Xhk3DbWq4+nwtETi1QwpU2umbHVo1G3CBicx10lmYMazf4GIa8xCNSN0rgocQFlXJLqYO/8pNIDJEEmbaNmv5ZOPtuRrTuIY4zko3rWaWzHzf0ChXKkDlDsQdVFoFnawbpIAK1JK2RGdimxXtVflbuVxwD0Mx+mU3a//MuxKb4VADP+nY0rqsYHQSmrs0MqkXGoCrnnwfUeFRT3OLFN+gc25o70KCSKe4+cyNH9/lk1t4U0WGUqfevqoDbroeJy3ixvRB/bH7WNm+tqj1epIaDhRwRcOM4cOJBUgtjA3wErmz1tqY7dSmaK/GVyGsdopq2VFNZD4pyBwauS7g9FvuZmX/dxigaDjWz+5a+lCEooye0U/Zai4XUi73nFllOcXy+vLZWfaSD+zulWdm1HlhgnH9exo2YK5whlAjGS8aGJ3t73RJx620pTiSZfM5ANaMdtg+ka+smBiPwyG9ltGJaGwtY1V6uHMNpcQDkUDhyyuTvzYI64L1iz34rX0qZW2k4AxCFrF2JkSv3S7GsI3A5qgpXUREp4CwMoMv3WMGGNqlAG0Ed/4Ich6Zd2GaatmMeFMZU+rBBAQ84DU1A1rer4bNBDWdr6g3R9iP4Sdau7oDOTOapn93qZIeuaoB7JJeH7Rf9ziZ/7nFAyoSKEPXmBS2UcS+A=')
INSERT [dbo].[Account] ([UserName], [Password]) VALUES (N'gDwedA2/9VtJFsraxibuQQ==', N'O3oZtlNqu6pM0AJUn6t8q0rBz9Z4uD9FVpl5CPW0O3WokJ6tNNpGHWrxEgoyuoZjY8Lv9Y4LZGaWpPuyqwR5tptmLqeOsv6WIPCo1/XtE/jl3dlzyVwUOHTiaCxTu4A7E7MOfXdidgvNXs69Ssj5R9jZ6be9Pj6ktITzFSkn//zS7XKAhr4PpxUy1ksbLtjyA+qYpmP1P1w7deKoYNisw4u/id4iQrnrtIJLjee7OsLmidDH8b4llmT6z8jALKJuo5C/o70+ECtM89KSU85JHsMU7YBAQp7mlDNbGSgJW+D46NIi/j/rHnggnvDSFBNRYJFkqsqbRQQxJW/WQtQUlQxdlGUjJioXTu/t5cWEACVXVCiPN46dxPJ9QufIH/fC7EDjiu6idrBydDSlroSaipcfYTBQbQeGAJ9RN/zWJ+l94Mgzu64ApbHatbCuDRb0Xs/wKB4aaziLKsvwxL1Pa/cT6VtDBcJ6VHVLdhAsg7+i/FNXYUptj5QkN3O3OjOIOcUWbU53BIANfdX1tyUQmNovnd1DFILN667UVoj33Ejolvew9D8WRyeqJWYSL0oET6yq2uzdIIpL0WrlpC8ok48IdQMltAPvPbBUxWqznC3vJF7keurEaz4YXOGPBrXXNv2HRBf6ZI6YgRdfAjeiNNhhhWA9ne5ZZJaz1KWEcwU=')
INSERT [dbo].[Account] ([UserName], [Password]) VALUES (N'gTDZRuIl2wdoWc/SY8bGXg==', N'IIBWdbpwpeof7GxhhlCJdAglDW4m8YY3XQPfxXsWqN034/hWDndWlrpe6qz0bmo942gxaPMyoHSwZj00cRaj6wynzhxB6Z7KQuWry+ufTs1NtjUEikiWCyCUtN41US5kTOKqRLN61+EdOzWu6N/EOXq9u+n7DrtNunwRI9pXpCcg1EDnaNO8fI3wXG4ZGXFA9xKbB33+iwGM7vgYoRNGZeXW8RSUw7X8YgU9s5iZsoX0x1Nhdd2zt+OSH0xk+WvxAlsDKY8V7zIotTZAmKm90Urv1KCuUYlFvVbsJRdvJWeluP7nTu7BWiD+Af/9cWxTkSruU09Vix4QsqW8vIphpJTMj0my37lRnNGXSrQab7IE7aM4H+wwlp7ZkZ+XVqSfeWiel74XiMtEshCN7/cNpiaozryFoAdFzg+By6dionZFAx0xZ9sKkeavMN923O8PKAQCl3+9gzuAL/iB3kbfCEqhrJ7p2hiPVAwVqCgvcMnP2pP6SNk7X+2eLx6UJ9Z3AYWITxVmgWScjN9STZIksIoexVF3iKn3r3bGLbGcTQsXDdUaDNSIsGNuozF3hL77fHPTqaEdup35bQ3rqXnVpVFgmsEbww8oopZ9KzvZkK0yiv54SWLJJx+1C9oXVLraIC4crBEDuW4urQEVEQ39+Z12fENlWs2H1JwpWuzk2DA=')
GO