« Volver a Drop Tables

Liferay 6.0.6 Drop All Tables Script

drop table Account_;
drop table Address;
drop table AnnouncementsDelivery;
drop table AnnouncementsEntry;
drop table AnnouncementsFlag;
drop table AssetCategory;
drop table AssetCategoryProperty;
drop table AssetEntries_AssetCategories;
drop table AssetEntries_AssetTags;
drop table AssetEntry;
drop table AssetLink;
drop table AssetTag;
drop table AssetTagProperty;
drop table AssetTagStats;
drop table AssetVocabulary;
drop table BlogsEntry;
drop table BlogsStatsUser;
drop table BookmarksEntry;
drop table BookmarksFolder;
drop table BrowserTracker;
drop table CalEvent;
drop table ClassName_;
drop table ClusterGroup;
drop table Company;
drop table Contact_;
drop table Counter;
drop table Country;
drop table CyrusUser;
drop table CyrusVirtual;
drop table DLFileEntry;
drop table DLFileRank;
drop table DLFileShortcut;
drop table DLFileVersion;
drop table DLFolder;
drop table EmailAddress;
drop table ExpandoColumn;
drop table ExpandoRow;
drop table ExpandoTable;
drop table ExpandoValue;
drop table Group_;
drop table Groups_Orgs;
drop table Groups_Permissions;
drop table Groups_Roles;
drop table Groups_UserGroups;
drop table IGFolder;
drop table IGImage;
drop table Image;
drop table JournalArticle;
drop table JournalArticleImage;
drop table JournalArticleResource;
drop table JournalContentSearch;
drop table JournalFeed;
drop table JournalStructure;
drop table JournalTemplate;
drop table Layout;
drop table LayoutPrototype;
drop table LayoutSet;
drop table LayoutSetPrototype;
drop table ListType;
drop table Lock_;
drop table MBBan;
drop table MBCategory;
drop table MBDiscussion;
drop table MBMailingList;
drop table MBMessage;
drop table MBMessageFlag;
drop table MBStatsUser;
drop table MBThread;
drop table MembershipRequest;
drop table Organization_;
drop table OrgGroupPermission;
drop table OrgGroupRole;
drop table OrgLabor;
drop table PasswordPolicy;
drop table PasswordPolicyRel;
drop table PasswordTracker;
drop table Permission_;
drop table Phone;
drop table PluginSetting;
drop table PollsChoice;
drop table PollsQuestion;
drop table PollsVote;
drop table Portlet;
drop table PortletItem;
drop table PortletPreferences;
drop table RatingsEntry;
drop table RatingsStats;
drop table Region;
drop table Release_;
drop table Resource_;
drop table ResourceAction;
drop table ResourceCode;
drop table ResourcePermission;
drop table Role_;
drop table Roles_Permissions;
drop table SCFrameworkVersi_SCProductVers;
drop table SCFrameworkVersion;
drop table SCLicense;
drop table SCLicenses_SCProductEntries;
drop table SCProductEntry;
drop table SCProductScreenshot;
drop table SCProductVersion;
drop table ServiceComponent;
drop table Shard;
drop table ShoppingCart;
drop table ShoppingCategory;
drop table ShoppingCoupon;
drop table ShoppingItem;
drop table ShoppingItemField;
drop table ShoppingItemPrice;
drop table ShoppingOrder;
drop table ShoppingOrderItem;
drop table SocialActivity;
drop table SocialEquityAssetEntry;
drop table SocialEquityGroupSetting;
drop table SocialEquityHistory;
drop table SocialEquityLog;
drop table SocialEquitySetting;
drop table SocialEquityUser;
drop table SocialRelation;
drop table SocialRequest;
drop table Subscription;
drop table TasksProposal;
drop table TasksReview;
drop table Team;
drop table Ticket;
drop table User_;
drop table UserGroup;
drop table UserGroupGroupRole;
drop table UserGroupRole;
drop table UserIdMapper;
drop table Users_Groups;
drop table Users_Orgs;
drop table Users_Permissions;
drop table Users_Roles;
drop table Users_Teams;
drop table Users_UserGroups;
drop table UserTracker;
drop table UserTrackerPath;
drop table Vocabulary;
drop table WebDAVProps;
drop table Website;
drop table WikiNode;
drop table WikiPage;
drop table WikiPageResource;
drop table WorkflowDefinitionLink;
drop table WorkflowInstanceLink;
drop table QUARTZ_JOB_DETAILS;
drop table QUARTZ_JOB_LISTENERS;
drop table QUARTZ_TRIGGERS;
drop table QUARTZ_SIMPLE_TRIGGERS;
drop table QUARTZ_CRON_TRIGGERS;
drop table QUARTZ_BLOB_TRIGGERS;
drop table QUARTZ_TRIGGER_LISTENERS;
drop table QUARTZ_CALENDARS;
drop table QUARTZ_PAUSED_TRIGGER_GRPS;
drop table QUARTZ_FIRED_TRIGGERS;
drop table QUARTZ_SCHEDULER_STATE;
drop table QUARTZ_LOCKS;
drop index IX_F7655CC3;
drop index IX_9955EFB5;
drop index IX_8040C593;
drop index IX_804154AF;
drop index IX_BAB9A1F7;
drop index IX_ADEE6A17;
drop index IX_64B194F2;
drop index IX_5FEABBC;
drop index IX_20D8706C;
0 archivos adjuntos
13960 Accesos
Promedio (0 Votos)
La valoración media es de 0.0 estrellas de 5.
Comentarios
Respuestas anidadas Autor Fecha
same but to drop tables in liferay 6.2.x drop... Pablo Rendón 9 de junio de 2014 15:11

