root/trunk/wifidog-auth/wifidog.schema @ 158

Revision 158, 2.0 KB (checked in by benoitg, 9 years ago)

it Gr�goire <bock@…>

  • wifidog-auth lives! New since the dark ages
  • Demo page to allow people to hack more easely on it
  • Support for multiple nodes. TODO: Merge with the database project.
  • Very cool local content architecture. Every hotspot can have a folder in the local_content directory. This folder can be filed by a single logo, leaving all the rest to the default content, or be completely custom (stylesheet, login page, portal page, header, etc.)
  • Everything in local content is templated with smarty, no problem with web designer wrecking havoc on the auth server. You can edit everything in local_content/default even if you only speak html.
  • No need to set any path in the web server config files (that one was a bitch to implement)
  • RSS feed support (optionnal, with magpierss), one feed per node (url stored in the database, works great, but no gui to edit it yet) and one network-wide RSS feed.
  • All path are editable from the config file
  • "Productize" the thing, so it make sense for other groups to install it (the network name, url, default RSS, and such are set from the config file.
  • Put most strings in gettext calls for easy future translation.
  • User can request that the server send the validation email again
  • User can change password
  • User who forgot his username can have it mailed to him.
  • User who lost his password can ask the system to generate a new one and mail it to him.
  • Email is now a separate field to preserve user privacy.
  • Database abstraction layer with very nice debugging features (just append true at the end of the call, and you'll see the query, the results, the query plan and number of affected rows. Also allow future upgrade to postgres.
  • Lots of other things I forgot.
  • Property svn:eol-style set to native
  • Property svn:executable set to *
  • Property svn:keywords set to Author Date Id Revision
RevLine 
[158]1# phpMyAdmin SQL Dump
2# version 2.5.4
3# http://www.phpmyadmin.net
4#
5# Host: localhost
6# Generation Time: Aug 03, 2004 at 02:43 AM
7# Server version: 4.0.18
8# PHP Version: 4.3.4
9#
10# Database : `wifidog`
11#
12CREATE DATABASE IF NOT EXISTS wifidog;
13
14USE wifidog;
15
16# --------------------------------------------------------
17
18#
19# Table structure for table `connections`
20#
21
22CREATE TABLE `connections` (
23  `conn_id` int(11) NOT NULL auto_increment,
24  `token` varchar(32) NOT NULL default '',
25  `token_status` enum('UNUSED','INUSE','USED') NOT NULL default 'UNUSED',
26  `timestamp_in` datetime default NULL,
27  `incoming` int(11) NOT NULL default '0',
28  `outgoing` int(11) NOT NULL default '0',
29  `hotspot_id` varchar(32) default NULL,
30  `hotspot_ip` varchar(15) default NULL,
31  `timestamp_out` datetime default NULL,
32  `user_id` varchar(45) NOT NULL REFERENCES users,
33  `user_mac` varchar(18) default NULL,
34  `user_ip` varchar(16) default NULL,
35  `last_updated` timestamp(14) NOT NULL,
36  PRIMARY KEY  (`conn_id`),
37  KEY `user_id` (`user_id`)
38) TYPE=InnoDB
39
40/* RELATIONS FOR TABLE `connections`:
41    `user_id`
42        `users` -> `user_id`
43*/;
44
45# --------------------------------------------------------
46
47#
48# Table structure for table `nodes`
49#
50
51CREATE TABLE `nodes` (
52  `node_id` varchar(32) NOT NULL default '',
53  `name` text,
54  `rss_url` text,
55  PRIMARY KEY  (`node_id`)
56) TYPE=InnoDB
57
58/* COMMENTS FOR TABLE `nodes`:
59    `rss_url`
60        `The url of the rss feed associated with the node for display on the portal page`
61*/;
62
63# --------------------------------------------------------
64
65#
66# Table structure for table `users`
67#
68
69CREATE TABLE `users` (
70  `user_id` varchar(45) NOT NULL default '',
71  `pass` varchar(16) NOT NULL default '',
72  `email` varchar(255) NOT NULL default '',
73  `account_status` int(11) default NULL,
74  `validation_token` varchar(64) NOT NULL default '',
75  `reg_date` int(11) NOT NULL default '0',
76  `online_status` int(11) default NULL,
77  PRIMARY KEY  (`user_id`),
78  UNIQUE KEY `email` (`email`)
79) TYPE=InnoDB;
Note: See TracBrowser for help on using the browser.