Share with us your project!
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
api
www
README.md

README.md

AppMonday-Web

Repository content

Here is the website of AppMonday, divided in two folders:

  • www/ => The website with HTML/CSS/JS
  • api/ => The API with PHP/MySQL

Check out the website online!

MySQL database

CREATE TABLE `competitions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `criterias` text NOT NULL,
  `start` datetime NOT NULL,
  `end` datetime NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE `notification_tokens` (
  `ios_device_token` varchar(255) NOT NULL DEFAULT '',
  `android_reg_id` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`ios_device_token`,`android_reg_id`)
);

CREATE TABLE `projects` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `user` varchar(255) NOT NULL DEFAULT '',
  `link` varchar(255) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `logo` text NOT NULL,
  `submit` datetime NOT NULL,
  `publish` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE `tips` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `user` varchar(255) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `publish` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
);

Mobile apps

AppMonday is also available on Android and iOS, check them out!