aboutsummaryrefslogtreecommitdiff
path: root/dbinit.sql
diff options
context:
space:
mode:
authorarf20 <aruizfernandez05@gmail.com>2024-03-16 17:15:11 +0100
committerarf20 <aruizfernandez05@gmail.com>2024-03-16 17:15:11 +0100
commit3de91148bc3b634feb6d4b882c743317c517b8b0 (patch)
tree4bdaa7e70c4fcf2bcb46587fb59e142299b8cb5b /dbinit.sql
parentda57beb574fb9f756a7de036e8003f75ec47432c (diff)
downloadarfnet2-cstims-3de91148bc3b634feb6d4b882c743317c517b8b0.tar.gz
arfnet2-cstims-3de91148bc3b634feb6d4b882c743317c517b8b0.zip
Add client and admin panels
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`)
+);