[Sommaire] [Imprimer]

   1  SELECT setval('ezapprove_items_s',max(id)+1) FROM ezapprove_items;
   2  SELECT setval('ezbasket_s',max(id)+1) FROM ezbasket;
   3  SELECT setval('ezcollab_group_s',max(id)+1) FROM ezcollab_group;
   4  SELECT setval('ezcollab_item_message_link_s',max(id)+1) FROM ezcollab_item_message_link;
   5  SELECT setval('ezcollab_item_s',max(id)+1) FROM ezcollab_item;
   6  SELECT setval('ezcollab_notification_rule_s',max(id)+1) FROM ezcollab_notification_rule;
   7  SELECT setval('ezcollab_profile_s',max(id)+1) FROM ezcollab_profile;
   8  SELECT setval('ezcollab_simple_message_s',max(id)+1) FROM ezcollab_simple_message;
   9  SELECT setval('ezcontentbrowsebookmark_s',max(id)+1) FROM ezcontentbrowsebookmark;
  10  SELECT setval('ezcontentbrowserecent_s',max(id)+1) FROM ezcontentbrowserecent;
  11  SELECT setval('ezcontentclass_attribute_s',max(id)+1) FROM ezcontentclass_attribute;
  12  SELECT setval('ezcontentclassgroup_s',max(id)+1) FROM ezcontentclassgroup;
  13  SELECT setval('ezcontentclass_s',max(id)+1) FROM ezcontentclass;
  14  SELECT setval('ezcontentobject_attribute_s',max(id)+1) FROM ezcontentobject_attribute;
  15  SELECT setval('ezcontentobject_link_s',max(id)+1) FROM ezcontentobject_link;
  16  SELECT setval('ezcontentobject_s',max(id)+1) FROM ezcontentobject;
  17  SELECT setval('ezcontentobject_tree_s', max(node_id)+1) FROM ezcontentobject_tree;
  18  SELECT setval('ezcontentobject_version_s',max(id)+1) FROM ezcontentobject_version;
  19  SELECT setval('ezcurrencydata_s',max(id)+1) FROM ezcurrencydata;
  20  SELECT setval('ezdiscountrule_s',max(id)+1) FROM ezdiscountrule;
  21  SELECT setval('ezdiscountsubrule_s',max(id)+1) FROM ezdiscountsubrule;
  22  SELECT setval('ezenumvalue_s',max(id)+1) FROM ezenumvalue;
  23  SELECT setval('ezforgot_password_s',max(id)+1) FROM ezforgot_password;
  24  SELECT setval('ezgeneral_digest_user_settings_s',max(id)+1) FROM ezgeneral_digest_user_settings;
  25  SELECT setval('ezimagefile_s',max(id)+1) FROM ezimagefile;
  26  SELECT setval('ezinfocollection_attribute_s',max(id)+1) FROM ezinfocollection_attribute;
  27  SELECT setval('ezinfocollection_s',max(id)+1) FROM ezinfocollection;
  28  SELECT setval('ezkeyword_attribute_link_s',max(id)+1) FROM ezkeyword_attribute_link;
  29  SELECT setval('ezkeyword_s',max(id)+1) FROM ezkeyword;
  30  SELECT setval('ezmessage_s',max(id)+1) FROM ezmessage;
  31  SELECT setval('ezmodule_run_s',max(id)+1) FROM ezmodule_run;
  32  SELECT setval('ezmultipricedata_s',max(id)+1) FROM ezmultipricedata;
  33  SELECT setval('eznode_assignment_s',max(id)+1) FROM eznode_assignment;
  34  SELECT setval('eznotificationcollection_item_s',max(id)+1) FROM eznotificationcollection_item;
  35  SELECT setval('eznotificationcollection_s',max(id)+1) FROM eznotificationcollection;
  36  SELECT setval('eznotificationevent_s',max(id)+1) FROM eznotificationevent;
  37  SELECT setval('ezoperation_memento_s',max(id)+1) FROM ezoperation_memento;
  38  SELECT setval('ezorder_item_s',max(id)+1) FROM ezorder_item;
  39  SELECT setval('ezorder_s',max(id)+1) FROM ezorder;
  40  SELECT setval('ezorder_status_history_s',max(id)+1) FROM ezorder_status_history;
  41  SELECT setval('ezorder_status_s',max(id)+1) FROM ezorder_status;
  42  SELECT setval('ezpackage_s',max(id)+1) FROM ezpackage;
  43  SELECT setval('ezpaymentobject_s',max(id)+1) FROM ezpaymentobject;
  44  SELECT setval('ezpdf_export_s',max(id)+1) FROM ezpdf_export;
  45  SELECT setval('ezpolicy_limitation_s',max(id)+1) FROM ezpolicy_limitation;
  46  SELECT setval('ezpolicy_limitation_value_s',max(id)+1) FROM ezpolicy_limitation_value;
  47  SELECT setval('ezpolicy_s',max(id)+1) FROM ezpolicy;
  48  SELECT setval('ezpreferences_s',max(id)+1) FROM ezpreferences;
  49  SELECT setval('ezproductcategory_s',max(id)+1) FROM ezproductcategory;
  50  SELECT setval('ezproductcollection_item_opt_s',max(id)+1) FROM ezproductcollection_item_opt;
  51  SELECT setval('ezproductcollection_item_s',max(id)+1) FROM ezproductcollection_item;
  52  SELECT setval('ezproductcollection_s',max(id)+1) FROM ezproductcollection;
  53  SELECT setval('ezrole_s',max(id)+1) FROM ezrole;
  54  SELECT setval('ezrss_export_item_s',max(id)+1) FROM ezrss_export_item;
  55  SELECT setval('ezrss_export_s',max(id)+1) FROM ezrss_export;
  56  SELECT setval('ezrss_import_s',max(id)+1) FROM ezrss_import;
  57  SELECT setval('ezsearch_object_word_link_s',max(id)+1) FROM ezsearch_object_word_link;
  58  SELECT setval('ezsearch_return_count_s',max(id)+1) FROM ezsearch_return_count;
  59  SELECT setval('ezsearch_search_phrase_s',max(id)+1) FROM ezsearch_search_phrase;
  60  SELECT setval('ezsearch_word_s',max(id)+1) FROM ezsearch_word;
  61  SELECT setval('ezsection_s',max(id)+1) FROM ezsection;
  62  SELECT setval('ezsubtree_notification_rule_s',max(id)+1) FROM ezsubtree_notification_rule;
  63  SELECT setval('eztrigger_s',max(id)+1) FROM eztrigger;
  64  SELECT setval('ezurlalias_s',max(id)+1) FROM ezurlalias;
  65  SELECT setval('ezurl_s',max(id)+1) FROM ezurl;
  66  SELECT setval('ezuser_accountkey_s',max(id)+1) FROM ezuser_accountkey;
  67  SELECT setval('ezuser_discountrule_s',max(id)+1) FROM ezuser_discountrule;
  68  SELECT setval('ezuser_role_s',max(id)+1) FROM ezuser_role;
  69  SELECT setval('ezvatrule_s',max(id)+1) FROM ezvatrule;
  70  SELECT setval('ezvattype_s',max(id)+1) FROM ezvattype;
  71  SELECT setval('ezwaituntildatevalue_s',max(id)+1) FROM ezwaituntildatevalue;
  72  SELECT setval('ezwishlist_s',max(id)+1) FROM ezwishlist;
  73  SELECT setval('ezworkflow_assign_s',max(id)+1) FROM ezworkflow_assign;
  74  SELECT setval('ezworkflow_event_s',max(id)+1) FROM ezworkflow_event;
  75  SELECT setval('ezworkflow_group_s',max(id)+1) FROM ezworkflow_group;
  76  SELECT setval('ezworkflow_process_s',max(id)+1) FROM ezworkflow_process;
  77  SELECT setval('ezworkflow_s',max(id)+1) FROM ezworkflow;