summaryrefslogtreecommitdiffstats
path: root/raddb/mods-config/sql/main/mysql/extras/wimax/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'raddb/mods-config/sql/main/mysql/extras/wimax/schema.sql')
-rw-r--r--raddb/mods-config/sql/main/mysql/extras/wimax/schema.sql16
1 files changed, 16 insertions, 0 deletions
diff --git a/raddb/mods-config/sql/main/mysql/extras/wimax/schema.sql b/raddb/mods-config/sql/main/mysql/extras/wimax/schema.sql
new file mode 100644
index 0000000..e32224a
--- /dev/null
+++ b/raddb/mods-config/sql/main/mysql/extras/wimax/schema.sql
@@ -0,0 +1,16 @@
+#
+# WiMAX Table structure for table 'wimax',
+# which replaces the "radpostauth" table.
+#
+
+CREATE TABLE wimax (
+ id int(11) NOT NULL auto_increment,
+ username varchar(64) NOT NULL default '',
+ authdate timestamp NOT NULL,
+ spi varchar(16) NOT NULL default '',
+ mipkey varchar(400) NOT NULL default '',
+ lifetime int(12) default NULL,
+ PRIMARY KEY (id),
+ KEY username (username),
+ KEY spi (spi)
+) ;