×
Please submit new Bug Reports on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues
built one but now i get the following error when attempting to install
David Thornton
New Member
Posts: 1
7 år 9 måneder siden #1472
af David Thornton
Denne besked har en vedhæftede fil.
built one but now i get the following error when attempting to install blev oprettet af David Thornton
Anyone have a clue what i am doing wrong here????
Warning
JInstaller: :Install: Error SQL You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(255) NOT NULL , `deceasedchildren` LONGTEXT(255) NOT NULL , `survivinggrand' at line 45 SQL=CREATE TABLE IF NOT EXISTS `#__obituarly_deathinfo` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `ordering` INT(11) NOT NULL , `state` TINYINT(1) NOT NULL , `checked_out` INT(11) NOT NULL , `checked_out_time` DATETIME NOT NULL , `created_by` INT(11) NOT NULL , `modified_by` INT(11) NOT NULL , `firstname` VARCHAR(255) NOT NULL , `middlename` VARCHAR(255) NOT NULL , `lastname` VARCHAR(255) NOT NULL , `nickname` VARCHAR(255) NOT NULL , `ageatdeath` VARCHAR(3) NOT NULL , `residenceatdeath` VARCHAR(255) NOT NULL , `dateofdeath` DATE NOT NULL , `placeofdeath` VARCHAR(255) NOT NULL , `causeofdeath` VARCHAR(255) NOT NULL , `dateofbirth` DATE NOT NULL , `placeofbirth` VARCHAR(255) NOT NULL , `mothersname` VARCHAR(255) NOT NULL , `momalive` VARCHAR(255) NOT NULL , `fathersname` VARCHAR(255) NOT NULL , `fatheralive` VARCHAR(255) NOT NULL , `grandmothername` VARCHAR(255) NOT NULL , `grandmotheralive` VARCHAR(255) NOT NULL , `grandfather` VARCHAR(255) NOT NULL , `grandfatheralive` VARCHAR(255) NOT NULL , `sibling1` VARCHAR(255) NOT NULL , `sibling1alive` VARCHAR(255) NOT NULL , `sibling2` VARCHAR(255) NOT NULL , `sibling2alive` VARCHAR(255) NOT NULL , `sibling3` VARCHAR(255) NOT NULL , `sibling3alive` VARCHAR(255) NOT NULL , `sibling4` VARCHAR(255) NOT NULL , `sibling4alive` VARCHAR(255) NOT NULL , `sibling5` VARCHAR(255) NOT NULL , `sibling5alive` VARCHAR(255) NOT NULL , `sibling6` VARCHAR(255) NOT NULL , `sibling6alive` VARCHAR(255) NOT NULL , `spouse` VARCHAR(255) NOT NULL , `spousealive` VARCHAR(255) NOT NULL , `dateofmarriage` DATE NOT NULL , `placeofmarriage` VARCHAR(255) NOT NULL , `survivingchildren` LONGTEXT(255) NOT NULL , `deceasedchildren` LONGTEXT(255) NOT NULL , `survivinggrandchildren` LONGTEXT(255) NOT NULL , `deceasedgrandchildren` LONGTEXT(255) NOT NULL , `survivinggreatgrandchildren` LONGTEXT(255) NOT NULL , `survivingotherfamily` LONGTEXT(255) NOT NULL , `deceasedotherfamily` LONGTEXT(255) NOT NULL , `survivingfriends` LONGTEXT(255) NOT NULL , `survivingpets` LONGTEXT(255) NOT NULL , `educationinfo` LONGTEXT(255) NOT NULL , `militaryservice` LONGTEXT(255) NOT NULL , `awards` LONGTEXT(255) NOT NULL , `employment` LONGTEXT(255) NOT NULL , `hobbies` LONGTEXT(255) NOT NULL , `chairatibleinfo` LONGTEXT(255) NOT NULL , `achievements` LONGTEXT(255) NOT NULL , `disappointments` LONGTEXT(255) NOT NULL , `unusual` LONGTEXT(255) NOT NULL , `placesofresidenct` LONGTEXT(255) NOT NULL , `dateofservice` DATE NOT NULL , `timeofservice` TIME NOT NULL , `placeofservice` VARCHAR(255) NOT NULL , `dateofvisitation` DATE NOT NULL , `timeofvisitation` TIME NOT NULL , `placeofvisitation` VARCHAR(255) NOT NULL , `dateofreception` DATE NOT NULL , `timeofreception` TIME NOT NULL , `placeofreception` VARCHAR(255) NOT NULL , `servicepallbearersother` LONGTEXT(255) NOT NULL , `othervigil` LONGTEXT(255) NOT NULL , `placeofinterment` LONGTEXT(255) NOT NULL , `funeralhome` VARCHAR(255) NOT NULL , `whotocall` VARCHAR(255) NOT NULL , `phoneforinfo` VARCHAR(255) NOT NULL , `donations` LONGTEXT(255) NOT NULL , `thankyou` LONGTEXT(255) NOT NULL , `poem` LONGTEXT(255) NOT NULL , `threewords` VARCHAR(255) NOT NULL , `firstnameplanner` VARCHAR(255) NOT NULL , `lastname_planner` VARCHAR(255) NOT NULL , `phoneforplanner` VARCHAR(255) NOT NULL , `emailofplanner` VARCHAR(255) NOT NULL , PRIMARY KEY (`id`) ) DEFAULT COLLATE=utf8mb4_unicode_ci;
Extension Install: SQL error processing query: DB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(255) NOT NULL , `deceasedchildren` LONGTEXT(255) NOT NULL , `survivinggrand' at line 45 SQL=CREATE TABLE IF NOT EXISTS `#__obituarly_deathinfo` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `ordering` INT(11) NOT NULL , `state` TINYINT(1) NOT NULL , `checked_out` INT(11) NOT NULL , `checked_out_time` DATETIME NOT NULL , `created_by` INT(11) NOT NULL , `modified_by` INT(11) NOT NULL , `firstname` VARCHAR(255) NOT NULL , `middlename` VARCHAR(255) NOT NULL , `lastname` VARCHAR(255) NOT NULL , `nickname` VARCHAR(255) NOT NULL , `ageatdeath` VARCHAR(3) NOT NULL , `residenceatdeath` VARCHAR(255) NOT NULL , `dateofdeath` DATE NOT NULL , `placeofdeath` VARCHAR(255) NOT NULL , `causeofdeath` VARCHAR(255) NOT NULL , `dateofbirth` DATE NOT NULL , `placeofbirth` VARCHAR(255) NOT NULL , `mothersname` VARCHAR(255) NOT NULL , `momalive` VARCHAR(255) NOT NULL , `fathersname` VARCHAR(255) NOT NULL , `fatheralive` VARCHAR(255) NOT NULL , `grandmothername` VARCHAR(255) NOT NULL , `grandmotheralive` VARCHAR(255) NOT NULL , `grandfather` VARCHAR(255) NOT NULL , `grandfatheralive` VARCHAR(255) NOT NULL , `sibling1` VARCHAR(255) NOT NULL , `sibling1alive` VARCHAR(255) NOT NULL , `sibling2` VARCHAR(255) NOT NULL , `sibling2alive` VARCHAR(255) NOT NULL , `sibling3` VARCHAR(255) NOT NULL , `sibling3alive` VARCHAR(255) NOT NULL , `sibling4` VARCHAR(255) NOT NULL , `sibling4alive` VARCHAR(255) NOT NULL , `sibling5` VARCHAR(255) NOT NULL , `sibling5alive` VARCHAR(255) NOT NULL , `sibling6` VARCHAR(255) NOT NULL , `sibling6alive` VARCHAR(255) NOT NULL , `spouse` VARCHAR(255) NOT NULL , `spousealive` VARCHAR(255) NOT NULL , `dateofmarriage` DATE NOT NULL , `placeofmarriage` VARCHAR(255) NOT NULL , `survivingchildren` LONGTEXT(255) NOT NULL , `deceasedchildren` LONGTEXT(255) NOT NULL , `survivinggrandchildren` LONGTEXT(255) NOT NULL , `deceasedgrandchildren` LONGTEXT(255) NOT NULL , `survivinggreatgrandchildren` LONGTEXT(255) NOT NULL , `survivingotherfamily` LONGTEXT(255) NOT NULL , `deceasedotherfamily` LONGTEXT(255) NOT NULL , `survivingfriends` LONGTEXT(255) NOT NULL , `survivingpets` LONGTEXT(255) NOT NULL , `educationinfo` LONGTEXT(255) NOT NULL , `militaryservice` LONGTEXT(255) NOT NULL , `awards` LONGTEXT(255) NOT NULL , `employment` LONGTEXT(255) NOT NULL , `hobbies` LONGTEXT(255) NOT NULL , `chairatibleinfo` LONGTEXT(255) NOT NULL , `achievements` LONGTEXT(255) NOT NULL , `disappointments` LONGTEXT(255) NOT NULL , `unusual` LONGTEXT(255) NOT NULL , `placesofresidenct` LONGTEXT(255) NOT NULL , `dateofservice` DATE NOT NULL , `timeofservice` TIME NOT NULL , `placeofservice` VARCHAR(255) NOT NULL , `dateofvisitation` DATE NOT NULL , `timeofvisitation` TIME NOT NULL , `placeofvisitation` VARCHAR(255) NOT NULL , `dateofreception` DATE NOT NULL , `timeofreception` TIME NOT NULL , `placeofreception` VARCHAR(255) NOT NULL , `servicepallbearersother` LONGTEXT(255) NOT NULL , `othervigil` LONGTEXT(255) NOT NULL , `placeofinterment` LONGTEXT(255) NOT NULL , `funeralhome` VARCHAR(255) NOT NULL , `whotocall` VARCHAR(255) NOT NULL , `phoneforinfo` VARCHAR(255) NOT NULL , `donations` LONGTEXT(255) NOT NULL , `thankyou` LONGTEXT(255) NOT NULL , `poem` LONGTEXT(255) NOT NULL , `threewords` VARCHAR(255) NOT NULL , `firstnameplanner` VARCHAR(255) NOT NULL , `lastname_planner` VARCHAR(255) NOT NULL , `phoneforplanner` VARCHAR(255) NOT NULL , `emailofplanner` VARCHAR(255) NOT NULL , PRIMARY KEY (`id`) ) DEFAULT COLLATE=utf8mb4_unicode_ci;
SQL =
CREATE TABLE IF NOT EXISTS `#__obituarly_deathinfo` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`ordering` INT(11) NOT NULL ,
`state` TINYINT(1) NOT NULL ,
`checked_out` INT(11) NOT NULL ,
`checked_out_time` DATETIME NOT NULL ,
`created_by` INT(11) NOT NULL ,
`modified_by` INT(11) NOT NULL ,
`firstname` VARCHAR(255) NOT NULL ,
`middlename` VARCHAR(255) NOT NULL ,
`lastname` VARCHAR(255) NOT NULL ,
`nickname` VARCHAR(255) NOT NULL ,
`ageatdeath` VARCHAR(3) NOT NULL ,
`residenceatdeath` VARCHAR(255) NOT NULL ,
`dateofdeath` DATE NOT NULL ,
`placeofdeath` VARCHAR(255) NOT NULL ,
`causeofdeath` VARCHAR(255) NOT NULL ,
`dateofbirth` DATE NOT NULL ,
`placeofbirth` VARCHAR(255) NOT NULL ,
`mothersname` VARCHAR(255) NOT NULL ,
`momalive` VARCHAR(255) NOT NULL ,
`fathersname` VARCHAR(255) NOT NULL ,
`fatheralive` VARCHAR(255) NOT NULL ,
`grandmothername` VARCHAR(255) NOT NULL ,
`grandmotheralive` VARCHAR(255) NOT NULL ,
`grandfather` VARCHAR(255) NOT NULL ,
`grandfatheralive` VARCHAR(255) NOT NULL ,
`sibling1` VARCHAR(255) NOT NULL ,
`sibling1alive` VARCHAR(255) NOT NULL ,
`sibling2` VARCHAR(255) NOT NULL ,
`sibling2alive` VARCHAR(255) NOT NULL ,
`sibling3` VARCHAR(255) NOT NULL ,
`sibling3alive` VARCHAR(255) NOT NULL ,
`sibling4` VARCHAR(255) NOT NULL ,
`sibling4alive` VARCHAR(255) NOT NULL ,
`sibling5` VARCHAR(255) NOT NULL ,
`sibling5alive` VARCHAR(255) NOT NULL ,
`sibling6` VARCHAR(255) NOT NULL ,
`sibling6alive` VARCHAR(255) NOT NULL ,
`spouse` VARCHAR(255) NOT NULL ,
`spousealive` VARCHAR(255) NOT NULL ,
`dateofmarriage` DATE NOT NULL ,
`placeofmarriage` VARCHAR(255) NOT NULL ,
`survivingchildren` LONGTEXT(255) NOT NULL ,
`deceasedchildren` LONGTEXT(255) NOT NULL ,
`survivinggrandchildren` LONGTEXT(255) NOT NULL ,
`deceasedgrandchildren` LONGTEXT(255) NOT NULL ,
`survivinggreatgrandchildren` LONGTEXT(255) NOT NULL ,
`survivingotherfamily` LONGTEXT(255) NOT NULL ,
`deceasedotherfamily` LONGTEXT(255) NOT NULL ,
`survivingfriends` LONGTEXT(255) NOT NULL ,
`survivingpets` LONGTEXT(255) NOT NULL ,
`educationinfo` LONGTEXT(255) NOT NULL ,
`militaryservice` LONGTEXT(255) NOT NULL ,
`awards` LONGTEXT(255) NOT NULL ,
`employment` LONGTEXT(255) NOT NULL ,
`hobbies` LONGTEXT(255) NOT NULL ,
`chairatibleinfo` LONGTEXT(255) NOT NULL ,
`achievements` LONGTEXT(255) NOT NULL ,
`disappointments` LONGTEXT(255) NOT NULL ,
`unusual` LONGTEXT(255) NOT NULL ,
`placesofresidenct` LONGTEXT(255) NOT NULL ,
`dateofservice` DATE NOT NULL ,
`timeofservice` TIME NOT NULL ,
`placeofservice` VARCHAR(255) NOT NULL ,
`dateofvisitation` DATE NOT NULL ,
`timeofvisitation` TIME NOT NULL ,
`placeofvisitation` VARCHAR(255) NOT NULL ,
`dateofreception` DATE NOT NULL ,
`timeofreception` TIME NOT NULL ,
`placeofreception` VARCHAR(255) NOT NULL ,
`servicepallbearersother` LONGTEXT(255) NOT NULL ,
`othervigil` LONGTEXT(255) NOT NULL ,
`placeofinterment` LONGTEXT(255) NOT NULL ,
`funeralhome` VARCHAR(255) NOT NULL ,
`whotocall` VARCHAR(255) NOT NULL ,
`phoneforinfo` VARCHAR(255) NOT NULL ,
`donations` LONGTEXT(255) NOT NULL ,
`thankyou` LONGTEXT(255) NOT NULL ,
`poem` LONGTEXT(255) NOT NULL ,
`threewords` VARCHAR(255) NOT NULL ,
`firstnameplanner` VARCHAR(255) NOT NULL ,
`lastname_planner` VARCHAR(255) NOT NULL ,
`phoneforplanner` VARCHAR(255) NOT NULL ,
`emailofplanner` VARCHAR(255) NOT NULL ,
PRIMARY KEY (`id`)
) DEFAULT COLLATE=utf8mb4_unicode_ci;
Warning
JInstaller: :Install: Error SQL You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(255) NOT NULL , `deceasedchildren` LONGTEXT(255) NOT NULL , `survivinggrand' at line 45 SQL=CREATE TABLE IF NOT EXISTS `#__obituarly_deathinfo` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `ordering` INT(11) NOT NULL , `state` TINYINT(1) NOT NULL , `checked_out` INT(11) NOT NULL , `checked_out_time` DATETIME NOT NULL , `created_by` INT(11) NOT NULL , `modified_by` INT(11) NOT NULL , `firstname` VARCHAR(255) NOT NULL , `middlename` VARCHAR(255) NOT NULL , `lastname` VARCHAR(255) NOT NULL , `nickname` VARCHAR(255) NOT NULL , `ageatdeath` VARCHAR(3) NOT NULL , `residenceatdeath` VARCHAR(255) NOT NULL , `dateofdeath` DATE NOT NULL , `placeofdeath` VARCHAR(255) NOT NULL , `causeofdeath` VARCHAR(255) NOT NULL , `dateofbirth` DATE NOT NULL , `placeofbirth` VARCHAR(255) NOT NULL , `mothersname` VARCHAR(255) NOT NULL , `momalive` VARCHAR(255) NOT NULL , `fathersname` VARCHAR(255) NOT NULL , `fatheralive` VARCHAR(255) NOT NULL , `grandmothername` VARCHAR(255) NOT NULL , `grandmotheralive` VARCHAR(255) NOT NULL , `grandfather` VARCHAR(255) NOT NULL , `grandfatheralive` VARCHAR(255) NOT NULL , `sibling1` VARCHAR(255) NOT NULL , `sibling1alive` VARCHAR(255) NOT NULL , `sibling2` VARCHAR(255) NOT NULL , `sibling2alive` VARCHAR(255) NOT NULL , `sibling3` VARCHAR(255) NOT NULL , `sibling3alive` VARCHAR(255) NOT NULL , `sibling4` VARCHAR(255) NOT NULL , `sibling4alive` VARCHAR(255) NOT NULL , `sibling5` VARCHAR(255) NOT NULL , `sibling5alive` VARCHAR(255) NOT NULL , `sibling6` VARCHAR(255) NOT NULL , `sibling6alive` VARCHAR(255) NOT NULL , `spouse` VARCHAR(255) NOT NULL , `spousealive` VARCHAR(255) NOT NULL , `dateofmarriage` DATE NOT NULL , `placeofmarriage` VARCHAR(255) NOT NULL , `survivingchildren` LONGTEXT(255) NOT NULL , `deceasedchildren` LONGTEXT(255) NOT NULL , `survivinggrandchildren` LONGTEXT(255) NOT NULL , `deceasedgrandchildren` LONGTEXT(255) NOT NULL , `survivinggreatgrandchildren` LONGTEXT(255) NOT NULL , `survivingotherfamily` LONGTEXT(255) NOT NULL , `deceasedotherfamily` LONGTEXT(255) NOT NULL , `survivingfriends` LONGTEXT(255) NOT NULL , `survivingpets` LONGTEXT(255) NOT NULL , `educationinfo` LONGTEXT(255) NOT NULL , `militaryservice` LONGTEXT(255) NOT NULL , `awards` LONGTEXT(255) NOT NULL , `employment` LONGTEXT(255) NOT NULL , `hobbies` LONGTEXT(255) NOT NULL , `chairatibleinfo` LONGTEXT(255) NOT NULL , `achievements` LONGTEXT(255) NOT NULL , `disappointments` LONGTEXT(255) NOT NULL , `unusual` LONGTEXT(255) NOT NULL , `placesofresidenct` LONGTEXT(255) NOT NULL , `dateofservice` DATE NOT NULL , `timeofservice` TIME NOT NULL , `placeofservice` VARCHAR(255) NOT NULL , `dateofvisitation` DATE NOT NULL , `timeofvisitation` TIME NOT NULL , `placeofvisitation` VARCHAR(255) NOT NULL , `dateofreception` DATE NOT NULL , `timeofreception` TIME NOT NULL , `placeofreception` VARCHAR(255) NOT NULL , `servicepallbearersother` LONGTEXT(255) NOT NULL , `othervigil` LONGTEXT(255) NOT NULL , `placeofinterment` LONGTEXT(255) NOT NULL , `funeralhome` VARCHAR(255) NOT NULL , `whotocall` VARCHAR(255) NOT NULL , `phoneforinfo` VARCHAR(255) NOT NULL , `donations` LONGTEXT(255) NOT NULL , `thankyou` LONGTEXT(255) NOT NULL , `poem` LONGTEXT(255) NOT NULL , `threewords` VARCHAR(255) NOT NULL , `firstnameplanner` VARCHAR(255) NOT NULL , `lastname_planner` VARCHAR(255) NOT NULL , `phoneforplanner` VARCHAR(255) NOT NULL , `emailofplanner` VARCHAR(255) NOT NULL , PRIMARY KEY (`id`) ) DEFAULT COLLATE=utf8mb4_unicode_ci;
Extension Install: SQL error processing query: DB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(255) NOT NULL , `deceasedchildren` LONGTEXT(255) NOT NULL , `survivinggrand' at line 45 SQL=CREATE TABLE IF NOT EXISTS `#__obituarly_deathinfo` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `ordering` INT(11) NOT NULL , `state` TINYINT(1) NOT NULL , `checked_out` INT(11) NOT NULL , `checked_out_time` DATETIME NOT NULL , `created_by` INT(11) NOT NULL , `modified_by` INT(11) NOT NULL , `firstname` VARCHAR(255) NOT NULL , `middlename` VARCHAR(255) NOT NULL , `lastname` VARCHAR(255) NOT NULL , `nickname` VARCHAR(255) NOT NULL , `ageatdeath` VARCHAR(3) NOT NULL , `residenceatdeath` VARCHAR(255) NOT NULL , `dateofdeath` DATE NOT NULL , `placeofdeath` VARCHAR(255) NOT NULL , `causeofdeath` VARCHAR(255) NOT NULL , `dateofbirth` DATE NOT NULL , `placeofbirth` VARCHAR(255) NOT NULL , `mothersname` VARCHAR(255) NOT NULL , `momalive` VARCHAR(255) NOT NULL , `fathersname` VARCHAR(255) NOT NULL , `fatheralive` VARCHAR(255) NOT NULL , `grandmothername` VARCHAR(255) NOT NULL , `grandmotheralive` VARCHAR(255) NOT NULL , `grandfather` VARCHAR(255) NOT NULL , `grandfatheralive` VARCHAR(255) NOT NULL , `sibling1` VARCHAR(255) NOT NULL , `sibling1alive` VARCHAR(255) NOT NULL , `sibling2` VARCHAR(255) NOT NULL , `sibling2alive` VARCHAR(255) NOT NULL , `sibling3` VARCHAR(255) NOT NULL , `sibling3alive` VARCHAR(255) NOT NULL , `sibling4` VARCHAR(255) NOT NULL , `sibling4alive` VARCHAR(255) NOT NULL , `sibling5` VARCHAR(255) NOT NULL , `sibling5alive` VARCHAR(255) NOT NULL , `sibling6` VARCHAR(255) NOT NULL , `sibling6alive` VARCHAR(255) NOT NULL , `spouse` VARCHAR(255) NOT NULL , `spousealive` VARCHAR(255) NOT NULL , `dateofmarriage` DATE NOT NULL , `placeofmarriage` VARCHAR(255) NOT NULL , `survivingchildren` LONGTEXT(255) NOT NULL , `deceasedchildren` LONGTEXT(255) NOT NULL , `survivinggrandchildren` LONGTEXT(255) NOT NULL , `deceasedgrandchildren` LONGTEXT(255) NOT NULL , `survivinggreatgrandchildren` LONGTEXT(255) NOT NULL , `survivingotherfamily` LONGTEXT(255) NOT NULL , `deceasedotherfamily` LONGTEXT(255) NOT NULL , `survivingfriends` LONGTEXT(255) NOT NULL , `survivingpets` LONGTEXT(255) NOT NULL , `educationinfo` LONGTEXT(255) NOT NULL , `militaryservice` LONGTEXT(255) NOT NULL , `awards` LONGTEXT(255) NOT NULL , `employment` LONGTEXT(255) NOT NULL , `hobbies` LONGTEXT(255) NOT NULL , `chairatibleinfo` LONGTEXT(255) NOT NULL , `achievements` LONGTEXT(255) NOT NULL , `disappointments` LONGTEXT(255) NOT NULL , `unusual` LONGTEXT(255) NOT NULL , `placesofresidenct` LONGTEXT(255) NOT NULL , `dateofservice` DATE NOT NULL , `timeofservice` TIME NOT NULL , `placeofservice` VARCHAR(255) NOT NULL , `dateofvisitation` DATE NOT NULL , `timeofvisitation` TIME NOT NULL , `placeofvisitation` VARCHAR(255) NOT NULL , `dateofreception` DATE NOT NULL , `timeofreception` TIME NOT NULL , `placeofreception` VARCHAR(255) NOT NULL , `servicepallbearersother` LONGTEXT(255) NOT NULL , `othervigil` LONGTEXT(255) NOT NULL , `placeofinterment` LONGTEXT(255) NOT NULL , `funeralhome` VARCHAR(255) NOT NULL , `whotocall` VARCHAR(255) NOT NULL , `phoneforinfo` VARCHAR(255) NOT NULL , `donations` LONGTEXT(255) NOT NULL , `thankyou` LONGTEXT(255) NOT NULL , `poem` LONGTEXT(255) NOT NULL , `threewords` VARCHAR(255) NOT NULL , `firstnameplanner` VARCHAR(255) NOT NULL , `lastname_planner` VARCHAR(255) NOT NULL , `phoneforplanner` VARCHAR(255) NOT NULL , `emailofplanner` VARCHAR(255) NOT NULL , PRIMARY KEY (`id`) ) DEFAULT COLLATE=utf8mb4_unicode_ci;
SQL =
CREATE TABLE IF NOT EXISTS `#__obituarly_deathinfo` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`ordering` INT(11) NOT NULL ,
`state` TINYINT(1) NOT NULL ,
`checked_out` INT(11) NOT NULL ,
`checked_out_time` DATETIME NOT NULL ,
`created_by` INT(11) NOT NULL ,
`modified_by` INT(11) NOT NULL ,
`firstname` VARCHAR(255) NOT NULL ,
`middlename` VARCHAR(255) NOT NULL ,
`lastname` VARCHAR(255) NOT NULL ,
`nickname` VARCHAR(255) NOT NULL ,
`ageatdeath` VARCHAR(3) NOT NULL ,
`residenceatdeath` VARCHAR(255) NOT NULL ,
`dateofdeath` DATE NOT NULL ,
`placeofdeath` VARCHAR(255) NOT NULL ,
`causeofdeath` VARCHAR(255) NOT NULL ,
`dateofbirth` DATE NOT NULL ,
`placeofbirth` VARCHAR(255) NOT NULL ,
`mothersname` VARCHAR(255) NOT NULL ,
`momalive` VARCHAR(255) NOT NULL ,
`fathersname` VARCHAR(255) NOT NULL ,
`fatheralive` VARCHAR(255) NOT NULL ,
`grandmothername` VARCHAR(255) NOT NULL ,
`grandmotheralive` VARCHAR(255) NOT NULL ,
`grandfather` VARCHAR(255) NOT NULL ,
`grandfatheralive` VARCHAR(255) NOT NULL ,
`sibling1` VARCHAR(255) NOT NULL ,
`sibling1alive` VARCHAR(255) NOT NULL ,
`sibling2` VARCHAR(255) NOT NULL ,
`sibling2alive` VARCHAR(255) NOT NULL ,
`sibling3` VARCHAR(255) NOT NULL ,
`sibling3alive` VARCHAR(255) NOT NULL ,
`sibling4` VARCHAR(255) NOT NULL ,
`sibling4alive` VARCHAR(255) NOT NULL ,
`sibling5` VARCHAR(255) NOT NULL ,
`sibling5alive` VARCHAR(255) NOT NULL ,
`sibling6` VARCHAR(255) NOT NULL ,
`sibling6alive` VARCHAR(255) NOT NULL ,
`spouse` VARCHAR(255) NOT NULL ,
`spousealive` VARCHAR(255) NOT NULL ,
`dateofmarriage` DATE NOT NULL ,
`placeofmarriage` VARCHAR(255) NOT NULL ,
`survivingchildren` LONGTEXT(255) NOT NULL ,
`deceasedchildren` LONGTEXT(255) NOT NULL ,
`survivinggrandchildren` LONGTEXT(255) NOT NULL ,
`deceasedgrandchildren` LONGTEXT(255) NOT NULL ,
`survivinggreatgrandchildren` LONGTEXT(255) NOT NULL ,
`survivingotherfamily` LONGTEXT(255) NOT NULL ,
`deceasedotherfamily` LONGTEXT(255) NOT NULL ,
`survivingfriends` LONGTEXT(255) NOT NULL ,
`survivingpets` LONGTEXT(255) NOT NULL ,
`educationinfo` LONGTEXT(255) NOT NULL ,
`militaryservice` LONGTEXT(255) NOT NULL ,
`awards` LONGTEXT(255) NOT NULL ,
`employment` LONGTEXT(255) NOT NULL ,
`hobbies` LONGTEXT(255) NOT NULL ,
`chairatibleinfo` LONGTEXT(255) NOT NULL ,
`achievements` LONGTEXT(255) NOT NULL ,
`disappointments` LONGTEXT(255) NOT NULL ,
`unusual` LONGTEXT(255) NOT NULL ,
`placesofresidenct` LONGTEXT(255) NOT NULL ,
`dateofservice` DATE NOT NULL ,
`timeofservice` TIME NOT NULL ,
`placeofservice` VARCHAR(255) NOT NULL ,
`dateofvisitation` DATE NOT NULL ,
`timeofvisitation` TIME NOT NULL ,
`placeofvisitation` VARCHAR(255) NOT NULL ,
`dateofreception` DATE NOT NULL ,
`timeofreception` TIME NOT NULL ,
`placeofreception` VARCHAR(255) NOT NULL ,
`servicepallbearersother` LONGTEXT(255) NOT NULL ,
`othervigil` LONGTEXT(255) NOT NULL ,
`placeofinterment` LONGTEXT(255) NOT NULL ,
`funeralhome` VARCHAR(255) NOT NULL ,
`whotocall` VARCHAR(255) NOT NULL ,
`phoneforinfo` VARCHAR(255) NOT NULL ,
`donations` LONGTEXT(255) NOT NULL ,
`thankyou` LONGTEXT(255) NOT NULL ,
`poem` LONGTEXT(255) NOT NULL ,
`threewords` VARCHAR(255) NOT NULL ,
`firstnameplanner` VARCHAR(255) NOT NULL ,
`lastname_planner` VARCHAR(255) NOT NULL ,
`phoneforplanner` VARCHAR(255) NOT NULL ,
`emailofplanner` VARCHAR(255) NOT NULL ,
PRIMARY KEY (`id`)
) DEFAULT COLLATE=utf8mb4_unicode_ci;
Denne besked har en vedhæftede fil.
Log venligst på for at se den!
Venligst Log på eller Opret en konto for at deltage i samtalen
Tid til at oprette siden: 0.049 sekunder