Anypost, a free open source, fully anonymous chat app
- Anonymous Posting
- Commenting
- Topics
- Download any Apache or NGINX server with PHP and MYSQL
- Create database called
anypost
- Create Tables in the databse:
CREATE TABLE `comments` (
`id` int(255) NOT NULL,
`post_id` varchar(255) NOT NULL,
`comment` varchar(500) NOT NULL,
`upload_time` varchar(20) NOT NULL,
`display_time` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE `posts` (
`id` int(255) NOT NULL,
`title` varchar(111) NOT NULL,
`comment` varchar(500) NOT NULL,
`upload_time` varchar(111) NOT NULL,
`display_time` varchar(100) NOT NULL,
`topic` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE `topics` (
`id` int(255) NOT NULL,
`topic` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `topics`
--
INSERT INTO `topics` (`id`, `topic`) VALUES
(4, 'Question'),
(5, 'Bored Post');
For Dev:
CREATE TABLE `accounts` (
`id` int(11) NOT NULL,
`username` varchar(50) NOT NULL,
`password` varchar(255) NOT NULL,
`email` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `accounts` (`id`, `username`, `password`, `email`) VALUES
(1, 'test', 'test', 'test@test.com'),