ALTER TABLE salary ALTER COLUMN salary_date SET DEFAULT current_date;
ALTER TABLE salary
ADD CONSTRAINT FK_Salary_Employee_ID FOREIGN KEY(employee_id)
REFERENCES EMPLOYEE(employee_id)
ON UPDATE CASCADE
ON DELETE CASCADESELECT
DATE_FORMAT(FROM_UNIXTIME(`VisitTime`), '%Y-%m-%d %H:00:00') AS visit_time,
COUNT(DISTINCT `MacValue`) AS mac_cnt
FROM `point`
GROUP BY 1;$('.popup-button').on('click', function () {
$('.popup-thanks').fadeIn(),
$('.popup-callback').fadeOut();
});$('.popup-thanks').fadeIn(),
$('.popup-callback').fadeOut();$('.popup-button').on('click', function () {
if (
// проверка заполнения имени
$(".popup-input-name").val().length > 1 &&
// проверка корректного заполнения телефона
/^\+?7[ -]?\(?\d{3}\)?[ -]?\d{3}[ -]?\d{2}[ -]?\d{2}$/.test( $(".popup-input-phone").val() ) &&
// проверка корректного заполнения e-mail
/^[a-z0-9\-\.]+@[a-z0-9\-\.]+\.[a-z]+$/i.test( $(".popup-input-mail").val() )
) {
$('.popup-thanks').fadeIn(),
$('.popup-callback').fadeOut();
} else {
alert ("Просьба корректно заполнить поля формы");
}
});
SELECT t1.*
FROM primary_tbl t1
LEFT JOIN second_tbl t2 ON t2.pid=t1.id
WHERE t2.pid IS NULL
AND t1.key='file_name'$(".string_block:not(.row):nth-child(2n)").wrapAll("<div class='row' />");$(".string_block:not(.row):nth-child(even)").wrapAll("<div class='row' />");SELECT *
FROM setting_salue sv
JOIN setting s ON s.id = sv.setting_id
WHERE (sv.domain_id = DOMAIN_ID OR sv.domain_id IS NULL)
AND (sv.language_id = LANG_ID OR sv.language_id IS NULL)insmod png
background_image /grub/splash.png### поиск раздела с grub
insmod part_msdos
insmod ext2
set root='hd0,msdos1'
if [ x$feature_platform_search_hint = xy ]; then
search --no-floppy --fs-uuid --set=root --hint-bios=hd0,msdos1 --hint-efi=hd0,msdos1 --hint-baremetal=ahci0,msdos1 UUID=b5b64681-55f6-4345-8a96-c5704d4549fd
else
search --no-floppy --fs-uuid --set=root b5b64681-55f6-4345-8a96-c5704d4549fd
fi
### включение графического режима и загрузка фоновой картинки
if loadfont /grub/fonts/unicode.pf2 ; then
set gfxmode="640x480"
insmod gfxterm
insmod vbe
terminal_output gfxterm
if terminal_output gfxterm; then true ; else
terminal gfxterm
fi
# фоновая картинка
insmod png
background_image -m stretch /grub/splash.png
fi
###set default="0"
set timeout=10
set timeout_style=menu
set menu_color_normal=white/black
set menu_color_highlight=black/light-gray
### поиск раздела с grub
insmod part_msdos
insmod ext2
set root='hd0,msdos1'
if [ x$feature_platform_search_hint = xy ]; then
search --no-floppy --fs-uuid --set=root --hint-bios=hd0,msdos1 --hint-efi=hd0,msdos1 --hint-baremetal=ahci0,msdos1 UUID=b5b64681-55f6-4345-8a96-c5704d4549fd
else
search --no-floppy --fs-uuid --set=root b5b64681-55f6-4345-8a96-c5704d4549fd
fi
### включение графического режима и загрузка фоновой картинки
if loadfont /grub/fonts/unicode.pf2 ; then
set gfxmode="640x480"
insmod gfxterm
insmod vbe
terminal_output gfxterm
if terminal_output gfxterm; then true ; else
terminal gfxterm
fi
# фоновая картинка
insmod png
background_image -m stretch /grub/splash.png
fi
###
menuentry 'Red Hat Enterprise Linux ES (2.6.9-5.ELsmp)' --class gnu-linux --class gnu --class os {
insmod ext2
set root='hd0,msdos1'
linux /vmlinuz-2.6.9-5.ELsmp ro root=/dev/sda6 quiet
initrd /initrd-2.6.9-5.ELsmp.img
}
menuentry 'Red Hat Enterprise Linux ES-up (2.6.9-5.EL)' --class gnu-linux --class gnu --class os {
insmod ext2
set root='hd0,msdos1'
linux /vmlinuz-2.6.9-5.EL ro root=/dev/sda6 quiet
initrd /initrd-2.6.9-5.EL.img
}SELECT t.value, count(*) as users_count
FROM users u
JOIN (
SELECT d1.text as value, d1.user_id FROM data1 d1
UNION
SELECT d2.name as value, d2.user_id FROM data2 d2
) t on t.user_id = u.id
GROUP BY t.value
ORDER BY users_count DESCfor root, dirs, files in os.walk(src):
for file in files:
if file.endswith(('png','jpg')):
shutil.move(os.path.join(root, file), dst)quant: Number($(el).find('.cart-popup__calcdisp').find('span').text().replace(/[\s\n\t]/mg, "").replace(/,/mg, ".")),
let priceOfOne = $(el).find('.cart-popup__nums_one').find('span').text().replace(/[\s\n\t]/mg, "").replace(/,/mg, "."),
num = priceOfOne.toLowerCase().indexOf('руб'),<input type="text" id="number" value="100">document.getElementById("number").onblur = function(){
this.value = parseInt(this.defaultValue) + parseInt(this.value);
this.defaultValue = this.value;
}$sql = "SELECT * FROM tbl WHERE replace(replace(replace(replace(phone,'(',''),')',''),' ',''),'-','') LIKE concat(replace(replace(replace(replace('".$num."','(',''),')',''),' ',''),'-',''), '%')";Не совсем понимаю как это реализовать с помощь полнотекстового поиска.
^\+?7[ -]?\(?\d{3}\)?[ -]?\d{3}[ -]?\d{2}[ -]?\d{2}$