64 lines
1.4 KiB
SQL
64 lines
1.4 KiB
SQL
CREATE TABLE `apps` (
|
|
`id` TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
|
|
`name` VARCHAR(30),
|
|
`url` VARCHAR(50),
|
|
`icon` VARCHAR(30),
|
|
`urlbase` VARCHAR(15),
|
|
`NSFW` VARCHAR(10),
|
|
PRIMARY KEY (`id`)
|
|
);
|
|
|
|
CREATE TABLE `links` (
|
|
`id` TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
|
|
`category` VARCHAR(20),
|
|
`name` VARCHAR(50),
|
|
`url` VARCHAR(100),
|
|
PRIMARY KEY (`id`)
|
|
);
|
|
|
|
CREATE TABLE `tabs` (
|
|
`id` TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
|
|
`name` VARCHAR(50),
|
|
`NSFW` BOOLEAN,
|
|
PRIMARY KEY (`id`)
|
|
);
|
|
|
|
CREATE TABLE `categories` (
|
|
`id` TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
|
|
`name` VARCHAR(50),
|
|
PRIMARY KEY (`id`)
|
|
);
|
|
|
|
CREATE TABLE `messages` (
|
|
`id` TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
|
|
`message` VARCHAR(255),
|
|
`easteregg` BOOLEAN,
|
|
PRIMARY KEY (`id`)
|
|
);
|
|
|
|
CREATE TABLE `personaldata` (
|
|
`fname` VARCHAR(20),
|
|
`lname` VARCHAR(30),
|
|
`email` VARCHAR(50)
|
|
);
|
|
|
|
CREATE TABLE `providers` (
|
|
`id` TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
|
|
`name` VARCHAR(20),
|
|
`url` VARCHAR(100),
|
|
`prefix` VARCHAR(5),
|
|
PRIMARY KEY (`id`)
|
|
);
|
|
|
|
CREATE TABLE `themes` (
|
|
`id` TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
|
|
`name` VARCHAR(20),
|
|
`imagebackground` VARCHAR(100),
|
|
`colorbackground` VARCHAR(9),
|
|
`colorserachbackground` VARCHAR(9),
|
|
`colortextpri` VARCHAR(9),
|
|
`colortextacc` VARCHAR(9),
|
|
`colorborder` VARCHAR(9),
|
|
PRIMARY KEY (`id`)
|
|
);
|