sqlconf.books.03-import.sql Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of bootstrap-maven-plugin Show documentation
Show all versions of bootstrap-maven-plugin Show documentation
The Bootstrap Maven plugin is responsible for bootstrapping a project out of template packs
-- create addresses for accounts
INSERT INTO ADDRESS (street_name, city) values('Avenue des champs Elysées', 'Paris');
INSERT INTO ADDRESS (street_name, city) values('Park avenue', 'New-York');
INSERT INTO ADDRESS (street_name, city) values('Tochomae', 'Tokyo');
INSERT INTO ADDRESS (street_name, city) values('California Street', 'San Francisco');
-- create dummy accounts
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000001', 'admin', 'admin', '[email protected]', true, 1);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000002', 'user', 'user', '[email protected]', true, 2);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000003', 'demo', 'demo', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000004', 'user04', 'user04', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000005', 'user05', 'user05', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000006', 'user06', 'user06', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000007', 'user07', 'user07', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000008', 'user08', 'user08', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000009', 'user09', 'user09', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000010', 'user10', 'user10', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000011', 'user11', 'user11', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000012', 'user12', 'user12', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000013', 'user13', 'user13', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000014', 'user14', 'user14', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000015', 'user15', 'user15', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000016', 'user16', 'user16', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000017', 'user17', 'user17', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000018', 'user18', 'user18', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000019', 'user19', 'user19', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000020', 'user20', 'user20', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000021', 'user21', 'user21', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000022', 'user22', 'user22', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000023', 'user23', 'user23', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000024', 'user24', 'user24', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000025', 'user25', 'user25', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000026', 'user26', 'user26', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000027', 'user27', 'user27', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000028', 'user28', 'user28', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000029', 'user29', 'user29', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000030', 'user30', 'user30', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000031', 'user31', 'user31', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000032', 'user32', 'user32', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000033', 'user33', 'user33', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000034', 'user34', 'user34', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000035', 'user35', 'user35', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000036', 'user36', 'user36', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000037', 'user37', 'user37', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000038', 'user38', 'user38', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000039', 'user39', 'user39', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000040', 'user40', 'user40', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000041', 'user41', 'user41', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000042', 'user42', 'user42', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000043', 'user43', 'user43', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000044', 'user44', 'user44', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000045', 'user45', 'user45', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000046', 'user46', 'user46', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000047', 'user47', 'user47', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000048', 'user48', 'user48', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000049', 'user49', 'user49', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000050', 'user50', 'user50', '[email protected]', true, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, address_id) VALUES ('000000000000000000000000000000000051', 'disabled', 'disabled', '[email protected]', false, 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, civility, address_id) VALUES ('000000000000000000000000000000000052', 'homer', 'homer', '[email protected]', true, 'MR', 3);
INSERT INTO ACCOUNT (id, login, password, email, is_enabled, civility, address_id) VALUES ('000000000000000000000000000000000053', 'maggy', 'maggy', '[email protected]', true, 'MS', 3);
-- define available roles
INSERT INTO ROLE (role_name) VALUES ('ROLE_ADMIN');
INSERT INTO ROLE (role_name) VALUES ('ROLE_USER');
INSERT INTO ROLE (role_name) VALUES ('ROLE_MONITORING');
-- admin has admin, user and monitoring roles
INSERT INTO ACCOUNT_ROLE (account_id, role_id) VALUES ('000000000000000000000000000000000001', 1);
INSERT INTO ACCOUNT_ROLE (account_id, role_id) VALUES ('000000000000000000000000000000000001', 2);
INSERT INTO ACCOUNT_ROLE (account_id, role_id) VALUES ('000000000000000000000000000000000001', 3);
-- user has user role
INSERT INTO ACCOUNT_ROLE (account_id, role_id) VALUES ('000000000000000000000000000000000002', 2);
-- demo has user role
INSERT INTO ACCOUNT_ROLE (account_id, role_id) VALUES ('000000000000000000000000000000000003', 2);
-- books for admin
INSERT INTO BOOK(account_id, title, number_of_pages) VALUES ('000000000000000000000000000000000001', 'Prime Faces User Guide' , 444);
INSERT INTO BOOK(account_id, title, number_of_pages) VALUES ('000000000000000000000000000000000001', 'Spring Web Flow Reference Guide', 108);
INSERT INTO BOOK(account_id, title, number_of_pages) VALUES ('000000000000000000000000000000000001', 'Spring 3.0 Reference Documentation', 770);
INSERT INTO BOOK(account_id, title, number_of_pages) VALUES ('000000000000000000000000000000000001', 'Java Persistence with Hibernate', 880);
INSERT INTO BOOK(account_id, title, number_of_pages) VALUES ('000000000000000000000000000000000001', 'Effective Java' , 350);
-- books for user
INSERT INTO BOOK(account_id, title, number_of_pages) VALUES ('000000000000000000000000000000000002', 'How to create a web app' , 100);
INSERT INTO BOOK(account_id, title, number_of_pages) VALUES ('000000000000000000000000000000000002', 'How to deal with large projects' , 544);
INSERT INTO BOOK(account_id, title, number_of_pages) VALUES ('000000000000000000000000000000000002', 'How to speed up project dev?' , 453);
-- books for demo
INSERT INTO BOOK(account_id, title, number_of_pages) VALUES ('000000000000000000000000000000000003', 'Complete history of the universe' , 9809900);
INSERT INTO BOOK(account_id, title, number_of_pages) VALUES ('000000000000000000000000000000000003', 'The Solar System' , 800);
INSERT INTO BOOK(account_id, title, number_of_pages) VALUES ('000000000000000000000000000000000003', 'The Rolling Stones' , 1800);
INSERT INTO LEGACY (name, code, dept, extra_info) VALUES ('name1', 'code1', 1, 'extra1');
INSERT INTO LEGACY (name, code, dept, extra_info) VALUES ('name2', 'code2', 2, 'extra2');
INSERT INTO LEGACY (name, code, dept, extra_info) VALUES ('name3', 'code3', 3, 'extra3');
INSERT INTO LEGACY (name, code, dept, extra_info) VALUES ('name4', 'code4', 4, 'extra4');
© 2015 - 2024 Weber Informatics LLC | Privacy Policy