21 lines
837 B
PHP
21 lines
837 B
PHP
|
<?php
|
||
|
|
|
||
|
|
$SQL = "create table usersubscriptions
|
||
|
|
|
||
|
|
(
|
||
|
|
|
||
|
|
usersubscription_serial serial,
|
||
|
|
usersubscription_user_serial bigint unsigned default 0,
|
||
|
|
usersubscription_report varchar(100) default null,
|
||
|
|
usersubscription_report_description varchar(128) default null,
|
||
|
|
usersubscription_stop_date_string varchar(10) not null,
|
||
|
|
usersubscription_stop_date date null,
|
||
|
|
usersubscription_origin varchar(100) default null,
|
||
|
|
usersubscription_timestamp timestamp default current_timestamp on update current_timestamp,
|
||
|
|
|
||
|
|
primary key (usersubscription_serial)
|
||
|
|
)
|
||
|
|
|
||
|
|
default character set = utf8";
|
||
|
|
?>
|