« Torna 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 Allegati
13962 Visualizzazioni
Media (0 Voti)
La media del punteggio è 0.0 stelle su 5.
Commenti
Commenti Autore Data
same but to drop tables in liferay 6.2.x drop... Pablo Rendón 9 giugno 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;
Inviato il 09/06/14 15.11.