aboutsummaryrefslogtreecommitdiff
path: root/dbinit.sql
diff options
context:
space:
mode:
Diffstat (limited to 'dbinit.sql')
-rw-r--r--dbinit.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/dbinit.sql b/dbinit.sql
index 5a989ab..d9220d1 100644
--- a/dbinit.sql
+++ b/dbinit.sql
@@ -11,3 +11,12 @@ CREATE TABLE `arfnet2`.`users` (
`regdate` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
PRIMARY KEY (`id`)
);
+
+CREATE TABLE `arfnet2`.`services` (
+ `id` INT NOT NULL AUTO_INCREMENT ,
+ `name` VARCHAR(255) NOT NULL ,
+ `type` ENUM('free','standard','premium') NOT NULL ,
+ `billing` DECIMAL NOT NULL ,
+ `description` TEXT NOT NULL ,
+ PRIMARY KEY (`id`)
+);