Skip to content

Instantly share code, notes, and snippets.

@martinlau
Created January 9, 2013 05:57
Show Gist options
  • Save martinlau/4491003 to your computer and use it in GitHub Desktop.
Save martinlau/4491003 to your computer and use it in GitHub Desktop.
SQL resulting from adding a new site through liferay's control panel.
INSERT INTO GROUP_ VALUES(10614,10154,10196,10001,10614,0,0,'Test Site','This is a test site',2,'','/test-site','1','1')
INSERT INTO LAYOUTSET VALUES(10615,10614,10154,'2013-01-09 16:56:01.504000','2013-01-09 16:56:01.504000','1','0',0,'classic','01','mobile','01','',0,'','','0')
INSERT INTO LAYOUTSET VALUES(10616,10614,10154,'2013-01-09 16:56:01.506000','2013-01-09 16:56:01.506000','0','0',0,'classic','01','mobile','01','',0,'','','0')
INSERT INTO RESOURCEPERMISSION VALUES(611,10154,'com.liferay.portal.model.Group',4,'10614',10163,0,2097151)
INSERT INTO USERGROUPROLE VALUES(10196,10614,10171)
INSERT INTO USERS_GROUPS VALUES(10196,10614)
INSERT INTO ASSETENTRY VALUES(10617,10192,10154,10196,'Test Test','2013-01-09 16:56:02.502000','2013-01-09 16:56:02.502000',10001,10614,'',0,'0',NULL,NULL,NULL,NULL,'','Test Site','This is a test site','','','',0,0,0.0E0,0)
COMMIT
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment