File: /home/velceapa/.mysql_history
use velceapa_crm;
LOAD DATA INFILE '/home/velceapa/crm.velcea-partners.ro/csv_data_import/data.csv'
INTO TABLE crm
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\n'
;
LOAD DATA INFILE '/home/velceapa/crm.velcea-partners.ro/csv_data_import/data.csv' INTO TABLE crm FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n';
SHOW VARIABLES LIKE 'secure_file_priv';
LOAD DATA LOCAL INFILE '/home/velceapa/crm.velcea-partners.ro/csv_data_import/data.csv'
INTO TABLE crm
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\n'
;
LOAD DATA LOCAL INFILE '/home/velceapa/crm.velcea-partners.ro/csv_data_import/data.csv' INTO TABLE crm FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n';
exit;
showt DATABASES;
use velceapa_faststart;
CREATE TABLE grants (
id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
html TEXT NOT NULL,
form VARCHAR(500) NOT NULL,
created_at TIMESTAMP NULL DEFAULT NULL,
updated_at TIMESTAMP NULL DEFAULT NULL
);
CREATE TABLE grants ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255) NOT NULL, html TEXT NOT NULL, form VARCHAR(500) NOT NULL, created_at TIMESTAMP NULL DEFAULT NULL, updated_at TIMESTAMP NULL DEFAULT NULL );
CREATE TABLE leads_velceaasociatii (
id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
phone VARCHAR(50) NOT NULL,
email VARCHAR(255) NOT NULL,
descr TEXT NOT NULL COMMENT 'Problem description',
timp TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
created_at TIMESTAMP NULL DEFAULT NULL,
updated_at TIMESTAMP NULL DEFAULT NULL
);
CREATE TABLE leads_velceaasociatii ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255) NOT NULL, phone VARCHAR(50) NOT NULL, email VARCHAR(255) NOT NULL, descr TEXT NOT NULL COMMENT 'Problem description', timp TIMESTAMP DEFAULT CURRENT_TIMESTAMP, created_at TIMESTAMP NULL DEFAULT NULL, updated_at TIMESTAMP NULL DEFAULT NULL );
exit;
use velceapa_faststart
INSERT INTO grants (id, name, html, form, created_at, updated_at) VALUES
(13, 'Obtine 200.000 lei nerambursabili prin programul Femeia Antreprenor (2022-2026)', '<h1>Obtine 200.000 lei nerambursabili prin programul Femeia Antreprenor</h1><p>Obtine 200.000 lei nerambursabili prin programul Femeia Antreprenor (2022-2026)!</p><p>Buna ziua, Programul Femeia Antreprenor este destinat...</p>', 'https://your-form-url.com/form13', NOW(), NOW()),
(12, 'Obtine si tu o finantare nerambursabila de 200.000 lei prin programul START UP NATION (2022-2026)', '<h1>Obtine si tu o finantare nerambursabila de 200.000 lei</h1><p>Obtine si tu o finantare nerambursabila de 200.000 lei, prim programul START UP NATION (2022-2026)...</p>', 'https://your-form-url.com/form12', NOW(), NOW()),
(11, 'Schema de ajutor de minimis pentru sectorul cultural', '<h1>Schema de ajutor de minimis pentru sectorul cultural</h1><p>Ministerul Culturii a lansat pe 9 martie 2022, în consultare publică, Schema de ajutor de minimis...</p>', 'https://your-form-url.com/form11', NOW(), NOW()),
(10, 'Programul IMM Invest Romania', '<h1>Programul IMM Invest Romania</h1><p>Programul IMM Invest Romania!</p><p>Programul IMM INVEST ROMANIA permite IMM-urilor afectate semnificativ...</p>', 'https://your-form-url.com/form10', NOW(), NOW()),
(9, 'Granturi pentru digitalizarea IMM', '<h1>Granturi pentru digitalizarea IMM</h1><p>Granturi pentru Digitalizarea IMM!</p><p>Microîntreprinderile românești și firmele mici...</p>', 'https://your-form-url.com/form9', NOW(), NOW()),
(8, 'Electric UP', '<h1>Electric UP</h1><p>Grant-ul Electric UP!</p><p>Guvernul a adoptat programul "Electric Up", prin care IMM-urile...</p>', 'https://your-form-url.com/form8', NOW(), NOW()),
(7, 'Ajutor de stat HORECA', '<h1>Ajutor de stat HORECA</h1><p>Ajutor de stat HORECA!</p><p>Scopul schemei de ajutor: Scopul prezentei scheme de ajutor de stat este...</p>', 'https://your-form-url.com/form7', NOW(), NOW()),
(6, 'Granturi de maximum 25.000 euro pentru o noua afacere', '<h1>Granturi de maximum 25.000 euro pentru o noua afacere</h1><p>Granturi de maximum 25.000 euro pentru o noua afacere!</p><p>Va prezentam programul prin care puteti obtine...</p>', 'https://your-form-url.com/form6', NOW(), NOW()),
(5, 'POC 4.1.1', '<h1>POC 4.1.1</h1><p>Prin programul POC 4.1.1, puteti obtine o finantare nerambursabila de pana la 1.000.000 EUR...</p>', 'https://your-form-url.com/form5', NOW(), NOW()),
(4, 'START-UP NATION III - 200.000 lei nerambursabili', '<h1>START-UP NATION III - 200.000 lei nerambursabili</h1><p>Prin intermediul programului Start-up Nation România, antreprenorii care au înființat...</p>', 'https://your-form-url.com/form4', NOW(), NOW());
INSERT INTO grants (id, name, html, form, created_at, updated_at) VALUES (13, 'Obtine 200.000 lei nerambursabili prin programul Femeia Antreprenor (2022-2026)', '<h1>Obtine 200.000 lei nerambursabili prin programul Femeia Antreprenor</h1><p>Obtine 200.000 lei nerambursabili prin programul Femeia Antreprenor (2022-2026)!</p><p>Buna ziua, Programul Femeia Antreprenor este destinat...</p>', 'https://your-form-url.com/form13', NOW(), NOW()), (12, 'Obtine si tu o finantare nerambursabila de 200.000 lei prin programul START UP NATION (2022-2026)', '<h1>Obtine si tu o finantare nerambursabila de 200.000 lei</h1><p>Obtine si tu o finantare nerambursabila de 200.000 lei, prim programul START UP NATION (2022-2026)...</p>', 'https://your-form-url.com/form12', NOW(), NOW()), (11, 'Schema de ajutor de minimis pentru sectorul cultural', '<h1>Schema de ajutor de minimis pentru sectorul cultural</h1><p>Ministerul Culturii a lansat pe 9 martie 2022, în consultare publică, Schema de ajutor de minimis...</p>', 'https://your-form-url.com/form11', NOW(), NOW()), (10, 'Programul IMM Invest Romania', '<h1>Programul IMM Invest Romania</h1><p>Programul IMM Invest Romania!</p><p>Programul IMM INVEST ROMANIA permite IMM-urilor afectate semnificativ...</p>', 'https://your-form-url.com/form10', NOW(), NOW()), (9, 'Granturi pentru digitalizarea IMM', '<h1>Granturi pentru digitalizarea IMM</h1><p>Granturi pentru Digitalizarea IMM!</p><p>Microîntreprinderile românești și firmele mici...</p>', 'https://your-form-url.com/form9', NOW(), NOW()), (8, 'Electric UP', '<h1>Electric UP</h1><p>Grant-ul Electric UP!</p><p>Guvernul a adoptat programul "Electric Up", prin care IMM-urile...</p>', 'https://your-form-url.com/form8', NOW(), NOW()), (7, 'Ajutor de stat HORECA', '<h1>Ajutor de stat HORECA</h1><p>Ajutor de stat HORECA!</p><p>Scopul schemei de ajutor: Scopul prezentei scheme de ajutor de stat este...</p>', 'https://your-form-url.com/form7', NOW(), NOW()), (6, 'Granturi de maximum 25.000 euro pentru o noua afacere', '<h1>Granturi de maximum 25.000 euro pentru o noua afacere</h1><p>Granturi de maximum 25.000 euro pentru o noua afacere!</p><p>Va prezentam programul prin care puteti obtine...</p>', 'https://your-form-url.com/form6', NOW(), NOW()), (5, 'POC 4.1.1', '<h1>POC 4.1.1</h1><p>Prin programul POC 4.1.1, puteti obtine o finantare nerambursabila de pana la 1.000.000 EUR...</p>', 'https://your-form-url.com/form5', NOW(), NOW()), (4, 'START-UP NATION III - 200.000 lei nerambursabili', '<h1>START-UP NATION III - 200.000 lei nerambursabili</h1><p>Prin intermediul programului Start-up Nation România, antreprenorii care au înființat...</p>', 'https://your-form-url.com/form4', NOW(), NOW());
update grants set form = 'https://docs.google.com/forms/d/e/1FAIpQLSc7MavrwkN1dybsH09n-ap6fI5A2aSm4rpntohBFDrIZxxi_w/viewform';