FilesExpand file tree

main

/

install.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

66 lines (60 loc) · 1.89 KB

main

/

install.sql

Copy path

Top

File metadata and controls

• Code
• Blame

66 lines (60 loc) · 1.89 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

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

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

DROP TABLE IF EXISTS `cloud_config`;

CREATE TABLE `cloud_config` (

`key` varchar(32) NOT NULL,

`value` varchar(255) DEFAULT NULL,

PRIMARY KEY (`key`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `cloud_config` (`key`, `value`) VALUES

('admin_username', 'admin'),

('admin_password', '123456'),

('bt_url', ''),

('bt_key', ''),

('whitelist', '0'),

('download_page', '1'),

('new_version', '7.9.8'),

('update_msg', '暂无更新日志'),

('update_date', '2023-01-29'),

('new_version_win', '7.8.0'),

('update_msg_win', '暂无更新日志'),

('update_date_win', '2022-12-08'),

('new_version_btm', '1.0.12'),

('update_msg_btm', '暂无更新日志'),

('update_date_btm', '2023-02-12'),

('updateall_type', '0'),

('syskey', 'UqP94LtI8eWAIgCP');

DROP TABLE IF EXISTS `cloud_black`;

CREATE TABLE `cloud_black` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`ip` varchar(20) NOT NULL,

`enable` tinyint(1) NOT NULL DEFAULT '1',

`addtime` datetime NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `ip`(`ip`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

DROP TABLE IF EXISTS `cloud_white`;

CREATE TABLE `cloud_white` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`ip` varchar(20) NOT NULL,

`enable` tinyint(1) NOT NULL DEFAULT '1',

`addtime` datetime NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `ip`(`ip`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

DROP TABLE IF EXISTS `cloud_record`;

CREATE TABLE `cloud_record` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`ip` varchar(20) NOT NULL,

`addtime` datetime NOT NULL,

`usetime` datetime NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `ip`(`ip`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

DROP TABLE IF EXISTS `cloud_log`;

CREATE TABLE `cloud_log` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`uid` tinyint(4) NOT NULL DEFAULT '1',

`action` varchar(40) NOT NULL,

`data` varchar(150) DEFAULT NULL,

`addtime` datetime NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;