-
Notifications
You must be signed in to change notification settings - Fork 0
/
DEP.sql
49 lines (44 loc) · 6.58 KB
/
DEP.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
CREATE TABLE IF NOT EXISTS `redirect` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`slug` varchar(14) DEFAULT NULL,
`url` varchar(50) DEFAULT NULL,
`createdat` datetime DEFAULT NULL,
`createdby` int(11) DEFAULT NULL,
`wallpaper` mediumblob,
PRIMARY KEY (`id`),
UNIQUE KEY `slug` (`slug`),
KEY `createdby` (`createdby`),
CONSTRAINT `redirect_ibfk_1` FOREIGN KEY (`createdby`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
-- Dumping data for table pweb.redirect: ~7 rows (approximately)
DELETE FROM `redirect`;
/*!40000 ALTER TABLE `redirect` DISABLE KEYS */;
INSERT INTO `redirect` (`id`, `name`, `slug`, `url`, `createdat`, `createdby`, `wallpaper`) VALUES
(2, '', 'ad01', 'http://tabulator.info/examples/4.1#editable', '2018-11-08 18:32:37', NULL, NULL),
(3, '', '0a15', 'https://unicode-table.com/en/search/?q=pen', '2018-11-08 18:33:43', NULL, NULL),
(4, '', '9ca0', 'http://tabulator.info/examples/4.1#editable', '2018-11-08 18:53:06', NULL, NULL),
(8, 'judulnyas', '665d', 'http://tabulator.info/examples/4.1#editable', '2018-11-08 19:58:28', 4, _binary ''),
(9, '', '5dad', 'http://tabulator.info/examples/4.1#editable', '2018-11-08 20:50:36', NULL, NULL),
(10, '', '1afe', 'https://unicode-table.com/en/search/?q=pen', '2018-11-08 20:55:35', 4, _binary 0x89504E470D0A1A0A0000000D49484452000000B20000002108060000007D78F185000000017352474200AECE1CE90000000467414D410000B18F0BFC61050000000970485973000012740000127401DE661F780000080549444154785EED9AED5352691887F7CFA9863632142A7421154D93C437DAC5C40DDF071DCDCC9C5E8DD11886CDDDC5B7658C41D7B5658899709C4C77ADB166EA43D307FBD2A7FD5B7E7B3FE7050F785414B0899E0FD7C8799E9B031EAE739FFB7ECEF9EE9846070EE76B878BCCC90BB8C89CBC808BCCC90BB8C89CBC808BCCC90BB8C89CBC808BCCC90BBE1D91B5769CF13D8735FE064D2F24663CBBC43A30F42482BB8DC694B98BB8F37604B36F5DA8A3EDB30137BDA6EDA58A444C67871DEF821DD80AB661F3C6055C4ABC578FDF46697CD4A2184BC1542DBC37DEA8187BE0923EE3226D1BD1B9C23E7F04B71E2862D2A6043F5A36B03AF41FDEDD22FADF60425FA212971E869E3042934330A8CC1D35DF88C84614043648DE15181D552AF34ACAD13EB98E686C1103170D297392C8AF9CA866DB9264BE59490641C4162C5514A2A0CC4AAF9DF45A7CEFA52B4DF8107460BA58DE970A7B883C395F2E6CD72D3191FBD0E354C4A4C9E91F5E62F3D667FC6D69C1694D0BC65A3FE3DDE04B5C5789ADBD1FC1C2BC0F952A7332DAC60984965F23E47140A3327F947C2322DF849932717DE0A6CA5C32A6DB314497D7E1BB962A31A3147DAF48A4B50614B3ED54911B9B281337E191141B97A52CB88078A0039BDDE715FB52414DE4BE9FF09BE2333211F9BA83C4ED5F46AF3C56BA4199F913FED027C731DA275F23FAD7C49E22330C3D8B58A2E3F5B8473CD1BE14DF88C81E945229513DDEA632A7C07017BF538659F0BA76C93025E8595388DC7605BF906477C6A4F98A5A2123CF97E99232F2F0F0356CF9ADE84CDA970A6A223B1BE053886C9AED27915D682C54C4A4C983562A271419D854F93E6391D9156CE009C5C6E67055AB367F34644FE42A2F4CE135D44BF5677D240ABDDDBC33CE7C136767566093E362519C4D8D93626AA57AB621BE06CBF84D9C501CA83333628D7BC219842526C7ADC0D4569FBC2F81F444AEF5BEA06C1CC180517D7E7FF418BDD1425999D5C83FE345C779E805B9B74B0C2505C5E57836E694E289E936E16F92C859A4E5F22712F733FE34D349A10DE0EF4112BB6F195D724C8D582A44776337B11B0358A0F9E961EBCE390103AEFAD9B18D61C4A676A5CB9CEC886C2051483ADB8C171A1D1B33E3B8DD0BF3CC144E2AE3AC53A822A16CE129688B99BC461CAFDB197766E2398C5DDD382EED4B33F454105F29A220727C03B6389D3056DA176BE6026B24F473E8CB594C1BCE4544C1D559C339EBF6671ED338F130423F16352FD9ABF7CE63CEDF810FC32614A4CE51F6DD246937FB4DB09F626385A8B0D9A88ECE9DC8C7B44FB0CC9A3CF77B2C338907DFEFDAECA59F9119568CCC53FCFC384CAAF36EF8A49321E4695299CF9CEC886C0DA29AE42873A776F94AAA50344702C5423875E04B50AB2865642A21992032356FE7EA149F5917440D7D8F52B7FC3E993432728D4FC846D3C32A57914362EF7050966D82BF2875AE107EB682E1BD08BB725CADB4C82A5D9868278199CC7D5462ECF13B1C4C646A663D71127511EDAAFB9433721C776D5F41466659CE3C721D1A838AD05A2FCA48A69AF1EE9D736920881B09263277EAB68074421D4AE48E301DE81778F893CADC6128B2E01F92F29F66BDCA3C357F34F7AE37A5F9CBA9C883F8A39B49FC09ABDDD4F4B1D58BD22BC29C503BBB636851C41F54640D357D82A835EAF3B9267B3532D5B5E7E6D6D040C2B04B37AB91CF3AEDDBF369656D9113CE29942D6E24EAED04B914B987899CAD1F420FFF3D6AF0BC95B0179560C92BD6BE5B13764C532328AF681CA5C897ABC4C62E6464A5842CF5476AF4E8B59B5EB70692E20F2A72768FDFC1C99EC8323A2B4E7505512634606B30DAA571831F96FD6462D843B0529C6DCE8F938ACC9EF38C2CFC10D9C9C8176C0D54EB3663CE24AD588C5A5047E5C4C00D6AEC48EEBA2F20B29075FB6270C96372BDDCFD11ABF477B9AA25299E8B2CB3432AA9F95ADCAE73D53839CE1AB60D143B94E3F5D087732C72D66A64139E0544490BA8D99BA7662F21ACB0CEDC8047D2F8D6BD724513A8C72396C53312B9496CBAE8844C5DD715D690075FE2B662ACAA74039B4CE6A13718FB7E7B9CD128ACE084F1B3626C2FF6AB912FDD67EBF3AF11BC9F9B9B27D911B92B840A9F07A7CCD25D339D0305BE152A33E4150491E35DE2EA43CD8C57CAB66CD5C2035340B16AE17E2A9427D5BE5E71BB9C4A9630BB2B976391352E71D562F62E74AAF3E931D04F5977A21603D2F6A37B24AC9491476F93A8632C234B8D2065EDF98A428A3360B8BF195BFEE60C33723F1E4BAB03D1BF92EFCA9D362EE35F9276B5C98306415A2B5C960D618C357FAB9707715A11AFB9368725DA4FC8E3826EDFE67CBF550B2B8684138CB19BEC99911D91B5AD38E38BA2465AF76558C30BD0B165B19458B9FE956B69DBE2D394B87A68C7A34279C1E6D9DAB079A4173A768B39A72267BE8E2CDE04B98667CA65BDA20B78E6976A647F3DFC895BD4CA35E7366CDE2E47B3F26EA0FCFE0341994FC88C4CE4D4B2A004977F8821D6278ACBF8B7F325C60AFB30D1C9B6B79BBFC4BE86C308C66401D5F62921AD3FFF3EB8FBD54C3E31D85AF29022B9658BDC95165F23C68798A683BDF4AB3B2797BF23A1654610E6E8FE8772B4CFAE231A09A071CF4C3B245E2D28AE56753E33B8C82954DE6719EDCB3F3B7018B446175DE2D9034F61B41FFAEEE4C1604FC009CF5A74ECD15BE8ACB8EA958EEB5E7119C045DE81F4F45B0E17EF7341A55052AC2338E9C38FA6A3F9DE1A5B1A4FBF09AB19EB58783283DE9AFD975E0F0B17590DAD83325BECAB12F94BC09F47E670B20C17999317709139790117999317709139790117999317709139790117999307E8F03FF51A9977D0AB7D480000000049454E44AE426082),
(11, '231321', 'ddd7', 'https://unicode-table.com/en/search/?q=pen', '2018-11-08 20:57:33', 4, _binary '');
/*!40000 ALTER TABLE `redirect` ENABLE KEYS */;
-- Dumping structure for table pweb.user
CREATE TABLE IF NOT EXISTS `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL DEFAULT '0',
`email` varchar(50) NOT NULL DEFAULT '0',
`pass` varchar(50) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
-- Dumping data for table pweb.user: ~2 rows (approximately)
DELETE FROM `user`;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` (`id`, `name`, `email`, `pass`) VALUES
(4, 'Rizanw_', '[email protected]', '12345'),
(5, 'Rizanw_', '[email protected]', 'rzkandre');
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;