[Summary] [Package List] [Test Cases]
| Tests | Errors | Failures | Skipped | Success Rate | Time |
|---|---|---|---|---|---|
| 2 | 0 | 1 | 0 | 50% | 1,474 |
Note: failures are anticipated and checked for with assertions while errors are unanticipated.
[Summary] [Package List] [Test Cases]
| Package | Tests | Errors | Failures | Skipped | Success Rate | Time |
|---|---|---|---|---|---|---|
| 1 | 0 | 1 | 0 | 0% | 1 | |
| fr.paris.lutece.plugins.stock.modules.billetterie.web | 1 | 0 | 0 | 0 | 100% | 0,474 |
Note: package statistics are not computed recursively, they only sum up all of its testsuites numbers.
| Class | Tests | Errors | Failures | Skipped | Success Rate | Time | |
|---|---|---|---|---|---|---|---|
 |
antrunsql | 1 | 0 | 1 | 0 | 0% | 1 |
| Class | Tests | Errors | Failures | Skipped | Success Rate | Time | |
|---|---|---|---|---|---|---|---|
 |
UriEncodingTest | 1 | 0 | 0 | 0 | 100% | 0,474 |
[Summary] [Package List] [Test Cases]
 |
antrunsql | 1 |
[sql] Failed to execute: INSERT INTO `core_feature_group` (`id_feature_group`, `feature_group_description`, `feature_group_label`, `feature_group_order`) VALUES ('BILLETTERIE', 'module.stock.billetterie.features.group.billetterie.description', 'module.stock.billetterie.features.group.billetterie.label', 1)
[sql] Failed to execute: INSERT INTO `core_dashboard` (`dashboard_name`, `dashboard_column`, `dashboard_order`) VALUES ('billeterieAdminDashboardComponent', 2, 1)
[sql] Failed to execute: INSERT INTO `core_page` (`id_page`, `id_parent`, `name`, `description`, `date_update`, `status`, `page_order`, `id_template`, `date_creation`, `role`, `code_theme`, `node_status`, `image_content`, `mime_type`, `meta_keywords`, `meta_description`, `id_authorization_node`) VALUES (1, 0, 'accueil', 'Page d''accueil', '2012-01-10 11:03:53', 1, 1, 4, '2003-09-09 04:38:01', 'none', 'default', 0, 0x4749463839610b001400a10100b6b6b6ffffffffc885cccccc2c000000000b001400000224448e3996ba8d86644d4e68afcb34644b7de0218e25783e2753865ff756a3fc6035d63505003b, 'image/gif', NULL, NULL, 1)
[sql] Failed to execute: INSERT INTO `core_portlet` (`id_portlet`, `id_portlet_type`, `id_page`, `name`, `date_update`, `status`, `portlet_order`, `column_no`, `id_style`, `accept_alias`, `date_creation`, `display_portlet_title`, `role`) VALUES (98, 'BILLETTERIE_PORTLET', 1, 'Nos spectacles à l''affiche', '2012-01-18 14:29:40', 0, 1, 1, 1, 0, '2012-01-13 16:11:24', 0, 'none'), (99, 'BILLETTERIE_PORTLET', 1, 'Nos spectacles à venir', '2012-01-18 09:58:47', 0, 1, 1, 1, 0, '2012-01-17 14:34:27', 0, 'none')
[sql] Failed to execute: INSERT INTO `core_portlet_type` (`id_portlet_type`, `name`, `url_creation`, `url_update`, `home_class`, `plugin_name`, `url_docreate`, `create_script`, `create_specific`, `create_specific_form`, `url_domodify`, `modify_script`, `modify_specific`, `modify_specific_form`) VALUES ('BILLETTERIE_PORTLET', 'module.stock.billetterie.portlet.name', 'plugins/stock/modules/billetterie/CreatePortletBilletterie.jsp', 'plugins/stock/modules/billetterie/ModifyPortletBilletterie.jsp', 'fr.paris.lutece.plugins.stock.modules.billetterie.business.portlet.BilletteriePortletHome', 'stock-billetterie', 'plugins/stock/modules/billetterie/DoCreatePortletBilletterie.jsp', '/admin/portlet/script_create_portlet.html', '/admin/plugins/stock/modules/billetterie/portlet_billetterie.html', '', 'plugins/stock/modules/billetterie/DoModifyPortletBilletterie.jsp', '/admin/portlet/script_modify_portlet.html', '/admin/plugins/stock/modules/billetterie/portlet_billetterie.html', '')
[sql] Failed to execute: INSERT INTO `core_style` (`id_style`, `description_style`, `id_portlet_type`, `id_portal_component`) VALUES (1, 'Portlet_Show', 'BILLETTERIE_PORTLET', 0)
[sql] Failed to execute: INSERT INTO `core_stylesheet` (`id_stylesheet`, `description`, `file_name`, `source`) VALUES (1501, 'Portlet_Show_style', 'portlet_billetterie.xsl', 0x3c3f786d6c2076657273696f6e3d22312e30223f3e0d0a3c78736c3a7374796c6573686565742076657273696f6e3d22312e302220786d6c6e733a78736c3d22687474703a2f2f7777772e77332e6f72672f313939392f58534c2f5472616e73666f726d223e0d0a3c78736c3a6f7574707574206d6574686f643d2268746d6c2220696e64656e743d2279657322202f3e0d0a0d0a093c78736c3a74656d706c617465206d617463683d22706f72746c6574223e0d0a09093c6469763e0d0a0909093c78736c3a617474726962757465206e616d653d22636c617373223e706f72746c6574203c78736c3a76616c75652d6f662073656c6563743d2262696c6c657474657269652f74797065506f72746c6574222f3e3c2f78736c3a6174747269627574653e0d0a0909093c68333e0d0a090909093c78736c3a76616c75652d6f662064697361626c652d6f75747075742d6573636170696e673d22796573222073656c6563743d22706f72746c65742d6e616d6522202f3e0d0a0909093c2f68333e0d0a0909093c64697620636c6173733d22706f72746c65742d636f6e74656e74223e0d0a090909093c64697620636c6173733d2273686f775f6c6973745f70616765223e0d0a09090909093c78736c3a617474726962757465206e616d653d2268726566223e3c78736c3a76616c75652d6f662073656c6563743d2275726c222f3e3c2f78736c3a6174747269627574653e0d0a09090909093c78736c3a63686f6f73653e0d0a09090909093c78736c3a7768656e20746573743d2262696c6c657474657269655b73686f775d223e0d0a09090909093c78736c3a666f722d656163682073656c6563743d2262696c6c657474657269652f73686f77223e0d0a0d0a0909090909093c64697620636c6173733d2273686f775f64657461696c73223e0d0a090909090909093c78736c3a617474726962757465206e616d653d227374796c65223e6261636b67726f756e642d636f6c6f723a203c78736c3a76616c75652d6f662073656c6563743d2263617465676f7279436f6c6f72222f3e3b3c2f78736c3a6174747269627574653e0d0a090909090909093c613e0d0a09090909090909093c78736c3a617474726962757465206e616d653d227469746c65223e3c78736c3a76616c75652d6f662073656c6563743d226e616d65222f3e3c2f78736c3a6174747269627574653e0d0a09090909090909093c78736c3a617474726962757465206e616d653d2268726566223e3c78736c3a76616c75652d6f662073656c6563743d2275726c222f3e3c2f78736c3a6174747269627574653e0d0a09090909090909093c696d673e0d0a0909090909090909093c78736c3a617474726962757465206e616d653d22737263223e3c78736c3a76616c75652d6f662073656c6563743d22706f7374657255726c222f3e3c2f78736c3a6174747269627574653e0d0a0909090909090909093c78736c3a617474726962757465206e616d653d22616c74223e3c78736c3a76616c75652d6f662073656c6563743d226e616d65222f3e3c2f78736c3a6174747269627574653e0d0a09090909090909093c2f696d673e0d0a090909090909093c2f613e0d0a090909090909093c62722f3e0d0a090909090909093c6120636c6173733d22656e2d7361766f69722d706c7573223e0d0a09090909090909093c78736c3a617474726962757465206e616d653d2268726566223e3c215b43444154415b6a73702f736974652f506f7274616c2e6a73703f706167653d62696c6c6574746572696526616374696f6e3d66696368652d737065637461636c652670726f647563745f69643d5d5d3e3c78736c3a76616c75652d6f662073656c6563743d226964222f3e3c2f78736c3a6174747269627574653e0d0a09090909090909093c78736c3a617474726962757465206e616d653d227469746c65223e44c3a97461696c7320647520737065637461636c653c2f78736c3a6174747269627574653e0d0a09090909090909093c78736c3a76616c75652d6f662073656c6563743d226e616d6522202f3e0d0a09090909090909093c62722f3e0d0a0909090909090909454e205341564f495209504c55530d0a090909090909093c2f613e0d0a0909090909093c2f6469763e0d0a09090909093c2f78736c3a666f722d656163683e0d0a09090909090d0a09090909093c6272207374796c653d22636c6561723a626f746822202f3e0d0a09090909093c7370616e20636c6173733d226c69656e2d64657461696c223e0d0a09090909093c613e0d0a09090909093c78736c3a63686f6f73653e0d0a0909090909093c78736c3a7768656e20746573743d2262696c6c657474657269652f74797065506f72746c6574203d2027614c6166666963686527223e0d0a090909090909093c78736c3a617474726962757465206e616d653d2268726566223e6a73702f736974652f506f7274616c2e6a73703f706167653d62696c6c6574746572696526616d703b616374696f6e3d612d6c616666696368653c2f78736c3a6174747269627574653e0d0a09090909090909566f697220746f7573206c657320737065637461636c657320656e20636f7572730d0a0909090909093c2f78736c3a7768656e3e0d0a0909090909093c78736c3a6f74686572776973653e0d0a090909090909093c78736c3a617474726962757465206e616d653d2268726566223e6a73702f736974652f506f7274616c2e6a73703f706167653d62696c6c6574746572696526616d703b616374696f6e3d612d76656e69723c2f78736c3a6174747269627574653e0d0a09090909090909566f697220746f7573206c657320737065637461636c657320c3a02076656e69720d0a0909090909093c2f78736c3a6f74686572776973653e0d0a09090909093c2f78736c3a63686f6f73653e0d0a09090909093c2f613e0d0a09090909093c2f7370616e3e0d0a09090909093c2f78736c3a7768656e3e0d0a09090909093c78736c3a6f74686572776973653e0d0a09090909093c78736c3a63686f6f73653e0d0a0909090909093c78736c3a7768656e20746573743d2262696c6c657474657269652f74797065506f72746c6574203d2027614c6166666963686527223e0d0a09090909090950617320646520737065637461636c6520656e20636f7572732e0d0a0909090909093c2f78736c3a7768656e3e0d0a0909090909093c78736c3a6f74686572776973653e0d0a09090909090950617320646520737065637461636c6520c3a02076656e69722e0d0a0909090909093c2f78736c3a6f74686572776973653e0d0a09090909093c2f78736c3a63686f6f73653e0d0a09090909093c2f78736c3a6f74686572776973653e0d0a090909093c2f78736c3a63686f6f73653e0d0a090909093c2f6469763e0d0a0909093c2f6469763e0d0a09093c2f6469763e0d0a093c2f78736c3a74656d706c6174653e0d0a0d0a3c2f78736c3a7374796c6573686565743e0d0a)
[sql] Failed to execute: INSERT INTO `core_style_mode_stylesheet` (`id_style`, `id_mode`, `id_stylesheet`) VALUES (1, 0, 1501)
[sql] Failed to execute: INSERT INTO `core_user_right` (`id_right`, `id_user`) VALUES ('CATEGORIES_MANAGEMENT', 1), ('CATEGORIES_MANAGEMENT', 2), ('OFFERS_MANAGEMENT', 1), ('PARTNERS_MANAGEMENT', 1), ('PRODUCTS_MANAGEMENT', 1), ('PRODUCTS_MANAGEMENT', 2), ('PURCHASES_MANAGEMENT', 1), ('STATISTICS_MANAGEMENT', 1)
[sql] Failed to execute: INSERT INTO core_admin_right(id_right,name,level_right,admin_url,description,is_updatable,plugin_name,id_feature_group,icon_url,documentation_url,id_order) VALUES ('STATISTICS_MANAGEMENT', 'module.stock.kiosque.adminFeature.statisticsManagement.name', 2, 'jsp/admin/plugins/stock/modules/kiosque/ManageStatistics.jsp', 'module.stock.kiosque.adminFeature.statisticsManagement.description', 0, 'stock-kiosque', 'KIOSQUE', 'images/admin/skin/plugins/stock/modules/kiosque/statistics.png', '', 4), ('PARTNERS_MANAGEMENT', 'module.stock.kiosque.adminFeature.partnersManagement.name', 2, 'jsp/admin/plugins/stock/modules/kiosque/ManagePartners.jsp', 'module.stock.kiosque.adminFeature.partnersManagement.description', 0, 'stock-kiosque', 'KIOSQUE', 'images/admin/skin/plugins/stock/modules/kiosque/partner.png', '', 3), ('OFFERS_MANAGEMENT', 'module.stock.kiosque.adminFeature.offresManagement.name', 2, 'jsp/admin/plugins/stock/modules/kiosque/ManageOffers.jsp', 'module.stock.kiosque.adminFeature.offresManagement.description', 0, 'stock-kiosque', 'KIOSQUE', 'images/admin/skin/plugins/stock/modules/kiosque/ticket.png', '', 2)
[sql] Failed to execute: CREATE TABLE IF NOT EXISTS `billetterie_portlet` ( `id_portlet` int(11) NOT NULL IDENTITY, `number_show` int(25) NOT NULL, `type_content_portlet` varchar(25) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id_portlet`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci IDENTITY=100
[sql] Failed to execute: CREATE TABLE IF NOT EXISTS `billetterie_district` ( `id` int(11) NOT NULL IDENTITY, `libelle` varchar(255) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
[sql] Failed to execute: INSERT INTO `billetterie_portlet` (`id_portlet`, `number_show`, `type_content_portlet`) VALUES (98, 8, 'a-laffiche'), (99, 5, 'a-venir')
[sql] Failed to execute: /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */
[sql] Failed to execute: CREATE TABLE kiosque_history ( id_history int default '0' NOT NULL, date_operation datetime default NULL, date_session datetime default NULL, event varchar(255) collate utf8_unicode_ci default NULL, hour_session datetime default NULL, id_offer varchar(255) collate utf8_unicode_ci default NULL, id_session int default NULL, kiosque varchar(255) collate utf8_unicode_ci default NULL, partner varchar(255) collate utf8_unicode_ci default NULL, partner_nickname varchar(255) collate utf8_unicode_ci default NULL, quantity int default NULL, type varchar(255) collate utf8_unicode_ci default NULL, PRIMARY KEY (id_history) )
[sql] Failed to execute: CREATE TABLE kiosque_offer ( commentary varchar(255) collate utf8_unicode_ci default NULL, id varchar(255) collate utf8_unicode_ci default NULL, nbPerson int default '0' NOT NULL, reducedPrice float default '0' NOT NULL, type varchar(255) collate utf8_unicode_ci default NULL, id_category int default '0' NOT NULL, genre_id_offer_genre int default NULL, bookingFax varchar(255) collate utf8_unicode_ci default NULL, PRIMARY KEY (id_category), KEY FK98243DDC5EF75F6 (genre_id_offer_genre), KEY FK98243DDCD4687647 (id_category), CONSTRAINT FK98243DDCD4687647 FOREIGN KEY (id_category) REFERENCES stock_ticket_category (id_category), CONSTRAINT FK98243DDC5EF75F6 FOREIGN KEY (genre_id_offer_genre) REFERENCES kiosque_offer_genre (id_offer_genre) )
[sql] Failed to execute: CREATE TABLE kiosque_offer_genre ( id_offer_genre int default '0' NOT NULL, name varchar(255) collate utf8_unicode_ci default NULL, PRIMARY KEY (id_offer_genre) )
[sql] Failed to execute: CREATE TABLE kiosque_partner ( booking_mail varchar(255) collate utf8_unicode_ci default NULL, booking_phone varchar(255) collate utf8_unicode_ci default NULL, nickname varchar(255) collate utf8_unicode_ci default NULL, schedule varchar(255) collate utf8_unicode_ci default NULL, id_provider int default '0' NOT NULL, type_id int default NULL, PRIMARY KEY (id_provider), KEY FK4D1A204836F73D41 (id_provider), KEY FK4D1A2048D88B6E77 (type_id), CONSTRAINT FK4D1A2048D88B6E77 FOREIGN KEY (type_id) REFERENCES kiosque_type_partner (id_type_partner), CONSTRAINT FK4D1A204836F73D41 FOREIGN KEY (id_provider) REFERENCES stock_provider (id_provider) )
[sql] Failed to execute: CREATE TABLE kiosque_session ( id_product int default '0' NOT NULL, parent_id int default NULL, initial_quantity int default NULL, PRIMARY KEY (id_product), KEY FKF2ADC6161B926833 (id_product), KEY FKF2ADC616ED70CFC9 (parent_id), CONSTRAINT FKF2ADC616ED70CFC9 FOREIGN KEY (parent_id) REFERENCES kiosque_session (id_product), CONSTRAINT FKF2ADC6161B926833 FOREIGN KEY (id_product) REFERENCES stock_ticket_product (id_product) ) [sql] Failed to execute: CREATE TABLE kiosque_survey_export_format ( id_export int default '0' NOT NULL, description varchar(255) collate utf8_unicode_ci default NULL, extension varchar(255) collate utf8_unicode_ci default NULL, title varchar(255) collate utf8_unicode_ci default NULL, xsl_file longblob, PRIMARY KEY (id_export) )
[sql] Failed to execute: CREATE TABLE kiosque_type_partner ( id_type_partner int default '0' NOT NULL, name varchar(255) collate utf8_unicode_ci default NULL, PRIMARY KEY (id_type_partner) )
[sql] Failed to execute: CREATE TABLE kiosque_visitor ( date datetime NOT NULL default '1980-01-01 00:00:00', id_user int default '0' NOT NULL, nb_visitors int default NULL, PRIMARY KEY (date,id_user) )
[sql] Failed to execute: CREATE TABLE kiosque_session_kiosque_session ( kiosque_session_id_product int default '0' NOT NULL, subSessions_id_product int default '0' NOT NULL, UNIQUE KEY subSessions_id_product (subSessions_id_product), KEY FKF0C9F5ED63005F66 (subSessions_id_product), KEY FKF0C9F5EDE83F5A8D (kiosque_session_id_product), CONSTRAINT FKF0C9F5EDE83F5A8D FOREIGN KEY (kiosque_session_id_product) REFERENCES kiosque_session (id_product), CONSTRAINT FKF0C9F5ED63005F66 FOREIGN KEY (subSessions_id_product) REFERENCES kiosque_session (id_product) )
[sql] Failed to execute: /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */
[sql] Failed to execute: INSERT INTO kiosque_survey_export_format (id_export,title,description,extension,xsl_file) VALUES (1,'csv','exporter les réponses au format csv','csv','3C3F786D6C2076657273696F6E3D22312E302220656E636F64696E673D2249534F2D383835392D31223F3E0D0A3C78736C3A7374796C6573686565742076657273696F6E3D22312E302220786D6C6E733A78736C3D22687474703A2F2F7777772E77332E6F72672F313939392F58534C2F5472616E73666F726D223E0D0A3C78736C3A6F7574707574206D6574686F643D2274657874222F3E0D0A3C78736C3A74656D706C617465206D617463683D222F223E0D0A203C78736C3A6170706C792D74656D706C617465732073656C6563743D22666F726D2F7375626D6974732F7375626D6974222F3E200D0A3C2F78736C3A74656D706C6174653E0D0A0D0A3C78736C3A74656D706C617465206D617463683D22666F726D2F7375626D6974732F7375626D6974223E3C78736C3A696620746573743D22706F736974696F6E28293D31223E0D0A0920203C78736C3A746578743E224B696F73717565223B3C2F78736C3A746578743E0D0A0920203C78736C3A746578743E2244617465223B3C2F78736C3A746578743E0D0A2020202020203C78736C3A6170706C792D74656D706C617465732073656C6563743D227175657374696F6E732F7175657374696F6E222F3E200D0A09202020203C78736C3A746578743E262331303B3C2F78736C3A746578743E0D0A2020203C2F78736C3A69663E0D0A2020203C78736C3A6170706C792D74656D706C617465732073656C6563743D226B696F737175652D6E616D65222F3E200D0A09093C78736C3A746578743E3B3C2F78736C3A746578743E0D0A2020203C78736C3A6170706C792D74656D706C617465732073656C6563743D227375626D69742D64617465222F3E200D0A09093C78736C3A746578743E3B3C2F78736C3A746578743E0D0A2020203C78736C3A6170706C792D74656D706C617465732073656C6563743D227175657374696F6E732F7175657374696F6E2F726573706F6E736573222F3E200D0A09202020203C78736C3A746578743E262331303B3C2F78736C3A746578743E0D0A090D0A203C2F78736C3A74656D706C6174653E0D0A090D0A203C78736C3A74656D706C617465206D617463683D227175657374696F6E732F7175657374696F6E223E223C78736C3A76616C75652D6F662073656C6563743D227175657374696F6E2D7469746C65222F3E200D0A093C78736C3A746578743E223B3C2F78736C3A746578743E0D0A3C2F78736C3A74656D706C6174653E0D0A200D0A203C78736C3A74656D706C617465206D617463683D227175657374696F6E732F7175657374696F6E2F726573706F6E736573223E0D0A093C78736C3A746578743E223C2F78736C3A746578743E0D0A09093C78736C3A6170706C792D74656D706C617465732073656C6563743D22726573706F6E7365222F3E0D0A093C78736C3A746578743E223B3C2F78736C3A746578743E0D0A093C2F78736C3A74656D706C6174653E0D0A3C78736C3A74656D706C617465206D617463683D227175657374696F6E732F7175657374696F6E2F726573706F6E7365732F726573706F6E7365223E0D0A09203C78736C3A76616C75652D6F662073656C6563743D222E222F3E0D0A0920203C78736C3A696620746573743D22706F736974696F6E2829213D6C6173742829223E0D0A09093C78736C3A746578743E3B3C2F78736C3A746578743E0D0A0920203C2F78736C3A69663E0D0A203C2F78736C3A74656D706C6174653E0D0A203C2F78736C3A7374796C6573686565743E')
[sql] Failed to execute: CREATE TABLE IF NOT EXISTS stock_recommendation ( username varchar(255) NOT NULL, id_product int(11) NOT NULL, score DOUBLE NOT NULL, PRIMARY KEY (username , id_product ), INDEX( username ) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
[sql] Failed to execute: CREATE TABLE IF NOT EXISTS stock_category ( id_category int(11) NOT NULL DEFAULT '0', `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, description varchar(255) COLLATE utf8_unicode_ci NOT NULL, parent_id int(11) DEFAULT NULL, provider_id int(11) DEFAULT NULL, PRIMARY KEY (id_category), KEY FK9792900769015ED5 (provider_id), KEY FK97929007A735EC89 (parent_id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
[sql] Failed to execute: CREATE TABLE IF NOT EXISTS stock_category_attribute ( owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value text COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
[sql] Failed to execute: CREATE TABLE IF NOT EXISTS stock_category_attribute_date ( id int(11) NOT NULL IDENTITY, owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY owner_id (owner_id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
[sql] Failed to execute: CREATE TABLE IF NOT EXISTS stock_category_attribute_num ( owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value decimal(10,2) DEFAULT NULL, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
[sql] Failed to execute: CREATE TABLE IF NOT EXISTS stock_offer ( id_offer int(11) NOT NULL, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, description varchar(255) COLLATE utf8_unicode_ci NOT NULL, quantity int(11) NOT NULL, price float NOT NULL DEFAULT '0', statut varchar(255) COLLATE utf8_unicode_ci NOT NULL, product_id int(11) NOT NULL, offer_genre_id int(11) NOT NULL, min_tickets INT DEFAULT 0 NOT NULL, max_tickets INT DEFAULT 0 NOT NULL, PRIMARY KEY (id_offer), KEY product_id (product_id), KEY offer_genre_id (offer_genre_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
[sql] Failed to execute: CREATE TABLE IF NOT EXISTS stock_offer_attribute ( id int(11) NOT NULL IDENTITY, owner_id int(11) NOT NULL, attribute_key varchar(255) NOT NULL, attribute_value text NOT NULL, PRIMARY KEY (id), KEY owner_id (owner_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
[sql] Failed to execute: CREATE TABLE IF NOT EXISTS stock_offer_attribute_date ( owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
[sql] Failed to execute: CREATE TABLE IF NOT EXISTS stock_offer_attribute_num ( id int(11) NOT NULL IDENTITY, owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value decimal(10,2) DEFAULT NULL, PRIMARY KEY (id), KEY owner_id (owner_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
[sql] Failed to execute: CREATE TABLE IF NOT EXISTS stock_offer_genre ( id_offer_genre int(11) NOT NULL, `name` varchar(255) NOT NULL, PRIMARY KEY (id_offer_genre) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
[sql] Failed to execute: CREATE TABLE IF NOT EXISTS stock_offer_genre_attribute ( owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value text COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
[sql] Failed to execute: CREATE TABLE IF NOT EXISTS stock_offer_genre_attribute_date ( owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
[sql] Failed to execute: CREATE TABLE IF NOT EXISTS stock_offer_genre_attribute_num ( owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value decimal(10,2) DEFAULT NULL, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
[sql] Failed to execute: CREATE TABLE IF NOT EXISTS stock_product ( id_product int(11) NOT NULL DEFAULT '0', `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, description text COLLATE utf8_unicode_ci, price float DEFAULT NULL, category_id_category int(11) DEFAULT NULL, provider_id_provider int(11) DEFAULT NULL, PRIMARY KEY (id_product), KEY FK1BA2F4C6FC6A399A (category_id_category), KEY provider_id_provider (provider_id_provider), KEY provider_id_provider_2 (provider_id_provider) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
[sql] Failed to execute: CREATE TABLE IF NOT EXISTS stock_product_image ( id_product int(11) NOT NULL, tb_image blob, image mediumblob, real_image mediumblob, PRIMARY KEY (id_product) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
[sql] Failed to execute: CREATE TABLE IF NOT EXISTS stock_product_attribute ( owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value text COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
[sql] Failed to execute: CREATE TABLE IF NOT EXISTS stock_product_attribute_date ( owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
[sql] Failed to execute: CREATE TABLE IF NOT EXISTS stock_product_attribute_num ( owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value decimal(10,2) DEFAULT NULL, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
[sql] Failed to execute: CREATE TABLE IF NOT EXISTS stock_provider ( id_provider int(11) NOT NULL DEFAULT '0', address varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `comment` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, contactName varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, mail varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, phone_number varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (id_provider) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
[sql] Failed to execute: CREATE TABLE IF NOT EXISTS stock_provider_attribute ( owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value text COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
[sql] Failed to execute: CREATE TABLE IF NOT EXISTS stock_provider_attribute_date ( owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
[sql] Failed to execute: CREATE TABLE IF NOT EXISTS stock_provider_attribute_num ( owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value decimal(10,2) DEFAULT NULL, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
[sql] Failed to execute: CREATE TABLE IF NOT EXISTS stock_provider_stock_category ( stock_provider_id_provider int(11) NOT NULL DEFAULT '0', products_id_category int(11) NOT NULL DEFAULT '0', UNIQUE KEY products_id_category (products_id_category), KEY FKF592D1EC8CC9E500 (products_id_category), KEY FKF592D1ECF087CD7C (stock_provider_id_provider) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
[sql] Failed to execute: CREATE TABLE IF NOT EXISTS stock_purchase ( id_purchase int(11) NOT NULL, userName varchar(255) NOT NULL, quantity int(11) NOT NULL, offer_id int(11) NOT NULL, PRIMARY KEY (id_purchase) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
[sql] Failed to execute: CREATE TABLE IF NOT EXISTS stock_purchase_attribute ( owner_id int(11) NOT NULL DEFAULT '0', attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value text COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
[sql] Failed to execute: CREATE TABLE IF NOT EXISTS stock_purchase_attribute_date ( owner_id int(11) NOT NULL DEFAULT '0', attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
[sql] Failed to execute: CREATE TABLE IF NOT EXISTS stock_purchase_attribute_num ( owner_id int(11) NOT NULL DEFAULT '0', attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value decimal(10,2) DEFAULT NULL, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
[sql] Failed to execute: CREATE TABLE IF NOT EXISTS stock_sequences ( sequence_name varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', next_val bigint(20) DEFAULT NULL, PRIMARY KEY (sequence_name) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
[sql] Failed to execute: CREATE TABLE IF NOT EXISTS stock_ticket_product_statistic ( id_product_statistic int(11) NOT NULL IDENTITY, dayOfYear int(11) NOT NULL, `week` int(11) NOT NULL, `month` int(11) NOT NULL, `year` int(11) NOT NULL, product_id_product int(11) NOT NULL, `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id_product_statistic) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
[sql] Failed to execute: CREATE TABLE IF NOT EXISTS stock_ticket_purchase_statistic ( id_purchase_statistic int(11) NOT NULL, dayOfYear int(11) NOT NULL, `week` int(11) NOT NULL, `month` int(11) NOT NULL, `year` int(11) NOT NULL, purchase_id_purchase int(11) NOT NULL, `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id_purchase_statistic) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
[sql] Failed to execute: ALTER TABLE `stock_offer` ADD CONSTRAINT stock_offer_ibfk_1 FOREIGN KEY (product_id) REFERENCES stock_product (id_product)
[sql] Failed to execute: ALTER TABLE `stock_offer_attribute` ADD CONSTRAINT stock_offer_attribute_ibfk_2 FOREIGN KEY (owner_id) REFERENCES stock_offer (id_offer), ADD CONSTRAINT stock_offer_attribute_ibfk_1 FOREIGN KEY (owner_id) REFERENCES stock_offer (id_offer)
[sql] Failed to execute: ALTER TABLE `stock_offer_attribute_date` ADD CONSTRAINT stock_offer_attribute_date_ibfk_1 FOREIGN KEY (owner_id) REFERENCES stock_offer (id_offer)
[sql] Failed to execute: ALTER TABLE `stock_offer_attribute_num` ADD CONSTRAINT stock_offer_attribute_num_ibfk_1 FOREIGN KEY (owner_id) REFERENCES stock_offer (id_offer)
[sql] Failed to execute: ALTER TABLE `stock_product_attribute` ADD CONSTRAINT stock_product_attribute_ibfk_3 FOREIGN KEY (owner_id) REFERENCES stock_product (id_product), ADD CONSTRAINT stock_product_attribute_ibfk_1 FOREIGN KEY (owner_id) REFERENCES stock_product (id_product), ADD CONSTRAINT stock_product_attribute_ibfk_2 FOREIGN KEY (owner_id) REFERENCES stock_product (id_product)
[sql] Failed to execute: ALTER TABLE `stock_product_attribute_date` ADD CONSTRAINT stock_product_attribute_date_ibfk_1 FOREIGN KEY (owner_id) REFERENCES stock_product (id_product)
[sql] Failed to execute: ALTER TABLE `stock_product_attribute_num` ADD CONSTRAINT stock_product_attribute_num_ibfk_1 FOREIGN KEY (owner_id) REFERENCES stock_product (id_product)
[sql] Failed to execute: CREATE TABLE IF NOT EXISTS stock_product_subscription_user ( id int(11) NOT NULL, userName varchar(255) COLLATE utf8_unicode_ci NOT NULL, id_product int(11) NOT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
[sql] Failed to execute: ALTER TABLE `stock_product_subscription_user` ADD CONSTRAINT stock_product_subscription_user_ibfk_1 FOREIGN KEY (id_product) REFERENCES stock_product (id_product)
[sql] Failed to execute: INSERT INTO `stock_offer_genre` (`id_offer_genre`, `name`) VALUES (1, 'Tarif réduit'), (2, 'Invitation'), (3, 'Invitation spectacle enfants')
[sql] Failed to execute: INSERT INTO `stock_sequences` (`sequence_name`, `next_val`) VALUES ('billetterie_district_id',1)
[sql] Failed to execute: CREATE TABLE IF NOT EXISTS userban_user ( id varchar(255), state varchar(255), date timestamp, commentaire varchar(255), motif varchar(255), PRIMARY KEY (id) ) COMMENT='Contient les banissement d utilisateurs' |
