• Home
• com.jaxio.celerio
• bootstrap-maven-plugin
• 4.0.16
• source code
• 03-import.sql

×

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.

sqlconf.books-without-hibernate-search.03-import.sql Maven / Gradle / Ivy

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');

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);

INSERT INTO ROLE (role_name) VALUES ('ROLE_ADMIN');
INSERT INTO ROLE (role_name) VALUES ('ROLE_USER');
INSERT INTO ROLE (role_name) VALUES ('ROLE_MONITORING');

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);
INSERT INTO ACCOUNT_ROLE (account_id, role_id) VALUES ('000000000000000000000000000000000002', 2);
INSERT INTO ACCOUNT_ROLE (account_id, role_id) VALUES ('000000000000000000000000000000000003', 2);

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);

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);

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');