diff options
author | arf20 <aruizfernandez05@gmail.com> | 2024-03-16 17:15:11 +0100 |
---|---|---|
committer | arf20 <aruizfernandez05@gmail.com> | 2024-03-16 17:15:11 +0100 |
commit | 3de91148bc3b634feb6d4b882c743317c517b8b0 (patch) | |
tree | 4bdaa7e70c4fcf2bcb46587fb59e142299b8cb5b /dbinit.sql | |
parent | da57beb574fb9f756a7de036e8003f75ec47432c (diff) | |
download | arfnet2-cstims-3de91148bc3b634feb6d4b882c743317c517b8b0.tar.gz arfnet2-cstims-3de91148bc3b634feb6d4b882c743317c517b8b0.zip |
Add client and admin panels
Diffstat (limited to 'dbinit.sql')
-rw-r--r-- | dbinit.sql | 9 |
1 files changed, 9 insertions, 0 deletions
@@ -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`) +); |