same but to drop tables in liferay 6.2.x

drop table Account_;
drop table Address;
drop table AnnouncementsDelivery;
drop table AnnouncementsEntry;
drop table AnnouncementsFlag;
drop table AssetCategory;
drop table AssetCategoryProperty;
drop table AssetEntries_AssetCategories;
drop table AssetEntries_AssetTags;
drop table AssetEntry;
drop table AssetLink;
drop table AssetTag;
drop table AssetTagProperty;
drop table AssetTagStats;
drop table AssetVocabulary;
drop table BlogsEntry;
drop table BlogsStatsUser;
drop table BookmarksEntry;
drop table BookmarksFolder;
drop table BrowserTracker;
drop table CalEvent;
drop table ClassName_;
drop table ClusterGroup;
drop table Company;
drop table Contact_;
drop table Counter;
drop table Country;
drop table CyrusUser;
drop table CyrusVirtual;
drop table DLFileEntry;
drop table DLFileRank;
drop table DLFileShortcut;
drop table DLFileVersion;
drop table DLFolder;
drop table EmailAddress;
drop table ExpandoColumn;
drop table ExpandoRow;
drop table ExpandoTable;
drop table ExpandoValue;
drop table Group_;
drop table Groups_Orgs;
drop table Groups_Permissions;
drop table Groups_Roles;
drop table Groups_UserGroups;
drop table IGFolder;
drop table IGImage;
drop table Image;
drop table JournalArticle;
drop table JournalArticleImage;
drop table JournalArticleResource;
drop table JournalContentSearch;
drop table JournalFeed;
drop table JournalStructure;
drop table JournalTemplate;
drop table Layout;
drop table LayoutPrototype;
drop table LayoutSet;
drop table LayoutSetPrototype;
drop table ListType;
drop table Lock_;
drop table MBBan;
drop table MBCategory;
drop table MBDiscussion;
drop table MBMailingList;
drop table MBMessage;
drop table MBMessageFlag;
drop table MBStatsUser;
drop table MBThread;
drop table MembershipRequest;
drop table Organization_;
drop table OrgGroupPermission;
drop table OrgGroupRole;
drop table OrgLabor;
drop table PasswordPolicy;
drop table PasswordPolicyRel;
drop table PasswordTracker;
drop table Permission_;
drop table Phone;
drop table PluginSetting;
drop table PollsChoice;
drop table PollsQuestion;
drop table PollsVote;
drop table Portlet;
drop table PortletItem;
drop table PortletPreferences;
drop table RatingsEntry;
drop table RatingsStats;
drop table Region;
drop table Release_;
drop table Resource_;
drop table ResourceAction;
drop table ResourceCode;
drop table ResourcePermission;
drop table Role_;
drop table Roles_Permissions;
drop table SCFrameworkVersi_SCProductVers;
drop table SCFrameworkVersion;
drop table SCLicense;
drop table SCLicenses_SCProductEntries;
drop table SCProductEntry;
drop table SCProductScreenshot;
drop table SCProductVersion;
drop table ServiceComponent;
drop table Shard;
drop table ShoppingCart;
drop table ShoppingCategory;
drop table ShoppingCoupon;
drop table ShoppingItem;
drop table ShoppingItemField;
drop table ShoppingItemPrice;
drop table ShoppingOrder;
drop table ShoppingOrderItem;
drop table SocialActivity;
drop table SocialEquityAssetEntry;
drop table SocialEquityGroupSetting;
drop table SocialEquityHistory;
drop table SocialEquityLog;
drop table SocialEquitySetting;
drop table SocialEquityUser;
drop table SocialRelation;
drop table SocialRequest;
drop table Subscription;
drop table TasksProposal;
drop table TasksReview;
drop table Team;
drop table Ticket;
drop table User_;
drop table UserGroup;
drop table UserGroupGroupRole;
drop table UserGroupRole;
drop table UserIdMapper;
drop table Users_Groups;
drop table Users_Orgs;
drop table Users_Permissions;
drop table Users_Roles;
drop table Users_Teams;
drop table Users_UserGroups;
drop table UserTracker;
drop table UserTrackerPath;
drop table Vocabulary;
drop table WebDAVProps;
drop table Website;
drop table WikiNode;
drop table WikiPage;
drop table WikiPageResource;
drop table WorkflowDefinitionLink;
drop table WorkflowInstanceLink;
drop table QUARTZ_JOB_DETAILS;
drop table QUARTZ_JOB_LISTENERS;
drop table QUARTZ_TRIGGERS;
drop table QUARTZ_SIMPLE_TRIGGERS;
drop table QUARTZ_CRON_TRIGGERS;
drop table QUARTZ_BLOB_TRIGGERS;
drop table QUARTZ_TRIGGER_LISTENERS;
drop table QUARTZ_CALENDARS;
drop table QUARTZ_PAUSED_TRIGGER_GRPS;
drop table QUARTZ_FIRED_TRIGGERS;
drop table QUARTZ_SCHEDULER_STATE;
drop table QUARTZ_LOCKS;
drop table BACKGROUNDTASK;
drop table DDLRECORDSET;
drop table DDLRECORDVERSION;
drop table DDMCONTENT;
drop table DDMSTORAGELINK;
drop table DDMSTRUCTURE;
drop table DDMSTRUCTURELINK;
drop table DDMTEMPLATE;
drop table DLCONTENT;
drop table DLFILEENTRYMETADATA;
drop table DLFILEENTRYTYPE;
drop table DLFILEENTRYTYPES_DDMSTRUCTURES;
drop table DLFILEENTRYTYPES_DLFOLDERS;
drop table DLSYNCEVENT;
drop table JOURNALFOLDER;
drop table LAYOUTBRANCH;
drop table LAYOUTREVISION;
drop table LAYOUTSETBRANCH;
drop table MBTHREADFLAG;
drop table MDRACTION;
drop table MDRRULE;
drop table MDRRULEGROUP;
drop table MDRRULEGROUPINSTANCE;
drop table PORTALPREFERENCES;
drop table REPOSITORY;
drop table REPOSITORYENTRY;
drop table RESOURCEBLOCK;
drop table RESOURCETYPEPERMISSION;
drop table SOCIALACTIVITYCOUNTER;
drop table SOCIALACTIVITYLIMIT;
drop table SOCIALACTIVITYSET;
drop table SOCIALACTIVITYSETTING;
drop table SYSTEMEVENT;
drop table TRASHENTRY;
drop table TRASHVERSION;
drop table USERNOTIFICATIONDELIVERY;
drop table USERNOTIFICATIONEVENT;
drop table VIRTUALHOST;
drop table DDLRECORD;
drop table LAYOUTFRIENDLYURL;
drop table QUARTZ_SIMPROP_TRIGGERS;
drop table RESOURCEBLOCKPERMISSION;
drop table SOCIALACTIVITYACHIEVEMENT;
drop table USERGROUPS_TEAMS;
drop index IX_F7655CC3;
drop index IX_9955EFB5;
drop index IX_8040C593;
drop index IX_804154AF;
drop index IX_BAB9A1F7;
drop index IX_ADEE6A17;
drop index IX_64B194F2;
drop index IX_5FEABBC;
drop index IX_20D8706C;
Publicado el día 9/06/14 15:11.